How to dynamically map the stored proc return columns,values

Question

Dear Team,

I have .net core service which calls the stored procedure which returns any number of columns with variable return types , for example If I pass ID as 1 then stored proc can return 10 columns If pass Id as 2 then it could be 30 columns , If I pass Id as 3 then stored proc can return 3 columns . so as stated number of columns and their return types from the Procedure might be always varying.

So in this situation I can't handle fixed property class in service side.

Could you please let me know how I can handle this situation.

 

How to dynamically map the stored proc return columns,values and types to service class in Dot net core