EDennis.EFBase 1.2.4

Provides a SqlServerContext and SqlServerRepo for Entity Framework targeting SQL Server 2016+.  The SqlServerRepo class includes CRUD methods, as well as a method for returning JSON from a FOR JSON SQL Server SELECT statement.  SqlServerRepo supports auto-rollback transactions and sequence resetting for testing scenarios.

There is a newer version of this package available.
See the version list below for details.
Install-Package EDennis.EFBase -Version 1.2.4
dotnet add package EDennis.EFBase --version 1.2.4
<PackageReference Include="EDennis.EFBase" Version="1.2.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EDennis.EFBase --version 1.2.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

The EFBase package provides a SqlServerRepo and SqlServerContext for Entity Framework targeting SQL Server 2016+. The SqlServerRepo class includes methods for creating, reading (by PK), updating, and deleting -- both synchronously and asynchronously. The SqlServerRepo class also includes methods for returning JSON from a valid FOR JSON SQL Server SELECT statement. Finally, SqlServerRepo supports auto-rollback transactions and sequence-resetting, which are useful for testing. To use SqlServerRepo, be sure to extend both SqlServerRepo (for all of your repository classes) and SqlServerContext (for all of your DbContext subclasses). The following classes are included:

  1. SqlServerContext -- which extends DbContext to provide support for FOR JSON queries.
  2. SqlServerRepo -- which provides the base repository class. This class support auto-rollback transactions (for testing purposes).
  3. SequenceResetter-- which provides a method for resetting all sequences in a database.
  4. SqlExecutor -- which provides methods for executing multiple SQL statement blocks separated by GO.
  5. SqlJson -- which allows Entity Framework to return FOR JSON statements from SQL Server.](https://github.com/denmitchell/efbase/wiki/SqlJson)** -- which allows Entity Framework to return FOR JSON statements from SQL Server.

The EFBase package provides a SqlServerRepo and SqlServerContext for Entity Framework targeting SQL Server 2016+. The SqlServerRepo class includes methods for creating, reading (by PK), updating, and deleting -- both synchronously and asynchronously. The SqlServerRepo class also includes methods for returning JSON from a valid FOR JSON SQL Server SELECT statement. Finally, SqlServerRepo supports auto-rollback transactions and sequence-resetting, which are useful for testing. To use SqlServerRepo, be sure to extend both SqlServerRepo (for all of your repository classes) and SqlServerContext (for all of your DbContext subclasses). The following classes are included:

  1. SqlServerContext -- which extends DbContext to provide support for FOR JSON queries.
  2. SqlServerRepo -- which provides the base repository class. This class support auto-rollback transactions (for testing purposes).
  3. SequenceResetter-- which provides a method for resetting all sequences in a database.
  4. SqlExecutor -- which provides methods for executing multiple SQL statement blocks separated by GO.
  5. SqlJson -- which allows Entity Framework to return FOR JSON statements from SQL Server.](https://github.com/denmitchell/efbase/wiki/SqlJson)** -- which allows Entity Framework to return FOR JSON statements from SQL Server.

Release Notes

Fixed bug with StartTransaction and Rollback methods

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
2.3.0 273 1/16/2019
2.2.0 204 11/8/2018
2.1.9 221 10/22/2018
2.1.8 281 8/17/2018
2.1.7 293 7/30/2018
2.1.6 272 7/30/2018
1.3.4 279 7/23/2018
1.3.3 374 7/12/2018
1.3.2 320 7/12/2018
1.3.1 328 7/11/2018
1.3.0 365 6/6/2018
1.2.8 363 4/30/2018
1.2.7 376 4/26/2018
1.2.6 364 4/24/2018
1.2.5 347 4/23/2018
1.2.4 332 4/23/2018
1.2.3 373 4/22/2018
1.2.2 434 4/21/2018
1.2.1 322 3/22/2018
1.2.0 342 3/22/2018
1.1.2 424 3/13/2018
1.1.1 437 3/13/2018
1.1.0 377 3/12/2018
1.0.2 1,111 3/12/2018
1.0.1 1,887 3/12/2018
1.0.0 2,025 3/12/2018
0.1.2 302 3/10/2018
0.1.1 477 3/10/2018
0.1.0 323 3/10/2018
0.0.5-alpha 370 3/8/2018
0.0.4-alpha 325 2/13/2018
0.0.3-alpha 331 1/22/2018
Show less