public void SelectAllDataInt() { //Setup var t = new ShortTranslator(UNIT_TEST_COL_NAME); var cmd = CreateTextCommand(SelectTestDataSQL()); //Act var data = t.Translate(ExecuteDataTable(cmd)); //Assert Assert.AreEqual(5, data.Count); }
public void SelectAllDataIntWithFilter () { //setup const int testvalue = 123; var t = new ShortTranslator(UNIT_TEST_COL_NAME); var cmd = CreateTextCommand(SelectTestDataSQL(), "Where col >= @testValue"); cmd.Parameters.Add(testvalue.ToSqlParameter("@testValue")); //Act var data = t.Translate(ExecuteDataTable(cmd)); //Asert Assert.AreEqual(3, data.Count); }