Insert data into multiple tables using Storedprocedure in mvc3

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

I have created 3 tables like tblA, tblB, tblC
field are
tblA:
CharityId(PK) Name EmailId CategryId(FK)
1 abc abc@gmail.com 1
2 lmn lmn@gmail.com 1
3 pqr ssd@gmail.com 2
4 abc sss@gmail.com 3
tblB:
CategoryId(PK) Name
1 cat1
2 ca2
3 ca3
4 cat4
tblC:
CharityId(FK) CategryId(FK)
1 1
1 2
2 1
2 2
2 3

My intention is i when i want to insert data from view that will inserted to more than one tables like above and charityid and categoryid inserted into separate table like tblC.
How can i do this by using MVC3 with edm(stored procedures).

I have searched so many sites but no one can resolve this.
so please provide solution

Posted 27-Jan-13 21:10pm

DGKumar

Add a Solution

1 solution

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)

pranathis012 · Answer 1 · 2013-01-27T21:19:00

Hi,

In your SP itself you can insert data into 3 tables...
please follow the below syntax.

SQL

CREATE PROCEDURE XXXX
(
@Trans_Type VARCHAR(100),
--add your parameters---
)
AS
BEGIN
   IF @Trans_Type='INSERT-A'
       ---- INSERT DATA INTO tblA
   ELSE IF @Trans_Type='INSERT-B'
       ---- INSERT DATA INTO tblB
   ELSE IF @Trans_Type='INSERT-C'
       ---- INSERT DATA INTO tblC
END

you can do like this also....

I think it might be help for you....