Easiest way to check record is exist or not in Linq to Entity Query

Question

in store procedure we can check record is exist or not using following query for fast performance

if EXISTS ( Select 1 from Table_Name where id=@id )

But what about Linq query. right now i have to store whole data in object like this

UserDetail _U=db.UserDetails.where(x=>x.id==1).FirstOrDefault();

Any Solution?

Answer 1

Use Linq's Any ie bool exist = db.UserDetails.Any(x => x.id == 1);

if(db.UserDetails.Any(x => x.id == 1)) {
    var userDetail = db.UserDetails.FirstOrDefault(x => x.id == 1);
}

Answer 2

bool exist = db.UserDetails.Where(x=>x.id==1).Any();
if(exist){
  //your-code
 }else{
  //your-code
}

Answer 3

Just check

if(_U == null)

This way you will get what you want in single query and you not need to execute addition query like

db.UserDetails.Any(x => x.id == 1)