public void SQLBuilderAppendsEqualsClauseWithStringBasedIdentifiers() { var sqlBuilder = new SQLBuilder(string.Empty, SQLCommandType.NotSet); const string correctSQL = @"='Dummy'"; var dummyPOCOWithIntId = new DummyPOCO { FirstName = @"Dummy" }; Assert.AreEqual(correctSQL, sqlBuilder.EqualTo(dummyPOCOWithIntId.FirstName).ToString()); }
public void SQLBuilderAppendsNotEqualClauseWithIntegerBasedIdentifiers() { var sqlBuilder = new SQLBuilder(string.Empty, SQLCommandType.NotSet); const string correctSQL = @"!=1"; var dummyPOCOWithIntId = new DummyPOCO { Id = 1 }; Assert.AreEqual(correctSQL, sqlBuilder.NotEqualTo(dummyPOCOWithIntId.Id).ToString()); }
public void SQLBuilderWritesCorrectInsertCommand() { var sqlBuilder = new SQLBuilder(string.Empty, SQLCommandType.NotSet); var dummyPoco = new DummyPOCO { Id = 1, FirstName = @"Dummy", Surname = @"POCO" }; var parameters = new List <string> { @"id", @"firstname", @"surname" }; const string correctSQL = @"insert dbo.myTable (id,firstname,surname) values (1,'Dummy','POCO')"; Assert.AreEqual(correctSQL, sqlBuilder.Insert(@"myTable", parameters, dummyPoco.Id, dummyPoco.FirstName, dummyPoco.Surname).ToString()); }