public void DecimalTest() { using (var container = new RhetosTestContainer()) { container.Resolve <ISqlExecuter>().ExecuteSql("DELETE FROM TestTypes.Simple"); var repository = container.Resolve <Common.DomRepository>(); // Decimal(28,10) allows 18 digits before the decimal point and 10 digits after. var s = new TestTypes.Simple { Length = 123456789012345678.0123456789m }; Assert.AreEqual("123456789012345678.0123456789", s.Length.Value.ToString(System.Globalization.CultureInfo.InvariantCulture)); repository.TestTypes.Simple.Insert(s); var loaded = repository.TestTypes.Reader.Load().Single(); Assert.AreEqual(s.Length, loaded.Length); } }
public void DateTimeTest() { using (var container = new RhetosTestContainer()) { container.Resolve <ISqlExecuter>().ExecuteSql("DELETE FROM TestTypes.Simple"); var repository = container.Resolve <Common.DomRepository>(); for (int i = 0; i < 7; i++) { DateTime testTime = new DateTime(2013, 10, 27, 10, 45, 54, i * 1000 / 7); var item = new TestTypes.Simple { Start = testTime }; repository.TestTypes.Simple.Insert(item); var loaded = repository.TestTypes.Reader.Load().Single(); AssertIsNear(testTime, loaded.Start.Value); repository.TestTypes.Simple.Delete(item); } } }
public void DecimalSizeTest() { using (var container = new RhetosTestContainer()) { container.Resolve<ISqlExecuter>().ExecuteSql(new[] { "DELETE FROM TestTypes.Simple" }); var repository = container.Resolve<Common.DomRepository>(); var s = new TestTypes.Simple { Length = 1234567890123456789012345678m }; Assert.AreEqual("1234567890123456789012345678", s.Length.Value.ToString()); Assert.Inconclusive("NHibernate's limit"); repository.TestTypes.Simple.Insert(new[] { s }); var loaded = repository.TestTypes.Reader.All().Single(); Assert.AreEqual(s.Length, loaded.Length); } }
public void DateTimeTest() { using (var container = new RhetosTestContainer()) { container.Resolve<ISqlExecuter>().ExecuteSql(new[] { "DELETE FROM TestTypes.Simple" }); var repository = container.Resolve<Common.DomRepository>(); for (int i = 0; i < 7; i++) { DateTime testTime = new DateTime(2013, 10, 27, 10, 45, 54, i * 1000 / 7); var item = new TestTypes.Simple { Start = testTime }; repository.TestTypes.Simple.Insert(new[] { item }); var loaded = repository.TestTypes.Reader.All().Single(); AssertIsNear(testTime, loaded.Start.Value); repository.TestTypes.Simple.Delete(new[] { item }); } } }
public void DecimalPrecisionTest() { using (var container = new RhetosTestContainer()) { container.Resolve<ISqlExecuter>().ExecuteSql(new[] { "DELETE FROM TestTypes.Simple" }); var repository = container.Resolve<Common.DomRepository>(); var s = new TestTypes.Simple { Length = 0.0123456789m }; Assert.AreEqual("0.0123456789", s.Length.Value.ToString("F10", System.Globalization.CultureInfo.InvariantCulture)); repository.TestTypes.Simple.Insert(new[] { s }); var loaded = repository.TestTypes.Reader.All().Single(); Assert.AreEqual(s.Length, loaded.Length); } }
public void DecimalTest() { using (var container = new RhetosTestContainer()) { container.Resolve<ISqlExecuter>().ExecuteSql(new[] { "DELETE FROM TestTypes.Simple" }); var repository = container.Resolve<Common.DomRepository>(); // Decimal(28,10) allows 18 digits before the decimal point and 10 digits after. var s = new TestTypes.Simple { Length = 123456789012345678.0123456789m }; Assert.AreEqual("123456789012345678.0123456789", s.Length.Value.ToString(System.Globalization.CultureInfo.InvariantCulture)); repository.TestTypes.Simple.Insert(new[] { s }); var loaded = repository.TestTypes.Reader.Load().Single(); Assert.AreEqual(s.Length, loaded.Length); } }
public void DateTimeTest() { using (var executionContext = new CommonTestExecutionContext()) { executionContext.SqlExecuter.ExecuteSql(new[] { "DELETE FROM TestTypes.Simple" }); var repository = new Common.DomRepository(executionContext); for (int i = 0; i < 7; i++) { DateTime testTime = new DateTime(2013, 10, 27, 10, 45, 54, i * 1000 / 7); var item = new TestTypes.Simple { Start = testTime }; repository.TestTypes.Simple.Insert(new[] { item }); var loaded = repository.TestTypes.Reader.All().Single(); AssertIsNear(testTime, loaded.Start.Value); repository.TestTypes.Simple.Delete(new[] { item }); } } }
public void DecimalSizeTest() { using (var executionContext = new CommonTestExecutionContext()) { executionContext.SqlExecuter.ExecuteSql(new[] { "DELETE FROM TestTypes.Simple" }); var repository = new Common.DomRepository(executionContext); var s = new TestTypes.Simple { Length = 1234567890123456789012345678m }; Assert.AreEqual("1234567890123456789012345678", s.Length.Value.ToString()); Assert.Inconclusive("NHibernate's limit"); repository.TestTypes.Simple.Insert(new[] { s }); var loaded = repository.TestTypes.Reader.All().Single(); Assert.AreEqual(s.Length, loaded.Length); } }
public void DecimalPrecisionTest() { using (var executionContext = new CommonTestExecutionContext()) { executionContext.SqlExecuter.ExecuteSql(new[] { "DELETE FROM TestTypes.Simple" }); var repository = new Common.DomRepository(executionContext); var s = new TestTypes.Simple { Length = 0.0123456789m }; Assert.AreEqual("0.0123456789", s.Length.Value.ToString("F10", System.Globalization.CultureInfo.InvariantCulture)); repository.TestTypes.Simple.Insert(new[] { s }); var loaded = repository.TestTypes.Reader.All().Single(); Assert.AreEqual(s.Length, loaded.Length); } }