1. Quick Start Guide
2. Useful Tips for Schema projects
3. Technical Overview

Latest Release: 2.13
Auto-Upgrade: http://www.picasso.net.nz/codegenerator/publish.htm

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 (such as LINQ/Entities, NHibernate, NetTiers), particulary on its simplicity, transparancy, customisability, portability, and ease-of-regeneration when schema changes. Features UI-level code-generation tools to complement the main business layer, plus a minimalist suite of Framework helper classes to shorten common UI code wherever possible.

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).

Sophisticated in-memory caching option on a table-by-table basis (managed, indexed), offering order of magnitude performance improvements by eliminating trivial db activity.


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 (i.e. doesn't require 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 integration 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 three remote ADO.Net drivers including WCF, asmx, and aspx
- 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 Guide
2. Useful Tips for Schema projects
3. Technical Overview

Last edited Nov 15, 2010 at 11:25 AM by jeremyconnell, version 65