public void TestString() { //arrange const string s = "Hello"; const SqlType sqlType = SqlType.Db2; var dateTypes = new Dictionary<string, string>(); var converter = new Converter(sqlType, dateTypes); //act var result = converter.Convert(typeof(string), s, "Name"); //assert Assert.AreEqual("'Hello'", result); }
public void TestDbNull() { //arrange var dbNull = DBNull.Value; const SqlType sqlType = SqlType.Db2; var dateTypes = new Dictionary<string, string>(); var converter = new Converter(sqlType, dateTypes); //act var result = converter.Convert(typeof(string), dbNull, "Name"); //assert Assert.AreEqual("NULL", result); }
public void TestDate() { //arrange var dt = new DateTime(2001, 3, 30, 10, 45, 30, 839); const SqlType sqlType = SqlType.Db2; var dateTypes = new Dictionary<string, string>(); dateTypes.Add("StartDate", "TIMESTAMP"); var converter = new Converter(sqlType, dateTypes); //act var result = converter.Convert(typeof(DateTime), dt, "StartDate"); //assert Assert.AreEqual("'2001-03-30 10:45:30.839'", result); }
public void TestStringTimeSpan() { //arrange var ts = new TimeSpan(1, 2, 3); const SqlType sqlType = SqlType.SqlServer; var dateTypes = new Dictionary<string, string>(); var converter = new Converter(sqlType, dateTypes); //act var result = converter.Convert(typeof(TimeSpan), ts, "Name"); //assert Assert.AreEqual("'01:02:03'", result); }
public void TestStringDecimal() { //arrange const decimal i = 10.5M; const SqlType sqlType = SqlType.SqlServer; var dateTypes = new Dictionary<string, string>(); var converter = new Converter(sqlType, dateTypes); //act var result = converter.Convert(typeof(decimal), i, "Name"); //assert Assert.AreEqual("10.5", result); }
public void TestStringInteger() { //arrange const int i = 10; const SqlType sqlType = SqlType.SqlServer; var dateTypes = new Dictionary<string, string>(); var converter = new Converter(sqlType, dateTypes); //act var result = converter.Convert(typeof(int), i, "Name"); //assert Assert.AreEqual("10", result); }