Base solution for your next web application
Open Closed

ASPZero Abp, Version=3.5.0.0 is this version support to call oracle SP,packge #5746


User avatar
0
jehadk created

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)
  • User Avatar
    0
    maliming created
    Support Team

    Do you want to call the Orcal stored procedure via EF?

  • User Avatar
    0
    jehadk created

    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

  • User Avatar
    1
    ismcagdas created
    Support Team

    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.