I have a xml in C# code and has to store in sql table (4 tables). what is best way to insert xml records in tables
send XML string to Stored procedure and there we store xml data into multiple tables?
using SQL bulk copy in c# and store it in table?
Note: In the second one, when i insert 4 datatables into table (sql bulkcopy), if 3rd table gets an error the previous 2 tables data still remains. it wont be.
please any one suggest me