Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Anonymous User 2160 21 Jan 2016

I want to use 'let' keyword in linq query mvc entity framework. how to do this please help me.

Anonymous User

Other

I am a content writter !

1 Answers

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);
        }
    }
}

advertising