linq SingleorDefault

Question

I want to return a single row from the users table using domain account id as my primary and unique key

However when i use singleordefault and see its sql translation it performs entire select * from Users

my query is..

var user = base.SingleorDefault(t=>t.domainaccountid)

i want this to return just one row!

Answer 1

You could try Where along with FirstOrDefault:

var user = base.Where(t => t.domainaccountid == 123).FirstOrDefault();

Answer 2

What is base ? Is it possible that you've coerced it to IEnumerable<T> at some point, rather than IQueryable<T>? that would cause this. Note that database composition is only possible when using IQueryable<T>, so if any of your methods have returned something other than this, composition will end.