As a newcomer to LINQ I am greatly intrigued by the possibilities, although still learning the dynamics. I have 2 queries written in LINQ: DataClassesDataContext dc = new DataClassesDataContext (); var debts = from rec in dc.OurRecords join xd in dc.ExcelDatas on new { rec.AccountNumber, rec.paidToUs, rec.dueToUs, rec.GST } equals new { AccountNumber = xd.Account, paidToUs = xd.Amount1, dueToUs = xd.Amount3, GST = xd.Amount4 } where (rec.ourDate.Value.CompareTo(xd.DateAgency.Value)>=0 && rec.ourDate.Value.CompareTo(xd.DateDirect.Value)
Read More...