How to convert select query to lamda expression in mvc

IEnumerable<SelectListItem> stores =
        from PAN_UPLOAD in database.Stores
        where store.Orgcode="PISCAP" //and condition can be added
        select new SelectListItem { Value = store.Name, Text = store.ID,... };//Columns you want

 ViewBag.storeSelector = stores;

IEnumerable<SelectListItem> stores = database.Stores
        .Where(store => store.Orgcode== "PISCAP") //We can and condition 
        .Select(store => new SelectListItem { Value = store.Name, Text = store.ID,etc }); // Columns that you need

 ViewBag.storeSelector = stores;

 var query1 =  from RspUploadId,OrderId in PO_AMS c
                        where RspUploadId =775
                        join p in PAN_ORDRSP_TRK on c.OrderId equals p.OrderId
                        select (c.ODA063 == null ? null : 'kokhoong.wong@sg.panasonic.com')  
                        new { Category = c.Name, Name = p.Name };

 
var result = aspnet_Users
                .Join(aspnet_Membership, 
                u => u.MyUserId, 
                m => m.MyUserId, 
                (u, m) => new
             {
                UserName = u.UserName,
                IsApproved = u.IsApproved
             }
            );