How to add List of collection to DataBase. I have initialized one list[int32], add data through “add to collection” after how to store data into database
Loop over the collection and insert data to DB with Database Activities:
After Add to collection i have used for each loop to loop through the collection of list inside that i have put Execute Non Query activity.
This is my workflow of for each.
I have to store the array of data in last name like this in database.
This is the code in Execute Non Query
“Update Table_1 set [Last Name]='”+Convert.ToString(item)+“’ where [First Name]=‘A’”
I got the solution.
Thank you…