.NET tools, components, libraries and add-ins [NEW] My favorites| sign in | create your account  
LINQ in Action book
Advertise here! Contact us to know the options
Category

Object-relational mapping

Object-relational mapping (O/R Mapping) products integrate object-oriented programming languages capabilities with relational databases.

Display options and filters
Sort by:
Built for .NET
Free or free version available
Built for Mono
Built for .NET 2
Source code provided
Sold as a service
Library
Built for the Compact Framework
Discontinued
Add-in

Retina.NET

 Home Page Home Page
Categories:
Author: Andrés Vettori
Latest version: 2.0
Description: Open source object-relational mapping tool.
Added: 2004-08-04
Updated: 2008-05-31
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

Gentle.NET

 Home Page Home Page
Categories:
Author: Morten Mertner
Latest version: 1.2.9
Description: Database-independent object persistence framework written in C#.
Gentle.NET features automatic SQL generation and object construction, a caching subsystem, an SQL factory for creating custom queries, a list class for managing 1:n and n:m relations, concurrency control, data binding support, and more.
Gentle.NET supports a wide range of databases and runs under both MS.NET and
Mono. Metadata is automatically extracted from the database backend, which minimizes the amount of configuration required.
Added: 2004-02-06
Updated: 2005-02-22
Attributes: Built for .NET[BuiltForDotNet] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided] Built for Mono[Built for Mono]

GenWise Studio

 Home Page Home Page
Categories:
Author: GenWise
Latest version: 1.09
Description: Template-based generation tool for NHibernate and ASP.NET with AJAX.

Features include:
- Creates a full NHibernate BO-Layer and/or ASP.NET application from an existing database
- Supports SQL Server, SQL Server Express, Sybase, Postgress, DB2, Oracle, MySql
- You can add your own code to the generated code without losing it in the next generation cycle
Added: 2006-01-03
Updated: 2007-05-15
Attributes: Built for .NET 2[BuilfForDotNet2]

LLBLGen Pro

 Home Page Home Page
Categories:
Author: Solutions Design
Latest version: 2.5
Description: Generates a complete data-access tier and business objects tier (in C# or VB.NET).
LLBLGen uses O/R mapping technology and a task-based code generator. It comes with a visual O/R mapping designer to setup and manage your project.

Features include:
- Database independent code
- Full entity type inheritance
- Custom developer code is preserved
- Typed lists and typed views
- Stored procedures support
- Flexible concurrency mechanism
- Fine-grained validation framework
- Auditing support
- Authorization support
- Dependency injection mechanism
- XML and binary serialization support
- Prefetch paths
- Singularization and pluralization
- Hierarchical in-memory projections

Supported databases: Access 2000/XP/2003/2007, SQL Server 7/2000/2005/Express/MSDE/CE/CE-Desktop, Oracle 8i/9i/10g, IBM DB2 7.x/8.x/9.x (not on AS/400), as well as several versions of PostgreSql, Firebird, Interbase, MySql, Sybase ASE and ASA
Added: 2003-09-08
Updated: 2007-08-23
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Source code provided[SourceCodeProvided] Built for the Compact Framework[BuiltForCompactFramework]

Persistor.NET

 Home Page Home Page
Categories:
Author: 2Top Software Engineering
Latest version: 1.5
Description: Object oriented persistence framework that provides transparent persistence.

Features include:
- supports the .NET Framework 3.5 including generic types, multi-dimensional native arrays, inheritance, polymorphism, value type and reference type semantics as well as interfaces and boxing of primitive objects and value type objects.
- based on non intrusive persistence and can therefore support even types from third party manufacturers as well as types from the .NET Framework itself.
- supports database agnostic development; all required mapping information is created transparently at runtime.
- supports SQL Server, Oracle, and MySQL.
Added: 2006-05-19
Updated: 2008-05-20
Attributes: Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable]

EdgeXtend for C#

 Home Page Home Page
Categories:
Author: Persistence Software
Description: Generates database mapping classes.
The mapping classes allow application objects to transparently access and update relational data, and take advantage of caching to provide high performance and scalability.
EdgeXtend enables application developers to use model-driven development. The data that an applications requires is visually modeled, using
common tools such as Rational Rose or Eclipse, and EdgeXtend automatically generates all the corresponding classes used to access data within that application. The SQL code is generated dynamically at runtime.
Added: 2004-05-21
Attributes: Built for .NET[BuiltForDotNet]

ObjectMapper .NET

 Home Page Home Page
Categories:
Author: Gerhard StephanSoftwareentwicklung
Latest version: 1.50.1312.0
Description: Persistence framework for Oracle, SQL Server, Access and XML Files.

