freedom-manufaktur/fm.EntityFrameworkCore.Relationalv8.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)