TanvirArjel/TanvirArjel.EFCore.QueryRepositoryv1.5.4
.NET 8.0.NET 9.0.NET 10.0
This library is a Generic Query Repository implementation for EF Core ORM which will remove developers' pain to write query repository layer for each .NET Core and .NET project. This library includes the following notable features: 1. This library can be run on any .NET Core or .NET application which has .NET Core 3.1, .NET Standard 2.1 and .NET 5.0+ support. 2. It has all the required methods to query your data in whatever way you want without getting IQueryable<T> from the repository. 3. It also has Specification<T> pattern support so that you can build your query dynamically i.e. differed query building. 4. It also has database-level projection support for your query. 5. It also has support to run raw SQL command against your relational database. 6. It also has support to choose whether you would like to track your query entity/entities or not. 7. Most importantly, it has full Unit Testing support. It facilitates the writing unit test with mocking. 8. It also has pagination support. 9. Free raw SQL query support both for complex type and primitive types.
Get Started
$ dotnet add package TanvirArjel.EFCore.QueryRepositoryReadme
EF Core Generic Repository
This library is a Generic Repository implementation for EF Core ORM which will remove developers' pain to write repository layer for each .NET Core and .NET project.
⭐ Giving a star
If you find this library useful, please don't forget to encourage me to do such more stuffs by giving a star to this repository. Thank you.
🔥 What's new
Pagination Support:
PaginationSpecification<Employee> specification = new PaginationSpecification<Employee>();
specification.Conditions.Add(e => e.Name.Contains("Ta"));
specification.PageIndex = 1;
specification.PageSize = 10;
PaginatedList<EmployeeDto> paginatedList = await _repository.GetListAsync(specification, e => new EmployeeDto
{
Id = e.Id
Name = e.Name,
DepartmentName = e.DepartmentName
});
Free raw SQL support:
List<string> search = new List<string>() { "Tanvir", "Software" };
string sqlQuery = "Select EmployeeName, DepartmentName from Employee Where EmployeeName LIKE @p0 + '%' and DepartmentName LIKE @p1 + '%'";
List<EmployeeDto> items = await _repository.GetFromRawSqlAsync<EmployeeDto>(sqlQuery, search);
⚙️ This library includes following notable features:
-
This library can be run on any .NET Core or .NET application which has .NET Core 3.1, .NET Standard 2.1 and .NET 5.0+ support.
-
It’s providing the Generic Repository with database transaction support.
-
It has all the required methods to query your data in whatever way you want without getting IQueryable<T> from the repository.
-
It also has
Specification<T>pattern support so that you can build your query dynamically i.e. differed query building. -
It also has database level projection support for your query.
-
It also has support to run raw SQL command against your relational database.
-
It also has support to choose whether you would like to track your query entity/entities or not.
-
It also has support to reset your EF Core DbContext state whenever you really needed.