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;");
QueryBuilder<Person> builder = new QueryBuilder<Person>(db, new SqlServerDialect());
builder.OrderBy(p => p.ID).OrderBy(p => p.Name);
// Act
string generatedSql = builder.BuildQuery();
// Assert
Assert.IsTrue(generatedSql.Contains("SELECT [t0].[ID],[t0].[Name],[t0].[Age],[t0].[BirthDate],[t0].[IsHappy] "));
Assert.IsTrue(generatedSql.Contains("FROM [PersonTable]"));
Assert.IsFalse(generatedSql.Contains("WHERE"));
Assert.IsTrue(generatedSql.Contains("ORDER BY [t0].[ID],[t0].[Name]"));
}
public void should_use_sortDirection_supplied_in_overload()
{
// Arrange
var db = new DataMapper(System.Data.SqlClient.SqlClientFactory.Instance, "Data Source=a;Initial Catalog=a;User Id=a;Password=a;");
QueryBuilder<Person> builder = new QueryBuilder<Person>(db, new SqlServerDialect());
builder.OrderBy(p => p.ID, SortDirection.Asc).OrderBy(p => p.Name, SortDirection.Desc);
// Act
string generatedSql = builder.BuildQuery();
// Assert
Assert.IsTrue(generatedSql.Contains("SELECT [t0].[ID],[t0].[Name],[t0].[Age],[t0].[BirthDate],[t0].[IsHappy] "));
Assert.IsTrue(generatedSql.Contains("FROM [PersonTable]"));
Assert.IsFalse(generatedSql.Contains("WHERE"));
Assert.IsTrue(generatedSql.Contains("ORDER BY [t0].[ID],[t0].[Name] DESC"));
}
public void ManualOrderByClause()
{
// Arrange
var db = new DataMapper(System.Data.SqlClient.SqlClientFactory.Instance, "Data Source=a;Initial Catalog=a;User Id=a;Password=a;");
QueryBuilder<Person> builder = new QueryBuilder<Person>(db, new SqlServerDialect());
builder
.OrderBy("RAND()");
// Act
string generatedSql = builder.BuildQuery();
// Assert
Assert.IsTrue(generatedSql.Contains("SELECT [t0].[ID],[t0].[Name],[t0].[Age],[t0].[BirthDate],[t0].[IsHappy] "));
Assert.IsTrue(generatedSql.Contains("FROM [PersonTable] [t0]"));
Assert.IsTrue(generatedSql.Contains("ORDER BY RAND()"));
}