public void Sort_Only_Query_No_Where()
{
// Arrange
var db = new DataMapper(System.Data.SqlClient.SqlClientFactory.Instance, "Data Source=a;Initial Catalog=a;User Id=a;Password=a;");
AutoQueryBuilder<Person> builder = new AutoQueryBuilder<Person>(db, false);
// Act
builder.OrderBy(p => p.ID).OrderBy(p => p.Name);
// Assert
builder.GenerateQueries();
string generatedSql = builder.QueryQueue.First().QueryText;
Assert.IsTrue(generatedSql.Contains("SELECT [ID],[Name],[Age],[BirthDate],[IsHappy] "));
Assert.IsTrue(generatedSql.Contains("FROM PersonTable"));
Assert.IsFalse(generatedSql.Contains("WHERE"));
Assert.IsTrue(generatedSql.Contains("ORDER BY [ID],[Name]"));
}
public void Sort_Only_Query_No_Where()
{
// Arrange
var db = new DataMapper(System.Data.SqlClient.SqlClientFactory.Instance, "Data Source=a;Initial Catalog=a;User Id=a;Password=a;");
AutoQueryBuilder <Person> builder = new AutoQueryBuilder <Person>(db, false);
// Act
builder.OrderBy(p => p.ID).OrderBy(p => p.Name);
// Assert
builder.GenerateQueries();
string generatedSql = builder.QueryQueue.First().QueryText;
Assert.IsTrue(generatedSql.Contains("SELECT [ID],[Name],[Age],[BirthDate],[IsHappy] "));
Assert.IsTrue(generatedSql.Contains("FROM PersonTable"));
Assert.IsFalse(generatedSql.Contains("WHERE"));
Assert.IsTrue(generatedSql.Contains("ORDER BY [ID],[Name]"));
}
