Friday, January 6, 2012

How to check IN Clause Condition in LINQ


List<int> ObjCircleList = null;
ObjCircleList = new List<int>();

for (int i = 0; i < ddlCircle.SelectedValue.Split(',').Count(); i++)
{
ObjCircleList.Add(Convert.ToInt32(ddlCircle.SelectedValue.Split(',')[i]));
}

string CentreNames = "", CentreIds = "";

foreach (Center c in Dbi.Contactss.ListContacts(db, 10).Where(p => ObjCircleList.Contains(p.CorpCenterId)).OrderBy(p => p.Center_name))
{

CentreNames = CentreNames + c.Center_name.Trim().TrimEnd() + "|";
CentreIds = CentreIds + c.id.ToString() + "|";
}

No comments:

Post a Comment