What is Entity Framework?

The Microsoft ADO.NET Entity Framework is an Object/Relational Mapping (ORM) structure that empowers engineers to work with relational data as domain-specific objects, Utilizing the Entity Framework, engineers issue queries utilizing LINQ, then retrieve and manipulate data as strongly typed objects. The Entity Framework's ORM execution gives services like change tracking, identity resolution, lazy loading, and query translation so that developers can focus on their application-specific business logic rather than the data access fundamentals.

Entity framework is an Object/Relational Mapping (O/RM) structure.It is an upgrade to ADO.NET that gives engineers an automated mechanism for accessing & storing information in the database.

Entity framework is useful in three scenarios.
First, if you already have existing database or you want to create new database.
Second, you want to focus on domain classes and create the database from domain classes.
Third, you want to design database schema on the visual designer and then create the database and classes.

What is Object-relational mapping (ORM, O/RM, and O/R mapping) ?

Object-relational mapping (ORM, O/RM, and O/R mapping) is a tool for storing data from domain objects to relational database like MS SQL Server, automatcally, without much programming. ORM includes three main parts: Domain class objects, Relational database objects and Mapping information on how domain objects map to relational database objects (tables, views & storedprocedures). ORM allows to keep database design separate from domain class design. This feature makes application maintainable and extendable. It also automates CRUD operation (Create, Read, Update & Delete) so that engineers doesn't need to write it manually.

List of object-relational mapping software for .Net

Praesent mattis

Pellentesque viverra vulputate enim. Aliquam erat volutpat. Pellentesque tristique ante ut risus. Quisque dictum. Integer nisl risus, sagittis convallis, rutrum id, elementum congue, nibh. Suspendisse dictum porta lectus. Donec placerat odio vel elit.

Read More