AgileRepository
这是一个可以帮助你快速开发Repository的lib。有点像SpringData JPA根据方法名、注解来自动生成查询方法的功能。
对于一些简单的查询，只需要定义接口就行了，实现都不用。
Github: AgileRepository
依赖
AspectCore >= 0.2.4
Dapper >= 1.50.4
DapperExtensions >= 1.6.3
System.Threading.Tasks.Extensions >= 4.3.0
使用
public interface IUserRepository:IAgileRepository<Users>
{
[QueryByMethodName]
IEnumerable<Users> QueryByUserName(string userName);
}
var repository = AgileRepository.Proxy.SingletonInstance<IUserRepository>();
repository.QueryByUserName("admin");
配置
AgileRepository.SetConfig(new AgileRepositoryConfig()
{
SqlMonitor = (sql, paramters ) =>
{
Console.WriteLine(sql);
},
ConnectionName = "conn"
});
示例
根据sql查询
[QueryBySql("SELECT * FROM USERS")]
IEnumerable<User> TestSql();
[QueryBySql("SELECT * FROM USERS where username=@userName")]
IEnumerable<User> TestSql1(string userName);
根据方法名称查询
[QueryByMethodName]
IEnumerable<User> QueryByUserName(string userName);
[QueryByMethodName]
IEnumerable<User> QueryByUserNameAndId(string userName, string id);
[QueryByMethodName]
IEnumerable<User> QueryByCreaterIsNull();
[QueryByMethodName]
IEnumerable<User> QueryByCreaterIsNotNull();
查询所有
[QueryAll]
IEnumerable<User> QueryAll();
根据 sql Count
[CountBySql("Select count(*) from users")]
int TestCount();
[CountBySql("Select count(*) from users where userName=@userName")]
int TestCount1(string userName);
根据方法名Count
[CountByMethodName]
int CountByUserName(string userName);
[CountByMethodName]
int CountByIdAndUserName(string id, string userName);
Count所有
[CountAll]
int CountAll();
Insert
[Insert]
int Insert(User user);
[Insert]
int Insert(IEnumerable<User> users);
Update
[Update]
int Update(User user);
[Update]
int Update(IEnumerable<User> users);
[Delete]
int Delete(User user);
[Delete]
int Delete(IEnumerable<User> users);
[DeleteByMethodName]
int DeleteByUserName(string userName);
执行非查询sql
[ExecuteBySql("Delete from [users] where id =@id ")]
int Execute(string id);
支持的where关键字
| Key | Name | Where |
|---|---|---|
| And | QueryByUserNameAndId | where UserName=@UserName And Id=@Id |
| Or | QueryByUserNameOrId | where UserName=@UserName Or Id=@Id |
| IsNull | QueryByUserNameIsNull | where UserName Is Null |
| IsNotNull | QueryByUserNameIsNotNull | where UserName Is Not Null |
| GreaterThen | QueryByAgeGreaterThen | where Age>@Age |
| GreaterEqual | QueryByAgeGreaterEqual | where Age>=@Age |
| LessThen | QueryByAgeLessThen | where Age<@Age |
| LessEqual | QueryByAgeLessEqual | where Age<=@Age |
| Not | QueryByAgeNot | where Age!=@Age |
| In | QueryByUserNameIn | where UserName in @UserName |
| NotIn | QueryByUserNameNotIn | where UserName Not in @UserName |
| Like | QueryByUserNameLike | where UserName Like @UserName |
| NotLike | QueryByUserNameNotLike | where UserName Not Like @UserName |