How to Add Entity Data Model In Project Of MVC

How to Add Entity Data Model In Project Of MVC 

Before Add Entity Mode First You Need to Know How To Add New Project In Asp.net MVC for this Read My Privious Blog


If you Already Know All the above Define concepts  and code the Please skip and Read this blog Continue, Now Next Main objective is in this blog is how to add Data entity model in project ,with in new or in existing Project . To do Please Follow This Steps

1). First You Need To Create A Directory in to Root of Project by right click on Project and select           New item then select Add new folder Option 



2). Now A new Folder (directory ) is added into root of your project Now Write this folder new from        new folder to what you want (here i write entitymodel) of the folder


3).Now you Need to add new Data Entity model Under this entity model directory to do this you            Need to right click on directory and select Add option from menu  and then select New Item


4). Now New popup menu Open then You select Data Option from selected menu then select                    ADO.net Data Entity Model And the Write Name of Entity model Here i write AngularJs 


5). Now You Need to select Type of model content I Have Crated Database first so i choose Datafirst
      so my choise is "EF Diagram from Database" option


6).Now Click On Next button Then we Have option of selection connection string or create New            Connection string 


     If you want to use Default connect to select next option other wise click on button new                         connection 

7). Now add new connection string by Follow streps (Leave this option if You want to use Default            connection string )
     Here New Pop up Open Now Select Your Provider Type (my choise is microsoft sql server)
     and click on continue button


8).  Next step to select Sql Server and then select database and then select there mode and there                credential


    Next Step is To select Datbase from list of database contain by server (note here i am using " ."            for local server)



9) Now You Need to Test Connection required to click "text connection" button to varify valid or             non  valid connetion perameter is passes



10).  Now You Need click on ok then this connection string store in entity framework connnection              string and connection pop will closed and now click next button of entity model contnet type              pop. In the next option Show what object of sql server you want to include in you entity                      framework  


12). Now You Need to setup ModelNamespace and what kind of object you want choose by check t            the check boxex, Now You can see database entity diagrame and there relations



13).The Next Step To Use This Entity  TO Use this entity include Namespace into top of controller           using "Using " keyword Before it you need to use entity class You Get by here 


      Now Finally Write Code of Employee controller I am Write below 

using AngularDemo.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using AngularDemo.EntityModel;
namespace AngularDemo.Controllers
{
    [Authorize]
    public class EmployeeController : Controller
    {
        // GET: Employee
        public ActionResult Index()
        {
            return View();
        }
         public JsonResult GetEmployees()
        {
            using (AngularDemoEntities db = new AngularDemoEntities())
            {
                var Emplist=db.Employees;
                return Json(Emplist, JsonRequestBehavior.AllowGet);
            }
        }
        // GET: Employee/Details/5
        public ActionResult Details(int id)
        {
            using (AngularDemoEntities db = new AngularDemoEntities())
            {
                var Emp = db.Employees.Find(id);
                return Json(Emp, JsonRequestBehavior.AllowGet);
            }
        }

        // GET: Employee/Create
        public ActionResult Create()
        {
            return View(new Employee());
        }

        // POST: Employee/Create
        [HttpPost]
        public ActionResult Create(Employee employee)
        {
            try
            {
                using (AngularDemoEntities db = new AngularDemoEntities())
                {
                    var Emp = db.Employees.Add(employee);
                    var s=db.SaveChanges();
                    return Json(s, JsonRequestBehavior.AllowGet);
                }
                
            }
            catch
            {
                return View(new Employee());
            }
        }

        // GET: Employee/Edit/5
        public ActionResult Edit(int id)
        {
            using (AngularDemoEntities db = new AngularDemoEntities())
            {
                var Emp = db.Employees.Find(id);
                return Json(Emp, JsonRequestBehavior.AllowGet);
            }

            
        }

        // POST: Employee/Edit/5
        [HttpPost]
        public ActionResult Edit(int id, Employee employee)
        {
            try
            {
                using (AngularDemoEntities db = new AngularDemoEntities())
                {
                    var oldemp = db.Employees.Find(id);
                   
                    db.Entry(oldemp).CurrentValues.SetValues(employee);
                    return (db.SaveChanges() > 0) ? Json(employee, JsonRequestBehavior.AllowGet) : Json(oldemp, JsonRequestBehavior.AllowGet);
                }

               
            }
            catch
            {
                return View();
            }
        }

        // GET: Employee/Delete/5
        public ActionResult Delete(int id)
        {
            using (AngularDemoEntities db = new AngularDemoEntities())
            {
                var Emp = db.Employees.Find(id);
                return Json(Emp, JsonRequestBehavior.AllowGet);
            }
        }

        // POST: Employee/Delete/5
        [HttpPost]
        public ActionResult Delete(int id, FormCollection collection)
        {
            try
            {
                using (AngularDemoEntities db = new AngularDemoEntities())
                {
                    var Emp = db.Employees.Find(id);
                    db.Employees.Remove(Emp);
                    return (db.SaveChanges() > 0) ? Json(new { sucess = "true", JsonRequestBehavior.AllowGet }) : Json(new { sucess = "false", JsonRequestBehavior.AllowGet });
                }
            }
            catch
            {
                return View();
            }
        }
    }
}

       

No comments:

Post a Comment

Thank You For Your Great Contribution

Featured Post

Sql dynamic query With Join And search using like query with multiple column

Sql dynamic query With Join And search using like query with multiple column declare @keyword varchar(100) DECLARE @sqlCommand va...

Popular Posts