Entity Framework Convert DateTime to string

Question

leaves = leaves.Where(s => s.Employee.Name.ToUpper().Contains(searchString.ToUpper())
                                   || s.StartDate.ToString().Contains(searchString));

This will leads to an error..please help me,

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

Eranga · Accepted Answer · 2012-01-24 07:37:12Z

3

Treat each case differently

DateTime dateValue;

if (DateTime.TryParse(searchString, out dateValue))
{
    leaves = leaves.Where(l => l.StartDate == dateValue);
}
else
{
    leaves = leaves.Where(s => s.Employee.Name.ToUpper().Contains(searchString.ToUpper()));
}

edited Jan 24, 2012 at 7:37

answered Jan 24, 2012 at 6:55

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

iJay Over a year ago

it works fine just missing this, leaves = leaves.Where(s => s.Employee.Name.ToUpper().Contains(searchString.ToUpper()));

Eranga Over a year ago

@user1134291 Sorry about that missing part. Updated my answer.

jeroenh · Accepted Answer · 2012-01-24 06:55:30Z

1

The error message says exactly what is going on: Entity Framework cannot translate that part of the expression into a SQL statement, which means you cannot search this way.

Without more context, your best option is probably to search by real dates (i.e. search since or until a certain date).

answered Jan 24, 2012 at 6:55

jeroenh

26.9k11 gold badges77 silver badges107 bronze badges

Collectives™ on Stack Overflow

Entity Framework Convert DateTime to string

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related