楼主提供的数据有限,没有发现到底是哪个字段标识每种菜是星期几上的,我根据自己猜测,给你个思路吧
也不知道行不行
public string GetNameByType(string type,DayOfWeek dw)
{
var obj = (from c in ObjectContext."食谱表"
where c."星期"==dw
select c).FirstOrDefault();
if (type == "主菜")
{
return obj.foodNames;
}
if (type == "主食")
{
return obj.staple_food;
}
if (type == "汤")
{
return obj.soup;
}
.
.
.
}
public void Find()
{
List<string> typeNames = new List<string>();
typeNames.Add("主菜");
typeNames.Add("主食");
typeNames.Add("汤");
.
.
.
foreach(var str in typeNames)
{
var list = from p in ObjectContext.BookInfoes
select new
{
星期一=GetNameByType(str,DayOfWeek.Monday),
星期二 = GetNameByType(str, DayOfWeek.Tuesday),
星期三 = GetNameByType(str, DayOfWeek.Wednesday),
星期四 = GetNameByType(str, DayOfWeek.Thursday),
.
.
.