使用.Contains（）和linq-to-sql(using .Contains() with linq-to-sql)

 我有以下查询接收作为参数的整数列表： 
 
public int GetMostRecent(List<int> TheIDs)
{
 ...using MyDC...

   var TheMostRecentID = (from d in MyDC.Data
                           where TheIDs.Contains(d.ID)
                           orderby d.DateTime
                           select d.ID).LastOrDefault(); 
}
 
 这是将参数集合中的列表与数据库中的数据进行匹配的最佳方式，还是比在linq-to-sql中使用.Contains（）方法更好的方法。 
 
 谢谢。 

I have the following query that receives a list of ints as a parameter:
 
public int GetMostRecent(List<int> TheIDs)
{
 ...using MyDC...

   var TheMostRecentID = (from d in MyDC.Data
                           where TheIDs.Contains(d.ID)
                           orderby d.DateTime
                           select d.ID).LastOrDefault(); 
}
 
Is this the best way to match a list within a parameter collection to data in the database or is there a better way than using the .Contains() method in linq-to-sql.
 
Thanks.

原文：https://stackoverflow.com/questions/9034673