fm.EntityFrameworkCore.Relational 4.0.0

Extends Microsoft.EntityFrameworkCore.Relational with some raw SQL methods. Directly invoke ExecuteScalar/ExecuteReader on DbContext. Bulk update and delete rows.

Commonly used Types:
DbContextExtensions
DbSetBulkExtensions
RelationalDatabaseFacadeExtensions

Commonly used methods:
ClearCommandTimeout()
ExecuteScalarAsync(string sql)
ExecuteScalarAsync(string sql, IEnumerable<object> parameters)
ExecuteReaderAsync(string sql)
ExecuteReaderAsync(string sql, IEnumerable<object> parameters)

SqlDeleteWhereAsync(string propertyName, object equalsValue)
SqlUpdateWhereAsync(string wherePropertyName, object whereValue, string setPropertyName, object setValue)
SqlUpdateWhereInAsync(string whereInPropertyName, object[] whereInValues, string setPropertyName, object setValue)
SqlUpdateWhereInAsync(string wherePropertyName, object whereValue, string whereInPropertyName, object[] whereInValues, string setPropertyName, object setValue)

Install-Package fm.EntityFrameworkCore.Relational -Version 4.0.0

dotnet add package fm.EntityFrameworkCore.Relational --version 4.0.0

<PackageReference Include="fm.EntityFrameworkCore.Relational" Version="4.0.0" />

paket add fm.EntityFrameworkCore.Relational --version 4.0.0

#r "nuget: fm.EntityFrameworkCore.Relational, 4.0.0"

Release Notes

Update to .NET 5.0

Dependencies

• .NETStandard 2.1

  • fm.Extensions.Common (>= 4.0.0)
  • Microsoft.EntityFrameworkCore.Relational (>= 5.0.0)
  • System.Interactive (>= 5.0.0)

Used By

Version History