public void SelectTableWithColumnsExplicitJoinWhereOrderBy()
{
Configuration.SetDialect(new TestDialect());
var b = new RawSelectBuilder();
b.FromSql("[WH].[INVOICE]");
b.SelectSql("T0.DATE, T0.TOTAL");
b.SelectSql("T1.NAME, T1.BALANCE");
b.JoinSql("[CUS].[CUSTOMER]", "T1.CUSTOMERID = T2.ID");
var spec = "SELECT T0.DATE, T0.TOTAL, T1.NAME, T1.BALANCE FROM [WH].[INVOICE] AS [T0] INNER JOIN [CUS].[CUSTOMER] AS [T1] ON T1.CUSTOMERID = T2.ID";
var gen = b.GetSqlText();
Assert.Equal(spec, gen);
}
public void SelectColumnsFromTable()
{
Configuration.SetDialect(new TestDialect());
var b = new RawSelectBuilder();
b.FromSql("[CUSTOMERS]");
b.SelectSql("_ID", "ID").SelectSql("NAME");
var spec = "SELECT _ID AS [ID], NAME FROM [CUSTOMERS] AS [T0]";
var gen = b.GetSqlText();
Assert.Equal(spec, gen);
}