Call Stored Procedure through Linq

Question

0.00/5 (No votes)

See more:

Hi,

I have a table Client having fields Id int,name varchar,address varchar
& have created stored procedure as below:

SQL

create procedure ClientInsert
@id int,
@name varchar(50),
@address varchar(100)
as
insert into Client (ID,Name,Address)values(@id,@name,@address).

The thing is that I want to insert the values using Linq in the table using stored procedure.
Please let me know how to implement.

Posted 26-Oct-10 2:09am

Mohd Wasif

Updated 26-Oct-10 2:12am

Sandeep Mewara

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TheyCallMeMrJames · Answer 1 · 2010-10-26T02:38:00

Per your last comment...

You would need to capture the value from the textbox and pass it through to the stored proc via the data context. Something similar to this:

string clientName = txtClientName.Text;
string clientAddress = txtClientAddress.Text;

YourDataContext dc = new YourDataContext();
dc.ClientInsert(yourId, clientName, clientAddress);

Again, I would not generate an ID client side, I would return it from the stored proc, so I would prefer to see this:

string clientName = txtClientName.Text;
string clientAddress = txtClientAddress.Text;
int? clientID = 0;
YourDataContext dc = new YourDataContext();
dc.ClientInsert(ref clientID, clientName, clientAddress);

Edited to fix second approach...

Cheers.

**PSK_** · Answer 2 · 2010-10-26T02:11:00

Solution 1

You can check this thread.

Stored Procedure in Linq to Sql Server[^]

Posted 26-Oct-10 2:11am

PSK_

TheyCallMeMrJames · Answer 3 · 2010-10-26T02:13:00

Solution 2

If you're using LINQ to SQL, you can drag the stored proc from the Server Explorer tool window onto your DBML diagram.

The stored proc will then be available through your Data Context.

You would likely want to return SCOPE_IDENTITY as well, so that the calling code would be able to know what the generated ID was of the record you've just inserted.

Cheers.

Posted 26-Oct-10 2:13am

TheyCallMeMrJames

Comments

Mohd Wasif 26-Oct-10 8:30am

Dear I have done all that but i need how to use through controls suppose if i m passing all the values through textbox and what would be linq query on button click.

thank u.

TheyCallMeMrJames 26-Oct-10 8:37am

Dear? Heheh...friendly! I'll post some pseudo code...

Call Stored Procedure through Linq

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Call Stored Procedure through Linq

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us