Getting error in LINQ

Question

LINQ to Entities does not recognize the method 'System.DateTime ToDateTime(System.String)' method, and this method cannot be translated into a store expression.

 

IN This Line :-

 

Events = db.Events.Where(a => (a.Active == true) && (a.IsDelete == false && a.IsRejected == false && Convert.ToDateTime(a.EventEndDate) > DateTime.Now)).ToList(); 

Answer 1

Hi,

 

Please try like below - 

Events = db.Events.Where(a => (a.Active == true) && (a.IsDelete == false && a.IsRejected == false && SqlFunctions.DateDiff("s",a.EventEndDate, DateTime.Now) > 0)).ToList();

Answer 2

Midhu T P Sir.... thank you so much