List of object-relational mapping software

This is a list of well-known object-relational mapping

Object-relational mapping

Object-relational mapping in computer software is a programming technique for converting data between incompatible type systems in object-oriented programming languages. This creates, in effect, a "virtual object database" that can be used from within the programming language...

software. It is not up-to-date or all-inclusive.

C++

style="font-size: 1.25em;" |
Name	Open source Open source The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...	License	Qt support	Boost support	MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... support	PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... support	SQLite SQLite SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard... support	XML XML Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards.... support	Oracle Oracle database The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation.... support	MSSQL Server Microsoft SQL Server Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network... support	ODBC support	IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... support
LiteSQL LiteSQL LiteSQL is an open-source C++ Object Relational Mapping persistence library for UNIXes, Mac OSX and Windows with support for SQLite3, PostgreSQL and MySQL as backends....		BSD BSD licenses BSD licenses are a family of permissive free software licenses. The original license was used for the Berkeley Software Distribution , a Unix-like operating system after which it is named....
ODB ODB (C++) ODB is an object-relational mapping system for the C++ language. It allows an application developer to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any mapping code...		GPL GNU General Public License The GNU General Public License is the most widely used free software license, originally written by Richard Stallman for the GNU Project.... /other
QxOrm		LGPL GNU Lesser General Public License The GNU Lesser General Public License or LGPL is a free software license published by the Free Software Foundation . It was designed as a compromise between the strong-copyleft GNU General Public License or GPL and permissive licenses such as the BSD licenses and the MIT License...
Wt::Dbo Wt - Web toolkit Wt is an open source widget-centric web application framework for the C++ programming language developed by Emweb. It has an API that resembles the C++ desktop application library Qt, using also a widget tree and event-driven signal/slot programming model....		GPL GNU General Public License The GNU General Public License is the most widely used free software license, originally written by Richard Stallman for the GNU Project.... / commercial

Java

Cayenne
Apache Cayenne
Apache Cayenne is an open source persistence framework licensed under the Apache License, providing object-relational mapping and remoting services. Cayenne binds one or more database schemas directly to Java objects, managing atomic commit and rollbacks, SQL generation, joins, sequences, and more...

, Apache
Apache Software Foundation
The Apache Software Foundation is a non-profit corporation to support Apache software projects, including the Apache HTTP Server. The ASF was formed from the Apache Group and incorporated in Delaware, U.S., in June 1999.The Apache Software Foundation is a decentralized community of developers...

, open source for Java
Kodo
Apache OpenJPA
OpenJPA is an open source implementation of the Java Persistence API specification. It is an object-relational mapping solution for the Java language, which simplifies storing objects in databases. It is open source software distributed under the Apache 2.0 Licence.- History :Kodo, a Java Data...

, commercial implementation of both Java Data Objects
Java Data Objects
Java Data Objects is a specification of Java object persistence. One of its features is a transparency of the persistent services to the domain model. JDO persistent objects are ordinary Java programming language classes ; there's no requirement for them to implement certain interfaces or extend...

and Java Persistence API
Java Persistence API
The Java Persistence API, sometimes referred to as JPA, is a Java programming language framework managing relational data in applications using Java Platform, Standard Edition and Java Platform, Enterprise Edition....
Torque
Apache Torque
Apache Torque is a sub project of the Apache Software Foundation Database Project. It is an object-relational mapper for Java. Torque lets you access and manipulate data in a relational database using Java objects...

, an object-relational mapper for Java
Athena Framework
Athena Framework
The Athena Framework is an open source application framework for Java platform. Additionally, it supports remoting to Adobe Flex.Since 2008, Jack Li and other developers at AthenaSource have been developing quite a number of cloud SaaS applications for their clients...

, open source Java ORM, native support for multitenancy SaaS and remoting to Adobe Flex
Adobe Flex
Adobe Flex is a software development kit released by Adobe Systems for the development and deployment of cross-platform rich Internet applications based on the Adobe Flash platform...
Carbonado
Carbonado (Java)
Carbonado is an open source relational database mapping framework, written in Java. Rather than following a typical O/R mapping approach, the relational model is preserved, while still being object-oriented. Not being tied to specific features of SQL or JDBC, Carbonado also supports non-SQL...

, open source framework, backed by Berkeley DB
Berkeley DB
Berkeley DB is a computer software library that provides a high-performance embedded database for key/value data. Berkeley DB is a programmatic software library written in C with API bindings for C++, PHP, Java, Perl, Python, Ruby, Tcl, Smalltalk, and most other programming languages...

