Practical Introduction To Entity Framework: Day 1

What is Entity Framework?

It is an Object Relational Mapper (ORM) that enables programmers to communicate with a relational database.

What is ORM?

Object Relational Mapper: processing a relational database and mapped in such way so as programmers can use it in their code easily.

Why Entity Framework?

Using this we can do all the DB select, insert, update, delete operations without writing ADO .Net code that we write for every single query of a database.

1. To do the faster development use Entity Framework
2. Connect with any database like SQL or Oracle
3. Auto-generated Model
4. Works well with Stored Procedures

First create a table in your database: I have attached my DB structure here.



Now in Visual Studio add a new item: ADO entity Model.





Select your database and save the entity to do CRUD operations.



Select your tables.



After clicking on Finish an edmx is created for your project.

Now

Create Entity Object to do CRUD operations

FirstDayEntities ObjEntity = new FirstDayEntities();

        #region Read All Merchants
        var ObjMerchantsList = ObjEntity.Merchants;
        #endregion

        #region Insert
        Merchant ObjMerchant = new Merchant() { Name = "Mangesh Gaherwar", Address = "Solapur" };
        ObjEntity.AddToMerchants(ObjMerchant); //   ObjEntity.Merchants.AddObject(ObjMerchant); //both r same
        int InsertResult = ObjEntity.SaveChanges();
        #endregion

        #region Update
        Merchant ObjUpdateMerchant = ObjEntity.Merchants.Where<Merchant>(a => a.Name == "Mangesh Gaherwar").FirstOrDefault();
        ObjUpdateMerchant.Address = "Kamote";
        int UpdateResult = ObjEntity.SaveChanges();
        #endregion

        #region Delete
        Merchant ObjDeleteMerchant = ObjEntity.Merchants.Where<Merchant>(a => a.Name == "Mangesh Gaherwar").FirstOrDefault();
        ObjEntity.Merchants.DeleteObject(ObjDeleteMerchant);
        int DeleteResult = ObjEntity.SaveChanges();
        #endregion

That's it.

If your database table structure is the same then only change the connection string in the web.config

We will see some more fundamentals in Practical of Entity Framework: Day 2.

Please find the attached source code Zip.

Thank you for reading.