Lattice.DataMapper 1.0

Lattice.DataMapper is a useful .NET based object persistence library for relational databases. Lattice.DataMapper bridges the gap between objects and data source and allows the developer to work at the object level with little knowledge of the data source. In addition, Lattice.DataMapper shields your business logic from data source schema changes and data source provider changes which benefits maintainability.
The Lattice.DataMapper framework will help you to significantly reduce the amount of .net code that you normally need to access a relation database. Simplicity is the biggest advantage of Lattice.DataMapper over other frameworks and object relational mapping (O/R Mapper) tools. To use Lattice.DataMapper you need only be familiar with XML, stored procedures and SQL. Lattice.DataMapper provides the platform and flexibility to build your own architecture and you, the developer, have the full power of both stored procedures and SQL at your fingertips.
Lattice.DataMapper is a tool that maps .NET objects to and from an underlying relational database using external XML configuration and mapping files. The data access is externalized in XML and can include both SQL queries and stored procedure calls. An API is provided to then dynamically store and retrieve .NET objects using the mapping definitions.
Main features:
- Support .NET 2.0 and .NET 1.1 framework
- Support for different data providers and multiple data sources.
- Support object pre-fetch( one-to-one, one-to-many, many-to-many relationship )
- Queries are batched and run as one transaction
- Batch job can be run asynchronously at scheduled time as separate thread
- Cache can be set up per query ( supports cache database dependency )
- Support .NET 2.0 Generic and nullable value type
- Support nullable value types using null-value attribute
- Logging and error handling using Log4net framework
- Support distributed transactions without deriving from the ServiceComponent
- XML file based configuration file to define available data providers and data sources.
- XML based mapping files to define O/R mapping
- XSLT template based tool to auto-generate stored procedures, business entities and mapping files.