Look at the following procedure.

Step 1

Create a database with some sample data using the following SQL script.

  1. CREATE DATABASE MVC;
  3. USE MVC;
  5. CREATE TABLE dbo.Students(ID int, Name varchar(50), Gender varchar(6), Fees int);
  7. INSERT INTO dbo.Students
  8. VALUES(1, 'Harry', 'Male', 2500);
  10. INSERT INTO dbo.Students
  11. VALUES(2, 'Jane', 'Female', 2400);
  13. INSERT INTO dbo.Students
  14. VALUES(3, 'Emma', 'Female', 2100);
  16. INSERT INTO dbo.Students
  17. VALUES(4, 'Roster', 'Male', 2500);
  19. INSERT INTO dbo.Students
  20. VALUES(5, 'Chris', 'Male', 2900);
  22. INSERT INTO dbo.Students
  23. VALUES(6, 'Evan', 'Male', 2200);
  25. INSERT INTO dbo.Students
  26. VALUES(7, 'Cathlie', 'Female', 2550);
  28. INSERT INTO dbo.Students
  29. VALUES(8, 'Jack', 'Male', 2500);
  31. INSERT INTO dbo.Students
  32. VALUES(9, 'Jone', 'Male', 2900);
  34. INSERT INTO dbo.Students
  35. VALUES(10, 'Videra', 'Female', 2550);
  37. INSERT INTO dbo.Students
  38. VALUES(11, 'Sara', 'Female', 2900);
  40. INSERT INTO dbo.Students
  41. VALUES(12, 'Mak', 'Male', 2500);
  43. INSERT INTO dbo.Students
  44. VALUES(13, 'Max', 'Male', 2550);
  46. INSERT INTO dbo.Students
  47. VALUES(14, 'Brock', 'Male', 2900);
  49. INSERT INTO dbo.Students
  50. VALUES(15, 'Eddie', 'Male', 2500);
  52. INSERT INTO dbo.Students
  53. VALUES(16, 'Edna', 'Female', 2500);
Step 2

Create a new MVC Project in Visual Studio and name it "MVCDataAccessByEntityFrame".

MVC Project

empty templet

Step 3

Install Entity Framework using Nuget package manager from Solution Explorer into your project.

nuget package manager

solution explorer

Step 4

Go to the Models folder in the Solution Explorer and add two class files.

Models

Step 5

Copy the following code to the preceding created class files.

Students.cs
  1. using System.ComponentModel.DataAnnotations.Schema;
  3. namespace MVCDataAccessByEntityFrame.Models
  4. {
  5. [Table("Students")]
  6. public class Students
  7. {
  8. public int ID { get; set; }
  9. public string Name { get; set; }
  10. public string Gender { get; set; }
  11. public int Fees { get; set; }
  12. }
  13. }
StudentsContext.cs
  1. using System.Data.Entity;
  2. namespace MVCDataAccessByEntityFrame.Models
  3. {
  4. public class StudentsContext : DbContext
  5. {
  6. public DbSet<Students> Students { get; set; }
  7. }
  8. }
Step 6

Go to the Controllers folder and add a controller to it.

Controllers

Step 7

Add the following code to the controller.
  1. using MVCDataAccessByEntityFrame.Models;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web.Mvc;
  6. namespace MVCDataAccessByEntityFrame.Controllers
  7. {
  8. public class StudentsController : Controller
  9. {
  10. public ActionResult Index()
  11. {
  12. StudentsContext studentsContext = new StudentsContext();
  13. List<Students> students = studentsContext.Students.ToList();
  14. return View(students);
  15. }
  16. public ActionResult Details(int id)
  17. {
  18. StudentsContext studentsContext = new StudentsContext();
  19. Students students = studentsContext.Students.Single(stu => stu.ID == id);
  20. return View(students);
  21. }
  23. }
  24. }
Step 8

Press Ctrl + Shift + B and then right-click on the index method and add a view.

index method

Step 9

Add the following code to the Index.cshtml.
  1. @model IEnumerable<MVCDataAccessByEntityFrame.Models.Students>
  2. @using MVCDataAccessByEntityFrame.Models;
  3. @{
  4. ViewBag.Title = "Students List";
  5. }
  7. <h2>Students List</h2>
  8. <ol start="1">
  9. @foreach (Students students in @Model)
  10. {
  11. <li id="item">
  12. @Html.ActionLink(students.Name, "Details", new { id = students.ID })
  13. </li>
  14. }
  15. </ol>
Step 10

Right-click on the Details method and add a view again.

add a view

Step 11

Add the following code to details.cshtml.
  1. @model MVCDataAccessByEntityFrame.Models.Students
  3. @{
  4. ViewBag.Title = "Students Details";
  5. }
  7. <table border="1">
  8. <tr>
  9. <td><b>ID:</b></td>
  10. <td>
  11. @Model.ID
  12. </td>
  13. </tr>
  14. <tr>
  15. <td><b>Name:</b></td>
  16. <td>@Model.Name</td>
  17. </tr>
  18. <tr>
  19. <td><b>Gender:</b></td>
  20. <td>@Model.Gender</td>
  21. </tr>
  22. <tr>
  23. <td><b>Fees:</b></td>
  24. <td>@Model.Fees</td>
  25. </tr>
  26. </table>
  27. <br />
  28. @Html.ActionLink("Back to Students List", "Index")
Step 12

Go to the web.config file in the Views folder in Solution Explorer and add the following code.
  1. <connectionStrings>
  2. <add name="StudentsContext" connectionString="server=ANKITBANSALPC; database = MVC; integrated security = SSPI" providerName="System.Data.SqlClient"/>
  3. </connectionStrings>
Step 13

Go to the Route.config file in the App_Start folder and paste in the following code.
  1. using System.Web.Mvc;
  2. using System.Web.Routing;
  4. namespace MVCDataAccessByEntityFrame
  5. {
  6. public class RouteConfig
  7. {
  8. public static void RegisterRoutes(RouteCollection routes)
  9. {
  10. routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
  12. routes.MapRoute(
  13. name: "Default",
  14. url: "{controller}/{action}/{id}",
  15. defaults: new { controller = "Students", action = "Index", id = UrlParameter.Optional }
  16. );
  17. }
  18. }
  19. }
Step 14

Save all the changes and Press F5 to run the project and you will see a list of Students and on clicking a specific student name, you will see the details of that student.

student list

details

Explanation

Students.cs

StudentsContext.cs

StudentsController.cs

Index.cshtml

Details.cshtml

Route.config

Download Source code here.

See this article in my own blog: debugsolutions and technewsinform.