Problem with LINQ to Entities and String.StartsWith?
I would guess that EF don't support the overload of StartsWith that take the StringComparison parameter It should support StartsWith EndsWith and Contains so maybe you can try: dp.LastName. StartsWith(searchTerm) or: dp.LastName.ToLower(). StartsWith(searchTerm) and then make sure that searchterm also is lowercase.
I would guess that EF don't support the overload of StartsWith that take the StringComparison parameter. It should support StartsWith, EndsWith and Contains, so maybe you can try: dp.LastName. StartsWith(searchTerm) or: dp.LastName.ToLower().
StartsWith(searchTerm) and then make sure that searchterm also is lowercase.
Dead right, the whole string option thang throws EF – ProfK Sep 20 '09 at 15:09.
What I do if I want to do string manipulations is perform the query in linq-to-entities first, then manipulate the stings in linq-to-objects. In this example, I want to obtain a set of data containing a Contact's fullname, and ContactLocationKey, which is the string concatination of two Integer columns (ContactID and LocationID). Now, I grant that it does get cumbersome to have to write two anonymous selects, but I would argue that is outweighed by the convenience of which you can perform string (and other) functions not supported in L2E.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
Problem with LINQ to Entities and String.StartsWith
How to keep string data for having best performance when selecting string list via LINQ by StartsWith and EndsWith queries?
Dynamic LINQ Query in LINQ to Entities , problem with WHERE clause?
Linq: Convert datatable rows to Dictionary
Linq linq-to-entities add join if condition is met?
Is there a DataContext in LINQ-to-Entities (NOT Linq-to-SQL)?