or JDBC
Java Database Connectivity
Java DataBase Connectivity, commonly referred to as JDBC, is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database. JDBC is oriented towards relational databases...
Ebean
Ebean
Ebean is an object-relational mapping product written in Java. It is designed to be simpler to use and understand than JPA or JDO products.- Simple API :...

, open source ORM framework
EclipseLink
EclipseLink
EclipseLink is the open source Eclipse Persistence Services Project from the Eclipse Foundation. The software provides an extensible framework that allows Java developers to interact with various data services, including databases, web services, Object XML mapping , and Enterprise Information Systems...

, Eclipse persistence platform
Enterprise Objects Framework
Enterprise Objects Framework
The Enterprise Objects Framework was introduced by NeXT in 1994 as a pioneering object-relational mapping product for its NeXTSTEP and OpenStep development platforms. The EOF abstracts the process of interacting with a relational database, mapping database rows to Java or Objective-C objects. This...

, Mac OS X/Java, part of Apple WebObjects
WebObjects
WebObjects was a Java web application server from Apple Inc., and a web application framework that ran on the server. It was available at no additional cost. Its hallmark features were its object-orientation, database connectivity, and prototyping tools...
Hibernate
Hibernate (Java)
Hibernate is an object-relational mapping library for the Java language, providing a framework for mapping an object-oriented domain model to a traditional relational database...

, open source ORM framework, widely used
MyBatis
MyBatis
MyBatis is a persistence framework available for Java and .NET that couples objects with stored procedures or SQL statements using an XML descriptor or annotations.MyBatis is free software that is distributed under the Apache License 2.0....

, formerly named iBATIS, has .NET port
iBATIS
IBATIS
iBATIS is a persistence framework which automates the mapping between SQL databases and objects in Java, .NET, and Ruby on Rails. In Java, the objects are POJOs . The mappings are decoupled from the application logic by packaging the SQL statements in XML configuration files...

, maintained by ASF
Apache Software Foundation
The Apache Software Foundation is a non-profit corporation to support Apache software projects, including the Apache HTTP Server. The ASF was formed from the Apache Group and incorporated in Delaware, U.S., in June 1999.The Apache Software Foundation is a decentralized community of developers...

, inactive as of 2010
Java Data Objects
Java Data Objects
Java Data Objects is a specification of Java object persistence. One of its features is a transparency of the persistent services to the domain model. JDO persistent objects are ordinary Java programming language classes ; there's no requirement for them to implement certain interfaces or extend...

(JDO)
Java Object Oriented Querying
Java Object Oriented Querying
jOOQ stands for Java Object Oriented Querying. It is a very light database mapping library in Java. Its purpose is to be both relational and object oriented by providing a Domain-specific language to construct queries from classes generated from a database schema...

(jOOQ)
Java Persistence API
Java Persistence API
The Java Persistence API, sometimes referred to as JPA, is a Java programming language framework managing relational data in applications using Java Platform, Standard Edition and Java Platform, Enterprise Edition....

(JPA)
DataNucleus
DataNucleus
DataNucleus is an open source project which provides a series of software products around data management in Java....

, open source JDO and JPA implementation
JPOX, open source JDO 2 reference implementation
Object Relational Bridge
Object Relational Bridge
Apache ObJectRelationalBridge is an Object/Relational mapping tool that allows transparent persistence for Java Objects against relational databases....

(Apache
Apache Software Foundation
The Apache Software Foundation is a non-profit corporation to support Apache software projects, including the Apache HTTP Server. The ASF was formed from the Apache Group and incorporated in Delaware, U.S., in June 1999.The Apache Software Foundation is a decentralized community of developers...

OJB), an object-relational mapper for Java; as of 2011/01/16, Apache
Apache Software Foundation
The Apache Software Foundation is a non-profit corporation to support Apache software projects, including the Apache HTTP Server. The ASF was formed from the Apache Group and incorporated in Delaware, U.S., in June 1999.The Apache Software Foundation is a decentralized community of developers...

ObJectRelationalBridge was retired
OpenJPA, Apache
Apache Software Foundation
The Apache Software Foundation is a non-profit corporation to support Apache software projects, including the Apache HTTP Server. The ASF was formed from the Apache Group and incorporated in Delaware, U.S., in June 1999.The Apache Software Foundation is a decentralized community of developers...

