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