public void OneTimeTearDown() { using (var context = new AllDataTypesContext()) context.Database.EnsureDeleted(); using (var context = new StringTypesContext()) context.Database.EnsureDeleted(); }
static void InsertAllDataTypes() { DateTime now = new DateTime(DateTime.Today.AddSeconds(1).AddMilliseconds(1).AddTicks(10).Ticks); using (var context = new AllDataTypesContext()) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); context.AllDataTypes.Add(new AllDataTypes() { AddressNumber1 = 1, AddressNumber2 = 2, AddressNumber3 = 3, AddressNumber4 = 4, AddressNumber5 = (long)5, AddressNumber6 = 6.36f, AddressNumber7 = 7.49f, AddressNumber8 = 8.64d, AddressNumber9 = 9.81m, AddressNumber10 = 10, BuildingName1 = "BuildingName1", BuildingName2 = "BuildingName2", BuildingName3 = "BuildingName3", BuildingName4 = "BuildingName4", BuildingName5 = "BuildingName5", BuildingName6 = UTF8Encoding.UTF8.GetBytes("BuildingName6"), BuildingName7 = UTF8Encoding.UTF8.GetBytes("BuildingName7"), BuildingName8 = UTF8Encoding.UTF8.GetBytes("BuildingName8"), BuildingName9 = UTF8Encoding.UTF8.GetBytes("BuildingName9"), BuildingName10 = UTF8Encoding.UTF8.GetBytes("BuildingName10"), BuildingName11 = "small", BuildingName12 = "small,medium,large,medium", BuildingName13 = now, BuildingName14 = now, BuildingName15 = now.TimeOfDay, BuildingName16 = now, BuildingName17 = (short)now.Year }); context.SaveChanges(); } using (var context = new AllDataTypesContext()) { var data = context.AllDataTypes.First(); Assert.Equal(1, data.AddressNumber1); Assert.Equal(2, data.AddressNumber2); Assert.Equal(3, data.AddressNumber3); Assert.Equal(4, data.AddressNumber4); Assert.Equal((long)5, data.AddressNumber5); Assert.Equal(6.36f, data.AddressNumber6); Assert.Equal(7.49f, data.AddressNumber7); Assert.Equal(8.64d, data.AddressNumber8); Assert.Equal(9.81m, data.AddressNumber9); Assert.Equal(10, data.AddressNumber10); Assert.Equal("BuildingName1", data.BuildingName1); Assert.Equal("BuildingName2", data.BuildingName2); Assert.Equal("BuildingName3", data.BuildingName3); Assert.Equal("BuildingName4", data.BuildingName4); Assert.Equal("BuildingName5", data.BuildingName5); Assert.Equal("BuildingName6".PadRight(120, '\0'), UTF8Encoding.UTF8.GetString(data.BuildingName6)); Assert.Equal("BuildingName7", UTF8Encoding.UTF8.GetString(data.BuildingName7)); Assert.Equal("BuildingName8", UTF8Encoding.UTF8.GetString(data.BuildingName8)); Assert.Equal("BuildingName9", UTF8Encoding.UTF8.GetString(data.BuildingName9)); Assert.Equal("BuildingName10", UTF8Encoding.UTF8.GetString(data.BuildingName10)); Assert.Equal("small", data.BuildingName11); Assert.Equal("small,medium,large", data.BuildingName12); Assert.Equal(now.Date, data.BuildingName13); Assert.Equal(now, data.BuildingName14); Assert.Equal(now.TimeOfDay, data.BuildingName15); Assert.Equal(now, data.BuildingName16); Assert.Equal(now.Year, data.BuildingName17); } }