Search code examples
entity-frameworkstored-procedures

Entity Framework stored procedure with multiple resultsets?

I am new to EF4 .

I am using a stored procedure that returns 2 resultsets? I understand that this is not possible and not supported.Pity!

What is the workaround? any code examples?

Thanks a lot

Solution

  • A blog post on the subject: http://blogs.infosupport.com/blogs/willemm/archive/2010/07/16/ado-net-entity-framework-advanced-scenarios-working-with-stored-procedures-that-return-multiple-resultsets.aspx

    Some possibly useful extensions: http://code.msdn.microsoft.com/EFExtensions