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");