Object/Relational Mapper & Code Generator in Net 2.0 for Relational & XML Schema

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

Latest Release: 2.4
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, 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 (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
- 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 Guide
2. Useful Tips for Schema projects
3. Technical Overview


Credits: Thanks to http://www.nvinteractive.co.nz/ for their full adoption and support
Sponsors: www.teameffect.com and www.swapster.co.nz