EntityDAC Express

EntityDAC Express is an object-relational mapping (ORM) tool for Delphi that comes with an advanced framework and LINQ support, as well. Its capabilities can help users handle database objects by allowing them to perform object-relational mapping.

Developers can access various object-oriented programming (OOP) functions, such as polymorphism, inheritance or encapsulation, as this tool provides full support for them.

Data can be retrieved from a database by using Language Integrated Query (LINQ) as a query engine that features no database dependencies.

EntityDAC Express allows programmers to rely on three different approaches while developing applications. It is possible to use the Database-First method, which implies the creation of data models and application cases subsequent to database generation. Similar to this method are the Model-First and the Code-First ones, only the object creation order is changed.

Implementing ORM within programs might benefit users by unifying application codes and simplifying development processes. Programmers can remove their projects' syntax-related dependencies, thus rendering them able to support multiple database integration.

Among the various supported databases, developers can find SQL Server, Oracle, MySQL, Firebird, PostgreSQL and SQLite.

LINQ is also a perk when it comes to simplifying applications, since developers use it as a query language and complement it with the Code completion Delphi engine while typing class names, attributes or keywords.

Developers can rely on EntityDAC Express for caching metadata, LINQ queries or entities that were loaded from the database. These features can prevent unnecessary hogging resulted from loading identical data and boost the application's overall performance.