public void UpdateWithDeclarationAsParameter()
{
string expectedQuery = @"
UPDATE [TestTable]
SET
[TestTable].[Id] = @TestTable_Id,
[TestTable].[Title] = @TestTable_Title
";
Dictionary <string, object> expectedParameters = new Dictionary <string, object> {
{ "TestTable_Id", 1 },
{ "TestTable_Title", "testTitle" },
};
TSqlBuilder builder = new TSqlBuilder();
UpdateDeclaration <TestTable> updDeclaration = new UpdateDeclaration <TestTable>();
updDeclaration.Set(f => f.Id, 1);
updDeclaration.Set(f => f.Title, "testTitle");
builder.Update <TestTable>(updDeclaration);
TSqlQuery actualQuery = builder.CompileQuery();
Assert.AreEqual(NormalizeSqlQuery(expectedQuery), NormalizeSqlQuery(actualQuery.Query));
CollectionAssert.AreEquivalent(expectedParameters, actualQuery.Parameters);
}
void Save()
{
KeyIsDirty = false;
BodyIsDirty = false;
FError.Text = string.Empty;
UpdateDeclaration?.Invoke(this, new DeclarationString(FSelection.Text.Trim(), FBody.Text.Trim()));
}