Features include:
- Extracts the DDL file from the application object model.
- SQL Query API: can be used to build queries independently of the native SQL dialect the actual database is using.
- Virtual Links mapping technique: concept to build views within the business entities. Values of related entities can be joined directly into the object as read-only properties.
- Versioning: adresses database versioning via version attributes on classes and properties. This feature makes it possible to work with different database versions at the same time using the same entity model. The version used at runtime can be selected by the concrete instance of the ObjectMapper .NET.
- Paging: intended for server-side paging, a feature for browsing large collections of data.
- Object localization: a method is propvided to localize value objects for different languages. This is done implicitely during database queries, no additional queries are required.
- The requirements of the framework on the entity model are an interface supported by entity classes and meta information provided as attributes on classes and properties.
- Possible use of typed or self defined collections
- Optimistic concurrency
- Open for custom factory frameworks: instead of hardwiring the creation of objects, it is separated and customizable.
Added: 2006-06-30
Updated: 2007-02-20
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

DomainObjects

 Home Page Home Page
Categories:
Author: Richard Beauchamp
Latest version: 1.1.1
Description: Object to relational database management tool for the .NET 2 platform.

Features include:
- strongly-typed, IntelliSense-assisted queries
- support for partial types, nullable types, generic collections and methods
- attribute-based transaction management
- optimistic concurrency support
- configurable, app-domain-level, object cache
- a tool to automatically reverse-engineer your database schema into an object to relational mapping xml file used by DomainObjects
- a persistable object code generator
- support for SQL Server 2000 and 2005, Oracle 10g and 9i and MySql

Previous name: OJB.NET
Added: 2003-07-25
Updated: 2006-12-27
Attributes: Built for .NET 2[BuilfForDotNet2] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

DataObjects.NET

 Home Page Home Page
Categories:
Author: X-tensive.com
Latest version: 4.0
Description: Database persistence layer for the .NET Framework.
Business logic layer development framework, object-relational mapper and set of storage implementations.

Features include:
- Storage independent data access layer
- Object-relational mapping framework with transparent persistence
- Support for arbitrary Keys, persistent Entities, Structures and EntitySets
- Common services, such as: Validation, Atomicity, Transactional services, Full-text search, Caching
- A set of storage providers allowing you to get rid of SQL databases at all: Memory storage, File system provider, Distributed storage provider
Added: 2003-10-06
Updated: 2009-03-03
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided] Built for Mono[Built for Mono]

TierDeveloper

 Home Page Home Page
Categories:
Author: AlachiSoft
Latest version: 6.1
Description: Object-relational mapping code generation tool.
TierDeveloper also generates custom ASP.NET and Windows Forms applications.

Features include:
- Generates business and data objects
- Supports Ajax, ASP.NET, Windows Forms, Remote web services
- Generates ASP.NET and Windows Forms applications that use the generated middle-tier objects
- Template-based code generation tool, with a template IDE
- Supports round-trip development so you don't lose your code changes
- Object inheritance
- Object binding and updatable datasets
- Supports Form Designer integrated with VS 2005
- Supports VB.NET and C#
- Supports SQL Server 7/2000/2005, Oracle 8i/9i/10g, DB2 7.x/8.1, Access 2000 or later
- Incorporates distributed caching (Ncache)
Added: 2003-05-20
Updated: 2009-01-27
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable]

WilsonORMapper

 Home Page Home Page
Categories:
Author: Paul Wilson
Latest version: 4.2.2.0
Description: Automatically retrieve and persist objects from MS Sql Server, Access, Oracle, etc.
It is based on the syntax of Microsoft ObjectSpaces and it includes the WilsonORHelper to create the XML mapping file and classes. There is no need to inherit your classes from any specific base class, and it also optionally supports the use of stored procedures for persistence. It also includes support for queries and sorting, as well as paged collections.

Features include:
- Composite keys supported.
- Supports one-to-many, many-to-one, and many-to-many relationships.
- Supports optional lazy-loading to minimize reads from the database.
- No need to inherit objects from a base class or embed any attributes.
- Map either member fields or properties, with reflection or interface.
- Mappings are made in one or more XML files.
- Persistence is done with parameterized dynamic SQL.
- Stored procedures can optionally be configured for persistence.
- Retrieve individual objects by primary key.
- Retrieve collections as a static ObjectSet or a cursor ObjectReader.
- GetCollection returns strongly typed collections.
- Retrieve DataSets, optionally specifying a specific subset of fields.
- Query with any where and sort clauses (use SQL or the QueryHelper).
- Build simple expressions with an OPath-like syntax using the QueryHelper.
- Support for .NET 2.0 Generics and Nullable Types.
Added: 2004-01-08
Updated: 2006-01-25
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Source code provided[SourceCodeProvided]

RapTier

 Home Page Home Page
Categories:
Author: SharpPower
Latest version: 1.4.2
Description: Template-based C#, VB.NET, and SQL code generator for multi-tier development.
Key features: Object-Relational Mapping; Generation of WebForm and WinForm UI; Extendable templates; Transactional support; Support of DataTable objects; Data paging; Multi-database support: SQL Server, Access, Oracle, MySQL; Stored procedures generation; .NET data provider independent access.

RapTier is available in three editions: Lite, Professional and Enterprise. The light edition is free.

Previous name: 2LKit nTier Builder.
Added: 2003-06-05
Updated: 2003-11-11
Attributes: Built for .NET[BuiltForDotNet] Free or free version available[FreeVersionAvailable]

CoolStorage.NET

 Home Page Home Page
Categories:
Latest version: 1.2.0
Description: Object-relational mapping library.

