EFCore Execute Stored Procedure and get resulting SELECT statement as a DataTable or List<Object>

I currently have a stored procedures that could return different types of data depending on the arguments passed. i.e:

EXEC spGetData 'CAR'

Will execute:

SELECT * from dbo.Car

EXEC spGetData 'TRUCK'

Will execute:

SELECT * from dbo.Truck

I want to execute this stored procedure from EFCore 5 and without using ADO.NET if possible.

Is this possible?

asked Jun 11 '21 at 18:11

Ali Bdeir

1

No, it's not possible. This is not what EF Core is for. – Ivan Stoev Jun 11 '21 at 18:18
Instead, use Dapper. – Gert Arnold Jul 30 '21 at 19:10

0 Answers0