none
POCO for multiple resultset RRS feed

  • Question

  • Hi,

    I have a stored procedure that returns data from 2 tables based on condition.

    For e.g

    if param = 1 then select * from A

    if param = 2 then select * from B

    if param =3 then select * from A; select * from B;

    Here the column of table A and B are different.

    For such cases how do i create a POCO entity. Should I create properties for both the columns (from table A and B) ??

    Any help would be appreciated. Thanx in advance.


    San

    Tuesday, August 21, 2012 10:33 AM

Answers

  • Hi San,

    Welcome to the MSDN forum.

    In my humble opinion, you are required to create two corresponding properties to receive the return data, because you do not know the return result and dynamic mapping is not possible.

    Good day.


    Alexander Sun [MSFT]
    MSDN Community Support | Feedback to us

    • Marked as answer by Alexander Sun Thursday, August 30, 2012 1:28 AM
    Thursday, August 23, 2012 6:35 AM