Cant seem to convert int to a string within linq expression

Question

I am getting the following error on the following procedure

public Patient getPatientByPatientId(int PatientID)
{
    Patient patient = new Patient();
    if (PatientID == -1)
    {
       patient = new Patient();
    }
     else
    {
       using (var myContext = new SMBASchedulerEntities(this.Connectionstring))
        {
                patient = myContext.Patients
               .Where(w => w.PatientID == Convert.ToString(PatientID)).FirstOrDefault();
         }
        }
        return patient;
}

The error is

n unhandled exception of type 'System.NotSupportedException' occurred in EntityFramework.SqlServer.dll

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

Use `PatientID.ToString()` instead – Fabio Jan 13 '18 at 22:22 — Fabio, Jan 13 '18 at 22:22
your `Patient.PatientID` is a string? – Patrick Artner Jan 13 '18 at 22:24 — Patrick Artner, Jan 13 '18 at 22:24

Ehsan Ullah Nazir · Answer 1 · 2018-01-13T22:32:38.447

Convert your code

patient = myContext.Patients.Where(w => w.PatientID == Convert.ToString(PatientID)).FirstOrDefault();

to

patient = myContext.Patients.Where(w => w.PatientID ==PatientId.ToString()).FirstOrDefault();

Above query with assuming that PatientId is String

But Error says LINQ to Entities does not recognize the method 'System.String ToString(**Int32**)' method

Means PatientId is Int.

Then try with following code

patient = myContext.Patients.Where(w => w.PatientID ==PatientId).FirstOrDefault();

Cant seem to convert int to a string within linq expression

1 Answers1