HOW TO USE 'LET' KEYWORD IN LINQ QUERY MVC ENTITY FRAMEWORK.

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 659  View(s)
Ratings:
Rate this:
I want to use 'let' keyword in linq query mvc entity framework. how to do this please help me.
  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: How to use 'let' keyword in linq query mvc entity framework.

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

        }
    }

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!