EntityDAC is an innovative and trustworthy development tool that intends to provide Delphi developers with an Object Relational Mapping part and offer Language Integrated Query assistance.
EntityDAC is an ORM for Delphi using LINQ support. It offers a strong framework that enables performing object-relational mapping of database items to Delphi courses with complete support for encapsulation, inheritance, polymorphism, and other OOP attributes. To recover data in the database, LINQ can be employed as a database separate query engine. Additionally, there's a feature-rich ORM modeling tool accessible - Entity Developer lets you produce and edit your ORM models visually and create Delphi entity classes through this version automatically.
ORM is a programming system that operates by converting information between incompatible systems in object-oriented languages, whereas LINQ is a part that adds native question capacities to .NET Framework languages.
The utility's most important objective is to offer developers a frame that may map database tables, with polymorphism, encapsulation, inheritance, and several different methods, to Delphi classes.
EntityDAC supports three distinct forms of design development, enabling users to select whichever best matches their needs, such as'Database First','' Model First' or''Code First', every alternative going through a set of distinct steps.
The program also includes Entity Developer, a powerful application that will help users in the development and editing operations of the ORM versions; additionally, it can create Delphi entity courses from the input version.
Using LINQ as a database query tool, EntityDAC significantly eases the code writing process, too, due to the Code Completion Delphi motor that comes into action when users type category attributes or names, keywords, and other related products.
As a consequence of utilizing ORM when mapping tables into Delphi courses, EntityDAC effectively encourages the production of new software while also allowing for ORM integration to priority developed jobs.
While EntityDAC is principally addressed at experienced folks with good background knowledge of software development, it will come with comprehensive help documentation to help both the complex and the novices in their own endeavors.
There are numerous approaches to database software development. Database-First -- a database has been designed first, and a data model and program classes are created based on the present database. Model-First -- an information model is designed first in a version programmer tool, then a database and program classes are created by this model. Code-First -- in this instance, application classes would be the first origin, on the grounds of which a database could be created, in addition to a version, if needed. When creating programs using EntityDAC, you'll have the ability to use all of the 3 ways.
Entity Developer permits you to visually create and edit ORM versions without typing a line of XML code or guide describing course features in Delphi code. It supports the production of all sorts of mapping, for example, dining table dividing, mapping things to several tables, advanced types, inheritance hierarchies, etc... Code generation is extremely flexible because of utilizing T4-like templates, enabling virtually whatever you might want for code creation, and you might even create your own templates for additional programming languages.
Using ORM when creating your software must accelerate the program's growth and merge the program code and create software independent of the particulars and syntax of the SQL database to which it is designed, which enables you to support several databases within your program free of effort. Consequently, Language Integrated Query (LINQ) can be employed in EntityDAC for a query language. Using LINQ also significantly simplifies writing and additional support of questions. In this, the Code conclusion Delphi engine is used when assessing LINQ keywords, category names, characteristics, etc... And in precisely the same style, LINQ questions syntax check is done in the software compilation stage.
Object-relational mapping of database tables into Delphi classes may be achieved to classes inherited by a fundamental TEntity course and habit classes inherited form TObject also. This kind of approach enables using EntityDAC to grow new programs and only introduce ORM to existing jobs. Moreover, different mapping techniques are supported: code mapping, feature mapping, and XML mapping.
To increase application functionality, EntityDAC lets caching metadata, all things loaded in the database, LINQ queries, and a whole lot more. Such caching permits you to prevent multiple loading of the same data and vastly enhance performance compared to using the typical Data Access Components.
