Select Data From DataBase Using Entity Framework in Asp.Net MVC

This article will show you how you can select or retrieve data from data base using entity frame work using linq, C# in asp.net mvc. Data read using linq from SQL server database table.

First we will create a sql table and add some data in it.

CREATE TABLE [dbo].[StudentDetail](        [Id] [int] IDENTITY(1,1) NOT NULL,        [Name] [varchar](50) NULL,        [Address] [varchar](50) NULL,        [Section] [varchar](50) NULL,        [Marks] [int] NULL ) ON [PRIMARY]

After adding some data table look as.

So for this article will first we will create a new asp.net mvc application and add entity .edmx file. And include the table.

Now we will add a new model class file and add the below code in it.

using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace MVC_Demos.Models {     public class StudentModel     {         public List<Student> StudentList { get; set; }     }     public class Student     {         public int Id { get; set; }         public string Name { get; set; }         public string Address { get; set; }         public string Section { get; set; }         public string Marks { get; set; }     } }

After this we will add a controller class file and add the below .

using MVC_Demos.Models; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; namespace MVC_Demos.Controllers {     public class HomeController : Controller     {         //         // GET: /Home/         [HttpGet]         public ActionResult Index()         {             StudentModel _studentModel = new StudentModel();             _studentModel.StudentList = GetStudentList();             return View(_studentModel);         }         ///         /// Get student detail from data base list         ///         public List<Student> GetStudentList()         {             List<Student> _student = new List<Student>();             //Create instance for entity class             DemoEntities _demoEntities = new DemoEntities();             var stuData = from data in _demoEntities.StudentDetails                           select data;             foreach (var item in stuData)             {                 _student.Add(new Student { Id = item.Id, Name = item.Name, Marks = item.Address, Address = item.Address, Section = item.Section });             }             return _student;         }     } }

        

Now from above code just check the below code.

public List<Student> GetStudentList()         {             List<Student> _student = new List<Student>();             //Create instance for entity class             DemoEntities _demoEntities = new DemoEntities();             var stuData = from data in _demoEntities.StudentDetails                           select data;             foreach (var item in stuData)             {                 _student.Add(new Student { Id = item.Id, Name = item.Name, Marks = item.Address, Address = item.Address, Section = item.Section });             }             return _student;         }

Here in above code I have created the object for the entity class and then selected data from table all which present in table. After that I have applied look to pull all the data in the list for further processing.

Have a look of the entity class file

Now we will create a view and add the below code in it.

@model MVC_Demos.Models.StudentModel @{     ViewBag.Title = "select data from database using entity framework in asp.net mvc"; } <style type="text/css">     .gridtable {         font-family: verdana,arial,sans-serif;         font-size: 11px;         color: #333333;         border-width: 1px;         border-color: #666666;         border-collapse: collapse;     }         .gridtable th {             border-width: 1px;             padding: 8px;             border-style: solid;             border-color: #666666;             background-color: #dedede;         }         .gridtable td {             border-width: 1px;             padding: 8px;             border-style: solid;             border-color: #666666;             background-color: #ffffff;         }         .gridtable tr:hover td,         .gridtable tr.even:hover td.active,         .gridtable tr.odd:hover td.active {             background: #b6ff00;         } </style> @using (Html.BeginForm("Index", "Home")) {     <table width="100%" cellpadding="5" cellspacing="2" border="0" style="background-color: White;" class="gridtable">         <thead>             <tr>                 <th>Id</th>                 <th>Name</th>                 <th>Marks</th>                 <th>Address</th>                 <th>Section</th>             </tr>         </thead>         @foreach (var item in Model.StudentList)         {             <tr>                 <td>@item.Id</td>                 <td>@item.Name</td>                 <td>@item.Marks</td>                 <td>@item.Address</td>                 <td>@item.Section</td>             </tr>         }             </table> }

In above code I have render the model class and bind the detail with table to display the records. Now we have done run the application to check the output.