How to use custom functions and stored procedure in microservices application #728

3 Answer(s)

• 

  0

  alper created 3 years ago

  Support Team Director

  There's a sample project show how to run Stored Procedures in ABP Framework.

  • https://docs.abp.io/en/abp/latest/Entity-Framework-Core#add-custom-repositories
  • https://github.com/abpframework/abp-samples/tree/master/StoredProcedureDemo

  Save Cancel
• 

  0

  lalitChougule created 3 years ago

  Hi @alper,

  Below code is for Executing SP on SQL server:

  public async Task UpdateEmail(Guid id, string email, CancellationToken cancellationToken = default)
  {
      await DbContext.Database.ExecuteSqlRawAsync(
          "EXEC UpdateEmailById @email, @id",
          new List<object> {new SqlParameter("id", id), new SqlParameter("email", email)},
          cancellationToken);
  }
  

  I am using PostgreSQL 13 , Is this the same way to execute it on PostgreSQL and even I am not able to find SqlParameter i.e. new SqlParameter("id", id) do I need to install any package for same ?

  Save Cancel
• 

  0

  alper created 3 years ago

  Support Team Director

  according to the Microsoft docs it supports SqlParameters

  https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.relationaldatabasefacadeextensions.executesqlrawasync?view=efcore-5.0#Microsoft_EntityFrameworkCore_RelationalDatabaseFacadeExtensions_ExecuteSqlRawAsync_Microsoft_EntityFrameworkCore_Infrastructure_DatabaseFacade_System_String_System_Object___

  Save Cancel