hi i'm having problem with linq query datetime...
-
hi i'm having problem with linq query... this is what i have var query = from venue in db.Venues select venue; query = query.Where(q =>; SqlMethods.DateDiffDay(q.ExpiresDate, DateTime.Now) == 7); query = query.Where(q =>; q.IsDisplay).OrderByDescending(q =>; q.ExpiresDate); what i want is to populate venues which are expired 7 days from todate..but date formats are different of q.ExpiresDate and DateTime.Now. how to solve this problem...is thr anyway that i can format datetime.now to expiredatetime... need help urgetly...
-
hi i'm having problem with linq query... this is what i have var query = from venue in db.Venues select venue; query = query.Where(q =>; SqlMethods.DateDiffDay(q.ExpiresDate, DateTime.Now) == 7); query = query.Where(q =>; q.IsDisplay).OrderByDescending(q =>; q.ExpiresDate); what i want is to populate venues which are expired 7 days from todate..but date formats are different of q.ExpiresDate and DateTime.Now. how to solve this problem...is thr anyway that i can format datetime.now to expiredatetime... need help urgetly...
-
why are you not doing the whole query as LINQ?
var query = from venue in db.venues
where venue.IsDisplay && DateTime.Now.Subtract(venue.ExpiresDate).TotalDays == 7
select venue;hey J4amiec thankx for reply.i hv tried u r solution bt it gives this error Method 'System.TimeSpan Subtract(System.DateTime)' has no supported translation to SQL. ....
-
why are you not doing the whole query as LINQ?
var query = from venue in db.venues
where venue.IsDisplay && DateTime.Now.Subtract(venue.ExpiresDate).TotalDays == 7
select venue;finally manage to get done the work...maybe this is nt the correct way bt it works fine... var query = from venue in db.Venues where ((venue.ExpiresDate < DateTime.Today.AddDays(1).Date && venue.ExpiresDate > DateTime.Today.AddDays(-2).Date) || (venue.ExpiresDate < DateTime.Today.AddDays(7).Date && venue.ExpiresDate > DateTime.Today.AddDays(5).Date)) && venue.IsDisplay select venue;
-
hey J4amiec thankx for reply.i hv tried u r solution bt it gives this error Method 'System.TimeSpan Subtract(System.DateTime)' has no supported translation to SQL. ....