Features include:
- Supports SQL Server 2000/2005, MySQL, DB2, Oracle, Access
- Existing relational data models can be mapped to CoolStorage objects
- All relation types are supported: One-To-One, One-To-Many, Many-To-One and Many-To-Many
- Support for transactions, including .NET 2.0 TransactionScope
- Nullable columns can be mapped to .NET 2.0 nullable fields or any other value
- Delayed (lazy) loading
- Database-independent object query language
- Event framework to intercept events
- Identity (auto-increment) keys are supported for all database types
- Composite keys are fully supported, even for object relations
- Sessionless data access
- Pageable object collections
- Collections implement IBindingList so they can be used by controls (grids) as a data source
Added: 2007-06-08
Attributes: Built for .NET 2[BuilfForDotNet2] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

NDO

 Home Page Home Page
Categories:
Author: House of Tools Development
Latest version: 1.2
Description: NET Data Objects (NDO) is a tool for object-relational mapping (O/R-mapping).

Features include:
- Ordinary .NET classes can be made persistent with a custom attribute
- Wizards support code generation for persistent classes, relations and accessor properties
- Integrated query language, syntax is checked by the compiler
- An assembly enhancer provides transparent access to the database
- Reverse mapping tool produces C# classes and mappings from existing databases
- Lazy Loading (on-demand loading) of child objects
- Supports inheritance and polymorphism
- Supports transactions
- Supports distributed applications with serializable object containers
- Based on ADO.NET; any database with an ADO.NET provider can be used
- Ready to run for SQL Server, Oracle, MySql, Access and Firebird; Supports custom providers
- Code generation for the DDL code to build the database tables
- Open architecture for extensions
- Add-in for Visual Studio; command line integration for other IDEs and tools
Added: 2006-11-01
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library] Add-in[AddIn] Free or free version available[FreeVersionAvailable]

Grove

 Home Page Home Page
Categories:
Latest version: 2.1
Description: Object-relational mapping component.

Grove includes:
- Grove Component: an object-oriented develop component that supports multiple databases; It provides support for two-tier, three-tier, or n-tier architectures.
- Grove Toolkit: add-in for Visual Studio that allows previewing entity classes or XML descriptions from the data source, such as single objects or relation objects.
Added: 2004-01-26
Updated: 2006-10-22
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library] Add-in[AddIn] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

Evaluant Universal Storage Services

 Home Page Home Page
Categories:
Author: Evaluant
Latest version: 0.9.1
Description: Evaluant Universal Storage Services (EUSS) is an extensible programming model and runtime components for building data-aware solutions.
With EUSS you can access any type of data (XML, RDBMS, Objects, ...) with the same code.

Features include:
- Object-Relational mapping enabling you to reuse an existing database
- Generic relational datastore
- In-Memory Database (IMDB)
- Remote storage for making distributed applications
- XML-based configuration
- Domain model management using three different techniques: code generation with ability to import major UML case tools files, dynamic Proxy for importing your own domain classes, debuggable Aspect Oriented Programming
- Provider-based architecture
- Cache provider
- RDBMS provider independance
- Visual Studio 2003 and 2005 integration
Added: 2006-09-25
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Add-in[AddIn] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

NHibernate

 Home Page Home Page
Categories:
Latest version: 2.0.0.GA
Description: Object persistence library for relational databases.
NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database. Given an XML description of your entities and relationships, NHibernate automatically generates SQL for loading and storing the objects. Optionally, you can describe your mapping metadata with attributes in your source code.

NHibernate supports transparent persistence, your object classes don't have to follow a restrictive programming model. Persistent classes do not need to implement any interface or inherit from a special base class. This makes it possible to design the business logic using plain .NET (CLR) objects and object-oriented idiom.

Features include:
- Supports natural OO idiom; inheritance, polymorphism, composition and the .NET collections framework
- Support for fine-grained object models: a variety of mappings for collections and dependent objects
- No build-time bytecode enhancement: there's no extra code generation or bytecode processing steps in your build procedure
- The query options: NHibernate addresses both sides of the problem; not only how to get objects into the database, but also how to get them out again
- Support for "conversations": NHibernate supports long-lived persistence contexts, detach/reattach of objects, and takes care of optimistic locking automatically
Added: 2003-05-20
Updated: 2008-08-26
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

GURA Object Director

 Home Page Home Page
Categories:
Author: D2O
Latest version: 2.0
Description: Object-relational mapping tool.
The GURA Object Director takes data from a data source and translates it into any business object. It interacts with the GURA Data Gate to manage the loading, saving and deleting of the data, driven by actions taken on objects.
GURA Object Director comes in two versions: GURA 1 is the variant implementing 1:1 relationships between data source items and business objects. GURA 2 is the variant that implements n:n relationships.

Features include:

