EntityFrameworkExtension #5639

5 Answer(s)

• 

  1

  ismcagdas created 5 years ago

  Support Team

  Hi,

  You can create a custom repository https://aspnetboilerplate.com/Pages/Documents/Repositories#custom-repositories and the run raw sql query you want https://docs.microsoft.com/en-us/ef/core/querying/raw-sql

  Save Cancel
• 

  0

  buddhit created 5 years ago

  Hi there,

  I know that bit, but priviously we used to have EntityFrameworkExtension class with WithSqlParam method that used to inject params for the query. My question is : Is there any reason that extension is removed ??

  Regards Buddhi

  Save Cancel
• 

  0

  ryancyq created 5 years ago

  Support Team

  Which version of AspNetZero you upgraded from/to?

  Did you use EFCore-FluentStoredProcedure for WithSqlParam()previously?

  Save Cancel
• 

  0

  buddhit created 5 years ago

  Hi there

  We have two sperate apps one uses ASPNETZERO 5.5 and another one use 5.6.2. on the 5.5 we have have EntityFrameworkExtension class with WithSqlParam but on the 5.6.2 we cant find have EntityFrameworkExtension class.

   public async Task<int> DeleteDormantRecord(long ppmId)
          {
              EnsureConnectionOpen();
              const string sql = @"delete from Dormantrecords where ppmId = @id";
  
              using (var command = CreateCommand(sql, _transactionProvider, CommandType.Text))
              {
                  var com = command.WithSqlParam("id", ppmId);
  
                  return await com.ExecuteNonQueryAsync();
              }
          }
  

  This is how we used WithSqlParam from extension class on the V5.5.

  Save Cancel
• 

  0

  ismcagdas created 5 years ago

  Support Team

  Hi @buddhit

  EntityFrameworkExtension is not created by us. Probably you have added it into your project.

  Save Cancel