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

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
Built for the Compact Framework
Free or free version available
Built for .NET 2
Built for Mono
Source code provided
Built for .NET 4
Library
Sold as a service
Built for Silverlight
Add-in
Discontinued

LLBLGen Pro

 Home Page Home Page

Categories: Object-relational mapping

Author: Solutions Design

Latest version: 3.0
Added 2003-09-08Updated 2010-06-18

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:
- Designer supports Entity Framework (v1 & v4), NHibernate (hbm & FluentNH), LINQ to SQL
- Supports Model-first and Database-first development
- 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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Built for .NET 4
Built for .NET 4
Built for the Compact Framework
Built for the Compact Framework
Source code provided
Source code provided

Genome

 Home Page Home Page

Categories: Object-relational mapping

Author: TechTalk

Latest version: 3.3.7
Added 2004-05-24Updated 2007-12-17

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.

Built for .NET 2
Built for .NET 2
Add-in
Add-in
Free or free version available
Free or free version available

POTIS Object-Relational Toolkit

 Home Page Home Page

Categories: Object-relational mapping

Author: POTIS

Latest version: 1.5
Added 2004-01-22

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.

Built for .NET
Built for .NET

OR.NET

 Home Page Home Page

Categories: Object-relational mapping

Author: Adam Rackis

Latest version: 5.0
Added 2008-01-26

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.

Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

Vanilla DAL

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Latest version: 0.2.2
Added 2006-11-14

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

Built for .NET
Built for .NET
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

NObject

 Home Page Home Page

Categories: Object-relational mapping

Author: Macrobject Software

Latest version: 2.0.0.1087
Added 2006-11-08

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Source code provided
Source code provided

Lattice.DataMapper

 Home Page Home Page

Categories: Object-relational mapping

Author: Lattice Business Software International

Latest version: 3.0
Added 2004-11-16Updated 2006-09-25

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.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available

Evaluant Universal Storage Services

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: Evaluant

Latest version: 0.9.1
Added 2006-09-25

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Add-in
Add-in
Free or free version available
Free or free version available
Source code provided
Source code provided

Habanero

 Home Page Home Page

Categories: Object-relational mapping, RAD - Dev automation

Author: Chillisoft Solutions

Latest version: 2.0.0
Added 2007-09-05Updated 2008-10-07

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

Built for .NET 2
Built for .NET 2
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

CoolStorage.NET

 Home Page Home Page

Categories: Object-relational mapping

Latest version: 1.2.0
Added 2007-06-08

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

Built for .NET 2
Built for .NET 2
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

DataObjects.NET

 Home Page Home Page

Categories: Object-relational mapping

Author: X-tensive.com

Latest version: 4.0
Added 2003-10-06Updated 2009-03-03

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Built for Mono
Built for Mono
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

OpenAccess

 Home Page Home Page

Categories: Object-relational mapping

Author: Telerik

Latest version: Q2 2009
Added 2004-10-20Updated 2009-10-28

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

Persistent Datasets

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: The Last Component

Latest version: 2.0.3
Added 2005-09-13Updated 2006-10-21

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Add-in
Add-in
Source code provided
Source code provided

EdgeXtend for C#

 Home Page Home Page

Categories: Object-relational mapping

Author: Persistence Software

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.

Built for .NET
Built for .NET

Entity Framework Profiler

 Home Page Home Page

Categories: Object-relational mapping, Profiling - Debugging

Author: Hibernating Rhinos

Latest version: Beta
Added 2009-12-17

Entity Framework Profiler (EF Prof) is a real-time visual debugger for Entity Framework.

Features include:
- Visual insight into the interaction between your database and application code
- Analysis and detection of common pitfalls when using Entity Framework
- Analysis is delivered via SQL and linkable code execution
- Supports .NET 3.5 and .NET 4.0

Built for .NET 2
Built for .NET 2
Built for .NET 4
Built for .NET 4

DomainObjects

 Home Page Home Page

Categories: Object-relational mapping

Author: Richard Beauchamp

Latest version: 1.1.1
Added 2003-07-25Updated 2006-12-27

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

Built for .NET 2
Built for .NET 2
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

Retina.NET

 Home Page Home Page

Categories: Object-relational mapping

Author: Andrés Vettori

Latest version: 2.0
Added 2004-08-04Updated 2008-05-31

Open source object-relational mapping tool.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

.NetTiers

 Home Page Home Page

Categories: Code generation, Object-relational mapping, Persistence - Data-tier

Author: John Roland

Latest version: 2.3.0 Beta 2
Added 2006-03-21Updated 2008-12-08

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

BizBlox

 Home Page Home Page

Categories: Object-relational mapping

Author: Pixolüt Industries

Latest version: 1.6.0.3
Added 2004-10-19Updated 2008-06-03

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.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

Nolics.net

 Home Page Home Page

