public void SelectAllFieldsWithDeclarationAsParameter()
{
string expectedQuery = @"
SELECT
[TestTable].[Id],
[TestTable].[Title],
[TestTable].[FloatVal],
[TestTable].[DecimalVal],
[TestTable].[CreationDate],
[TestTable].[NullableId]
FROM [TestTable]
";
SelectDeclaration <TestTable> selectDeclaration = new SelectDeclaration <TestTable>();
selectDeclaration.AllFields();
TSqlBuilder builder = new TSqlBuilder();
builder
.Select <TestTable>(selectDeclaration);
TSqlQuery actualQuery = builder.CompileQuery();
Assert.AreEqual(NormalizeSqlQuery(expectedQuery), NormalizeSqlQuery(actualQuery.Query));
CollectionAssert.IsEmpty(actualQuery.Parameters);
}
public void SelectWithDeclarationAsParameter()
{
string expectedQuery = @"
SELECT
[TestTable].[Id],
[TestTable].[Title]
FROM [TestTable]
";
SelectDeclaration <TestTable> selectDeclaration = new SelectDeclaration <TestTable>();
selectDeclaration.Field(f => f.Id);
selectDeclaration.Field(f => f.Title);
TSqlBuilder builder = new TSqlBuilder();
builder
.Select <TestTable>(selectDeclaration);
TSqlQuery actualQuery = builder.CompileQuery();
Assert.AreEqual(NormalizeSqlQuery(expectedQuery), NormalizeSqlQuery(actualQuery.Query));
CollectionAssert.IsEmpty(actualQuery.Parameters);
}
