SQL Linq to SQL帮助(&L)

这可能是你想要的:

var a = from myObj in db.MyObjs
        group myObj by myObj.Date.ToString("yyyy-mm")
            into ymGroup
            select new { Date = ymGroup.Key, Start = ymGroup.Min(c => c.ID), End = ymGroup.Max(c => c.ID) };

    tableData.GroupBy(i => i.Date).Select(i => new
          {
              DateTime = i.Key,
              Start = i.Min(j => j.ID),
              End = i.Max(j => j.ID)
          });

我不是这方面的专家,但您可以尝试以下代码

var yourRows = _entities.YourTable.Where(colid => ((colid.Id == 3) || (colid.Id == 6) || (colid.Id == 8)));
return View(yourRows);

希望它对你有用!!

当心