ORM and EntityFramework – intro

ORM (Object Relational Mapping) is basically an approach for storing data from domain/entity objects to relational database in an automated way without writing much code. A true ORM is independent of what database server we refer to, the code underlying ORM’s is database independent and can run with any database server having similar database with a structure needed by the application. ORM has 3 main parts: Entity class objects, Relational DB objects and information on how domain objects maps to relational DB objects, i.e., tables, views and storedprocedures. ORM helps us to keep our database design separate from our domain class design. This makes our application maintainable and extendable. It also automates standard CRUD operation (Create, Read, Update & Delete)

EntityFramework Architecture

Application interacts with Entity Data Model (Entity Framework), that acts as an interface between ADO.NET provider and database, fetches/saves data.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s