代码拉取完成，页面将自动刷新
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.
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.
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
});
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 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 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.
Most importantly, it has full Unit Testing support.
Pagination support.
Free raw SQL query support both for complex type and primitive types.
First install the latest version of TanvirArjel.EFCore.GenericRepository nuget package into your project as follows:
Package Manager Console:
Install-Package TanvirArjel.EFCore.GenericRepository
.NET CLI:
dotnet add package TanvirArjel.EFCore.GenericRepository
Then in the ConfigureServices method of the Startup class:
public void ConfigureServices(IServiceCollection services)
{
// For single DbContext
services.AddGenericRepository<YourDbContext>();
// If multiple DbContext
services.AddGenericRepository<YourDbContext1>();
services.AddGenericRepository<YourDbContext2>();
}
First install the latest version of TanvirArjel.EFCore.QueryRepository nuget package into your project as follows:
Package Manager Console:
Install-Package TanvirArjel.EFCore.QueryRepository
.NET CLI:
dotnet add package TanvirArjel.EFCore.QueryRepository
Then in the ConfigureServices method of the Startup class:
public void ConfigureServices(IServiceCollection services)
{
// For single DbContext
services.AddQueryRepository<YourDbContext>();
// For multiple DbContext
services.AddQueryRepository<YourDbContext1>();
services.AddQueryRepository<YourDbContext2>();
}
public class EmployeeService
{
// For query version, please use `IQueryRepository` instead of `IRepository`
private readonly IRepository _repository; // If single DbContext
private readonly IRepository<YourDbContext1> _dbContext1Repository; // If multiple DbContext
public EmployeeService(IRepository repository, IRepository<YourDbContext1> dbContext1Repository)
{
_repository = repository;
_dbContext1Repository = dbContext1Repository;
}
public async Task<Employee> GetEmployeeAsync(int employeeId)
{
Employee employee = await _repository.GetByIdAsync<Employee>(employeeId);
return employee;
}
}
public class EmployeeService
{
private readonly IRepository _repository; // If single DbContext
private readonly IRepository<YourDbContext1> _dbContext1Repository; // If multiple DbContext
public EmployeeService(IRepository repository, IRepository<YourDbContext1> dbContext1Repository)
{
_repository = repository;
_dbContext1Repository = dbContext1Repository;
}
public async Task<int> CreateAsync(Employee employee)
{
await _repository.AddAsync(employee);
await _repository.SaveChangesAsync();
return employee.Id;
}
}
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。