Linq list filtered on list

-

modelItems is a list of Model
intList is a list of Integers


I am looking for modelItems where the id is in my Int List


var myFilteredList= modelItems.Where(item => intList.Contains(item.Id))

  .Select(a => a).ToList();

Comments

Post a Comment

Popular posts from this blog

Return View of a model or an HttpStatusCode

-
        public ActionResult Details(int? id)         {             if (id == null)             {                 return new HttpStatusCodeResult(HttpStatusCode.BadRequest);             }                     OrderNote orderNote = mymethodtoretriverecord(id);             if (orderNote == null)             {                 return HttpNotFound();             }             return View(orderNote);         }        
Read more

Linq - Data Entities - Records by Max Date with CASE

-
Image
 I needed to get essentially a summary by case statement for a given date.  As you can see I have defined the MAX date into a variable.  This example also shows using a substring of the first character in a LET statement  DateTime? maxDate =                 (from a in context.tbl_tslog                 orderby a.CurrentTime                 select (DateTime?) a.CurrentTime ).Max(); var dbRecords = (from c in context.tbl_testlog                            where (c.CurrentTime >=maxDate)                                         let range = (  c.Usr.ToUpper().Substring(0,1) == "B" ? "US" :                     ...
Read more

Meta Data - Annotating Models

-
One of the issues with using Entity Framework is that you may want some special annotation but you don't want to use a DTO or other object outside of EF. One way to afford you the opportunity to Annotate on the original EF model is to extend with a partial class of meta data. In your Data Models folder (or really anywhere in your data project) you would add a class (Partial Classes) that would contain empty pointers to your data classes - (in my tt files I have a company class and a systemUser class which represent models from the tables in my database): PartialClasses.cs using System.ComponentModel.DataAnnotations; namespace MySite.Data {     [MetadataType(typeof(systemUsersMetadata))]     public partial class systemUser     {     }     [MetadataType(typeof(companyMetadata))]     public partial class company     {     } } Once you have this setup you can begin to annotate! Create a system...
Read more