Introduction

This article explains how to retrieve data from the database in the ASP. NET Web API. For retrieving the data we use the ADO.NET Entity Data Model. The Entity Data Model is an entity relationship data model. The Entity Data Model works with the SQL and other query Languages designed for invoking the declarative queries and updates in terms of entities and relationships.

The Entity Data Model gives links and information for working with the data used by the applications built on the Entity Framework.

The following is the procedure for retrieving the data from the database.

Step 1

First we create a table and insert some data into this table.

  1. Start SQL Server.
  2. Select "New Query".
  3. Create a database and a table.

Use the following queries:

create database Demo  
use Demo  
create table info(ID int IDENTITY PRIMARY KEY,Name varchar(50),Appointment varchar(50),Technology varchar(50), Task varchar(MAX) )  
Insert into info values ('A.P godse','Software Develpoer','.NET, Database', 'Computer Graphics')  
Insert into info values ('yashwant Kanitker','Programmer','.NET, PHP, JSON','Let us C')  
Insert into info values ('E balaguruswami','Programmer', '.NET, Javascript','Object Oriented System')  
Insert into info values ('R.S, Aggrawal','Software Developer',' Web API, MVC4','Design Analysis and Algorithm') 

Step 2

Step 3

Now add the Entity Framework to our application.

Step 4

Now open the Entity Data Model Wizard.

Step 5

In this step:

Step 6

In this step:

Step 7

Open the Home controller.

Enter this code:

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Web;  
using System.Web.Mvc;  
using ReteriveValue.Models;  
namespace ReteriveValue.Controllers  
{  
    public class HomeController : Controller  
    {  
        ReteriveDemoEntities reterive = new ReteriveDemoEntities();  
        public ActionResult Index()  
        {  
            return View(reterive);  
        }  
    }  
} 

Step 8

In the the "index.cshtml" file:

Write this code:

@model ReteriveValue.Models.ReteriveDemoEntities  
@{  
   ViewBag.Title = "Index";  
}  
<h2>Reteriving Data From Database</h2>  
 <!DOCTYPE html>  
<html>  
<head>  
<meta name="viewport" content="width=device-width" />  
<title>Index</title>  
<style type="text/css">  
table, td, th {  
 border: 1px solid green;  
}  
 th {  
        background-color: Pink;  
        color: white;  
     }  
    </style>  
    </head>  
    <body>  
    <table style="margin-left: 25%; margin-top: 10px; border: 2px solid LightGray;">  
     <tr>  
         <th>ID</th>  
         <th>Name</th>  
         <th>Appointment</th>  
         <th>Technology</th>  
         <th>Task</th>  
      </tr>  
   @foreach (var item in Model.infoes)  
   {  
       <tr>  
           <td>@item.ID</td>  
           <td>@item.Name<td>  
           <td>@item.Appointment<td>  
           <td>@item.Technology</td>  
           <td>@item.Task</td>  
        </tr>  
    }  
 </table>  
       </body>  
</html>

Step 9

Execute the application, the output will look like this:

Retrieve Data From Database in ASP.Net Web API