public void SelectAllDataNChar()
 {
     //Setup 
     var cmd = CreateTextCommand(SelectTestDataSQL());
     var t = new CharTranslator(UNIT_TEST_COL_NAME);
     //Act
     var data = t.Translate(ExecuteDataTable(cmd));
     //Assert
     Assert.AreEqual(5, data.Count);
 }
        public void SelectAllDataBigIntWithFilter ()
        {
            //setup
            const char testvalue = 'A';
            var t = new CharTranslator(UNIT_TEST_COL_NAME);
            var cmd = CreateTextCommand(SelectTestDataSQL(), "Where col = @testValue");
            cmd.Parameters.Add(testvalue.ToSqlParameter("@testValue"));

            //Act
            var data = t.Translate(ExecuteDataRow(cmd));

            //Asert
            Assert.AreEqual('A', data);
        }