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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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...