Equvalent linq code of "SELECT COUNT(*) FROM ToDos WHERE Name='ABC'" will be
considering
dbempEntities obj = new dbempEntities ();
var count = (from todo in obj.ToDos
where todo.Name=="ABC"
select obj.ToDos.AsEnumerable()
).Count();
here ToDos is my table name contained by entities yours 'tblemptemp'