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.


Lattice.DataMapper Main Features:

---

Support for different data providers and multiple data sources.

Support both OracleClient and ODP.NET and SqlTypes

Two-Phase Commit Distributed transactions without deriving from the ServicedComponent.

Non- intrusive O/R mapping, there is no PersistenceObject base class

Map objects to stored procedures or static SQL statements

Support BLOB and CLOB

Return Identity Number from SQL Server or Sequence Number from Oracle

Support stored procedure output parameters

XML file based configuration file to define available data providers and data sources

XML based mapping files to define O/R mapping

No dynamic SQL statement and data access code generated

Logging and error handling using Log4net framework

XSLT template based tool to auto-generate stored procedures, business entities and mapping files