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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
http://www.code-sample.com
http://www.code-sample.xyz

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.