public void Insert <T>(Expression <Func <InsertDeclaration <T>, InsertDeclaration <T> > > expression)
{
InsertDeclaration <T> declaration = new InsertDeclaration <T>();
declaration = expression.Compile().Invoke(declaration);
Insert <T>(declaration);
}
public void InsertWithDeclarationAsParameter()
{
string expectedQuery = @"
INSERT [TestTable] (Title, CreationDate)
VALUES(
@TestTable_Title,
SYSUTCDATETIME()
)
";
Dictionary <string, object> expectedParameters = new Dictionary <string, object> {
{ "TestTable_Title", "testTitle" },
};
TSqlBuilder builder = new TSqlBuilder();
InsertDeclaration <TestTable> insertDecalration = new InsertDeclaration <TestTable>();
insertDecalration.Set(f => f.Title, "testTitle");
insertDecalration.Set(f => f.CreationDate, TSqlStatement.SysUtcDateTimeCall);
builder.Insert <TestTable>(insertDecalration);
TSqlQuery actualQuery = builder.CompileQuery();
Assert.AreEqual(NormalizeSqlQuery(expectedQuery), NormalizeSqlQuery(actualQuery.Query));
CollectionAssert.AreEquivalent(expectedParameters, actualQuery.Parameters);
}
public void Insert <T>(InsertDeclaration <T> declaration)
{
InsertClause insertClause = new InsertClause(typeof(T).Name, declaration.GetFields());
_clauses.Add(insertClause);
}
