public void TestSelect_19()
{
_clause = new SelectClause(new SqlServerDialect(), new TestEntityResolver(), new TestEntityAliasRegister());
_clause.Select <Sample>(t => new object[] { t.Email, t.IntValue });
var result = _clause.ToSql();
Assert.Equal("Select [as_Sample].[t_Email],[as_Sample].[t_IntValue]", result);
}
public void TestSelect_26()
{
_clause = new SelectClause(new SqlServerBuilder(), new SqlServerDialect(), new EntityResolver(new TestEntityMatedata()), new TestEntityAliasRegister());
_clause.Select <Sample>(t => new object[] { t.Email, t.DecimalValue }, true);
var result = _clause.ToSql();
Assert.Equal("Select [as_Sample].[Sample_Email] As [Email],[as_Sample].[DecimalValue]", result);
}
public void TestSelect_24()
{
_clause = new SelectClause(new SqlServerBuilder(), new SqlServerDialect(), new EntityResolver(new TestEntityMatedata()), new TestEntityAliasRegister());
_clause.Select <Sample>(t => new Dictionary <object, string> {
{ t.Email, "e" }, { t.Url, "u" }
});
var result = _clause.ToSql();
Assert.Equal("Select [as_Sample].[Sample_Email] As [e],[as_Sample].[Sample_Url] As [u]", result);
}
/// <summary>
/// 设置列名
/// </summary>
/// <typeparam name="TEntity">实体类型</typeparam>
/// <param name="column">列名</param>
/// <param name="columnAlias">列别名</param>
/// <returns></returns>
public virtual ISqlBuilder Select <TEntity>(Expression <Func <TEntity, object> > column, string columnAlias = null) where TEntity : class
{
SelectClause.Select(column, columnAlias);
return(this);
}
/// <summary>
/// 设置列名
/// </summary>
/// <typeparam name="TEntity">实体类型</typeparam>
/// <param name="columns">列名，范例：t => new object[] { t.Id, t.Name }</param>
/// <param name="propertyAsAlias">是否将属性名映射为列别名</param>
/// <returns></returns>
public virtual ISqlBuilder Select <TEntity>(Expression <Func <TEntity, object[]> > columns, bool propertyAsAlias = false) where TEntity : class
{
SelectClause.Select(columns, propertyAsAlias);
return(this);
}
/// <summary>
/// 设置列名
/// </summary>
/// <param name="columns">列名</param>
/// <param name="tableAlias">表别名</param>
/// <returns></returns>
public virtual ISqlBuilder Select(string columns, string tableAlias = null)
{
SelectClause.Select(columns, tableAlias);
return(this);
}
public void TestSelect_2()
{
_clause.Select("a");
Assert.Equal("Select [a]", GetSql());
}
public void TestSelect_18()
{
_clause = new SelectClause(new SqlServerDialect(), new TestEntityResolver(), new EntityAliasRegister());
_clause.Select <Sample>(t => new object[] { t.Email, t.IntValue });
Assert.Equal("Select [t_Email],[t_IntValue]", GetSql());
}
public void TestClone()
{
_clause.Select("a");
var copy = _clause.Clone(null, null);
copy.Select("b");
Assert.Equal("Select [a]", GetSql());
Assert.Equal("Select [a],[b]", copy.ToSql());
}
public void TestDistinct()
{
_clause.Distinct();
_clause.Select("a");
Assert.Equal("Select Distinct [a]", GetSql());
}
/// <summary>
/// 设置子查询列
/// </summary>
/// <param name="action">子查询操作</param>
/// <param name="columnAlias">列别名</param>
/// <returns></returns>
public virtual ISqlBuilder Select(Action <ISqlBuilder> action, string columnAlias)
{
SelectClause.Select(action, columnAlias);
return(this);
}
/// <summary>
/// 设置子查询列
/// </summary>
/// <param name="builder">Sql生成器</param>
/// <param name="columnAlias">列别名</param>
/// <returns></returns>
public virtual ISqlBuilder Select(ISqlBuilder builder, string columnAlias)
{
SelectClause.Select(builder, columnAlias);
return(this);
}
