tags:

views:

8

answers:

0

I have a db with sprocs, and it uses Linq to Sql's datacontext to access them. I believe that every time you execute the method call that represents the sproc from the datacontext it fires off the request to the database.

I was wondering if there was a way of batching the requests, similarly to how the datacontext batches non-sproc calls? Specifically, I'm thinking in terms of transactions, and not maintaining transactions across calls to the db.

Example:

MyDataContext dc = new MyDataContext(); dc.MySproc(myparam); dc.MySproc(myparam); dc.MySproc(myparap);

If I'm not mistaken, the above would send three requests to the db. How can those simply get batched and sent up in one swoop?

Thanks!