Loading

MVC Search by Id which is int type:

Dharmendra Kumar Pandit

8y1kLINQ

Hey can anyone help me for:

my code is : //SearchByID

public ActionResult SearchByID(string txtID)

{

var IDList = from n in db.tblDonors select n;

if (!String.IsNullOrEmpty(txtID))

{

IDList = IDList.Where(c =>Convert.ToString( c.D_ID).Contains(txtID));

}

return View(IDList);

}

I'm getting the following error:

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

3 Replies

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

Manav Pandya8y ago
Accepted answer
Hello

Just store txtID in seperate string variable and use it inside linq

And try to run c.D_ID without conver.tostring()

Let me know if something went wrong

Thanks
+5
kalai vanan8y ago
Hi,

try this bro

var GetIdList = db.tblDonors.where(s => s.D_ID == convert.Toint32(txtID)).select(s => s.D_ID).ToList();
0
Altaf Ansari8y ago
try this :
int id = Convert.ToInt32(txtID);
var IDList = db.tblDonors.Where(x=> x.D_ID==id).Select(y=> y.D_ID).toList();
+1