How to create model or business object from database in visual studio asp.net - How to create Entity Data Model - DbContext class

 > Add new item in visual studio

> Add ADO.net entity data model

>Click generate from database

>Set connection string Yes or no

> Select table

>Click finish

> Click on ok when says it can harm computer

> Go to model.tt

> You can copy entity model

Note:- When creating a Entity Data Model> In the EDMX file > Goto properties and Code generation Stratigy to Default > you will see the code in the designer file(if it is showing blank file)

In web.config file connection string name will store as (use dbcontext) for remeber.

we have to use context.cs class for CRUD operation

example

//create 

using (EmployeeDBContext dbContext = new EmployeeDBContext())

        {

            dbContext.Employees.Add(employee);

            dbContext.SaveChanges();

        }

===============

//update

using (EmployeeDBContext dbContext = new EmployeeDBContext())

        {

            var entity = dbContext.Employees.FirstOrDefault(e => e.ID == id);

            entity.FirstName = employee.FirstName;

            entity.LastName = employee.LastName;

            entity.Gender = employee.Gender;

            entity.Salary = employee.Salary;

            dbContext.SaveChanges();

        }

==============

//Delete

using (EmployeeDBContext dbContext = new EmployeeDBContext())

        {

            dbContext.Employees.Remove(dbContext.Employees.FirstOrDefault(e => e.ID == id));

            dbContext.SaveChanges();

        }

============

//Getall

  using (BookMasterdbEntities db=new BookMasterdbEntities())

        {

           return db.BookMasters.ToList();

        }

==============

//Getbyid

  using (BookMasterdbEntities dbContext = new BookMasterdbEntities())

        {

            dbContext.BookMasters.add(dbContext.BookMasters.FirstOrDefault(a => a.BookID == id));

            dbContext.SaveChanges();

        }

ref:- https://dotnettutorials.net/lesson/web-api-with-sql-server/