EntityDbExtensions

Simplify Entity Framework Delete Children Operations

Overview

Tired of manual and repetitive code when it comes to deleting child and subsequent objects with validations and nested loops? The EntityDbExtensions library simplifies the process for you. By simply invoking the method UpdateAndHandleDeletedChildren in the .Update of the root class, it will automatically handle the recursive deletion of all child, grandchild, and subsequent objects that have been removed from your root class.

The method will inspect classes containing a virtual child property with a List type, such as IEnumerable, ICollection or List.

 public virtual IEnumerable<YourChild> YourChild { get; private set; }

It performs a validation check to determine if the object has been deleted, marking it as removed. This marking signals Entity Framework to handle the deletion seamlessly. The validation process is recursive, ensuring that all child and subsequent objects undergo thorough validation for removal.

Features

• Effortless Database Operations: Streamline your Entity Framework database operations with simplified methods.

• Extension Methods for DbContext: Easily perform common database operations using intuitive extension methods on your DbContexts.

• Update and Handle Deleted Children: Handle the validation and removal of all deleted children from your root class with just a single command.

Getting Started

1. Installation:
   • Install the EntityDbExtensions NuGet package in your .NET project.

<PackageReference Include="EntityDbExtensions" Version="1.2.0" />

Usage: Add the EntityDbExtensions using statement to your code. Start using the extension methods on your Entity Framework entities.

using EntityDbExtensions;

 public async Task<bool> Update(YourEntity entity)
 {
    var entityDb = await Get(entity.Id);
    if (entityDb == null) throw new InvalidOperationException($"{nameof(YourEntity)} not found.");
	
    await _yourDbContext.UpdateAndHandleDeletedChildren(entity, entityDb);  // Here the magic happens.

    return await _yourDbContext.SaveChangesAsync() > 0;
 }

Benchmark case:

| Method                                                                | Mean     | Error    | StdDev   | Gen0     | Gen1    | Allocated |
|---------------------------------------------------------------------- |---------:|---------:|---------:|---------:|--------:|----------:|
| Default_EntityUpdate_Benchmark_SQLLite                                | 22.41 ms | 0.226 ms | 0.212 ms | 250.0000 |       - |   4.02 MB |
| EntityDbExtensions_UpdateAndHandleDeletedChildren_Benchmark_SQLLite   | 22.23 ms | 0.224 ms | 0.210 ms | 250.0000 |       - |   4.16 MB |
| Default_EntityUpdate_Benchmark_SQLServer                              | 16.71 ms | 0.120 ms | 0.101 ms | 218.7500 | 31.2500 |   3.55 MB |
| EntityDbExtensions_UpdateAndHandleDeletedChildren_Benchmark_SQLServer | 16.56 ms | 0.153 ms | 0.136 ms | 218.7500 | 31.2500 |   3.69 MB |

Contribution

Contributions are welcome! If you find any issues or have suggestions for improvements, feel free to open an issue or create a pull request.

License

This project is licensed under the MIT License.

LinkedIn - ( https://www.linkedin.com/in/alan-evandro-barboza/ )