Code
IList<string> list = new List<string>();
list.Add("00002");
list.Add("00003");
list.Add("00006");
list.Add("00004");
IList<Customer> clist = (from cust in ctx.Customer where list.ToArray().Contains(cust.CustomerCode) select cust).ToList<Customer>();
IList<string> list = new List<string>();
list.Add("00002");
list.Add("00003");
list.Add("00006");
list.Add("00004");
IList<Customer> clist = (from cust in ctx.Customer where list.ToArray().Contains(cust.CustomerCode) select cust).ToList<Customer>();
换一种方法
Code
IList<string> list = new List<string>();
list.Add("00002");
list.Add("00003");
list.Add("00006");
list.Add("00004");
string codes = string.Join(",", list.Select(c=>"'"+c+"'").ToArray());
string query = "SELECT VALUE C FROM Customer AS C WHERE C.CustomerCode IN {" + codes + "}";
ObjectQuery<Customer> custobject = new ObjectQuery<Customer>(query, ctx);
IList<Customer> clist = custobject.ToList<Customer>();
IList<string> list = new List<string>();
list.Add("00002");
list.Add("00003");
list.Add("00006");
list.Add("00004");
string codes = string.Join(",", list.Select(c=>"'"+c+"'").ToArray());
string query = "SELECT VALUE C FROM Customer AS C WHERE C.CustomerCode IN {" + codes + "}";
ObjectQuery<Customer> custobject = new ObjectQuery<Customer>(query, ctx);
IList<Customer> clist = custobject.ToList<Customer>();