Click here to Skip to main content
15,882,865 members
Home / Discussions / Database
   

Database

 
GeneralRe: Selective queries? Pin
Member 448708313-Jun-14 10:26
Member 448708313-Jun-14 10:26 
AnswerRe: Selective queries? Pin
jschell13-Jun-14 8:32
jschell13-Jun-14 8:32 
GeneralRe: Selective queries? Pin
Member 448708313-Jun-14 10:27
Member 448708313-Jun-14 10:27 
GeneralRe: Selective queries? Pin
Mycroft Holmes13-Jun-14 13:10
professionalMycroft Holmes13-Jun-14 13:10 
AnswerRe: Selective queries? Pin
Jörgen Andersson13-Jun-14 9:21
professionalJörgen Andersson13-Jun-14 9:21 
AnswerRe: Selective queries? Pin
Tim Carmichael13-Jun-14 13:00
Tim Carmichael13-Jun-14 13:00 
AnswerRe: Selective queries? Pin
Member 448708316-Jun-14 7:08
Member 448708316-Jun-14 7:08 
AnswerRe: Selective queries? Pin
Member 448708324-Jun-14 7:25
Member 448708324-Jun-14 7:25 
I've been looking at repository pattern implementations (using .Net and EF). Many of them aren't selective.

One of the most common methods is GetByID. This gets the whole record. Is this really bad? It will return one record, and in most systems it'll use the primary key.

One of the most shocking things I have seen is List<myentity> GetAll(). This returns ALL records in a table. This is clearly going to become an issue in large systems.

Another way some systems work is by using DDD and having aggregates return all related data. This tends to make the code simple, but I have doubts about scalability. Has anybody got experience with a system like this?
QuestionOLEDB for Old school DBASE or Foxpro databases, SUM with 2 decimal places Pin
jkirkerx12-Jun-14 18:30
professionaljkirkerx12-Jun-14 18:30 
AnswerRe: OLEDB for Old school DBASE or Foxpro databases, SUM with 2 decimal places Pin
Eddy Vluggen13-Jun-14 7:51
professionalEddy Vluggen13-Jun-14 7:51 
General[SOLVED] Pin
jkirkerx13-Jun-14 8:55
professionaljkirkerx13-Jun-14 8:55 
QuestionXQuery and Namespace Pin
kjfoley111-Jun-14 7:51
kjfoley111-Jun-14 7:51 
AnswerRe: XQuery and Namespace Pin
Eddy Vluggen11-Jun-14 9:36
professionalEddy Vluggen11-Jun-14 9:36 
AnswerRe: XQuery and Namespace Pin
kjfoley111-Jun-14 10:12
kjfoley111-Jun-14 10:12 
GeneralRe: XQuery and Namespace Pin
Mycroft Holmes11-Jun-14 13:03
professionalMycroft Holmes11-Jun-14 13:03 
QuestionIs there any one know what is the problem with my installing?I know nothing about PHP? Pin
basicshoes10-Jun-14 21:36
basicshoes10-Jun-14 21:36 
AnswerRe: Is there any one know what is the problem with my installing?I know nothing about PHP? Pin
Richard MacCutchan10-Jun-14 21:54
mveRichard MacCutchan10-Jun-14 21:54 
GeneralRe: Is there any one know what is the problem with my installing?I know nothing about PHP? Pin
basicshoes10-Jun-14 21:56
basicshoes10-Jun-14 21:56 
QuestionHow to get the Output based on Next Date if exists in the Table Pin
Robymon9-Jun-14 22:28
Robymon9-Jun-14 22:28 
SuggestionRe: How to get the Output based on Next Date if exists in the Table Pin
Richard MacCutchan9-Jun-14 22:47
mveRichard MacCutchan9-Jun-14 22:47 
AnswerRe: How to get the Output based on Next Date if exists in the Table Pin
Mycroft Holmes9-Jun-14 22:51
professionalMycroft Holmes9-Jun-14 22:51 
GeneralRe: How to get the Output based on Next Date if exists in the Table Pin
Robymon9-Jun-14 22:56
Robymon9-Jun-14 22:56 
GeneralRe: How to get the Output based on Next Date if exists in the Table Pin
Mycroft Holmes9-Jun-14 23:01
professionalMycroft Holmes9-Jun-14 23:01 
AnswerRe: How to get the Output based on Next Date if exists in the Table Pin
Tim Carmichael10-Jun-14 2:49
Tim Carmichael10-Jun-14 2:49 
AnswerRe: How to get the Output based on Next Date if exists in the Table Pin
Bernhard Hiller10-Jun-14 20:56
Bernhard Hiller10-Jun-14 20:56 

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.