Click here to Skip to main content
14,271,317 members
   

C#

 
GeneralRe: help Pin
CHill608-Jul-19 2:17
protectorCHill608-Jul-19 2:17 
GeneralRe: help Pin
Mycroft Holmes8-Jul-19 11:26
memberMycroft Holmes8-Jul-19 11:26 
QuestionZKTeco with C# Pin
Member 142231355-Jul-19 20:01
memberMember 142231355-Jul-19 20:01 
AnswerRe: ZKTeco with C# Pin
OriginalGriff5-Jul-19 20:18
protectorOriginalGriff5-Jul-19 20:18 
GeneralRe: ZKTeco with C# Pin
BillWoodruff6-Jul-19 20:53
mveBillWoodruff6-Jul-19 20:53 
AnswerRe: ZKTeco with C# Pin
BillWoodruff6-Jul-19 20:50
mveBillWoodruff6-Jul-19 20:50 
QuestionC# LINQ JOIN: Getting out of memory exception Pin
Mou_kol5-Jul-19 10:03
memberMou_kol5-Jul-19 10:03 
AnswerRe: C# LINQ JOIN: Getting out of memory exception Pin
Mycroft Holmes5-Jul-19 13:28
memberMycroft Holmes5-Jul-19 13:28 
That query is such a dog breakfast that I'm not surprised it fails. You are probably creating the equivalent of an outer join and getting 800k * 800k records.

I would ask a couple of question of the requirements, why do you need 800k records in the client and how do you expect to use the collection when you have it.

If this was my problem I would create a view in the database to validate the joins and then select on the view with a filter (you cannot consume 800k record in the client).
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

GeneralRe: C# LINQ JOIN: Getting out of memory exception Pin
Mou_kol8-Jul-19 5:53
memberMou_kol8-Jul-19 5:53 
GeneralRe: C# LINQ JOIN: Getting out of memory exception Pin
Dave Kreskowiak8-Jul-19 6:27
mveDave Kreskowiak8-Jul-19 6:27 
GeneralRe: C# LINQ JOIN: Getting out of memory exception Pin
Eddy Vluggen8-Jul-19 8:22
mveEddy Vluggen8-Jul-19 8:22 
GeneralRe: C# LINQ JOIN: Getting out of memory exception Pin
Gerry Schmitz8-Jul-19 10:50
mveGerry Schmitz8-Jul-19 10:50 
GeneralRe: C# LINQ JOIN: Getting out of memory exception Pin
Mycroft Holmes8-Jul-19 11:31
memberMycroft Holmes8-Jul-19 11:31 
AnswerRe: C# LINQ JOIN: Getting out of memory exception Pin
Dave Kreskowiak5-Jul-19 18:55
mveDave Kreskowiak5-Jul-19 18:55 
AnswerRe: C# LINQ JOIN: Getting out of memory exception Pin
lmoelleb9-Jul-19 22:42
memberlmoelleb9-Jul-19 22:42 
GeneralRe: C# LINQ JOIN: Getting out of memory exception Pin
Mou_kol14-Jul-19 0:34
memberMou_kol14-Jul-19 0:34 
GeneralRe: C# LINQ JOIN: Getting out of memory exception Pin
lmoelleb14-Jul-19 10:41
memberlmoelleb14-Jul-19 10:41 
QuestionMouse delta Pin
MatrixRatrix4-Jul-19 0:14
memberMatrixRatrix4-Jul-19 0:14 
AnswerRe: Mouse delta Pin
BillWoodruff4-Jul-19 2:19
mveBillWoodruff4-Jul-19 2:19 
QuestionWPF MVVM Entity Framework(using code First Approach) Pin
Member 145206353-Jul-19 23:21
memberMember 145206353-Jul-19 23:21 
AnswerRe: WPF MVVM Entity Framework(using code First Approach) Pin
F-ES Sitecore3-Jul-19 23:28
mveF-ES Sitecore3-Jul-19 23:28 
GeneralRe: WPF MVVM Entity Framework(using code First Approach) Pin
Member 145206354-Jul-19 2:48
memberMember 145206354-Jul-19 2:48 
GeneralRe: WPF MVVM Entity Framework(using code First Approach) Pin
Gerry Schmitz4-Jul-19 7:36
mveGerry Schmitz4-Jul-19 7:36 
GeneralRe: WPF MVVM Entity Framework(using code First Approach) Pin
Mycroft Holmes4-Jul-19 13:01
memberMycroft Holmes4-Jul-19 13:01 
AnswerRe: WPF MVVM Entity Framework(using code First Approach) Pin
BillWoodruff4-Jul-19 2:22
mveBillWoodruff4-Jul-19 2:22 

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.