List of Objects bulk insert/Update in SQL Server table

Asked Nov 03 '15 at 09:37

Active Nov 03 '15 at 09:42

Viewed 735 times

In a C# program,I have a list, which contains 5 objects

obj 1:

BaseId=105,ID=1,value=4,numberOfMembers=2

obj 2:

BaseId=105,ID=2,value=6,numberOfMembers=3

obj 3:

BaseId=105,ID=3,value=10,numberOfMembers=5

obj 4:

BaseId=105,ID=0,value=20,numberOfMembers=10

obj 5:

BaseId=105,ID=0,value=25,numberOfMembers=50

I need to insert/update all these together into an sql table on a single button click. When id=0 insert it and when id != 0,update the table.

The numberOfMembers is selected from a drop down[2,3,5,10]. For a BaseID, numberOfMembers do not repeat, avoid inserting data at that time.

Please help me to achieve it using a SQL query.

Thanks in advance

edited Nov 03 '15 at 09:42

marc_s

asked Nov 03 '15 at 09:37

CSharpBeginner

*For a BaseID, numberOfMembers do not repeat, avoid inserting data at that time* - please elaborate this requirement. – Nikhil Vartak Nov 03 '15 at 09:44
Possible duplicate of [Solutions for INSERT OR UPDATE on SQL Server](http://stackoverflow.com/questions/108403/solutions-for-insert-or-update-on-sql-server) – Freek Wiekmeijer Nov 03 '15 at 09:46
Dropdown values [2,3,5,10,50] is taken from another table. For one baseiD only 5 records are allowed. Do not select any of the drop down values more than one time – CSharpBeginner Nov 03 '15 at 09:54
Use `Table_Value_Parameters` With `MERGE` Statement in Sql-Server. – A_Sk Nov 03 '15 at 09:55
Thanks to all your Replies. Merge statement helped me – CSharpBeginner Nov 09 '15 at 05:43

0 Answers0