EfCore.GenericServices
2.0.0
See the version list below for details.
dotnet add package EfCore.GenericServices --version 2.0.0
NuGet\Install-Package EfCore.GenericServices -Version 2.0.0
<PackageReference Include="EfCore.GenericServices" Version="2.0.0" />
paket add EfCore.GenericServices --version 2.0.0
#r "nuget: EfCore.GenericServices, 2.0.0"
// Install EfCore.GenericServices as a Cake Addin
#addin nuget:?package=EfCore.GenericServices&version=2.0.0
// Install EfCore.GenericServices as a Cake Tool
#tool nuget:?package=EfCore.GenericServices&version=2.0.0
EfCore.GenericServices
This library helps you quickly code Create, Read, Update and Delete (CRUD) accesses for a web/mobile/desktop application. It acts as a adapter and command pattern between a database accessed by Entity Framework Core (EF Core) and the needs of the front-end system.
This library takes advantage of the fact that each of the four CRUD database accesses differ in what they do, but they have a common set of data part they all use, which are:
- What database class/table do you want to access?
- What properties in that class/table do you want to access or change?
This library uses DTOs (data transfer objects), also known as ViewModels, plus a special interface to define the class/table and the properties to access. That allows the library to implement a generic solution for each of the four CRUD accesses, where the only thing that changes is the DTO you use.
Typical web applications have hundreds of CRUD pages - display this, edit that, delete the other - and each CRUD access has to adapt the data in the database to show the user, and then apply the changes to the database. So, you create one set of update code for your specific application and then cut/paste + change one line (the DTO name) for all the other versions.
I personally work with ASP.NET Core, so my examples are from that, but it will work with any NET Core type of application (I do know one person have used this libary with WPF).
NuGet link and link to documentation.
MIT license.
Code examples of using EfCore.GenericServices
I personally work with ASP.NET Core, so my examples are all around ASP.NET Core, but EfCore.GenericServices will work with any NET Core type of application (I do know one person have used this libary with WPF).
ASP.NET Core MVC - razor pages
The classic way to produce HTML pages in ASP.NET is using the MVC approach, with razor pages.
Here a simple example to show you the basic way to inject and then call the ICrudServices
, in this case a simple List.
public class BookController
private ICrudServices _service;
public BookController(ICrudServices service)
{
_service = service;
}
public ActionResult Index()
{
var dataToDisplay = _service.ReadManyNoTracked<BookListDto>().ToList()
return View(dataToDisplay);
}
//... etc.
ASP.NET Core MVC - razor pages
Here is the code from the example Razor Page application contained in this repo for adding a review to a Book (the example site is a tiny Amazon-like site). This example shows an more complex example where I am updating the Book class that uses a Domain-Driven Design (DDD) approach to add a new review to a book. The code shown is the complete code in the AddReview.cshtml.cs class.
public class AddReviewModel : PageModel
{
private readonly ICrudServices _service;
public AddReviewModel(ICrudServices service)
{
_service = service;
}
[BindProperty]
public AddReviewDto Data { get; set; }
public void OnGet(int id)
{
Data = _service.ReadSingle<AddReviewDto>(id);
if (!_service.IsValid)
{
_service.CopyErrorsToModelState(ModelState, Data, nameof(Data));
}
}
public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
return Page();
}
_service.UpdateAndSave(Data);
if (_service.IsValid)
return RedirectToPage("BookUpdated", new { message = _service.Message});
//Error state
_service.CopyErrorsToModelState(ModelState, Data, nameof(Data));
return Page();
}
}
NOTE: If you compare the code above with the
AddPromotion or
ChangePubDate
updates in the same example then you will see they are identical apart from the type of the Data
property.
And the ViewModel/DTO isn't anything special (see the
AddReviewDto).
They just need to be marked with an empty
ILinkToEntity<TEntity>
interface, which tells GenericServices which EF Core entity
class to map to. For more security you can also mark any read-only properties with the
[ReadOnly(true)]
attribute - GenericServices will never try to update the
database with any read-only marked property.
ASP.NET Web API
When using ASP.NET Web API then another companion library called EfCore.GenericServices.AspNetCore provides extension methods to help return the data in the correct form (plus other methods to allow unit testing of Web API actions using EfCore.GenericServices).
The code below comes from the example ToDoController example in the EfCore.GenericServices.AspNetCore GitHub repo.
public class ToDoController : ControllerBase
{
[HttpGet]
public async Task<ActionResult<WebApiMessageAndResult<List<TodoItem>>>> GetManyAsync([FromServices]ICrudServices service)
{
return service.Response(await service.ReadManyNoTracked<TodoItem>().ToListAsync());
}
[Route("name")]
[HttpPatch()]
public ActionResult<WebApiMessageOnly> Name(ChangeNameDto dto, [FromServices]ICrudServices service)
{
service.UpdateAndSave(dto);
return service.Response();
//... other action methods removed
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- AutoMapper (>= 7.0.1)
- Microsoft.AspNetCore.JsonPatch (>= 2.1.1)
- Microsoft.EntityFrameworkCore (>= 2.1.1)
NuGet packages (3)
Showing the top 3 NuGet packages that depend on EfCore.GenericServices:
Package | Downloads |
---|---|
EfCore.GenericServices.AspNetCore
A support library to the EfCore.GenericServices and EfCore.GenericBizRunner libraries. It converts IStatusGeneric into ASP.NET Core's ModelState or Web API response |
|
EntityServices
Package Description |
|
UZB.ELYORBEK.EF
CRUD operations works. |
GitHub repositories (2)
Showing the top 2 popular GitHub repositories that depend on EfCore.GenericServices:
Repository | Stars |
---|---|
JonPSmith/AuthPermissions.AspNetCore
This library provides extra authorization and multi-tenant features to an ASP.NET Core application.
|
|
JonPSmith/PermissionAccessControl2
Version 2 of example application to go with articles on feature and data authorization
|
Version | Downloads | Last updated |
---|---|---|
8.1.0 | 0 | 5/4/2024 |
8.0.0 | 294 | 4/10/2024 |
6.0.0 | 2,924 | 11/22/2023 |
5.2.1 | 16,216 | 1/3/2023 |
5.2.0 | 3,645 | 11/15/2022 |
5.2.0-preview001 | 648 | 12/8/2022 |
5.1.1 | 16,912 | 2/2/2022 |
5.1.0 | 24,643 | 11/10/2021 |
5.1.0-preview001 | 157 | 11/4/2021 |
5.0.1 | 16,079 | 7/8/2021 |
5.0.0 | 18,899 | 1/6/2021 |
3.3.0 | 1,306 | 6/21/2021 |
3.2.2 | 16,974 | 5/22/2020 |
3.2.1 | 3,467 | 4/11/2020 |
3.2.0 | 1,159 | 4/10/2020 |
3.1.0 | 42,044 | 1/27/2020 |
3.0.0 | 5,125 | 10/12/2019 |
2.1.0-preview001 | 1,048 | 10/4/2019 |
2.0.3 | 3,643 | 7/29/2019 |
2.0.2 | 11,029 | 4/4/2019 |
2.0.1 | 4,858 | 3/10/2019 |
2.0.0 | 7,313 | 1/2/2019 |
2.0.0-preview001 | 2,601 | 12/24/2018 |
1.3.3 | 5,590 | 10/27/2018 |
1.3.2 | 1,872 | 10/22/2018 |
1.3.1 | 1,993 | 9/26/2018 |
1.3.0 | 1,947 | 9/18/2018 |
1.2.6 | 10,181 | 8/18/2018 |
1.2.4 | 2,919 | 7/29/2018 |
1.2.3 | 2,112 | 7/24/2018 |
1.2.2 | 1,425 | 7/16/2018 |
1.2.1 | 1,460 | 7/14/2018 |
1.1.0 | 2,099 | 6/7/2018 |
1.0.0 | 2,308 | 4/12/2018 |
- New feature: Now handles EF Core's DbQuery type (DbQuery type is only used for reads) - fixes Issue #16.
- New Feature: Added `ProjectFromEntityToDto{TEntity,TDto}` to the services. This allows you to read data with a query prior to the projection to a DTO. Fixes issue #10 and #15
- New Feature: Added `IGenericStatus BeforeSaveChanges(DbContext)` to configuration.
This allows you to inject code that is called just before SaveChanges/SaveChangesAsync is run. This allows you
to add some validation, logging etc. - see issue #14.
- Improvement: Previously the Sql error handler was only used if validation was turned on.
Now, if the SaveChangesExceptionHandler property is not null, then taht method is called,
i.e. it is not longer dependant on the state of the ...ValidateOnSave flag in the config.
- Breaking change (Minor): In version 1.3.1 both `DeleteAndSave` and `DeleteWithActionAndSave` used `IgnoreQueryFilters` to get all entities.
This was done so that soft deleted items would be found, but its dangerous in multi-tenant systems.
In 2.0.0 only `DeleteWithActionAndSave` will use `IgnoreQueryFilters` to get all entities. That is safer, as you can provide extra checks in the method you provide.
- Performance bug fix: There was a performance issue when using the setup methods use in unit testing and non-DI situations