Data Translation
- Support for n:n translations between data tables and objects
- Data can be translated from different data sources into the same object or different objects at the same time
- Updates return the data to the data source from which it came from
Translation Rules
- Data translations can be managed at a component or data type level
- Controllable data translations right down to data field specific
- Data translation mapping relationships support same name relationships as well as specific
- Translation criteria allows finer control of data translation
- Translation rules as objects allows inheritance and all object natured features
- Use standard data table keys or define your own in translation rules
General
- Support for SQL and stored procedures
- Data driven object type creation
- Force checking of data availability during updating
- CRUD operations fully customisable and controllable
- Supports OLE DB databases
Added: 2007-12-17
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library]

MyGeneration

 Home Page Home Page
Categories:
Author: MyGeneration Software
Latest version: 1.2.0.6
Description: Generates code from templates by combining a scripting engine with a database meta-data API.

Features include:
- supports SQL Server, Oracle, DB2, MySQL, PostgreSQL, Access, FireBird, Interbase, SQLite and VistaDB.
- can generate O/R mapping files for Gentle.NET, Opf3 and NHibernate.
- template languages supported include C#, VB.NET, JScript, and VBScript.
- templates support include files for reuse.
- each template has an optional user interface code section.
- allows the user to alias the names of tables, views, columns, relationships, etc.
- command line interface provided
- syntax editor with full Unicode support.
- plug-in support allows you to extend functionality to all templates.
Added: 2004-02-11
Updated: 2007-04-17
Attributes: Built for .NET[BuiltForDotNet] Free or free version available[FreeVersionAvailable]

BizBlox

 Home Page Home Page
Categories:
Author: Pixolüt Industries
Latest version: 1.6.0.3
Description: Toolkit for object/relational mapping.

Features include:
- Bundled BizBlox Builder tool reads your SQL Scripts to create your data (entity) classes and finder classes. SQL scripts can be generated from the SQL Server 2000 Enterprise Manager or hand written.
- Code synchronization so you can import changes to your schema back in to the code without affecting your code changes or finder methods.
- Uses ADO.NET with caching techniques.
- Provides support for transactions.
- Query library and built in multi language - multi character-set search engine. No need to write SQL again.
- Includes NUnit test suite source code for validation and code examples.
Added: 2004-10-19
Updated: 2008-06-03
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

SqlTac

 Home Page Home Page
Categories:
Author: Caber Computing
Latest version: 0.106.57
Description: Tool for DBAs and developers that provides database management features and extends LINQ to SQL's SqlMetal.

Features include:
- Analyzes your risk and the cost of a failing to capture your domain knowledge
- Analyzes your database's design
- Compares (diffs) two database schemas
- Optionally corrects problems with your database's design
- Validates all of the SQL used in your stored procedures, views and user defined functions
- Checks the consistency of your database, reporting orphans
- Documents your domain knowledge
- Backups database schemas
- Object-relational mapping (ORM)
- Builds a LINQ to SQL (DLinq) data access layer by improving SQLMetal (Organization of the source code, multiple collapsable regions, emits XML comments)
- Assists in building help files of your domain knowledge
- Supports .NET 3.5 and Visual Studio 2008
- Supports SQL Server 2000, 2005 and 2008 CTP
- Sandcastle Oct. 2007 CTP
Added: 2008-03-06
Attributes: Built for .NET 2[BuilfForDotNet2]

NJDX

 Home Page Home Page
Categories:
Author: Software Tree
Latest version: 1.5
Description: NJDX (.NET Jet Database eXchange) is an object-relational mapping tool

Features include:
- No need to inherit from a base class or implement any special interface
- No static generation of code; dynamic mapping engine
- Declarative mapping
- Object caching
- Support for class hierarchies
- GUI tool that allows interactive development using live data and verifying the mapping
- NJDXStudio: add-In for Visual Studio
- Reverse-engineer an object model from an existing relational schema
- Forward-engineering for schema creation
- Supports SQL Server, Oracle, DB2, MS Access, MySQL, PostgreSQL, InterBase, and OleDB data sources
Added: 2005-11-04
Updated: 2006-04-25
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Add-in[AddIn]

OPF.Net

 Home Page Home Page
Categories:
Latest version: 0.9.01.599
Description: The Object Persistence Framework for .NET (OPF.Net) is a set of classes that implement an object-relational mapping strategy for object oriented access to traditional relational database management systems and other types of persistent storage types such as XML files.
Added: 2003-10-20
Updated: 2004-06-10
Attributes: Built for .NET[BuiltForDotNet] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

OpenAccess

 Home Page Home Page
Categories:
Author: Telerik
Latest version: Q1 2009
Description: Object-relational mapping tool.

Features include:
- Forward and reverse mapping
- Deployment flexibility, Mapping in the middle
- Support for 7 databases
- Support for LINQ, OQL, and SQL languages
- Transparent data access, lazy loading and automatic change tracking
- Visual Studio integration
- Disconnected API
- Synchronized distributed level 2 cache
- Stored procedures support
- Fetch plans
- Flexible concurrency mechanisms
- Support for medium trust environments
- Integration with Telerik Reporting

Previous names: Vanatec OpenAccess and Versant Open Access .NET
Added: 2004-10-20
Updated: 2008-02-22
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

ARBT ORM Framework

 Home Page Home Page
