public void DateTimeMillisecond() { using (new SoodaTransaction()) { bool b = AllDataTypes.Linq().Any(a => a.NnDateVal.Millisecond == 123); Assert.IsTrue(b); b = AllDataTypes.Linq().Any(a => a.NnDateVal.Millisecond == 0); Assert.IsFalse(b); } }
public void DateTimeHour() { using (new SoodaTransaction()) { bool b = AllDataTypes.Linq().Any(a => a.NnDateVal.Hour == 13); Assert.IsTrue(b); b = AllDataTypes.Linq().Any(a => a.NnDateVal.Hour == 1); Assert.IsFalse(b); } }
public void DateTimeDayOfYear() { using (new SoodaTransaction()) { bool b = AllDataTypes.Linq().Any(a => a.NnDateVal.DayOfYear == 204); Assert.IsTrue(b); b = AllDataTypes.Linq().Any(a => a.NnDateVal.DayOfYear == 203); Assert.IsFalse(b); } }
public void DateTimeMonth() { using (new SoodaTransaction()) { bool b = AllDataTypes.Linq().Any(a => a.NnDateVal.Month == 7); Assert.IsTrue(b); b = AllDataTypes.Linq().Any(a => a.NnDateVal.Month == 6); Assert.IsFalse(b); } }
public void AllDataTypesMinTest() { string ser; using (TestSqlDataSource testDataSource = new TestSqlDataSource("default")) { testDataSource.Open(); using (SoodaTransaction tran = new SoodaTransaction()) { tran.RegisterDataSource(testDataSource); AllDataTypes adt = new AllDataTypes(); // the range for decimal doesn't match the range in SQL adt.DateVal = DateTime.Now; adt.IntVal = Int32.MinValue; adt.Int64Val = Int64.MinValue; adt.DecimalVal = -1000000.12345m; adt.DoubleVal = Double.MinValue; adt.FloatVal = Single.MinValue; adt.StringVal = "test 12345"; adt.BoolVal = true; adt.NnDateVal = DateTime.Now; adt.NnIntVal = Int32.MinValue; adt.NnInt64Val = Int64.MinValue; adt.NnDecimalVal = -1000000.12345m; adt.NnDoubleVal = Double.MinValue; adt.NnFloatVal = Single.MinValue; adt.NnStringVal = "test 12345"; adt.NnBoolVal = true; ser = tran.Serialize(); Console.WriteLine("ser: {0}", ser); tran.Deserialize(ser); Assert.AreEqual(ser, tran.Serialize()); Console.WriteLine("Serialization is stable..."); tran.Commit(); } } }
//[Test] public void AllDataTypesNotNullDefaults() { using (TestSqlDataSource testDataSource = new TestSqlDataSource("default")) { testDataSource.Open(); using (SoodaTransaction tran = new SoodaTransaction()) { tran.RegisterDataSource(testDataSource); AllDataTypes adt = new AllDataTypes(); Assert.AreEqual(adt.NnDateVal, DateTime.MinValue); Assert.AreEqual(adt.NnIntVal, (int)0); Assert.AreEqual(adt.NnInt64Val, (long)0); Assert.AreEqual(adt.NnDecimalVal, (decimal)0); Assert.AreEqual(adt.NnDoubleVal, (double)0); Assert.AreEqual(adt.NnFloatVal, (float)0); Assert.AreEqual(adt.NnStringVal, String.Empty); Assert.AreEqual(adt.NnBoolVal, false); } } }