Lattice.DataMapper
Lattice.DataMapper is a persistence framework for .NET. Lattice.DataMapper provides a simple and flexible way to map objects to relational database. Unlike most other O/R Mapper using dynamic SQL, Lattice.DataMapper uses static SQL, either stored procedures or SQL statement. Lattice.DataMapper simply uses one or more external XML mapping files to map objects to stored procedures or SQL statement. Lattice.DataMapper is configured using a central XML configuration file, which provides configuration details for Data Sources, Data Providers and path of mapping file. Lattice.DataMapper is easy to use and learn. Simplicity is the biggest advantage of Lattice.DataMapper over other frameworks and object relational mapping 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 also includes a XML/XSLT template-based tool for generating stored procedures and business entities which support MS SQL Server, Oracle and IBM DB2 UDB. Main features: �Support for different data providers and multiple data sources. �Support distributed transactions without deriving from the ServiceComponent. �Non- instructive O/R mapping, there is no PersistenceObject base class. �Map objects to relational database using either stored procedures or static SQL statement. �Logging and error handling using Log4net framework. �XML/XSLT template based tool to auto-generate stored procedures and business entities.