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())); }