KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I want to get the today entered records using LINQ to SQL. I wrote the below code but it is returning previous date records also. DateTime todaysDate = DateTime.Now; DateTime yesterdaysDate = DateTime.Now.AddDays(-1); var result = (from a in cxt.visitor.OrderByDescending(n => n.singin) where (a.singin > yesterdaysDate && a.singin <= todaysDate) select new {a.visitorid, a.visitorname, a.visitingperson, a.phonenumber, a.reasonforvisit, a.signature, a.singin }); Can you please tell me how to get the today entered records only using LINQ to SQL?
Tags (comma-separated)
Save Edits
Cancel