public void ComplexWhereClause()
{
#region expected
string expectedQ1 =
@"SELECT
[dbo].[Blogs].[Id]
FROM
[dbo].[Blogs]
WHERE
(([dbo].[Blogs].[Id] > 2) OR ([dbo].[Blogs].[Name] = N'Ken'))
";
#endregion
var from = new FromClause(SQL.Blogs);
var whereIdGraterThan2 = new WhereClause(SQL.Blogs.Id > 2);
var whereIdNameIsKen = new WhereClause(SQL.Blogs.Name == "Ken");
SQLQuery q1 = SQLQuery
.Select(SQL.Blogs.Id)
.From(from)
.Where(whereIdGraterThan2 || whereIdNameIsKen);
Assert.AreEqual(expectedQ1, q1.ToString());
}
public void ReusingClauses()
{
#region expected
string expectedQ1 =
@"SELECT
[dbo].[Blogs].[Id]
FROM
[dbo].[Blogs]
WHERE
([dbo].[Blogs].[Id] = 2)
";
string expectedQ2 =
@"SELECT
[dbo].[Blogs].[Name]
FROM
[dbo].[Blogs]
WHERE
([dbo].[Blogs].[Id] = 2)
";
#endregion
var from = new FromClause(SQL.Blogs);
var where = new WhereClause(SQL.Blogs.Id == 2);
SQLQuery q1 = SQLQuery
.Select(SQL.Blogs.Id)
.From(from)
.Where(where);
SQLQuery q2 = SQLQuery
.Select(SQL.Blogs.Name)
.From(from)
.Where(where);
Assert.AreEqual(expectedQ1, q1.ToString());
Assert.AreEqual(expectedQ2, q2.ToString());
}