public void Test_Select_35()
{
SqlBuilderCore <UserInfo> builder = null;
var list = new List <UserInfo> {
new UserInfo {
Id = 2
}
};
list.ForEach(_ =>
{
builder = SqlBuilder.Select <UserInfo>(o => new { o.Id, o.Name })
.Where(u => !u.Id.Equals(_.Id) == false);
});
Assert.AreEqual("SELECT A.Id,A.Name FROM [Base_UserInfo] AS A WHERE A.Id = @Param0", builder.Sql);
Assert.AreEqual(1, builder.Parameters.Count);
}
public void Test_Select_27()
{
SqlBuilderCore <UserInfo> builder = null;
var list = new List <UserInfo> {
new UserInfo {
Name = "新用户"
}
};
list.ForEach(_ =>
{
builder = SqlBuilder.Select <UserInfo>(o => new { o.Id, o.Name })
.Where(u => u.Name == _.Name);
});
Assert.AreEqual("SELECT A.Id,A.Name FROM [Base_UserInfo] AS A WHERE A.Name = @Param0", builder.Sql);
Assert.AreEqual(1, builder.Parameters.Count);
}
/// <summary>
/// 查询单个实体
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static async Task <TEntity> ToEntityAsync <TEntity>(this SqlBuilderCore <TEntity> @this, IRepository repository) where TEntity : class
{
return(await @this.ToEntityAsync <TEntity, TEntity>(repository));
}
/// <summary>
/// 查询单个实体
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <typeparam name="TReturn"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static TReturn ToEntity <TEntity, TReturn>(this SqlBuilderCore <TEntity> @this, IRepository repository) where TEntity : class
{
return(repository.FindEntity <TReturn>(@this.Sql, @this.DynamicParameters));
}
/// <summary>
/// 查询单个实体
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static TEntity ToEntity <TEntity>(this SqlBuilderCore <TEntity> @this, IRepository repository) where TEntity : class
{
return(@this.ToEntity <TEntity, TEntity>(repository));
}
/// <summary>
/// 执行Sql
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static async Task <int> ExecuteAsync <TEntity>(this SqlBuilderCore <TEntity> @this, IRepository repository) where TEntity : class
{
return(await repository.ExecuteBySqlAsync(@this.Sql, @this.DynamicParameters));
}
/// <summary>
/// 执行Sql
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static int Execute <TEntity>(this SqlBuilderCore <TEntity> @this, IRepository repository) where TEntity : class
{
return(repository.ExecuteBySql(@this.Sql, @this.DynamicParameters));
}
/// <summary> /// 分页 /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="this"></param> /// <param name="repository"></param> /// <param name="orderField"></param> /// <param name="isAscending"></param> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <returns></returns> public static (List <TEntity> list, long total) ToPage <TEntity>(this SqlBuilderCore <TEntity> @this, IRepository repository, string orderField, bool isAscending, int pageSize, int pageIndex) where TEntity : class
/// <summary>
/// 查询单个对象
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static async Task <object> ToObjectAsync <TEntity>(this SqlBuilderCore <TEntity> @this, IRepository repository) where TEntity : class
{
return(await repository.FindObjectAsync(@this.Sql, @this.DynamicParameters));
}
/// <summary>
/// 查询单个对象
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static object ToObject <TEntity>(this SqlBuilderCore <TEntity> @this, IRepository repository) where TEntity : class
{
return(repository.FindObject(@this.Sql, @this.DynamicParameters));
}
/// <summary>
/// 查询集合
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <typeparam name="TReturn"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static async Task <List <TReturn> > ToListAsync <TEntity, TReturn>(this SqlBuilderCore <TEntity> @this, IRepository repository) where TEntity : class
{
return((await repository.FindListAsync <TReturn>(@this.Sql, @this.DynamicParameters))?.ToList());
}
/// <summary>
/// 查询集合
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <typeparam name="TReturn"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static List<TReturn> ToList<TEntity, TReturn>(this SqlBuilderCore<TEntity> @this, IRepository repository) where TEntity : class
{
return repository.FindList<TReturn>(@this.Sql, @this.DynamicParameters)?.ToList();
}
/// <summary>
/// 查询集合
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static List<TEntity> ToList<TEntity>(this SqlBuilderCore<TEntity> @this, IRepository repository) where TEntity : class
{
return @this.ToList<TEntity, TEntity>(repository);
}
/// <summary>
/// 查询单个实体
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <typeparam name="TReturn"></typeparam>
/// <param name="this"></param>
/// <param name="repository"></param>
/// <returns></returns>
public static async Task<TReturn> ToEntityAsync<TEntity, TReturn>(this SqlBuilderCore<TEntity> @this, IRepository repository) where TEntity : class
{
return await repository.FindEntityAsync<TReturn>(@this.Sql, @this.DynamicParameters);
}
