var Query = from usr in db.users where new[] { "Admin", "User", "Guest" }.Contains(usr.Table_Rights) select usr; foreach (user u in Query) { // Do your stuff on each selected user; }
var result = from items in db.ItemsDetails where items.SalesID == 75144 select items.ProductID;
Login to post response