Esempio n. 1
0
        public void ShouldFormatDatesInIso8601Format()
        {
            DateTime dt = new DateTime(2015, 12, 31, 23, 59, 10).AddMilliseconds(12345);
            var parameter = dt.CreateSqlParameter("param", SqlDbType.DateTime);

            string executableSql = SqlDebugHelper.CreateExecutableSqlStatement("my_sp", parameter);
            Trace.WriteLine(executableSql);
            Assert.That(executableSql,
                Is.EqualTo("EXEC my_sp @param = convert(datetime,'2015-12-31 23:59:22:345', 121)"));
        }
Esempio n. 2
0
        public void ShouldCreateExecutableQuery()
        {
            DateTime dt = new DateTime(2010, 12, 31, 23, 59, 59);
            float? nullable = null;
            decimal decimalValue = 123.456m;

            string sql =
                "Select * FROM [dbo].[TableX] Where Column1 > @value1 and Column2 = @value2 and Column3 = @value3 and Column4 = @value4 and Column5 = @value5 and Column6 = @value6 and Column7 = @value7";

            IList<SqlParameter> parameters = new List<SqlParameter>();
            parameters.Add(0.CreateSqlParameter("value1"));
            parameters.Add("hello world".CreateSqlParameter("value2"));
            parameters.Add(nullable.CreateSqlParameter("value3"));
            parameters.Add(decimalValue.CreateSqlParameter("value4"));
            parameters.Add(true.CreateSqlParameter("value5"));
            var sqlParameter = 321.12m.CreateSqlParameter("value6");
            sqlParameter.Size = 10;
            sqlParameter.Precision = 2;
            parameters.Add(sqlParameter);
            parameters.Add(dt.CreateSqlParameter("value7", SqlDbType.DateTime));

            string executableSql = SqlDebugHelper.CreateExecutableSqlStatement(sql, parameters);
            Trace.WriteLine(executableSql);
        }
 public void ShouldUse24HourNotationForNullableDates()
 {
     DateTime? nullableDateTime = new DateTime(2011, 10, 19, 16, 30, 25, 123);
     SqlParameter sqlParameter1 = nullableDateTime.CreateSqlParameter("ParameterName", SqlDbType.DateTime);
     Assert.That(sqlParameter1.Value, Is.EqualTo(nullableDateTime.Value));
 }