|
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! 
|
|
|
|
|
DROP DATABASE ???
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
DROP database 1?
Well it contains more data than just the table I am migrating.
For now.... 
|
|
|
|
|
Not once DROP DATABASE has been executed...
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
It's scarier than DROP NUKE.
|
|
|
|
|
Nah ... just think of it as an "Extreme Compact" instruction. 
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
The SQL Swat:
DROP YOUR DATABASE AND HANDS UP!
"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."
|
|
|
|
|
Quote: business people
Those people should have no business with your code 
|
|
|
|
|
|
BAIT
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
Oh well done I was thinking of the other degree as in 96° in the shade
"We can't stop here - this is bat country" - Hunter S Thompson - RIP
|
|
|
|
|
Yep 
|
|
|
|
|
Robert Hunter, Grateful Dead Songwriter, Dead At 78 : NPR[^]
Great songwriter gone. 
"Let there be songs to fill the air" ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
I expect him to be grateful dead.
(ok, I'll grab my coat)
I'd rather be phishing!
|
|
|
|
|
OK, OK I'll give you that one, even if it is a tad early.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
/ravi
|
|
|
|
|
I am sure it was a long, strange trip for him.
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
Comic book colors on a violin river crying Leonardo
Words from out a silk trombone
I rang a silent bell, beneath a shower of pearls
In the eagle-winged palace of the Queen Chinee
|
|
|
|
|
One of the concert venues I walk past on the way to work has up a memorial to him on the front...
"Robert Hunter fare the well
Thanks for the long strange trip"
Or something like that. Well I look up and instantly notice 'the well' and could only wonder if they ran out of 'e's. I really want to stop by after work today and point it out to them. Because I live in a college down they have probably had 1000 others do the exact same thing.
|
|
|
|
|
Anyone with a decent job offer?
I want to quit mine...
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
My bosses are always looking for someone. But they realy demand something from you. Every friday we go outside and grill some steaks. And it also has occured that they reserve a table at the Oktoberfest and force you to gulp down two or three litres of Oktoberfestbier in two hours. You may also be asked to learn the Bavarian hymn and come in traditional clothing to such events.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
No good. I do not eat meat or drink alcohol...
However, my German not that bad... Used to spend summer - working - in East Germany, when I was younger...
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
Quote: working - in East Germany, when I was younger.
KGB or Stasi?
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
Maybe he just built some plastic cars[^].
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
They weren't plastic! They were cardboard. 
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
