{"id":4567,"date":"2023-02-17T11:52:48","date_gmt":"2023-02-17T11:52:48","guid":{"rendered":"https:\/\/isophal.com\/?p=4567"},"modified":"2023-06-22T05:05:37","modified_gmt":"2023-06-22T05:05:37","slug":"%e1%9e%9f%e1%9f%92%e1%9e%9c%e1%9f%82%e1%9e%84%e1%9e%99%e1%9e%9b%e1%9f%8b%e1%9e%a2%e1%9f%86%e1%9e%96%e1%9e%b8-entity-framework","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2023\/02\/17\/4567.html\/","title":{"rendered":"\u179f\u17d2\u179c\u17c2\u1784\u1799\u179b\u17cb\u17a2\u17c6\u1796\u17b8 Entity Framework"},"content":{"rendered":"\n

\u1796\u17b8\u1798\u17bb\u1793\u17a1\u17be\u1799 .Net 3.5 \u1780\u17d2\u1793\u17bb\u1784\u1793\u17b6\u1798\u1787\u17b6\u17a2\u17d2\u1793\u1780\u17a2\u1797\u17b7\u179c\u178c\u17d2\u178d\u1793\u17cd\u1799\u17be\u1784\u1785\u17d2\u179a\u17be\u1793\u178f\u17c2\u1794\u17d2\u179a\u17be\u178a\u17be\u1798\u17d2\u1794\u17b8\u179f\u179a\u179f\u17c1\u179a\u1780\u17bc\u178a ADO.NET \u178a\u17be\u1798\u17d2\u1794\u17b8\u17a2\u1793\u17bb\u179c\u178f\u17d2\u178f\u1794\u17d2\u179a\u178f\u17b7\u1794\u178f\u17d2\u178f\u17b7\u1780\u17b6\u179a  Perform CRUD \u1787\u17b6\u1798\u17bd\u1799\u1798\u17bc\u179b\u178a\u17d2\u178b\u17b6\u1793\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u17d4 \u1785\u17c6\u1796\u17c4\u17c7\u1794\u1789\u17d2\u17a0\u17b6\u1793\u17c1\u17c7\u1799\u17be\u1784\u178f\u17d2\u179a\u17bc\u179c\u1794\u1784\u17d2\u1780\u17be\u178f\u1780\u17b6\u179a\u1797\u17d2\u1787\u17b6\u1794\u17cb\u1787\u17b6\u1798\u17bd\u1799 Database \u178a\u17c4\u1799\u1794\u17be\u1780\u1780\u17b6\u179a\u1797\u17d2\u1787\u17b6\u1794\u17cb (Open Connection), Create DataSet \u178a\u17be\u1798\u17d2\u1794\u17b8\u1794\u17d2\u179a\u1798\u17bc\u179b\u1799\u1780 (fetch) \u17ac\u1794\u1789\u17d2\u1787\u17bc\u1793\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 (submit data) \u1791\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1783\u17d2\u179b\u17b6\u17c6\u1784\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 (database) \u17a0\u17be\u1799\u1794\u17c6\u179b\u17c2\u1784\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1796\u17b8 DataSet \u1791\u17c5\u1787\u17b6 .NET Objects \u17ac\u1795\u17d2\u1791\u17bb\u1799\u1798\u1780\u179c\u17b7\u1789\u178a\u17be\u1798\u17d2\u1794\u17b8 Apply \u1791\u17c5\u179b\u17be Business rules \u179a\u1794\u179f\u17cb\u1799\u17be\u1784\u17d4 \u178f\u17b6\u1798\u1796\u17b7\u178f\u1793\u17c1\u17c7\u1782\u17ba\u1787\u17b6\u1796\u17c1\u179b\u179c\u17c1\u179b\u17b6\u178a\u17c2\u179b\u178f\u17d2\u179a\u17bc\u179c\u1780\u17b6\u179a\u178a\u17c6\u178e\u17be\u179a\u1780\u17b6\u179a\u179f\u17d2\u1798\u17bb\u1782\u179f\u17d2\u1798\u17b6\u1789\u1793\u17b7\u1784\u1784\u17b6\u1799\u1793\u17b9\u1784\u1798\u17b6\u1793\u1780\u17c6\u17a0\u17bb\u179f\u17d4 \u1780\u17d2\u179a\u17bb\u1798\u17a0\u17ca\u17bb\u1793 Microsoft \u1794\u17b6\u1793\u1795\u17d2\u178f\u179b\u17cb\u1793\u17bc\u179c Framework \u1798\u17bd\u1799\u17a0\u17c5\u1790\u17b6\u201c Entity Framework\u201d \u178a\u17be\u1798\u17d2\u1794\u17b8\u1792\u17d2\u179c\u17be\u17b1\u17d2\u1799 automate \u178a\u17c2\u179b\u1791\u17b6\u1780\u17cb\u1791\u1784\u1793\u17b9\u1784 Database \u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb\u1793\u17c1\u17c7\u1791\u17c5\u179b\u17be application \u179a\u1794\u179f\u17cb\u1799\u17be\u1784 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be\u1799\u17be\u1784\u1795\u17d2\u178f\u179b\u17cb\u1793\u17bc\u179c\u1796\u17d0\u178f\u17cc\u1798\u17b6\u1793\u179b\u17c6\u17a2\u17b7\u178f\u1785\u17b6\u17c6\u1794\u17b6\u1785\u17cb\u1791\u17c5\u17a2\u17c4\u1799 Entity Framework\u17d4 \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u17a2\u178f\u17d2\u1790\u1794\u1791\u1793\u17c1\u17c7\u1781\u17d2\u1789\u17bb\u17c6\u1793\u17b9\u1784\u1795\u17d2\u178f\u179b\u17cb\u1780\u17b6\u179a\u178e\u17c2\u1793\u17b6\u17c6\u1781\u17d2\u179b\u17b8\u17d7\u17a2\u17c6\u1796\u17b8 Entity Framework\u17d4<\/p>\n\n\n\n

Entity Framework in ASP.NET MVC<\/strong><\/h2>\n\n\n\n

In this article, I am going to discuss how to use Entity Framework in ASP.NET MVC<\/strong> Application to interact with SQL Server Database to perform the CRUD operation. In the ASP.NET MVC application, the controller responds to the incoming HTTP request, then gets the data from a model and hands it over to the view. The view then renders the data. The model can be entities or business objects. Here, in this article, we are going to discuss how to retrieve the data from the SQL Server Databaseusing the Entity Framework Database First Approach in ASP.NET MVC Application. In our upcoming article, we will discuss using business objects as our model.<\/p>\n\n\n\n

Creating the Database with Required Table and Data:<\/strong><\/h5>\n\n\n\n

Please use below SQL Script to create the  MVC_DB <\/strong>Database, Employee<\/strong> table and populate the Employee table with test data:<\/p>\n\n\n\n

<\/p>\n\n\n\n

--Create a database called MVC_DB\nCREATE DATABASE MVC_DB\nGO\n\n--Use MVC_DB\nUSE MVC_DB\nGO\n\n--Create a Table called Employee\nCREATE TABLE Employee\n(\n  EmployeeId int Primary Key Identity(1,1),\n  Name nvarchar(50),\n  Gender nvarchar(10),\n  City nvarchar(50),\n  Salary decimal(18,2)\n)\nGO\n\n--Insert some values into Employee Table\nINSERT INTO Employee values('Pranaya','Male','Mumbai', 2000)\nINSERT INTO Employee values('Sambit','Male','Chennai', 3000)\nINSERT INTO Employee values('Priyanka','Female','Hydrabad', 4000)\nINSERT INTO Employee values('Anurag','Male','Cheenai', 4000)\nINSERT INTO Employee values('Subrat','Male','Mumbai', 3000)\nINSERT INTO Employee values('Preety','Female','Mumbai', 2000)\nINSERT INTO Employee values('Trupti','Female','Hyderabad', 5000)\nGO<\/pre>\n\n\n\n
Let us understand how to use Entity Framework in ASP.NET MVC Application step by step.<\/p>\n\n\n\n
Step1: Create a new Empty ASP.NET MVC Application<\/strong><\/h5>\n\n\n\n
Open Visual Studio and click on the New Project link on the Startup page as shown below. Alternatively, you can also select the File menu -> New Project option from the Context menu.<\/p>\n\n\n\n
\"Creating<\/figure>\n\n\n\n
From the New Project window as shown in the below image, expand the Visual C# node and select Web from the left pane. From the middle pane select ASP.NET Web Application. Provide a meaningful name to your project such as CRUD_OperationsInMVC<\/strong>. Select the location where you want to create the project by clicking on the Browse button. Finally, click on the OK button as shown in the below image.<\/p>\n\n\n\n
\"Selecting<\/figure>\n\n\n\n
Once you click on the OK button a new dialog will pop up for selecting project Templates as shown in the below image. From the below window, we are going to choose the Empty Project Template and Select MVC from Add Folders and core reference section.<\/p>\n\n\n\n
\"Selecting<\/figure>\n\n\n\n
You can also change the authentication by clicking on the Change Authentication<\/strong> button. You can select the appropriate authentication mode for your application. Here, we are not going to have any authentication for our application. So select the No Authentication<\/strong> radio button and click OK<\/strong>. (By default, Individual User Accounts would be selected to authenticate users stored in the SQL Server database.)<\/p>\n\n\n\n
\"Selecting<\/figure>\n\n\n\n
Wait for some time till Visual Studio creates a simple MVC project using the default template.<\/p>\n\n\n\n
Step2: Adding ADO.NET Entity Data Model in ASP.NET MVC Application<\/strong><\/h5>\n\n\n\n
Right-Click on Models Folder, and then select Add => New Item<\/strong> from the context menu which will open the Add New Item window. From the \u201cAdd New Item\u201d window, from the left pane expand Installed => Visual C# => Data<\/strong> option. From the middle pane select the ADO.NET Entity Data Model template. Provide a meaningful name to your data model such as EmployeeDataModel <\/strong>and finally click on the Add <\/strong>button as shown in the below image.<\/p>\n\n\n\n
\"Adding<\/figure>\n\n\n\n
From the next Entity Data Model Wizard screen, as we are going to use the Entity Framework Database First<\/strong> approach, so select EF Designer from Database <\/strong>option and click on the Next<\/strong> button as shown in the image below.<\/p>\n\n\n\n
\"Selecting<\/figure>\n\n\n\n
In the next step, click on the new connection From Choose your data connection wizard as shown below.<\/p>\n\n\n\n
\"Creating<\/figure>\n\n\n\n
Provide the necessary details to communicate with the database such as Server name<\/strong>, select the Authentication Type<\/strong>, select the Database<\/strong> and click on the Ok <\/strong>button as shown below.<\/p>\n\n\n\n
\"Providing<\/figure>\n\n\n\n
Then provide a meaningful name for the connection string that is going to save in the web.config<\/strong> file. Here, I am naming the connection string as EmployeeDBContext<\/strong> and then click on the Next<\/strong> button as shown in the below image.<\/p>\n\n\n\n
\"Creating<\/figure>\n\n\n\n
Select the version of Entity Framework<\/strong><\/h5>\n\n\n\n
Here I am going to use Entity Framework 6.x,<\/strong> so I am selecting the Entity Framework 6.x<\/strong> radio button and click on the Next<\/strong> button as shown in the below image.<\/p>\n\n\n\n
\"Selecting<\/figure>\n\n\n\n
Selecting the Database Objects<\/strong><\/h5>\n\n\n\n
Then we need to select the database object for our application. As our database has one table, so we need to select that Employee<\/strong> Table. Provide a meaningful namespace to your EDMX<\/strong> file and finally click on the Finish<\/strong> button as shown in the below image.<\/p>\n\n\n\n
\"Selecting<\/figure>\n\n\n\n
Once you click on the Finish<\/strong> button, let\u2019s see what the things are created by Entity Framework. It will add the reference to the Entity Framework in the reference folder.<\/p>\n\n\n\n
\"Entity<\/figure>\n\n\n\n
The framework will create the EDMX file within the Models folder.<\/p>\n\n\n\n
\"Edmx<\/figure>\n\n\n\n
It will create the Employee Model.<\/strong><\/h5>\n\n\n\n
To see the Employee Model click on Employee.cs<\/strong> file, this is inside the EmployeeDataModel.tt<\/strong> File<\/p>\n\n\n\n
namespace CRUD_OperationsInMVC.Models\n{\n    using System;\n    using System.Collections.Generic;\n    \n    public partial class Employee\n    {\n        public int EmployeeId { get; set; }\n        public string Name { get; set; }\n        public string Gender { get; set; }\n        public string City { get; set; }\n        public Nullable<decimal> Salary { get; set; }\n    }\n}\n<\/pre>\n\n\n\n
It will create the connection string in the web.config file as shown below.<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
It will create the DBContext<\/strong> class for us whose name is the same as the name of the connection string that is EmployeeDBContext. <\/strong>The EmployeeDBContext <\/strong>class derives from the DbContext <\/strong>class and is responsible for establishing a connection to the database. The  EmployeeDataModel.Context.cs<\/strong> which is inside EmployeedataModel.Context.tt<\/strong> as sown below.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Below is the auto-generated code for the EmployeeDBContext class<\/strong><\/p>\n\n\n\n
namespace CRUD_OperationsInMVC.Models\n{\n    using System;\n    using System.Data.Entity;\n    using System.Data.Entity.Infrastructure;\n    \n    public partial class EmployeeDBContext : DbContext\n    {\n        public EmployeeDBContext()\n            : base(\"name=EmployeeDBContext\")\n        {\n        }\n    \n        protected override void OnModelCreating(DbModelBuilder modelBuilder)\n        {\n            throw new UnintentionalCodeFirstException();\n        }\n    \n        public virtual DbSet<Employee> Employees { get; set; }\n    }\n}<\/pre>\n\n\n\n
That\u2019s it. We successfully created our Entity Data Model. Now it\u2019s time to use this model in our application.<\/p>\n\n\n\n
Creating Controller:<\/strong><\/h5>\n\n\n\n
Right-Click on Controllers Folder. Select Add => Controller => Select MVC5 Controller Empty <\/strong>and then click on add button as shown in the below image.<\/p>\n\n\n\n
\"Creating<\/figure>\n\n\n\n
In the next Screen provide the controller name as EmployeeController<\/strong> and click on the Add<\/strong> button as shown below.<\/p>\n\n\n\n
\"Providing<\/figure>\n\n\n\n
Let\u2019s modify the default route in the RouteConfig<\/strong> class so that when the application runs for the first time it will redirect to the Index Action method of Employee Controller.<\/p>\n\n\n\n
After modifying the RouteConfig<\/strong> class the codes looks like as shown below<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
namespace CRUD_OperationsInMVC\n{\n    public class RouteConfig\n    {\n        public static void RegisterRoutes(RouteCollection routes)\n        {\n            routes.IgnoreRoute(\"{resource}.axd\/{*pathInfo}\");\n\n            routes.MapRoute(\n                name: \"Default\",\n                url: \"{controller}\/{action}\/{id}\",\n                defaults: new { controller = \"Employee\", action = \"Index\", id = UrlParameter.Optional }\n            );\n        }\n    }\n}<\/pre>\n\n\n\n
Let\u2019s modify the index action method of employee controller to use entity framework as shown below<\/strong><\/p>\n\n\n\n
namespace CRUD_OperationsInMVC.Controllers\n{\n    public class EmployeeController : Controller\n    {\n        public ActionResult Index()\n        {\n            EmployeeDBContext dbContext = new EmployeeDBContext();\n            List<Employee> empList = dbContext.Employees.ToList();\n            return View(empList);\n        }\n    }\n}<\/pre>\n\n\n\n
Let\u2019s create the index view.<\/strong><\/h5>\n\n\n\n
Right-click on the Index Action Method and click on Add View. Then paste the following code in the Index,cshtml file.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
@model IEnumerable<CRUD_OperationsInMVC.Models.Employee>\n<table class=\"table\">\n    <tr>\n        <th>\n            @Html.DisplayNameFor(model => model.Name)\n        <\/th>\n        <th>\n            @Html.DisplayNameFor(model => model.Gender)\n        <\/th>\n        <th>\n            @Html.DisplayNameFor(model => model.City)\n        <\/th>\n        <th>\n            @Html.DisplayNameFor(model => model.Salary)\n        <\/th>\n    <\/tr>\n\n@foreach (var item in Model) {\n    <tr>\n        <td>\n            @Html.DisplayFor(modelItem => item.Name)\n        <\/td>\n        <td>\n            @Html.DisplayFor(modelItem => item.Gender)\n        <\/td>\n        <td>\n            @Html.DisplayFor(modelItem => item.City)\n        <\/td>\n        <td>\n            @Html.DisplayFor(modelItem => item.Salary)\n        <\/td>\n    <\/tr>\n}\n<\/table><\/pre>\n\n\n\n
That\u2019s it. Now run the application and you should get the result as expected as shown in the below image.<\/p>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
\u17d4 \u1780\u17d2\u179a\u17bb\u1798\u17a0\u17ca\u17bb\u1793 Microsoft \u1794\u17b6\u1793\u1795\u17d2\u178f\u179b\u17cb\u1793\u17bc\u179c Framework \u1798\u17bd\u1799\u17a0\u17c5\u1790\u17b6\u201c Entity Framework\u201d \u178a\u17be\u1798\u17d2\u1794\u17b8\u1792\u17d2\u179c\u17be\u17b1\u17d2\u1799 automate \u178a\u17c2\u179b\u1791\u17b6\u1780\u17cb\u1791\u1784\u1793\u17b9\u1784 Database \u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb\u1793\u17c1\u17c7\u1791\u17c5\u179b\u17be application \u179a\u1794\u179f\u17cb\u1799\u17be\u1784 <\/p>\n","protected":false},"author":1,"featured_media":4573,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[189,140],"tags":[575,570,576,577],"class_list":["post-4567","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-asp-net","category-programming","tag-ast-net","tag-crud","tag-entity-framework","tag-mvc"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=4567"}],"version-history":[{"count":2,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4567\/revisions"}],"predecessor-version":[{"id":4805,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4567\/revisions\/4805"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/4573"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=4567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=4567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=4567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}