Categories:
Author: ARBT Informatica
Latest version: 1.1
Description: The ARBT ORM (Object-Relational Mapping) Framework works as a library that provides several abstract classes from which business objects should inherit.
By using classes that implement object factory and object broker patterns, the solution's objects can be created with all information necessary to allow the mechanisms. Support classes can be used to store and retrieve instances from relational databases such as SQL Server, Oracle or any ADO.NET compatible server. Objects can be also persisted and retrieved in XML format. The attribute mapping can be done using database views or using XML description files.
Added: 2005-04-19
Attributes: Built for .NET[BuiltForDotNet]

Nolics.net 2005

 Home Page Home Page
Categories:
Author: Nolics
Latest version: 4.2
Description: O/R mapping tool for Visual Studio 2005 that allows developers to build database applications using objects only, using any .NET language.

Features include:
- Use a Domain Specific Language to handle the persistence of objects
- Changes to the object model are made to the classes while the schema is updated automatically (no intermediate mapping files, no mapping tools, and no mandatory embedded SQL)
- Data stored to database in normalized SQL form
- Accesses all data by default through views and stored procedures (CRUD rocedures customizable via XSLT)
- Import existing legacy databases, produce classes from schema
- Heterogenous groups of objects can be handled easily as a single unit
- Datasource model allows to change a datasource into a Web Service
- No base class requirement, Supports full inheritance
- Lazy-loading and optimizing cache
- Full versioning and history journaling
- Supports relation handling
- Supports the identity principle
- Supports data binding for both Windows Forms and ASP.NET
- Supports object level transactions (i.e. the object has an undo state)
- Supports user defined types and SQL Server 2005 UDTs
- Compatible with SQL Server 2000/2005/Express, Oracle 8.1.7 and above
Added: 2005-08-09
Updated: 2007-01-04
Attributes: Built for .NET 2[BuilfForDotNet2] Add-in[AddIn] Free or free version available[FreeVersionAvailable]

Sooda

 Home Page Home Page
Categories:
Latest version: 1.0
Description: Sooda (Simple Object-Oriented Data Access) is an Object-To-Relational Mapping software.
Features include:
- transparent object materialization
- support for any data type supported by the .NET Framework
- mapping of one-to-many relations as referenced objects and collections.
- mapping of many-to-many relations as collections
- various models of object inheritance
- heterogenous data access (including RDBMS, XML files, Web services, LDAP & AD directories)
- differential XML serialization and deserialization for moving data across layers
- optimistic locking and object versioning with collision detection
- support for long running transactions
- data caching with copy-on-write support
Sooda is an open source software distributed under the terms of the BSD license.
Added: 2004-10-02
Updated: 2007-11-26
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

NObject

 Home Page Home Page
Categories:
Author: Macrobject Software
Latest version: 2.0.0.1087
Description: Object-relational mapping framework.

Features include:
- Related Object/ObjectSet lazy-load; Supports field/property lazy-load
- Supports object state rollback
- Strongly-typed queries, Intellisence during editing, syntax check at compile-time
- Supports OQL on object-set
- Template-based code generation tool
Added: 2006-11-08
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library] Source code provided[SourceCodeProvided]

OR.NET

 Home Page Home Page
Categories:
Author: Adam Rackis
Latest version: 5.0
Description: Open source object-relational mapper and code generator.
OR.NET generates a data access layer in stand-alone C# 2.0 after scanning your database’s meta-data.

Features include:
- Creates all relationships based on both simple foreign keys, and many-to-many mapping tables. All identity columns will be found, and treated appropriately for inserts, and all nullable fields will be created as nullable properties in code.
- Transparently manages all foreign key relationships, and many-to-many relationships for you.
- In addition to automatic class structure generation, you can also manually create and modify classes by specifying which columns represents the key, which columns to create properties out of, and which other objects the new class links to, either through a foreign key, or a many-to-many mapping table – all through a GUI.
- The classes generated are database independent, with all data-access happening through generated assembler classes.
- All SQL commands are fully parameterized, and therefore resistant to injection attacks, and also slightly better performing due to SQL Server’s caching of execution plans.
Added: 2008-01-26
Attributes: Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

DataBlock

 Home Page Home Page
Categories:
Author: voidsoft
Latest version: 1.3.1
Description: Data Access and Object Relational Mapping framework.
DataBlock generates a complete layer (with suppport for CRUD operations and transactions) for your database entities.

Features include:
- Database independent code
- Supports C# and VB.NET
- Supports 1:1, 1:m and m:m relations with insert, delete and update cascade operations and lazy loading
- GUI code generation tool
- No external mapping files
- Support for stored procedures
- Support for SQL Server 7/2000, MS Access 97/2000/XP/2003, MySql 4.x and PostgreSQL
Added: 2004-12-14
Updated: 2007-01-12
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

Vanilla DAL

 Home Page Home Page
Categories:
Latest version: 0.2.2
Description: Data-access framework for RDBMS on top of ADO.NET.

Features include:
- Database independence
- SQL externalization via XML
- Automatic transaction management
- On-the-fly SQL generation for DataSets
- Convenience implementations for ever recurring tasks
Added: 2006-11-14
Attributes: Built for .NET[BuiltForDotNet] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

