CODEWITHSUNDEEP
c#entity-frameworklinq-to-entities
pravprab
pravprab

Reputation: 2293

LINQ to Entities does not recognize the method 'System.DateTime ToDateTime(System.String)' method

I am trying to convert one application to EntityFrameWork codefirst. My present code is

 string sFrom  ="26/12/2013";
 select * FROM Trans where  CONVERT(datetime, Date, 105) >=   CONVERT(datetime,'" + sFrom + "',105)

And i tried 

 DateTime dtFrom = Convert.ToDateTime(sFrom );
TransRepository.Entities.Where(x  =>Convert.ToDateTime(x.Date) >= dtFrom)

But I got an error like this

LINQ to Entities does not recognize the method 'System.DateTime ToDateTime(System.String)' method

Please help Thanks in advance

Upvotes: 7

Views: 50248

Answers (4)

Sam Kuppusamy
Sam Kuppusamy

Reputation: 31

Take the convert part out of linq statement and keep it in a variable, like this:

var xyz = Convert.ToDateTime("12/31/2018");

and use this variable in the linq statement.

Upvotes: 3

Phillip herd
Phillip herd

Reputation: 1

/i had a similar problem where i was getting a search string and querying a datetime column... see line 4/

1)case "Admission_Date":
2)if (!String.IsNullOrEmpty(SearchValue))
3)   {
4)   DateTime dtFrom = 
Convert.ToDateTime(SearchValue); 
wards = from s in db.CORE_DATA_tbl
    where s.Admit_Date == dtFrom
    orderby s.ActionType, s.AdmissionLocation
    select s;
    }
    break;

Upvotes: 0

Manish Mishra
Manish Mishra

Reputation: 12375

when you do this:

TransRepository.Entities.Where(x  =>Convert.ToDateTime(x.Date) >= dtFrom)

LINQ to Entities cannot translate most .NET Date methods (including the casting you used) into SQL since there is no equivalent SQL. What you need to do is to do below:

 DateTime dtFrom = Convert.ToDateTime(sFrom );
  TransRepository
 .Entities.ToList()//forces execution
 .Where(x  =>Convert.ToDateTime(x.Date) >= dtFrom)

but wait the above query will fetch entire data, and perform .Where on it, definitely you don't want that,

simple soultion would be this, personally, I would have made my Entity field as DateTime and db column as DateTime

but since, your db/Entity Date field is string, you don't have any other option, other than to change your field in the entity and db to DateTime and then do the comparison

Upvotes: 9

Ann L.
Ann L.

Reputation: 13975

Why is your date column a string? Shouldn't it be a DateTime?

Regardless, if you attempt to perform conversions using .NET functions in a .Where statement against a repository of entities, you'll get that error.

Your best option would be to change that column from a string to a DateTime and proceed from there. If you do, the .Where statement would be:

DateTime dtFrom = Convert.ToDateTime(sFrom );
var something = TransRepository.Entities.Where(x  => x.Date >= dtFrom) ;

Upvotes: 3

Related Questions