Categories: Object-relational mapping

Author: Nolics

Latest version: 2005 4.3 Alpha
Added 2003-09-28Updated 2004-07-22

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.

Built for .NET
Built for .NET
Library
Library
Add-in
Add-in

ObjectMapper .NET

 Home Page Home Page

Categories: Object-relational mapping

Author: Gerhard StephanSoftwareentwicklung

Latest version: 1.50.1312.0
Added 2006-06-30Updated 2007-02-20

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.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

OPF.Net

 Home Page Home Page

Categories: Object-relational mapping

Latest version: 0.9.01.599
Added 2003-10-20Updated 2004-06-10

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.

Built for .NET
Built for .NET
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

Dali

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: Revelation Technologies

Latest version: 2.2
Added 2004-12-21Updated 2006-12-05

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library

Grove

 Home Page Home Page

Categories: Object-relational mapping

Latest version: 2.1
Added 2004-01-26Updated 2006-10-22

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.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Add-in
Add-in
Free or free version available
Free or free version available
Source code provided
Source code provided

NDO

 Home Page Home Page

Categories: Object-relational mapping

Author: House of Tools Development

Latest version: 1.2
Added 2006-11-01

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Add-in
Add-in
Free or free version available
Free or free version available

Opf3

 Home Page Home Page

Categories: Object-relational mapping

Author: Chili Software

Latest version: 3.0.4.341
Added 2004-12-07

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.

Built for .NET 2
Built for .NET 2
Source code provided
Source code provided

Castle Project

 Home Page Home Page

Categories: AOP, Frameworks, Inversion of Control, Miscellaneous, Object-relational mapping

Latest version: 1.0 RC 3
Added 2006-01-08Updated 2007-10-11

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.

Built for .NET 2
Built for .NET 2
Built for Mono
Built for Mono
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

MyGeneration

 Home Page Home Page

Categories: Code generation, Object-relational mapping, Persistence - Data-tier

Author: MyGeneration Software

Latest version: 1.2.0.6
Added 2004-02-11Updated 2007-04-17

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.

Built for .NET
Built for .NET
Free or free version available
Free or free version available

GenWise Studio

 Home Page Home Page

Categories: Code generation, Object-relational mapping, RAD - Dev automation

Author: GenWise

Latest version: 1.09
Added 2006-01-03Updated 2007-05-15

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

Built for .NET 2
Built for .NET 2

GURA Object Director

 Home Page Home Page

Categories: Object-relational mapping

Author: D2O

Latest version: 2.0
Added 2007-12-17

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library

Nolics.net 2005

 Home Page Home Page

Categories: Object-relational mapping

Author: Nolics

Latest version: 4.2
Added 2005-08-09Updated 2007-01-04

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

Built for .NET 2
Built for .NET 2
Add-in
Add-in
Free or free version available
Free or free version available

Sooda

 Home Page Home Page

Categories: Object-relational mapping

Latest version: 1.0
Added 2004-10-02Updated 2007-11-26

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.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

Persistor.NET

 Home Page Home Page

Categories: Object-relational mapping

Author: 2Top Software Engineering

Latest version: 1.5
Added 2006-05-19Updated 2008-05-20

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.

Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available

RapTier

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: SharpPower

Latest version: 1.4.2
Added 2003-06-05Updated 2003-11-11

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.

Built for .NET
Built for .NET
Free or free version available
Free or free version available

DADO Solution

 Home Page Home Page

Categories: Object-relational mapping

Author: David Pizzi

Latest version: 1.1
Added 2003-12-01

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.

Built for .NET
Built for .NET
Free or free version available
Free or free version available
Source code provided
Source code provided

eXpress Persistent Objects for .NET

 Home Page Home Page

Categories: Object-relational mapping

Author: Developer Express

Latest version: 2007 vol 2
Added 2003-09-23Updated 2007-08-27

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Library
Library
Source code provided
Source code provided

Neo

 Home Page Home Page

Categories: Object-relational mapping

Latest version: 1.3.1
Added 2004-01-20Updated 2005-02-23

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.

Built for .NET
Built for .NET
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

DataBlock

 Home Page Home Page

Categories: Object-relational mapping

Author: voidsoft

Latest version: 1.3.1
Added 2004-12-14Updated 2007-01-12

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

SqlTac

 Home Page Home Page

Categories: Database management, LINQ, Object-relational mapping

Author: Caber Computing

Latest version: 0.315.67
Added 2008-03-06

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

Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available

ARBT ORM Framework

 Home Page Home Page

Categories: Object-relational mapping

Author: ARBT Informatica

Latest version: 1.1
Added 2005-04-19

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.

Built for .NET
Built for .NET

Linq to Sql Profiler

 Home Page Home Page

Categories: Object-relational mapping, Profiling - Debugging

Author: Hibernating Rhinos

Latest version: Beta
Added 2009-12-17

