LINQPad 调试

 

 

var ss=from o in Orders
from od in OrderDetails.Where(od=>od.OrderId == od.OrderId)
from c in Courses.Where(c=>c.CourseId == od.CourseId)
from cs in CourseSections.Where(cs => cs.CourseId == c.CourseId)
where o.SellerUserId == 10040
&& (o.Status == 2 ||o.Status ==3)
&& c.UserId == 10040
&& (c.Type ==1 || c.Type ==2)
&& cs.StartTime.Value.Day.Equals(DateTime.Now.Day)
select new{
CourseId = c.CourseId,
Title = c.Title,
UserId = c.UserId,
StartTime = cs.StartTime,
OrderId = o.OrderID
};
ss.Dump("Filtered");