how to reduce database call on saving the records
I have multiselect list for properties on my asp.net page which allow user to select some option and save it in a database.
Now the table structure is like this UserID and PropertyID.
Now, when I am saving this info currently I am running a loop and executed a single insert SP at a time.
Which surly makes the database call again and again.
I need to know is there any other way of doing these sort of task with minimum database calls
Now the table structure is like this UserID and PropertyID.
Now, when I am saving this info currently I am running a loop and executed a single insert SP at a time.
Which surly makes the database call again and again.
I need to know is there any other way of doing these sort of task with minimum database calls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.