get data from the table

Question

hi

i am using entity frame work in asp.net application.

Empid	login
1	102
2	103
3	104

how to get only one login of the empid=1 empid is primary key.

public static int GetLogid(int eid)

{

int res;

int bid = (from a in Entities.EmpLog

where EmpId==eid

select a.logId).First();

return res;

}

in the above format raise the error. int? to int

Munesh Sharma · Answer

public static int GetLogid(int eid) { int res; int ? bid = (from a in Entities.EmpLog where EmpId==eid select a.logId).First(); return res; }

Shuvojit Halder · Answer

You can do public static int GetLogid(int eid) { DbEntities Entities=new DbEntities(); int bid = (from a in Entities.EmpLog where EmpId==eid select a.login ).FirstOrDefault(); return bid ; }