forum

home / developersection / forums / how to use 'let' keyword in linq query mvc entity framework.

Ask Question

How to use 'let' keyword in linq query mvc entity framework.

Anonymous User 2044 21-Jan-2016
I want to use 'let' keyword in linq query mvc entity framework. how to do this please help me.
asp.net mvc c#  linq  mvc  entity framework 
Updated on 21-Jan-2016
Anonymous User

Other

I am a content writter !

Follow
Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

21-Jan-2016

The 'let' keyword is useful in query syntax. It  allows re-use of the expression and makes the query more readable.

@model IList<ForumMVC.CUSTOMER>
@{
    ViewBag.Title = "WebGrid CRUD Operations";   
}
<table style="background-color: #ccc; width:800px;">
    <thead style="background-color: red;">
        <tr>
            <th>ID</th>
             <th>Name</th>
             <th>Phone</th>
             <th>Email</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>             
        </tr>
        }
    </tbody>
</table>
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 = (from s in db.CUSTOMER
                                    let lowercaseCustomerName = s.CUST_NAME.ToLower()
                                    where lowercaseCustomerName.EndsWith("singh")
                                    select s).ToList();
            return View(data);
        }
    }
}

How to use

advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy