public void TestBuildsSelectAllQuery()
{
//--Act
var query = new SqlServerSelectQueryBuilder().SelectAll <Client>();
//--Assert
Console.WriteLine(query);
var queryLines = SplitQuery(query);
Assert.AreEqual(2, queryLines.Length);
Assert.AreEqual("select [Id], [CreatedByUserId], [CreatedDateUtc], [ModifiedByUserId], [ModifiedDateUtc], [Name], [IsActive]", queryLines[0]);
Assert.AreEqual("from [Client]", queryLines[1]);
}
private static void Main(string[] args)
{
var query = new SqlServerSelectQueryBuilder()
.SelectAll()
.From("Products")
.Join(JoinType.InnerJoin, "Categories", "Id", ComparisonOperator.EqualTo, "Products", "CategoryId")
.Where("Products", "Name", ComparisonOperator.StartsWith, "A")
.OrderBy("Products", "Name", SortDirection.Ascending)
.Take(25);
Console.WriteLine(query.BuildQuery());
Console.ReadLine();
}
public void TestBuildsSelectByKeyQueryMultiple()
{
//--Act
var query = new SqlServerSelectQueryBuilder().SelectByKey <ClientUser>();
//--Assert
Console.WriteLine(query);
var queryLines = SplitQuery(query);
Assert.AreEqual(3, queryLines.Length);
Assert.AreEqual("select [ClientId], [UserId], [IsActive]", queryLines[0]);
Assert.AreEqual("from [Client_User]", queryLines[1]);
Assert.AreEqual("where [ClientId] = @ClientId and [UserId] = @UserId", queryLines[2]);
}
public void TestBuildsSelectQueryWithBuilder()
{
//--Act
var query = new SqlServerSelectQueryBuilder().Select(new PredicateBuilder <Client>()
.Filter(x => x.IsActive));
//--Assert
Console.WriteLine(query);
var queryLines = SplitQuery(query);
Assert.AreEqual(3, queryLines.Length);
Assert.AreEqual("select [Id], [CreatedByUserId], [CreatedDateUtc], [ModifiedByUserId], [ModifiedDateUtc], [Name], [IsActive]", queryLines[0]);
Assert.AreEqual("from [Client]", queryLines[1]);
Assert.AreEqual("where [IsActive] = @IsActive", queryLines[2]);
}