, open source, supports JPA API
ORMLite
ORMLite
ORMLite is an open source software framework that provides lightweight object relational mapping between Java classes and SQL databases. It supports JDBC databases as well as Android mobile platform...

, lightweight open source framework supporting JDBC and Android
Sormula, lightweight open source ORM
TopLink
TopLink
In computing, TopLink is an object-relational mapping package for Java developers. It provides a framework for storing Java objects in a relational database or for converting Java objects to XML documents....

by Oracle
QuickDB ORM
QuickDB ORM
QuickDB is an object-relational mapping framework for the Java software platform. It was developed by Diego Sarmentero along with others and is licensed under the LGPL License...

, open source ORM framework (GNU LGPL)

.NET

ADO.NET Entity Framework
ADO.NET Entity Framework
ADO.NET Entity Framework is an object-relational mapping framework for the .NET Framework.-Overview:ADO.NET Entity Framework abstracts the relational schema of the data that is stored in a database and presents its conceptual schema to the application...

, included in .NET Framework 3.5 SP1 and above
AgileFx
AgileFx
AgileFx is an Open Source ORM for the .NET Framework, with features comparable to ADO.NET Entity Framework. It uses LINQ to SQL underneath, and extends LINQ to SQL to match the more advanced features found in Microsoft Entity Framework; while retaining its performance benefits.In a nutshell,...

, open source
Base One Foundation Component Library
Base One Foundation Component Library
The Base One Foundation Component Library is a rapid application development toolkit for building secure, fault-tolerant, database applications on Windows and ASP.NET...

, free or commercial
Dapper, Simple SQL object mapper for ADO.NET
Devart
Devart (company)
Devart is a software development company founded in 1998. It delivers native connectivity solutions, development and administration tools for Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite databases...

LinqConnect, commercial, an ORM solution for Oracle
Oracle Database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....

, MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...

, PostgreSQL
PostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...

, and SQLite
SQLite
SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...
Castle ActiveRecord, ActiveRecord for .NET, open source
DatabaseObjects
DatabaseObjects
-Database Objects:The DatabaseObjects library is an open source tool for mapping relation database systems to an object-oriented structure...

.NET, open source
DataObjects.NET
DataObjects.NET
DataObjects.Net is a persistence and object-relational mapping framework for the Microsoft .NET Framework. It allows the developer to define the business logic directly in one of the .NET languages like C#. The persistent objects can be retrieved by LINQ queries...

, commercial
DevForce
DevForce
DevForce is a framework for building and operating Rich Internet Applications . DevForce provides a complete framework for building enterprise applications for Silverlight, WPF, WinForms, ASP.NET, Windows Phone 7, and a variety of non-.Net clients.DevForce is fully integrated with Microsoft's...

, commercial, N-tier
ECO
ECO (Domain Driven Design)
ECO , is a software framework suited for Domain-Driven-Design from , designed to increase productivity by utilizing facilities such as Object-relational mapping for persisting domain objects, UML models for domain classes and executable State Machines for behavior control defined in UML notation...

, commercial but free use for up to 12 classes
EntitySpaces
EntitySpaces
EntitySpaces is an object-relational mapping tool, whose architecture can be used when writing an ASP.NET, .NET Framework or .NET Compact Framework application. The architecture is provider independent, allowing developers to run the same binary code against any of the supported databases...

, commercial
Habanero
Habanero.NET
Habanero is an Enterprise Application Framework for the .NET platform that provides tools for rapid application development using agile techniques. Habanero uses object-relational mapping to carry out data persistence from relational databases to objects in code, and provides runtime user...

, free open source enterprise application framework with a free code generating tool
MyBatis
MyBatis
MyBatis is a persistence framework available for Java and .NET that couples objects with stored procedures or SQL statements using an XML descriptor or annotations.MyBatis is free software that is distributed under the Apache License 2.0....

, free open source, formerly named iBATIS
iBATIS
IBATIS
iBATIS is a persistence framework which automates the mapping between SQL databases and objects in Java, .NET, and Ruby on Rails. In Java, the objects are POJOs . The mappings are decoupled from the application logic by packaging the SQL statements in XML configuration files...

, free open source, maintained by ASF
Apache Software Foundation
The Apache Software Foundation is a non-profit corporation to support Apache software projects, including the Apache HTTP Server. The ASF was formed from the Apache Group and incorporated in Delaware, U.S., in June 1999.The Apache Software Foundation is a decentralized community of developers...

