Loading

I am Getting Error Error 'System.Linq.IQueryable

Yogesh Vedpathak

public ActionResult Login(UserResgitartion objUser)

{

if (ModelState.IsValid)

{

using (MyDatabaseEntities Db = new MyDatabaseEntities())

{

var obj = Db.UserResgitartions.Where(a => a.UserName.Equals(objUser.UserName));

if(obj != null)

{

// Error here in userId and UserName

Session["UserID"]= obj.UserId.ToString();

Session["USERNAME"] = obj.UserName.ToString();

return RedirectToAction("UserDashBoard");

}

return View(objUser);

}

4 Replies

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

Ramesh Palanivel8y ago
Hi Yogesh,

No need to type case your object.

var obj = Db.UserResgitartions.Where(a => a.UserName.Equals(objUser.UserName)).FirstOrDefault();
+1
Yogesh Vedpathak8y ago
Problem solve after i made chanes in Query Like

var obj = Db.UserResgitartions.Where(a => a.UserName.Equals(objUser.UserName)).FirstOrDefault();
+2
Yogesh Vedpathak8y ago
Not working after add this ...same Issue
+2
Ramesh Palanivel8y ago
Hi Yogesh,

You missed to add .ToList() in your code,

var obj = Db.UserResgitartions.Where(a => a.UserName.Equals(objUser.UserName)).ToList();
+2