Click here to Skip to main content
14,920,872 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
AnswerRe: Question for DB admins, DB architects, etc. Pin
Sander Rossel27-Apr-21 22:47
professionalSander Rossel27-Apr-21 22:47 
GeneralRe: Question for DB admins, DB architects, etc. Pin
Phil Boyd28-Apr-21 1:26
MemberPhil Boyd28-Apr-21 1:26 
GeneralRe: Question for DB admins, DB architects, etc. Pin
jochance28-Apr-21 5:24
Memberjochance28-Apr-21 5:24 
AnswerRe: Question for DB admins, DB architects, etc. PinPopular
Carl_Sharman27-Apr-21 22:55
MemberCarl_Sharman27-Apr-21 22:55 
AnswerRe: Question for DB admins, DB architects, etc. Pin
Snorri Kristjansson27-Apr-21 23:04
professionalSnorri Kristjansson27-Apr-21 23:04 
AnswerRe: Question for DB admins, DB architects, etc. Pin
Slacker00728-Apr-21 0:17
professionalSlacker00728-Apr-21 0:17 
AnswerRe: Question for DB admins, DB architects, etc. Pin
Jörgen Andersson28-Apr-21 1:31
professionalJörgen Andersson28-Apr-21 1:31 
AnswerRe: Question for DB admins, DB architects, etc. Pin
maze328-Apr-21 6:28
professionalmaze328-Apr-21 6:28 
Just a point about what often seen as EF making very large queries for simple things.

If doing something like Get Record Where ID = 5

Quick SQL could be "select * from table where id = 5"

EF will use the full expanded out version, so that * becomes all the fields in the table.

So just like writing suitable SQL quieres, EF needs to be used appropriately. If just want to get 2 fields from a 20 field table, then in EF use .Select and Where in combination, and will generate out suitable query.

AnswerRe: Question for DB admins, DB architects, etc. Pin
Gerry Schmitz28-Apr-21 8:00
mveGerry Schmitz28-Apr-21 8:00 
GeneralRe: Question for DB admins, DB architects, etc. Pin
MSBassSinger28-Apr-21 8:11
professionalMSBassSinger28-Apr-21 8:11 
AnswerRe: Question for DB admins, DB architects, etc. Pin
Matt McGuire28-Apr-21 12:51
professionalMatt McGuire28-Apr-21 12:51 
AnswerRe: Question for DB admins, DB architects, etc. Pin
#realJSOP28-Apr-21 22:36
mva#realJSOP28-Apr-21 22:36 
AnswerRe: Question for DB admins, DB architects, etc. Pin
Luca Leonardo Scorcia30-Apr-21 13:21
professionalLuca Leonardo Scorcia30-Apr-21 13:21 
AnswerRe: Question for DB admins, DB architects, etc. Pin
Tomasz Jureczko2-May-21 7:14
MemberTomasz Jureczko2-May-21 7:14 
GeneralUnknown unknowns Pin
honey the codewitch27-Apr-21 11:05
mvahoney the codewitch27-Apr-21 11:05 
GeneralRe: Unknown unknowns Pin
BillWoodruff27-Apr-21 11:40
mveBillWoodruff27-Apr-21 11:40 
GeneralRe: Unknown unknowns Pin
honey the codewitch27-Apr-21 11:42
mvahoney the codewitch27-Apr-21 11:42 
GeneralRe: Unknown unknowns Pin
BillWoodruff27-Apr-21 12:07
mveBillWoodruff27-Apr-21 12:07 
GeneralRe: Unknown unknowns Pin
honey the codewitch27-Apr-21 12:12
mvahoney the codewitch27-Apr-21 12:12 
GeneralRe: Unknown unknowns Pin
Eddy Vluggen27-Apr-21 12:05
professionalEddy Vluggen27-Apr-21 12:05 
GeneralRe: Unknown unknowns Pin
honey the codewitch27-Apr-21 12:14
mvahoney the codewitch27-Apr-21 12:14 
GeneralRe: Unknown unknowns Pin
Eddy Vluggen27-Apr-21 12:22
professionalEddy Vluggen27-Apr-21 12:22 
GeneralRe: Unknown unknowns Pin
honey the codewitch27-Apr-21 12:24
mvahoney the codewitch27-Apr-21 12:24 
AnswerRe: Unknown unknowns Pin
Eddy Vluggen27-Apr-21 12:43
professionalEddy Vluggen27-Apr-21 12:43 
GeneralRe: Unknown unknowns Pin
CPallini27-Apr-21 20:31
mveCPallini27-Apr-21 20:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.