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