Linq Query where clause

Jagjit Saini

In below query i want data from current date to currentdate - 7 days in where Clause in LINQ.

LDataContext context = new LDataContext();
public List GetLog()
{
    List Result = (from t in context.View_Logs
                                                 orderby t.EntryDate descending
                                    select t).ToList();
    return Result;
}

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
1. LDataContext context = new LDataContext();
2. public List GetLog()
3. {
4. List Result = context.View_Logs.Where(x=>x.EntryDate=>DateTime.Now.AddDays(-7) && x.EntryDate<=DateTime.Now).OrderByDescending(x=>x.EntryDate).ToList();
5. return Result;
6. }

Sachin Singh4y ago

also, follow my articles for LINQ

https://www.sharpencode.com/article/Linq