public void SqlServerDeleteQuery_ShouldGenQuery() { // Arrange var command = new System.Data.SqlClient.SqlCommand(); var where = new WhereBuilder<Person>(command, p => p.ID == 5, false); IQuery query = new DeleteQuery("dbo.People", where.ToString()); // Act string queryText = query.Generate(); // Assert Assert.IsNotNull(queryText); Assert.IsTrue(queryText.Contains("DELETE FROM dbo.People")); Assert.IsTrue(queryText.Contains("WHERE ([ID] = @P0)")); Assert.AreEqual(command.Parameters["@P0"].Value, 5); }
public void SqlServerDeleteQuery_ShouldGenQuery() { // Arrange var command = new System.Data.SqlClient.SqlCommand(); TableCollection tables = new TableCollection { new Table(typeof(Person)) }; Expression<Func<Person, bool>> filter = p => p.ID == 5; var where = new WhereBuilder<Person>(command, new SqlServerDialect(), filter, tables, false, false); IQuery query = new DeleteQuery(new Dialect(), tables[0], where.ToString()); // Act string queryText = query.Generate(); // Assert Assert.IsNotNull(queryText); Assert.IsTrue(queryText.Contains("DELETE FROM [PersonTable]")); Assert.IsTrue(queryText.Contains("WHERE ([ID] = @P0)")); Assert.AreEqual(command.Parameters["@P0"].Value, 5); }