1. Quick Start Guide2. Useful Tips for Schema projects3. Technical OverviewLatest Release:
2.3Auto-Upgrade:
http://www.picasso.net.nz/codegenerator/publish.htmCredits: Thanks to
http://www.nvinteractive.co.nz/ for their full adoption and support
Introduction:Speed up your .Net 2.0 development with this powerful, flexible, and transparent Object-Relational data persistance framework.
Compares favourably with mainstream ORM solutions, particulary on its simplicity, transparancy, customisability, portability, and ease-of-regeneration when schema changes.
Configurable template-based code-generator rapidly converts your Relational or Xml schema into a easy-to-use, fully functional, highly customisable set of .Net 2.0 business objects, which extend powerful abstract classes.
Powerful dynamic queries meant you can rapidly develop a major .net application without ever writing SQL. Also supports the older option of using auto-generated (+customised) stored-procedures (if your dba insists on it).
All the usual bells and whistles, plus a few extras including:
- Easy to regenerate code as schema changes, whilst preserving all customisations (uses Partial Classes, Generics)
- Support for multi-column primary keys in the O/R model.
- Handle any type of relations (1-1, 1-n, n-n)
- Aggregates (SUM, AVG, MIN, MAX, COUNT)
- Powerful queries (joins and complex where expressions), plus easy support for stored procedures.
- Generates code (copy & paste) for relationship-mapping properties, allowing easy & efficient navigation around data relationships
- Transactional - Easily supports batches of operations within an ADO.Net Transactions (not MSDTC/TransactionScope)
- Paging support, including both sql-based, and in-memory paging
- Easily talk to several database instances simultanously
- Handles circular references without duplication.
- Natural intergration with xml data (e.g. xml blobs in db, or xml import/export functions)
- Can co-exist with other frameworks i.e. no constraints on db (other than suggested naming conventions)
- Total Db-Platform Independance and Optimisation. Includes Oracle, MySql, MSAccess, SqlServer, etc, plus two custom webservice-based ADO.Net drivers
- Sophisticated in-memory caching option on a table-by-table basis (managed, indexed), greatly improving performance in most circumstances.
- Option of a low-level audit trail to record full details of all inserts, updates and deletes.
- Easy to use code generator app, with high-quality fully-editable templates and logic
- Framework provides powerful abstract classes to minimise schema and application code.
Support options are available, including skype,msn,etc (rates neg.
1. Quick Start Guide2. Useful Tips for Schema projects3. Technical Overview