Object-relational mapping

Persistor.NET

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

Free or free version available

Add to my favorites[NEW]

Retina.NET

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 2

Free or free version available

Source code provided

Add to my favorites[NEW]

LightSpeed

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 2

Free or free version available

Source code provided

Add to my favorites[NEW]

Vanilla DAL

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

Library

Free or free version available

Source code provided

Add to my favorites[NEW]

Nolics.net 2005

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

Add-in

Free or free version available

Add to my favorites[NEW]

Dali

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 2

Library

Add to my favorites[NEW]

SqlTac

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

Free or free version available

Add to my favorites[NEW]

RapTier

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

Free or free version available

Add to my favorites[NEW]

Nolics.net

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

Library

Add-in

Add to my favorites[NEW]

Persistent Datasets

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 2

Library

Add-in

Source code provided

Add to my favorites[NEW]

Diamond Binding

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

Library

Add-in

Free or free version available

Add to my favorites[NEW]

OR.NET

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

Free or free version available

Source code provided

Add to my favorites[NEW]

Opf3

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

Source code provided

Add to my favorites[NEW]

ObjectMapper .NET

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 2

Library

Free or free version available

Source code provided

Add to my favorites[NEW]

NHibernate

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 2

Free or free version available

Source code provided

Add to my favorites[NEW]

SubSonic

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 2

Free or free version available

Source code provided

Add to my favorites[NEW]

NHibernate Profiler

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

Add to my favorites[NEW]

NJDX

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 2

Add-in

Add to my favorites[NEW]

Visual NHibernate

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

Add to my favorites[NEW]

Gentle.NET

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 Mono

Library

Free or free version available

Source code provided

Add to my favorites[NEW]

ODX.NET

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

Library

Free or free version available

Source code provided

Add to my favorites[NEW]

DevForce

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

Library

Add-in

Free or free version available

Source code provided

Add to my favorites[NEW]

Castle Project

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 Mono

Library

Free or free version available

Source code provided

Add to my favorites[NEW]

TierDeveloper

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 2

Free or free version available

Add to my favorites[NEW]

Evaluant Universal Storage Services

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 2

Add-in

Free or free version available

Source code provided

Add to my favorites[NEW]

BizBlox

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 2

Free or free version available

Source code provided

Add to my favorites[NEW]