What is ORM?

ORM (Object-Relational Mapping) is a tool for storing data from domain objects to relational database like MS SQL Server, in an automated way, 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 & stored procedures). ORM allows us to keep our database design separate from our domain class design. This makes the application maintainable and extendable. It also automates standard CRUD operation (Create, Read, Update and Delete) so that the developer doesn't need to write it manually.