What is ORM? Why we use ORM?

Understanding about Object Relation Mapper(ORM)

ORM is an Object Relation Mapper. The ORM is used to mapping between database layer to our Object Oriented code that is represent the database in our applications.

The Entity Framework and NHibernate are ORM tools.


LINQ is a ORM? No, LINQ is not an ORM. The LINQ is Language Integrated Query and used as query layer in our applications.

We can say that LINQ is a new query language that can be used to write the query using different types of sources.

The Object Relation Mapper(ORM) tools are
1.      Entity Framework and
2.      NHibernate

For example

using (dbDataContext database = new dbDataContext())
{
    var orders = from order in database.Orders
                  where order.ordernumber == "ord110xuz"
                  select new
                  {
                      order.ProductName,
                      order.UnitPrice
                  };

    foreach (var myorder in orders)
    {
       //TODO: as per you.
    }
}
You can use below link for more detail



Thank you!

ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^