Habanero

 Home Page Home Page
Categories:
Author: Chillisoft Solutions
Latest version: 2.0.0
Description: Enterprise Application Framework that provides the tools to produce an application from the data layer through to the front-end.
Released as free open source under the LGPL license, Habanero persists data to and from the database using object relational mapping (ORM), manages business objects to support a rich domain model, and generates user interfaces to display and edit the mapped data.

Features include:
- ORM: Map database tables to objects in code
- Persist property values to and from the database
- Define all mapping in a single XML file
- Switch between database vendors with one setting
- Support for MySQL, SQL Server, MS Access, Oracle, PostgreSQL, SQLite, Firebird
- FireStarter GUI class definitions xml manager
- Generate user interfaces and map properties to controls
- Develop for both desktop (with Windows Forms) and web (with Gizmox' Visual WebGUI)
- Generate new projects and code files
- Reverse engineer class definitions from existing databases
- Support variable data sources, including an in-memory database
Added: 2007-09-05
Updated: 2008-10-07
Attributes: Built for .NET 2[BuilfForDotNet2] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

Genome

 Home Page Home Page
Categories:
Author: TechTalk
Latest version: 3.3.7
Description: Object relational mapping framework.
Genome allows mapping behavior and persistent information of any .NET class in a relational database.

Features include:
- Object Query Language providing decomposition possibilities and type safety
- XML-based schema definition language for mapping
- Support for aspect-oriented programming methodology
- Allows declarative transaction management
- Database-level foreign key constraints
- Object level optimistic locking through rowversion field in the database and pessimistic locking managed by an application server.
- In-memory indexing of complex queries
- Database reverse engineering wizard
- Support for integrating custom written stored procedures
- Generates customized data access implementation as a post build step
- Extensible through APIs
- ASP.NET data binding integration
- LINQ integration
- Integration with Visual Studio 2003, 2005 and 2008
- Supports SQL Server 2000 and 2005, Oracle 9i and 10g, IBM DB2

Genome comes in the following editions: Professional, Express, Community.
Added: 2004-05-24
Updated: 2007-12-17
Attributes: Built for .NET 2[BuilfForDotNet2] Add-in[AddIn] Free or free version available[FreeVersionAvailable]

Diamond Binding

 Home Page Home Page
Categories:
Author: Dunn & Churchill
Latest version: 1.2.1.3
Description: Data layer tool for Visual Studio 2005, and SQL Server.

Diamond Binding provides an add-in for Visual Studio 2005 that allows selection of tables from your SQL Server 2000+ database to be available in code following the Active Record pattern. It keeps the definitions of mapped objects synchronised in partial classes (similar to the form designer) with little generated code.
The API provided by the Diamond Binding runtime supports CRUD operations on objects, relationships, complex and simple queries, lazy loading, cascades and more. Diamond Binding supports generics, so all interactions with your data layer occur in a type-safe fashion. Schema changes are then found at compile time, rather than deployment.
Added: 2007-10-29
Attributes: Built for .NET 2[BuilfForDotNet2] Library[Library] Add-in[AddIn] Free or free version available[FreeVersionAvailable]

Castle Project

 Home Page Home Page
Categories:
Latest version: 1.0 RC 3
Description: Framework that aspires to simplify the development of enterprise and web applications. Castle offers a set of tools (working together or independently) and integration with other open source projects.

Features include:
- Rapid web application development: MonoRail, an MVC web framework inspired by Ruby on Rails' Action Pack.
- Object-relational database mapping: ActiveRecord, a data mapping pattern implemented using NHibernate; ActiveRecord Generator, a desktop application to generate ActiveRecord classes based on database schemas.
- Inversion of control containers: MicroKernel/Windsor Container.
- Proxy generator for interfaces and classes: DynamicProxy.
- AOP framework based on dynamic proxies and XML configuration files: Aspect#.
- Visual Studio 2003/2005 integration.
Added: 2006-01-08
Updated: 2007-10-11
Attributes: Built for .NET 2[BuilfForDotNet2] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided] Built for Mono[Built for Mono]

Persistent Datasets

 Home Page Home Page
Categories:
Author: The Last Component
Latest version: 2.0.3
Description: O/R mapper and persistence layer generator based on the native DataSets with integrated native queries engine.

Features include:
- Allows writing 100% typed code using typed queries technology similar to DLINQ
- Supports DataSets and Domain Objects patterns.
- Mapping to tables, views, and stored procedures including procedure’s result sets
- Keeps your application code synchronized with database modifications
- Offers n-tier workflow including GUI binding
- Supports database identities, sequence generators
- Optimistic concurrency using database timestamps and locking fields
- Visual Studio integration including SourceSafe support
- Transactions
- Generating enumerations for basic tables
- Nullable generics support
- Inheritance
- Cascade load, save, update, delete and insert of hierarchical data
- SQL Server, Oracle support
- C#, VB support
- Cache by query
- Clustered cache
- ASP paging support
- DataSets inheritance
Added: 2005-09-13
Updated: 2006-10-21
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library] Add-in[AddIn] Source code provided[SourceCodeProvided]

