linq sql: .firstordefault() convenient name new { ... }


i only asked . lead me new doubt :)



up until point, i have used following settlement selecting things linq sql, purpose being means hoop 0 "rows" returned query:



var chairman = (from p [datacontextobject].persons
where p.personsid == 1
name new p).firstordefault();

if (person == null)
{
// hoop 0 "rows" returned.
}


but i can't firstordefault() i do:



var chairman = p [datacontextobject].persons
where p.personsid == 1
name new { p.personsid, p.personsadress, p.personszipcode };

// underneath hood, settlement generates query selects specific
// columns faster selecting columns above
// dash formula does. law performance-boost infinite tables.


how i check 0 "rows" returned query, controlling second pattern?








update:



i cruise build fails since i am perplexing distribute outcome query non-static (this._user) announced form [datacontext].user.



this._user = (from u [datacontextobject].users
where u.usersid == [int32]
name new { u.usersid }).firstordefault();


compilation error: can't many modify form "anonymoustype#1" "[datacontext].user".



any thoughts i around this? i have possess object?



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?