LINQ to Entities does not recognize the method 'System.String Last[String](System.Collections.Generic.IEnumerable`1[System.String])' method, and this method cannot be translated into a store expression.

Question

LINQ to Entities does not recognize the method 'System.String Last[String](System.Collections.Generic.IEnumerable`1[System.String])' method, and this method cannot be translated into a store expression.

Santosh Umarani 81

Hi,

I am executing the following query:
var testCases1 =
dbContext.CaseMasters.Where(x => x.VersionMasters.Any(s => s.IsDeleted && x.TestCaseID == s.TestCaseID
&& s.SupportedVersion.VersionID == s.SupportedVersionId
&& s.SupportedVersion.VersionBranches.Any(b => b.Branch. == branchName))
&& x.ProjectsMaster.TestProjectID == x.TestProjectID).AsEnumerable();

int count1 = testCases1.Count();

I am getting the error "LINQ to Entities does not recognize the method 'System.String LastString' method, and this method cannot be translated into a store expression."
May I know what am I doing wrong ? Please help me resolve the issue.
Kindly waiting for your response.

Thanks,
Santosh

Jack J Jun 25,296 Reputation points

2022-02-23T01:58:12.903+00:00

@Santosh Umarani , Welcome to Microsoft Q&A, based on your error, your code should have the Last keyword at least. However, I didn't see it. Which line throws the error?
Santosh Umarani 81 Reputation points

2022-02-23T03:36:16.257+00:00

Thank you JackJJun-MSFT for response.
I am getting the error while running "int count1 = testCases1.Count();"
Jack J Jun 25,296 Reputation points

2022-02-23T05:49:12.55+00:00

@Santosh Umarani , thanks for the response, based on my test, the code works for me without the problem. Then, I want to know how do you create the dbcontext, using code first, database first or adding ADO.NET Entity data Model? Also, you could refer to the link LINQ to Entities does not recognize the method '' method, and this method cannot be translated into a store expression. to select the object and convert it to the list.
·

Your answer

Jack J Jun 25,296 Reputation points

2022-02-23T01:58:12.903+00:00

@Santosh Umarani , Welcome to Microsoft Q&A, based on your error, your code should have the Last keyword at least. However, I didn't see it. Which line throws the error?
Santosh Umarani 81 Reputation points

2022-02-23T03:36:16.257+00:00

Thank you JackJJun-MSFT for response.
I am getting the error while running "int count1 = testCases1.Count();"
Jack J Jun 25,296 Reputation points

2022-02-23T05:49:12.55+00:00

@Santosh Umarani , thanks for the response, based on my test, the code works for me without the problem. Then, I want to know how do you create the dbcontext, using code first, database first or adding ADO.NET Entity data Model? Also, you could refer to the link LINQ to Entities does not recognize the method '' method, and this method cannot be translated into a store expression. to select the object and convert it to the list.
·

Share via

LINQ to Entities does not recognize the method 'System.String Last[String](System.Collections.Generic.IEnumerable`1[System.String])' method, and this method cannot be translated into a store expression.

Your answer