Dears, ASPZERO MVC Core(AspNetZeroCore v5.3.0) first if I can call oracle SP and it is support, how I can do that ?
3 Answer(s)
-
0
Do you want to call the Orcal stored procedure via EF?
-
0
YEs useing EF , are there another way
my Database is SQL server but I need to connect to another Database(Oracle) to call some SP
-
1
Hi @jehadk
If you want to use Oracle in AspNet Zero, you need to check this document first https://aspnetboilerplate.com/Pages/Documents/EF-Core-Oracle-Integration.
Then, you can create a custom repository to execute a SP, see https://aspnetboilerplate.com/Pages/Documents/Repositories#custom-repositories.
If you want to use SQL Server in your project and only want to execute Oracle SP in a specific service/class, then you can not do it using EF I guess, you need to use some other library for that.