void TestDateTimeOffset (TestDb db) { db.CreateTable<TestObj> (); TestObj o, o2; // // Ticks // o = new TestObj { ModifiedTime = new DateTimeOffset (2012, 1, 14, 3, 2, 1, TimeSpan.Zero), }; db.Insert (o); o2 = db.Get<TestObj> (o.Id); Assert.AreEqual (o.ModifiedTime, o2.ModifiedTime); }
private void CheckPK(TestDb db) { for (int i = 1; i <= 10; i++) { var na = new NoAttributes { Id = i, AColumn = i.ToString(), IndexedId = 0 }; db.Insert(na); } var item = db.Get<NoAttributes>(2); Assert.IsNotNull(item); Assert.AreEqual(2, item.Id); }
private void TestDateTime(TestDb db) { db.CreateTable <TestObj>(); TestObj o, o2; // // Ticks // o = new TestObj { ModifiedTime = new DateTime(2012, 1, 14, 3, 2, 1), }; db.Insert(o); o2 = db.Get <TestObj>(o.Id); Assert.AreEqual(o.ModifiedTime, o2.ModifiedTime); }
private void CheckPK(TestDb db) { for (int i = 1; i <= 10; i++) { var na = new NoAttributes { Id = i, AColumn = i.ToString(), IndexedId = 0 }; db.Insert(na); } var item = db.Get <NoAttributes>(2); Assert.IsNotNull(item); Assert.AreEqual(2, item.Id); }
public void Insert() { var db = new TestDb(); db.CreateTable<UnicodeProduct>(); string testString = "\u2329\u221E\u232A"; db.Insert(new UnicodeProduct { Name = testString, }); var p = db.Get<UnicodeProduct>(1); Assert.AreEqual(testString, p.Name); }
public void Insert() { var db = new TestDb(); db.CreateTable <Product>(); string testString = "\u2329\u221E\u232A"; db.Insert(new Product { Name = testString, }); var p = db.Get <Product>(1); Assert.AreEqual(testString, p.Name); }
private void TestDateTime(TestDb db) { db.CreateTable<TestObj>(); TestObj o, o2; // // Ticks // o = new TestObj { ModifiedTime = DateTime.UtcNow, }; db.Insert(o); o2 = db.Get<TestObj>(o.Id); Assert.AreEqual(o.ModifiedTime, o2.ModifiedTime.ToUniversalTime()); var expectedTimeZone = db.StoreDateTimeAsTicks ? DateTimeKind.Utc : DateTimeKind.Local; Assert.AreEqual(o2.ModifiedTime.Kind, expectedTimeZone); }
private void TestDateTime(TestDb db) { db.CreateTable<TestObj>(); // // Ticks // var org = new TestObj { Time1 = DateTime.UtcNow, Time2 = DateTime.Now, }; db.Insert(org); var fromDb = db.Get<TestObj>(org.Id); Assert.AreEqual(fromDb.Time1.ToUniversalTime(), org.Time1.ToUniversalTime()); Assert.AreEqual(fromDb.Time2.ToUniversalTime(), org.Time2.ToUniversalTime()); Assert.AreEqual(fromDb.Time1.ToLocalTime(), org.Time1.ToLocalTime()); Assert.AreEqual(fromDb.Time2.ToLocalTime(), org.Time2.ToLocalTime()); }
private void TestDateTime(TestDb db) { db.CreateTable <TestObj>(); TestObj o, o2; // // Ticks // o = new TestObj { ModifiedTime = DateTime.UtcNow, }; db.Insert(o); o2 = db.Get <TestObj>(o.Id); Assert.AreEqual(o.ModifiedTime, o2.ModifiedTime.ToUniversalTime()); var expectedTimeZone = db.StoreDateTimeAsTicks ? DateTimeKind.Utc : DateTimeKind.Local; Assert.AreEqual(o2.ModifiedTime.Kind, expectedTimeZone); }
private void TestDateTime(TestDb db) { db.CreateTable <TestObj>(); // // Ticks // var org = new TestObj { Time1 = DateTime.UtcNow, Time2 = DateTime.Now, }; db.Insert(org); var fromDb = db.Get <TestObj>(org.Id); Assert.AreEqual(fromDb.Time1.ToUniversalTime(), org.Time1.ToUniversalTime()); Assert.AreEqual(fromDb.Time2.ToUniversalTime(), org.Time2.ToUniversalTime()); Assert.AreEqual(fromDb.Time1.ToLocalTime(), org.Time1.ToLocalTime()); Assert.AreEqual(fromDb.Time2.ToLocalTime(), org.Time2.ToLocalTime()); }