public void From_Subselect_ToString()
{
const string expected = "From (Select F1 From Tab1)";
var subSelectGenerator = new SqlGenerator();
var subSelect = new SubSelectSource(subSelectGenerator.Select("F1").From("Tab1").SqlStatement);
var actual = Generator.From(subSelect)
.ToString();
Assert.AreEqual(expected, actual);
}
public void From_SubselectWithAlias()
{
const string expected = "From (Select F1 From Tab1) As X";
var subSelectGenerator = new SqlGenerator();
var subSelect = new SubSelectSource(subSelectGenerator.Select("F1").From("Tab1").SqlStatement);
Generator.From(new SourceAlias(subSelect, "X"));
var actual = GenerateSqlString();
Assert.AreEqual(expected, actual);
}
public void ConditionFieldWithSubSelectSource_MissingAlias()
{
const string expected = "F1 = 1";
var sqlGenerator = new SqlGenerator();
var subSelect = sqlGenerator.From("Tab1").Select("F1").SqlStatement;
var source = new SubSelectSource(subSelect);
Conditions.Add(new Field("F1", source), RelationalOperators.Equal, 1);
var actual = GenerateSqlString();
Assert.AreEqual(expected, actual);
}
