Click here to Skip to main content
15,904,155 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# Color challenge Pin
BillWoodruff2-Jul-17 14:35
professionalBillWoodruff2-Jul-17 14:35 
GeneralRe: C# Color challenge Pin
harold aptroot2-Jul-17 15:07
harold aptroot2-Jul-17 15:07 
GeneralRe: C# Color challenge Pin
BillWoodruff2-Jul-17 19:21
professionalBillWoodruff2-Jul-17 19:21 
GeneralRe: C# Color challenge Pin
Richard Deeming3-Jul-17 1:35
mveRichard Deeming3-Jul-17 1:35 
GeneralRe: C# Color challenge Pin
BillWoodruff3-Jul-17 2:51
professionalBillWoodruff3-Jul-17 2:51 
Questionprinting an string data. Pin
rahul199529-Jun-17 20:21
rahul199529-Jun-17 20:21 
AnswerRe: printing an string data. Pin
OriginalGriff29-Jun-17 20:34
mveOriginalGriff29-Jun-17 20:34 
AnswerRe: printing an string data. Pin
Richard MacCutchan29-Jun-17 21:36
mveRichard MacCutchan29-Jun-17 21:36 
AnswerRe: printing an string data. Pin
bindumol L29-Jun-17 21:53
bindumol L29-Jun-17 21:53 
SuggestionRe: printing an string data. Pin
Richard MacCutchan29-Jun-17 23:07
mveRichard MacCutchan29-Jun-17 23:07 
Questionqr code printing. Pin
rahul199528-Jun-17 0:31
rahul199528-Jun-17 0:31 
AnswerRe: qr code printing. Pin
Pete O'Hanlon28-Jun-17 0:35
mvePete O'Hanlon28-Jun-17 0:35 
Questionhow we can adjust the size of qr code while printing? Pin
rahul199527-Jun-17 19:07
rahul199527-Jun-17 19:07 
AnswerRe: how we can adjust the size of qr code while printing? Pin
OriginalGriff27-Jun-17 19:51
mveOriginalGriff27-Jun-17 19:51 
QuestionHow to Check Data for data existence in database using C# Pin
Tej_dev27-Jun-17 8:23
Tej_dev27-Jun-17 8:23 
AnswerRe: How to Check Data for data existence in database using C# Pin
Mycroft Holmes27-Jun-17 19:32
professionalMycroft Holmes27-Jun-17 19:32 
AnswerRe: How to Check Data for data existence in database using C# Pin
jschell28-Jun-17 6:03
jschell28-Jun-17 6:03 
GeneralRe: How to Check Data for data existence in database using C# Pin
Tej_dev28-Jun-17 9:20
Tej_dev28-Jun-17 9:20 
GeneralRe: How to Check Data for data existence in database using C# Pin
Pete O'Hanlon28-Jun-17 10:44
mvePete O'Hanlon28-Jun-17 10:44 
GeneralRe: How to Check Data for data existence in database using C# Pin
Tej_dev29-Jun-17 4:51
Tej_dev29-Jun-17 4:51 
GeneralRe: How to Check Data for data existence in database using C# Pin
Pete O'Hanlon29-Jun-17 4:55
mvePete O'Hanlon29-Jun-17 4:55 
GeneralRe: How to Check Data for data existence in database using C# Pin
jschell2-Jul-17 7:10
jschell2-Jul-17 7:10 
So a restatement of your original question to provide the actual problem.

You have a large number set of data that originates from outside of the database.
You need to process that data either by creating new records or updating existing ones.


So to start with, at least a few years ago (probably 10) universally it was always much more efficient to use database specific command line tools to batch process data. So you don't use C# at all. Although your C# might be used to initially produce the file which is then used for the batch processing.

As the other poster noted you database might support syntax that will do either an update or an insert. However if that is not the case then you can load the data into a different table and then, in the database itself (not C#) process the data to move it into the correct table(s).

You can also do further research by using "batch", "large" and "records" along with your actual database to seek other solutions.
QuestionRegex uppercase Pin
Farhad Eft27-Jun-17 0:00
Farhad Eft27-Jun-17 0:00 
QuestionRe: Regex uppercase Pin
Richard MacCutchan27-Jun-17 0:46
mveRichard MacCutchan27-Jun-17 0:46 
AnswerRe: Regex uppercase Pin
Pete O'Hanlon27-Jun-17 0:48
mvePete O'Hanlon27-Jun-17 0:48 

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.