POTIS Object-Relational Toolkit

 Home Page Home Page
Categories:
Author: POTIS
Latest version: 1.5
Description: O/R mapping tool for automatic translation of data between business object model and relational database.
PORT uses an XML schema to store the information about mappings between your application and the structure of a database, that will store the application's data. A graphical has been delivered to assist the whole process of mapping.
Added: 2004-01-22
Attributes: Built for .NET[BuiltForDotNet]

eXpress Persistent Objects for .NET

 Home Page Home Page
Categories:
Author: Developer Express
Latest version: 2007 vol 2
Description: Abstracts the database layer from a developer, leaving him or her fully in the object-oriented realm. With XPO, you can build applications that are compatible with multiple database systems without making any changes to your code.

Features include:
- Transparent and controllable object-relational mapping system
- Persistent class generation
- Bindable and pageable object collections
- Object queries
- Support for existing database schemas
- Database generation and updates
- Shareable stateless data access layer (DAL)
- Add persistence to existing inheritance hierarchies via interfaces
- XML model with custom attributes
- Delayed loading for object properties
- Transaction support
- Optimistic locking
- Support for SQL Server, Access, MySQL, Oracle, PostgreSQL, Firebird, PervasiveSQL, VistaDB, SQL Anywhere, Advantage, DB2, Sybase, SQLite
Added: 2003-09-23
Updated: 2007-08-27
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library] Source code provided[SourceCodeProvided]

DADO Solution

 Home Page Home Page
Categories:
Author: David Pizzi
Latest version: 1.1
Description: Framework for object-relational mapping and application server with support for distributed/replicated databases and distributed transactions.
Includes DADO Database Mapper, DADO Application Server and DADO Broker System.
Added: 2003-12-01
Attributes: Built for .NET[BuiltForDotNet] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

ODX.NET

 Home Page Home Page
Categories:
Latest version: 1.6.1
Description: Object-relational mapping library.

Features include:
- Inheritance (both single table & multiple table patterns) and polymorphism
- 1:N, N:N relationships, with integrity control
- Lazy loading
- Client entity cache
- Offline mode support (Multiple server connection support; Merging data sources; Constraint conflicts resolution)
- Flexible event model
- Save points and persistent snapshots
- Full .NET Remoting support
- On-the-fly proxy generation
- Transactions and optimistic concurrency
- XML data source with support for concurent access
- Supports OLEDB, ODBC, etc. Tested on ORACLE, PostgreSQL, MS Access, MS SQL Server CE.
- Data replication algorithm including constraint handling
- Paging
- Custom SQL selects
- SQL injection protection
Added: 2008-08-02
Attributes: Built for .NET 2[BuilfForDotNet2] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

LightSpeed

 Home Page Home Page
Categories:
Author: Mindscape
Latest version: 2.1
Description: Convention-over-configuration based domain model framework.
LightSpeed employs patterns from domain-driven design such as Repository, Unit of Work and Value Object.

Features include:
- Convention over configuration: no mapping files and minimal attributes
- Supports idiomatic .NET domain models: Validation, data binding, property change notification
- Uses LCG instead of reflection and smart query batching for performance
- Employs best practice patterns: Session-per-request, Unit of Work, etc.
- Supports caching including memcached
- Supports single table inheritance, value objects, generics, nullable types, optimistic concurrency and System.Transactions
- Database support for SQL Server, SQL Server Compact, Oracle, MySQL, PostgreSQL, SQLite, VistaDB and Firebird
- Full LINQ support to all supported databases
- Designed with testability in mind
- Soft Delete so that data is never deleted, just marked as deleted
- Polymorphic querying: querying types in your inheritance hierarchy made easier
- Support for nested units of work
- Debug Visualizer to aid generated SQL inspection
- Support for projections
- Visual Studio 2008 designer for modeling entities with database round tripping support

A free express version of LightSpeed is available.
Added: 2007-10-03
Updated: 2009-01-26
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

DevForce

 Home Page Home Page
Categories:
Author: IdeaBlade
Latest version: 3.5
Description: Framework and integrated suite of RAD tools for the development and deployment of .NET applications.
DevForce extends .NET with class libraries, components, RAD tools and a business object server.

Features include:
- Object-relational mapping
- Persistence management
- Declarative UI databinding
- Visual Studio RAD tools
- Business object server
- Business rules validation engine
- Integration into Visual Studio 2005

A free version is available: DevForce Express
Added: 2005-12-14
Updated: 2007-04-04
Attributes: Built for .NET 2[BuilfForDotNet2] Library[Library] Add-in[AddIn] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

Dali

 Home Page Home Page
Categories:
Author: Revelation Technologies
Latest version: 2.2
Description: Object-relational mapper and data access layer.
Dali is self-configuring, analyzing your database and object model and dynamically creating all necessary SQL. Dali can use existing business objects with little or no modification. Or, the included Dali Studio GUI utility can automatically generate data class code and stored procedures appropriate for your data model.

