forum

Home / DeveloperSection / Forums / how to select and retrieve data using linq query in entity framework

Ask Question

how to select and retrieve data using linq query in entity framework

Anonymous User183021-Jan-2016
I want to  select and retrieve data using  linq query in entity framework how to do this please help me.
asp.net mvclinq mvc entity framework 
Updated on 21-Jan-2016
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

21-Jan-2016 


index.cshtml
@model IList<ForumMVC.CUSTOMER>
@{
    ViewBag.Title = "WebGrid CRUD Operations";   
}
<table style="background-color: #ccc; width: 100%;">
    <thead style="background-color: red;">
        <tr>
            <th>ID</th>
             <th>Name</th>
             <th>Phone</th>
             <th>Email</th>
             <th>Address</th>
        </tr>
    </thead>
    <tbody style="background-color: #ddd;">
        @foreach(var obj in Model)
        {
        <tr>
            <th>@obj.CUST_ID</th>
             <th>@obj.CUST_NAME</th>
             <th>@obj.CUST_PHONE</th>
             <th>@obj.CUST_EMAILID</th>
             <th>@obj.CUST_ADDRESS</th>
        </tr>
        }
    </tbody>
</table>
Controller
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using ForumMVC;
using System.Data.Entity;
using ForumMVC.Models;
namespace ForumMVC.Controllers
{
    public class HomeController : Controller
    {
        forumEntities1 db = new forumEntities1();
        public ActionResult Index()
        {
            IList<CUSTOMER> data = db.CUSTOMER.Where(p => p.CUST_ID < 70 && p.CUST_ID > 50).ToList();
            return View(data);
        }
    }
}

answer 415872101093100

 

Liked By