but now inactive.
LINQ to SQL, included in .NET Framework 3.5
LLBLGen Pro
LLBLGen Pro
LLBLGen Pro is an O/R mapper and code generator for the Microsoft .NET platform, created by . Computer programmers and software architects use this software to create a data-access tier and business objects tier in C# or VB.NET for several O/R mapping frameworks, like NHibernate, Entity Framework,...

, commercial
Mintiera, free or commercial, creates open source by reverse mapping physical data model
Neo
Neo (object-relational toolset)
Neo is an object-relational mapping solution for the Microsoft .NET platform. It is open source software that is distributed freely by its creator, , of ThoughtWorks. It provides a framework for mapping an object-oriented domain model to a traditional relational database....

, open source
NHibernate
NHibernate
- External links :*** *NuGet...

, open source
nHydrate
Nhydrate
nHydrate is an object-relational mapping solution for the Microsoft .NET platform providing a framework for a relational database to be mapped to .NET objects...

, open source
ObjectMapper .NET
ObjectMapper .NET
ObjectMapper .NET is an Object-relational mapping solution for the Microsoft .NET platform. It is dual licensed under the GNU General Public License and a proprietary license for commercial and closed source uses....

, GPL and commercial license
OpenAccess ORM
OpenAccess ORM
OpenAccess ORM is an object-relational mapping tool and code generator for the Microsoft .NET platform. It provides a framework for mapping an object-oriented domain model to a traditional relational database...

, by Telerik free or commercial
Persistor.NET
Persistor.NET
Persistor.NET is an object-oriented persistence framework which provides persistence for pure object-oriented development. Persistor .NET saves, retrieves, and deletes pure .NET Framework object graphs within a SQL Server 2005 or SQL Server Express database...

, free or commercial
Quick Objects, free or commercial
Signum Framework
Signum Framework
Signum Framework is an open source ORM framework to develop applications on Microsoft .NET platform. It is focused on entities, so that the data model determines the database scheme...

, open source
SubSonic
Subsonic (software)
SubSonic is an open source object-relational mapper for Microsoft .NET Framework maintained by Rob Conery. The current version is , released in July 2009.- Supported databases :SubSonic 3.0 supports databases that can be used through System.Data.Common:...

, open source
XPO, commercial, by DevExpress

Object Pascal (Delphi)

Bold for Delphi
Bold for Delphi
Bold for Delphi is an advanced Object Relational Mapper and application framework. It is designed to significantly increase developer's productivity providing them with the following facilities:* Object-relational mapping for persisting domain objects...
ECO
ECO (Domain Driven Design)
ECO , is a software framework suited for Domain-Driven-Design from , designed to increase productivity by utilizing facilities such as Object-relational mapping for persisting domain objects, UML models for domain classes and executable State Machines for behavior control defined in UML notation...

by Capable Objects, available for Delphi 2007 and Delphi Prism 2010

Objective-C, Cocoa

Core Data
Core Data
Core Data is part of the Cocoa API in Mac OS X first introduced with Mac OS X 10.4 Tiger and for iOS with iPhone SDK 3.0. It allows data organised by the relational entity-attribute model to be serialised into XML, binary, or SQLite stores. The data can be manipulated using higher level objects...

, object graph management framework with several persistent stores, ships with Mac OS X and iOS

PHP

CakePHP
CakePHP
CakePHP is an open source web application framework for producing web applications. It is written in PHP, modeled after the concepts of Ruby on Rails, and distributed under the MIT License.-History:...

, ORM and framework for PHP5, open source (scalars, arrays, objects); based on database introspection, no class extending
MVC MED, open source MVC with basic functions integred, and mapping classes generator from MySQL database.
Doctrine
Doctrine (PHP)
See also DataEase, whose query language is also called DQL.Doctrine is an object-relational mapper for PHP that provides persistence for PHP objects. It sits on top of a database abstraction layer...

, open source ORM for PHP 5.2.3, 5.3.X free software (GNU LGPL)
PdoMap
PdoMap (PHP)
pdoMap is a PHP ORM framework released under . The main aim of this project is to provide to PHP developers a RAD framework and a new way of dealing with databases.- History :The project was started in April 2008 :...

, open source ORM for PHP 5.x, inspired by Hibernate, free software (GNU LGPL)
Propel
Propel (PHP)
Propel is a free, open-source object-relational mapping toolkit written in PHP. It is also an integral part of the PHP framework Symfony and was the default ORM up to, and including version 1.2.- History :...

