Compare with database table with class and insert

Question

1.00/5 (1 vote)

See more:

I have an huge data in a table now i want to add/update to the table.

I created the list of class for newly added data.

now want to insert the class data may be all some value need to be update rest of the inserted.

Which is the best approach?

What I have tried:

I try to basic approach using for loop but i think it not optimize way.

Posted 8-Jun-16 20:36pm

sabuj82

Updated 8-Jun-16 21:38pm

Add a Solution

Comments

Tomas Takac 9-Jun-16 2:55am

Not clear. Sounds like you want to insert/update a single record in the table. Correct? Does the table have a primary key?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sinisa Hajnal · Answer 1 · 2016-06-08T21:38:00

Since you didn't specify WHICH database its hard to give you hard and fast solution. In general, you have three ways:

1. Send all of the data for insert and update into the database - you need stored procedure with table (in SQL Server) or XML parameter - this way, all your processing is done in the database - SQL Server can treat XML as a table so you have bulk insert / update. This is the way I did it in 2010.

2. Use .NET specific classes SqlBulkInsert (or equivalents for your database) to send the data (you have to separate what is insert and what is update before sending) - NEVER USED, so I cannot provide any details

3. Send the data row by row, you can either decide in code (via RowState.Added, RowState.Modified properties) or in the database. If former, you need two stored procedures (or queries), one for insert, second for update). Or you can send the data into stored procedure and decide there. DB2 has a nice command MERGE which can do both at the same time :)

I hope this helps somewhat. Good luck