Loading

Facing error while getting value in property

Basit Nisar

LastModifiedDate= db.Database.SqlQuery("SELECT [dbo].[fnGetLastModifiedDate]( @TimeCardID,@InvoiceSourceTypeID)",
new SqlParameter("@TimeCardID", timecard.TimeCardID),
new SqlParameter("@InvoiceSourceTypeID", 1)
).FirstOrDefault(),

This function is returning DateTime value which i am adding in entity frame work code ,

but when running the solution it gives error

["LINQ to Entities does not recognize the method "]

Please suggest

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul3y ago
Hello Basit,

The error message "LINQ to Entities does not recognize the method" occurs because Entity Framework cannot translate the "fnGetLastModifiedDate" function into SQL code.

One way to resolve this issue is to retrieve the data from the database first, and then use LINQ to manipulate the data in memory.
0
Naimish Makwana3y ago
Hello Basit,

Please check below link it may helpful to you.

https://stackoverflow.com/a/22660119/3054222

Thanks

Naimish Makwana
0