Sunday, November 30, 2014

execute a stored procedure in a loop

Hi Professionals


Here's my case. I am using C#, and I have a List<string> as a result of certain calculation. What is required that I need to insert each item of the list into the database. This is done through a stored procedure, which perform some business logic on an item, then inserts it into a table. What is the best scenario to iterate through my list items? is it feasible to pass item by item to the stored procedure, which means that I will handle the loop in my C# program? or pass the entire list to the procedure and modify it to handle the loop in t-sql ??


I appreciate your assistance.


Regards


No comments:

Post a Comment