Features include:
- Supports stored procedures and parameterized queries
- Supports deep loading and saving of nested objects
- Supports generics for type safety; Supports .NET nullable types
- Supports saving and loading Web Forms directly
- Can use existing business objects
- No mapping files to get out-of-sync
- No SQL, OQL, IQL or other languages to learn
- No code generation or reverse engineering required
- Able to use a DataSet as a data store
- Raises events when objects are loaded or updated
Added: 2004-12-21
Updated: 2006-12-05
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Library[Library]

Lattice.DataMapper

 Home Page Home Page
Categories:
Author: Lattice Business Software International
Latest version: 3.0
Description: 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.
Lattice.DataMapper 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.

Features include:
- Support for different data providers and multiple data sources
- Supports object pre-fetch (one-to-one, one-to-many, many-to-many relationships)
- 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)
- Supports .NET 2.0 generics and nullable value types
- Logging and error handling using Log4net
- Support distributed transactions without deriving from 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.
Added: 2004-11-16
Updated: 2006-09-25
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable]

Nolics.net

 Home Page Home Page
Categories:
Author: Nolics
Latest version: 2005 4.3 Alpha
Description: Object-relational mapping tool.
The basic idea of Nolics.net is that the class definition is marked with attributes signaling that the objects inherited from that class are to be automatically stored into and retrieved from a database. Nolics.net provides for the automatic persistence of the classes. The members of the class are filled with data by automatically generated SQL statements and likewise, the updated objects are automatically saved into the database.
Added: 2003-09-28
Updated: 2004-07-22
Attributes: Built for .NET[BuiltForDotNet] Library[Library] Add-in[AddIn]

Opf3

 Home Page Home Page
Categories:
Author: Chili Software
Latest version: 3.0.4.341
Description: Object Persistent Framework for the .NET 2.0 platform.

Features include:
- Storage independence
- AutoIncrement values for Identifier (primary keys).
- Create relations between your objects by setting one custom attribute.
- Create the mapping between your object and the entity or fields in the storage by using simple attributes. No writing of queries to save, load, delete persistent is required.
- Concurrency checks on plugin basis.
- Store the result of your query in an IList.
- Events for each operation on your persistent objects.
- ItemSearcher to get objects from the storage.
- Supports SQL Server, Oracle, Access, PostgreSQL, PervasiveSQL, VistaDB.
Added: 2004-12-07
Attributes: Built for .NET 2[BuilfForDotNet2] Source code provided[SourceCodeProvided]

.NetTiers

 Home Page Home Page
Categories:
Author: John Roland
Latest version: 2.3.0 Beta 2
Description: CodeSmith templates for object-relational mapping that takes an existing SQL Server or Oracle database and generates a personnalized data-access layer to use in your applications.

Features include:
- Generates ready-to-use Visual Studio projects and solution
- Integrates with the Entreprise Library application blocks architecture
- Shipped with it's own plugin, so you can configure your application directly from the entlib configuration console
- Generates business entities with a 1:1 mapping (an entity for each table or view, with a property for each column)
- Generates Data Access Layer Components (DALC) for tables and views
- Generate strongly-typed collections for entities and repositories, supporting databinding.
- Creates an ASP.NET web service for distributed programming
- Create the stored procedures script and can automatically install them on the server
- Generates a NAnt build file, to compile, test and generate chm/html API documentation
Added: 2006-03-21
Updated: 2008-12-08
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

Neo

 Home Page Home Page
Categories:
Latest version: 1.3.1
Description: Neo (.NET Entity Objects) is a framework that provides an object facade for ADO.NET to the application developer. It includes tools to create the database schema from the object model and provides schema information at runtime allowing it to dynamically generate all SQL required for object persistence management. At the same time, much like ADO.NET DataSets, it is independent of the actual backing store and works equally well with objects transmitted in an XML representation.
Added: 2004-01-20
Updated: 2005-02-23
Attributes: Built for .NET[BuiltForDotNet] Library[Library] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]

SubSonic

 Home Page Home Page
Categories:
Latest version: 2.0.3
Description: Toolset that helps a website build itself.

SubSonic's core is:
- A Data Access Layer (DAL) builder that requires no code on your part. It builds itself at compile-time with a full object layer and strongly-typed collections.
- A utility toolset, with Rails-like scaffolding, migrations (DB Versioning), and code generators.
- A dynamic query tool, that lets you use SQL Server and the Enterprise Library without having to know SQL.
- An O/R mapper that extends to views and stored procedures.

Added: 2007-04-10
Updated: 2007-09-15
Attributes: Built for .NET[BuiltForDotNet] Built for .NET 2[BuilfForDotNet2] Free or free version available[FreeVersionAvailable] Source code provided[SourceCodeProvided]
Ignore this
Advertise here! Contact us to know the options
Help the .NET community get a consensus on great tools. Display your favorite tools on your own website or on your blog.
Keep track of your favorite tools. Build your personal watch list.
Advertise here! Contact us to know the options
Web site previews powered by WebSnapr
Hosted by WebHost4Life.com - Please use this Sponsor ID: madgeek - Thanks!
part of the metaSapiens network: metaSapiens | .NET Jobs | Fabrice's weblog | .NET tools | Java tools | Dynamics AX tools | LINQ book | MapShares | BD indépendante