Click here to Skip to main content
14,422,668 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.
 
GeneralRe: The Themed CCC is dead as of Monday. Pin
OriginalGriff26-Sep-19 0:20
communityengineerOriginalGriff26-Sep-19 0:20 
GeneralRe: The Themed CCC is dead as of Monday. Pin
CodeWraith26-Sep-19 1:44
MemberCodeWraith26-Sep-19 1:44 
GeneralRe: The Themed CCC is dead as of Monday. Pin
OriginalGriff26-Sep-19 1:53
communityengineerOriginalGriff26-Sep-19 1:53 
GeneralRe: The Themed CCC is dead as of Monday. Pin
CodeWraith26-Sep-19 2:33
MemberCodeWraith26-Sep-19 2:33 
GeneralRe: The Themed CCC is dead as of Monday. Pin
OriginalGriff26-Sep-19 2:46
communityengineerOriginalGriff26-Sep-19 2:46 
GeneralRe: The Themed CCC is dead as of Monday. Pin
OriginalGriff26-Sep-19 0:19
communityengineerOriginalGriff26-Sep-19 0:19 
GeneralRe: The Themed CCC is dead as of Monday. Pin
PeejayAdams26-Sep-19 0:22
MemberPeejayAdams26-Sep-19 0:22 
GeneralWoohoo! SQL Achievement! :D Pin
Super Lloyd25-Sep-19 20:26
MemberSuper Lloyd25-Sep-19 20:26 
I have a C# process that synchronise 2 databases.

In Database 1 the code read a list of Transaction, as source data

In Database 2, the code will INSERT Transaction, and UPSERT (i.e. maybe insert, maybe update) linked Box, Order and Plate records (i.e. normalise data on the fly)

I.e. it should convert source line data into a tree structure in target database

I am not using EntityFramework autodetect, I detect meself.... (maybe I could have, just don't like it...) and also I am using EntityFramework Bulk Operation extension (maybe not needed since I am limited to 2000 record at a time due to a select with Contains(), doesn't support autodetect change btw)

At any rate the tree update code was becoming increasingly ever so painfully convoluted as the business people thought it would be cool to include this and that info....

And then ... breakthrough happened!
The tree bulk UPSERT (i.e. UPDATE+INSERT) code became simple again! Big Grin | :-D
A new .NET Serializer
All in one Menu-Ribbon Bar
Taking over the world since 1371!

GeneralRe: Woohoo! SQL Achievement! :D Pin
Kornfeld Eliyahu Peter25-Sep-19 21:02
mveKornfeld Eliyahu Peter25-Sep-19 21:02 
GeneralRe: Woohoo! SQL Achievement! :D Pin
Super Lloyd25-Sep-19 22:08
MemberSuper Lloyd25-Sep-19 22:08 
GeneralRe: Woohoo! SQL Achievement! :D Pin
OriginalGriff25-Sep-19 22:17
communityengineerOriginalGriff25-Sep-19 22:17 
JokeRe: Woohoo! SQL Achievement! :D Pin
GKP199225-Sep-19 22:36
professionalGKP199225-Sep-19 22:36 
GeneralRe: Woohoo! SQL Achievement! :D Pin
OriginalGriff25-Sep-19 22:37
communityengineerOriginalGriff25-Sep-19 22:37 
JokeRe: Woohoo! SQL Achievement! :D Pin
phil.o25-Sep-19 22:55
mvephil.o25-Sep-19 22:55 
GeneralRe: Woohoo! SQL Achievement! :D Pin
RickZeeland25-Sep-19 22:56
communityengineerRickZeeland25-Sep-19 22:56 
GeneralMini CCCs 130 Pin
Tim Deveaux25-Sep-19 19:12
MemberTim Deveaux25-Sep-19 19:12 
GeneralRe: Mini CCCs 130 Pin
PeejayAdams25-Sep-19 23:44
MemberPeejayAdams25-Sep-19 23:44 
GeneralRe: Mini CCCs 130 Pin
pkfox26-Sep-19 3:31
professionalpkfox26-Sep-19 3:31 
GeneralRe: Mini CCCs 130 - Done Pin
Tim Deveaux26-Sep-19 3:58
MemberTim Deveaux26-Sep-19 3:58 
NewsRIP Robert Hunter Pin
jeron125-Sep-19 12:50
Memberjeron125-Sep-19 12:50 
GeneralRe: RIP Robert Hunter Pin
Maximilien25-Sep-19 13:11
MemberMaximilien25-Sep-19 13:11 
GeneralRe: RIP Robert Hunter Pin
jeron125-Sep-19 13:13
Memberjeron125-Sep-19 13:13 
GeneralRe: RIP Robert Hunter Pin
Ravi Bhavnani25-Sep-19 17:02
professionalRavi Bhavnani25-Sep-19 17:02 
GeneralRe: RIP Robert Hunter Pin
Rick York25-Sep-19 17:04
mveRick York25-Sep-19 17:04 
GeneralRe: RIP Robert Hunter Pin
GenJerDan25-Sep-19 21:14
MemberGenJerDan25-Sep-19 21:14 

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.