Best Practices - Inserting Data using Stored Procedures & LINQ

See more:

C#3.0

C#

LINQ

Hi Everyone :)

I have been using LINQ and would like advice on how to use LINQ for inserting data.

I have reviewed some articles on how to use insert SPROCS with LINQ.

I am trying to get down to the basics here.

I have an SPROC called Client_Insert. Now the articles that I have read advice me to add the Client table (in this case) to the OR mapper and specify the Insert property to Customize and mention the SPROC for adding data to the Client table.

I simply wish to pass the parameters to the SPROC and execute it using LINQ.

Questions.
1. As I understand the only reason to use the OR mapper (as mentioned above) is to restrict adding the data through an SP only. Is this correct?

2. I want to create a helper function that executes an SP within the LINQ framework and using a (DBTransaction) transaction. If I were not using LINQ I would be passing an array of SQLParameters
e.g.
SqlParameter[] Myparam

How will I pass parameters to a helper function that executes an insert SP using the LINQ freamework?


3. Please give me any other useful advice :)

Have a great day!!