Linq to sql problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jaystar
    New Member
    • Oct 2011
    • 1

    Linq to sql problem

    Hi all I get this error
    The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value

    when using the below code. Any ideas please

    var longtime = from d in context.DocketT Bs
    //where (DateTime.Now.T oString("dd-MM-yyyy HH:mm:ss")) - Convert.ToDateT ime(c.Docket_Da teRaised + ":00") > TimeSpan.FromMi nutes(60)
    where (DateTime.Now - Convert.ToDateT ime(d.Docket_Da teRaised + ":00") > TimeSpan.FromMi nutes(2))
    // where c.Docket_Status .Equals("Ea")

    //DateTime.ParseE xact

    // && !(c.Docket_Stat us == "CL" || c.Docket_Status == "Ca")
    select new {d.Docket_Numbe r, d.Docket_DateRa ised, d.Docket_Machin e};
Working...