How I can retrieve data from stored procedure in multiple table?

Question

I have a stored procedure in SQL as below:

CREATE PROCEDURE USP_Select
    (@id INT)
AS
    SELECT * FROM EMO;
    SELECT * FROM student WHERE id = @id;
    SELECT * FROM tbl1;

    RETURN 0

I am getting data using Entity Framework from that stored procedure using this code:

Modalities context = new Modalities();
context.USP_Select(1);

How can I define which table data gets in my code?

So here how can I get data different tables in code from the stored procedure?

Does this help? msdn.microsoft.com/en-us/library/jj691402(v=vs.113).aspx — Gabriel Rainha
– Gabriel Rainha, Commented Nov 2, 2017 at 11:20

Sunny Jangid · Accepted Answer · 2017-11-02 12:27:11Z

0

first, add your stored procedure in .edmx file and create a complex type for that stored procedure and you can use an entity. Use the following link to create complex type

Adding stored procedures complex types in Entity Framework

answered Nov 2, 2017 at 12:27

Sunny Jangid

5764 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

imanshu15 · Accepted Answer · 2017-11-06 12:13:51Z

0

Cant you just pass a parameter to select which table you wanna get data from?

CREATE PROCEDURE USP_Select
   @table varchar(50),
   @id INT = NULL
    AS
    BEGIN

     IF @table = "EMO" 
     BEGIN 
        SELECT * FROM EMO;
     END
     ELSE IF @table = "student"
     BEGIN
        SELECT * FROM student WHERE id = @id;
     END
     ELSE IF @table = "tal1"
     BEGIN
        SELECT * FROM tbl1;
     END


END

answered Nov 6, 2017 at 12:13

imanshu15

7644 silver badges24 bronze badges

Collectives™ on Stack Overflow

How I can retrieve data from stored procedure in multiple table?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related