, ORM and query-toolkit for PHP 5, inspired by Apache
Apache Software Foundation
The Apache Software Foundation is a non-profit corporation to support Apache software projects, including the Apache HTTP Server. The ASF was formed from the Apache Group and incorporated in Delaware, U.S., in June 1999.The Apache Software Foundation is a decentralized community of developers...

Torque, free software, MIT
Rocks
Rocks (PHP)
The Rocks Library contains a database independent object-relational mapper for PHP 5.1 plus, allowing easy access to all types of database.However the Rocks Framework also includes other functionality such as a templated system for producing web pages, which encaspulates general web development...

, open source ORM for PHP 5.1 plus, free for non-commercial use, GPL
Qcodo
Qcodo
The Qcodo Development Framework is an open-source PHP web application framework which builds an Object Relational Model , CRUD UI pages, and AJAX hooks from an existing data model. It additionally includes a tightly-integrated HTML and JavaScript form toolkit which interfaces directly with the...

, ORM and framework for PHP5, open source
Redbean
Redbean (software)
RedBean is free, BSD licensed, open-source object-relational mapping software written by Gabor de Mooij. It currently only supports PHP. Although it can be used as a stand-alone library there is also an integrated edition available for the Zend Framework....

, ORM layer for PHP 5, creates and maintains tables on the fly, open source, BSD
Torpor
Torpor (PHP)
Torpor is free, open source Object-relational mapping framework for PHP 5.1 and above. It is written entirely in PHP with limited reliance on standard XML extensions and is independent of any other PHP frameworks.- History :Torpor was started as an independent project in July 2009 and reached...

, open source ORM for PHP 5.1 plus, free software, MIT, database and OS agnostic
Yii
Yii
Yii is an open source, object-oriented, high-performance component-based PHP web application framework. Yii is pronounced as "Yee" or [ji:] and it's an acronym for "Yes It Is!".- History :...

, ORM and framework for PHP5, released under the BSD license. Based on the ActiveRecord pattern.

Python

Dejavu, Open Source thread-safe Object-Relational Mapper for Python applications
Django, ORM included in Django framework, open source
SQLAlchemy
SQLAlchemy
SQLAlchemy is an open source SQL toolkit and object-relational mapper for the Python programming language released under the MIT License.SQLAlchemy provides "a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a...

, open source
SQLObject
SQLObject
SQLObject is a Python object-relational mapper between a SQL database and Python objects. It is currently experiencing community popularity, and forms a part of many applications...

, open source
Storm
Storm (software)
In computer software, Storm is a Python object-relational mapper between a SQL database and Python objects. It has been developed at Canonical Ltd...

, open source (LGPL 2.1) developed at Canonical Ltd.
Canonical Ltd.
Canonical Ltd. is a private company founded by South African entrepreneur Mark Shuttleworth to market commercial support and related services for Ubuntu Linux and related projects. Canonical is registered in London and employs staff around the world...
Tryton
Tryton
Tryton is a three-tier high-level general purpose computer application platform on top of which is built a business solution through a set of so-called Tryton modules....

, open source
web2py
Web2py
Web2py is an open source web application framework. Web2py is written in the Python language and is programmable in Python. Since web2py was originally designed as a teaching tool with emphasis on ease of use and deployment, it does not have any project-level configuration files. Web2py was...

, ORM named DAL is included in web2py framework, open source

Ruby

ActiveRecord, part of Ruby on Rails
Ruby on Rails
Ruby on Rails, often shortened to Rails or RoR, is an open source web application framework for the Ruby programming language.-History:...

, open source
Datamapper
Datamapper
Datamapper is an object-relational mapper library written in Ruby and commonly used with Merb. It was developed to address perceived shortcomings in Ruby on Rails' ActiveRecord library.Some features of Datamapper:...
iBATIS
IBATIS
iBATIS is a persistence framework which automates the mapping between SQL databases and objects in Java, .NET, and Ruby on Rails. In Java, the objects are POJOs . The mappings are decoupled from the application logic by packaging the SQL statements in XML configuration files...

, free open source

Smalltalk

TOPLink/Smalltalk
TopLink
In computing, TopLink is an object-relational mapping package for Java developers. It provides a framework for storing Java objects in a relational database or for converting Java objects to XML documents....

, by Oracle, the Smalltalk predecessor of the Java version of TOPLink

The source of this article is wikipedia, the free encyclopedia. The text of this article is licensed under the GFDL.