EntityDAC - ORM for Delphi with LINQ support

EntityDAC is an ORM for Delphi with LINQ support. It provides a powerful framework that allows performing object-relational mapping of database objects to Delphi classes with full support for encapsulation, inheritance, polymorphism and other OOP features. To retrieve data from a database, LINQ is used as a database independent query engine. In addition, there is a feature-rich ORM modeling tool available – Entity Developer that allows you to create and edit your ORM models visually, and generate Delphi entity classes by this model automatically.

Main features EntityDAC

Database-First, Model-First & Code-First development

There are several approaches to database application development. Database-First – a database is developed first, then a data model and application classes are generated on the basis of the existing database. Model-First – a data model is developed first in a model developer tool, then a database and application classes are generated by this model. Code-First – in this case, application classes are the original source, on the basis of which a database can be generated, as well as a model, if necessary. When developing applications using EntityDAC, you will be able to use all the three ways.

Database-, Model-, Code-First Development

Visual ORM Model Designer with Code generation

Entity Developer allows you to create and edit ORM models visually, without typing a line of XML code or manual describing class attributes in Delphi code. It supports creation of all kinds of mapping, such as table splitting, mapping entity to several tables, complex types, inheritance hierarchies, etc. Code generation is very flexible due to using T4-like templates, allowing virtually anything you may want for code generation, and you may even create your own templates for other programming languages.

Visual ORM Designer
Buy now

LINQ queries

Using ORM when developing your applications must not only accelerate development of the application itself, but also unify the application code and make applications independent of the specifics and syntax of the SQL database for which it is developed, that will allow to support multiple databases in your application with no effort. Therefore, Language Integrated Query (LINQ) is used in EntityDAC as a query language. Using LINQ also significantly simplifies writing and further support of queries, since, at this, the Code completion Delphi engine is used when typing LINQ keywords, class names, their attributes, etc. And in the same way, LINQ queries syntax check is performed at the stage of application compilation.

LINQ Queries

Class mapping

Object-relational mapping of database tables to Delphi classes can be performed not only to classes inherited from a basic TEntity class, but to custom classes inherited from TObject as well. Such an approach allows using EntityDAC for development of new applications, as well as simply introduce ORM to already existing projects. In addition, different mapping methods are supported: code mapping, attribute mapping and XML mapping.

Class Mapping

Entity & Query Cache

To increase application performance, EntityDAC allows caching metadata, all entities loaded from the database, LINQ queries, and much more. Such caching allows you to avoid multiple loading of the same data and vastly improve performance in comparison to using the standard Data Access Components.

Entity & Query Cache
Buy Now EntityDAC

What our customers say

I'm more than happy to describe my experience with EntityDac...EntityDAC is the missing Delphi ORM we've been looking for. Encapsulation, inheritance, polymorphism, not to mention Database Independence and the LINQ...
Andrew Tierney
CEO and Founder, CastleSoft Pty Ltd
I originally purchased TMS Aurelius (ORM). I could not get it off the ground after three days. Poor documentation. I tried EntityDac. I had EntityDac up and running using my database in 30 minutes...
Bud Chapin
Owner / Bud's Pc Consulting & Custom Programming
This is "THE ORM FOR DELPHI". Easy to use and powerful. With this tool I have simplified the DB managing in my Delphi application and I can create true cross-db application using EntityDAC and UNIDAC, two great products.
Angelo Lopez
Founder/Analyst/Developer, Unocom Italia
I don't say one of your competitors is bad, but my first impression is that EntityDAC is more USER FRIENDLY, and the entity developer looks much better (at least at the eyes of a DBForge X user)as the counterpart DataModeler.
Francesco Todini

Discover Other Connectivity Solutions

ADO.NET - ODBC - SSIS - Excel Add-ins - Delphi - OData

Find out more

Get extra benefits with Devart for Enterprise

Learn more about our convenient software purchasing process and an array of benefits for enterprise companies.

  • Bonuses for corporate clients

    These may include fast and effective deployment, corporate budget optimization, and a number of special deals.

  • Dedicated manager

    We will save your time by providing a dedicated manager to consult you and guide you through all the purchasing and licensing processes.
Learn more

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.