public void TestSelect_17() { _clause.Select("a.[b],c,[d]", "o"); _clause.AppendSql("e=1,"); _clause.Select("f"); _clause.AppendSql("g"); _clause.Select("h"); Assert.Equal("Select [a].[b],[o].[c],[o].[d],e=1,[f],g[h]", GetSql()); }
/// <summary> /// 添加到Select子句 /// </summary> /// <param name="action">子查询操作</param> /// <param name="columnAlias">列别名</param> /// <returns></returns> public virtual ISqlBuilder AppendSelect(Action <ISqlBuilder> action, string columnAlias) { SelectClause.AppendSql(action, columnAlias); return(this); }
/// <summary> /// 添加到Select子句 /// </summary> /// <param name="builder">Sql生成器</param> /// <param name="columnAlias">列别名</param> /// <returns></returns> public virtual ISqlBuilder AppendSelect(ISqlBuilder builder, string columnAlias) { SelectClause.AppendSql(builder, columnAlias); return(this); }
/// <summary> /// 添加到Select子句 /// </summary> /// <param name="sql">Sql语句</param> /// <returns></returns> public virtual ISqlBuilder AppendSelect(string sql) { SelectClause.AppendSql(sql); return(this); }
public void TestSelect_16() { _clause.AppendSql("a"); Assert.Equal("Select a", GetSql()); }