public void ToString_WithMoreThanOneField_GeneratesCorrectSQLClause()
{
var table = new Tables_Blogs();
var fields = new IFormatableField[]
{
new Tables_Blogs_Id(table),
new Tables_Blogs_Name(table)
};
var select = new SelectClause(fields);
string expected =
@"SELECT
[dbo].[Blogs].[Id],
[dbo].[Blogs].[Name]
";
Assert.AreEqual(expected, select.ToString());
}
/// <summary>
/// SELECT clause
/// </summary>
/// <param name="fields">SELECT columns</param>
/// <returns><see cref="SQLSelectQuery"/></returns>
public static SQLSelectQuery Select(params IFormatableField[] fields)
{
var selectClause = new SelectClause(fields);
var q = new SQLSelectQuery(selectClause);
return q;
}
