public void SelectRowCount() { string expectedQuery = "SELECT @@ROWCOUNT"; TSqlBuilder builder = new TSqlBuilder(); builder.SelectRowCount(); TSqlQuery actualQuery = builder.CompileQuery(); Assert.AreEqual(NormalizeSqlQuery(expectedQuery), NormalizeSqlQuery(actualQuery.Query)); CollectionAssert.IsEmpty(actualQuery.Parameters); }
public void UpdateAndSelectRowCount() { string expectedQuery = @" UPDATE [TestTable] SET [TestTable].[Id] = @TestTable_Id, [TestTable].[Title] = @TestTable_Title SELECT @@ROWCOUNT "; TSqlBuilder builder = new TSqlBuilder(); builder.Update <TestTable>( upd => upd .Set(f => f.Id, 1) .Set(f => f.Title, "testTitle") ); builder.SelectRowCount(); TSqlQuery actualQuery = builder.CompileQuery(); Assert.AreEqual(NormalizeSqlQuery(expectedQuery), NormalizeSqlQuery(actualQuery.Query)); }