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