In addition to mkgoud's Answer:
The logical thing to do is to pass Array/List to your store procedure. But, store procedure do not have a support for Array/List parameter handling. Thus you will need to come up with other innovative solutions. There are several way of doing this, take a look at
this post[
^].