Hello,
I am writing a Windows service that does some processing and build a list of Objects of Type A. For each object A in this list, I need to call a Oracle stored procedure, pass in 3 properties as parameters and get a value back (or not) and store the value (if there is one from SP) to the 4th property of the object.
So, same type of objects in list, same parameters being populated and same proc being called.
Now, instead of looping through the list and calling the proc every time, I was wondering if there is a way to gather a batch of 50 or 100 objects, pass their properties as parameters and get back a list of output values (some null, some non-null). That would reduce the number of calls made to the proc.
What would the best way be to handle the above scenario?
Thanks for your assistance
I am writing a Windows service that does some processing and build a list of Objects of Type A. For each object A in this list, I need to call a Oracle stored procedure, pass in 3 properties as parameters and get a value back (or not) and store the value (if there is one from SP) to the 4th property of the object.
So, same type of objects in list, same parameters being populated and same proc being called.
Now, instead of looping through the list and calling the proc every time, I was wondering if there is a way to gather a batch of 50 or 100 objects, pass their properties as parameters and get back a list of output values (some null, some non-null). That would reduce the number of calls made to the proc.
What would the best way be to handle the above scenario?
Thanks for your assistance