Stored proc with multiple returns

[lipanna]

I'm calling SP that has 5 of these conditions:

If (condition) select a, b, c... RETURN 0;

If (condition) select a, b, c... RETURN 0;

SP always returns only one resultset. Each select has exactly the same columns. However, generated POCO contains 5 resultsets and I get an error message that EF doesn't support multiple resultsets. Is there a way around it? EF Core 6. Thanks.

[sjh37]

@lipanna in your connection string add ;MultipleActiveResultSets=True

[lipanna]

Hi Simon, It is there by default, but doesn't seem to work...

Settings.ConnectionString = "Data Source=xxx;Initial Catalog=xxx;Integrated Security=True;MultipleActiveResultSets=True;Encrypt=false;TrustServerCertificate=true";

[NeilN1]

Piggy-backing on this - there's been no "magic" added to the latest versions of EF Reverse POCO to make up for the lack of EF Core's support for returning multiple result sets or table variables, right? We have to roll our own solution?

// public async Task<UspMemberStatusReportGetReturnModel> UspMemberStatusReportGetAsync() Cannot be created as EF Core does not yet support stored procedures with multiple result sets.