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!