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 has a XML/XSLT template based code generator to generate stored procedures, business entities and mapping files which supports Oracle and SQL Server.
Demo application is available for download that supports both Oracle and SQL Server(ASP.NET and Windows Application) in C# and VB.NET version.