Linq to Sql Profiler (L2S Prof) is a real-time visual debugger for LINQ to SQL.

Features include:
- Visual insight into the interaction between your database and application code
- Analysis and detection of common pitfalls when using LINQ to SQL
- Analysis is delivered via SQL and linkable code execution
- Supports .NET 3.5 and .NET 4.0

Built for .NET 2
Built for .NET 2
Built for .NET 4
Built for .NET 4

Diamond Binding

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: Dunn & Churchill

Latest version: 1.2.1.3
Added 2007-10-29

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.

Built for .NET 2
Built for .NET 2
Library
Library
Add-in
Add-in
Free or free version available
Free or free version available

ODX.NET

 Home Page Home Page

Categories: Object-relational mapping

Latest version: 1.6.1
Added 2008-08-02

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

Built for .NET 2
Built for .NET 2
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

DevForce

 Home Page Home Page

Categories: Frameworks, Object-relational mapping, RAD - Dev automation, Web Services - Remoting - WCF

Author: IdeaBlade

Latest version: 3.5
Added 2005-12-14Updated 2007-04-04

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

Built for .NET 2
Built for .NET 2
Library
Library
Add-in
Add-in
Free or free version available
Free or free version available
Source code provided
Source code provided

SubSonic

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier, RAD - Dev automation

Latest version: 2.0.3
Added 2007-04-10Updated 2007-09-15

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.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

NJDX

 Home Page Home Page

Categories: Object-relational mapping

Author: Software Tree

Latest version: 1.5
Added 2005-11-04Updated 2006-04-25

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Add-in
Add-in

NHibernate

 Home Page Home Page

Categories: Object-relational mapping

Latest version: 2.0.0.GA
Added 2003-05-20Updated 2008-08-26

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

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

WilsonORMapper

 Home Page Home Page

Categories: Object-relational mapping

Author: Paul Wilson

Latest version: 4.2.2.0
Added 2004-01-08Updated 2006-01-25

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.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Source code provided
Source code provided

TierDeveloper

 Home Page Home Page

Categories: Object-relational mapping, RAD - Dev automation

Author: AlachiSoft

Latest version: 6.1
Added 2003-05-20Updated 2009-01-27

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)

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available

NHibernate Profiler

 Home Page Home Page

Categories: Object-relational mapping, Profiling - Debugging

Author: Hibernating Rhinos

Latest version: 1.0
Added 2009-12-17

NHibernate Profiler (NH Prof) is a real-time visual debugger for NHibernate.

Features include:
- Visual insight into the interaction between your database and application code
- Analysis and detection of common pitfalls when using NHibernate
- Analysis is delivered via SQL and linkable code execution
- Supports NHibernate 1.2.x, 2.0.x and 2.1.x

Built for .NET 2
Built for .NET 2

Gentle.NET

 Home Page Home Page

Categories: Object-relational mapping, Persistence - Data-tier

Author: Morten Mertner

Latest version: 1.2.9
Added 2004-02-06Updated 2005-02-22

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.

Built for .NET
Built for .NET
Built for Mono
Built for Mono
Library
Library
Free or free version available
Free or free version available
Source code provided
Source code provided

LightSpeed

 Home Page Home Page

Categories: Object-relational mapping

Author: Mindscape

Latest version: 2.1
Added 2007-10-03Updated 2009-01-26

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.

Built for .NET
Built for .NET
Built for .NET 2
Built for .NET 2
Free or free version available
Free or free version available
Source code provided
Source code provided

Visual NHibernate

 Home Page Home Page

Categories: Object-relational mapping

Author: Slyce Software

Latest version: 2.2.10.1099
Added 2009-12-04Updated 2010-04-23

Visual designer and mapping tool for creating and editing NHibernate projects.

Features include:
- Allows you to start from existing database, existing NHibernate project (source code), or new blank project
- Supports all of NHibernate's mapping scenarios: Single entity to single database table, Single entity to multiple database tables, and Single table to multiple entities
- Supports all NHibernate collection types: Sets, Bags, Lists, and Maps
- Supported mapping types: one-to-one, one-to-many, many-to-many
- Mappings can be: unidirectional, bidirectional
- Inheritance Designer
- Inheritance designer that supports all the strategies that NHibernate supports: Table per concrete class, Table per class hierarchy, and Table per subclass
- Allows you to add virtual relationships, rename tables, and rename columns
- Supports multiple databases in a project
- Supported databases: SQL Server 2005/2008/CE/Express, Oracle, MySQL, PostgreSQL, Firebird
- Also supports Components

Built for .NET 2
Built for .NET 2
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
Discontinued tools
Hosted by Arvixe
part of the metaSapiens network: metaSapiens | .NET Jobs | Fabrice's weblog | .NET tools | Java tools | Tuneo | LINQ book | MapShares | BD indépendante | Parking partagé