CODEWITHSUNDEEP
c#sqllinqentity-frameworkasp.net-mvc-4
Kulahan
Kulahan

Reputation: 522

How to set an Entity Framework query equal to a string

I'm very new to Entity Framework. I'm trying to use it to query the database, and I want to set a string equal to the result of that query.

Here's the code I'm using:

string UserId = (db.StudentModel.Where(b => b.UserName == strCert)).ToString();

Now, obviously this sets UserId equal to the query. How do I set UserId equal to the result?

Upvotes: 0

Views: 1738

Answers (2)

har07
har07

Reputation: 89285

Do you mean something like this :

string UserId = db.StudentModel.FirstOrDefault(b => b.UserName == strCert).UserId;

or more safely :

var student = db.StudentModel.FirstOrDefault(b => b.UserName == strCert);
if(student != null) 
{
    string UserId = student.UserId;
    /* do something with UserId here */
}

Upvotes: 2

Sergey Boiko
Sergey Boiko

Reputation: 471

use this: 

db.StudentModel.FirstOrDefault(b => b.UserName == strCert).UserId

but would be better to get object and check for null

var user = db.StudentModel.FirstOrDefault(b => b.UserName == strCert);

Upvotes: 1

Related Questions