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

ziorinfoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jagssiduralaConnect With a Mentor Commented:
we can achive this with Sql2008 feature called 'Table Valued Parameters'

Refer these links

http://msdn.microsoft.com/en-us/library/bb675163.aspx

http://www.sqlteam.com/article/sql-server-2008-table-valued-parameters
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.