Click here to Skip to main content
15,560,584 members
Home / Discussions / Database
   

Database

 
QuestionSQL Linq, Joins, returns 1st record over and over Pin
jkirkerx23-Jul-15 10:11
professionaljkirkerx23-Jul-15 10:11 
Answer[Solved] Pin
jkirkerx23-Jul-15 12:30
professionaljkirkerx23-Jul-15 12:30 
QuestionEntity Framework Book. Pin
Kevin Marois23-Jul-15 6:29
professionalKevin Marois23-Jul-15 6:29 
QuestionRe: Entity Framework Book. Pin
Richard MacCutchan23-Jul-15 7:36
mveRichard MacCutchan23-Jul-15 7:36 
AnswerRe: Entity Framework Book. Pin
Kevin Marois23-Jul-15 8:31
professionalKevin Marois23-Jul-15 8:31 
AnswerRe: Entity Framework Book. Pin
Mycroft Holmes23-Jul-15 15:10
professionalMycroft Holmes23-Jul-15 15:10 
QuestionSQL Linq, select from select and join Pin
jkirkerx21-Jul-15 14:27
professionaljkirkerx21-Jul-15 14:27 
SuggestionRe: SQL Linq, select from select and join Pin
Richard Deeming22-Jul-15 2:50
mveRichard Deeming22-Jul-15 2:50 
By creating two different DbContext classes, you're making things much harder for yourself. Entity Framework can only generate SQL queries for sets in a single context; as soon as you need to join to a set in a different context, you have to pull all of the data into memory first.

Based on your SQL query, both tables are in the same database, so it would make much more sense to have both sets in the same context. That way, you can join them together properly, and Entity Framework will generate more efficient queries.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: SQL Linq, select from select and join Pin
jkirkerx22-Jul-15 7:02
professionaljkirkerx22-Jul-15 7:02 
GeneralRe: SQL Linq, select from select and join Pin
Richard Deeming22-Jul-15 9:00
mveRichard Deeming22-Jul-15 9:00 
GeneralRe: SQL Linq, select from select and join Pin
jkirkerx22-Jul-15 10:04
professionaljkirkerx22-Jul-15 10:04 
QuestionTrouble working with dates again and union and sum Pin
jkirkerx20-Jul-15 14:08
professionaljkirkerx20-Jul-15 14:08 
AnswerRe: Trouble working with dates again and union and sum Pin
jkirkerx20-Jul-15 14:34
professionaljkirkerx20-Jul-15 14:34 
Generalmake nullable type Pin
jkirkerx20-Jul-15 14:59
professionaljkirkerx20-Jul-15 14:59 
General[Got It] Pin
jkirkerx21-Jul-15 10:58
professionaljkirkerx21-Jul-15 10:58 
GeneralThe above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx22-Jul-15 9:54
professionaljkirkerx22-Jul-15 9:54 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
Mycroft Holmes22-Jul-15 15:15
professionalMycroft Holmes22-Jul-15 15:15 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx23-Jul-15 7:38
professionaljkirkerx23-Jul-15 7:38 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
Brisingr Aerowing23-Jul-15 8:37
professionalBrisingr Aerowing23-Jul-15 8:37 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx23-Jul-15 9:21
professionaljkirkerx23-Jul-15 9:21 
QuestionDatabase management Pin
Otekpo Emmanuel19-Jul-15 10:22
Otekpo Emmanuel19-Jul-15 10:22 
GeneralRe: Database management Pin
PIEBALDconsult19-Jul-15 10:40
professionalPIEBALDconsult19-Jul-15 10:40 
AnswerRe: Database management Pin
Richard MacCutchan19-Jul-15 23:00
mveRichard MacCutchan19-Jul-15 23:00 
AnswerRe: Database management Pin
Mycroft Holmes19-Jul-15 23:32
professionalMycroft Holmes19-Jul-15 23:32 
AnswerRe: Database management Pin
Wendelius20-Jul-15 7:50
mveWendelius20-Jul-15 7:50 

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.