Entity Framework 6 (EF6) is a proven object-relational (O/RM) mapper for .NET with many years of feature development and stabilization. Like O/RM, EF6 reduces the impedance mismatch between the relational and object-oriented worlds, allowing developers to write applications that interact with data stored in relational databases with strongly typed .NET objects that represent the domain of the database. application, and eliminate the need for much of the data access "mechanical" code that you would normally write. Mapping POCO entity classes that do not depend on any EF type. Models can be generated from existing databases and then manually edited, or they can be created from scratch and then used to generate new databases. Integration with .NET Framework application models, including ASP.NET, and through data binding, with WPF and WinForms. Database connectivity based on ADO.NET and various providers available to connect to SQL Server, Oracle, MySQL, SQLite, PostgreSQL, DB2, etc.
Features
- Automatic Change Tracking
- Identity Resolution and Unit of Work
- Eager, Lazy, and Explicit Loading
- One-to-one, one-to-many, and many-to-many relationships
- Inheritance (table by hierarchy, table by type, and table by concrete class)
- A visual designer for creating entity models