private ArubaAllTypes[] InitializeAllTypes()
{
var allTypesList = new ArubaAllTypes[EntitiesCount];
for (var i = 0; i < EntitiesCount; i++)
{
var allTypes = new ArubaAllTypes
{
c2_smallint = (short)i,
c3_tinyint = (byte)i,
c4_bit = i % 2 == 0,
c5_datetime = new DateTime(1990, i % 12 + 1, i % 28 + 1, i % 12, i % 60, i % 60),
c6_smalldatetime = new DateTime(2010, i % 12 + 1, i % 28 + 1, i % 12, 0, 0),
c7_decimal_28_4 = 10 + (decimal)((double)i / 4),
c8_numeric_28_4 = -5 + (decimal)((double)i / 8),
c9_real = (float)i / 3,
c10_float = i + (double)i / 3,
c11_money = i + (decimal)((double)i / 5),
c12_smallmoney = i + (decimal)((double)i / 2),
c13_varchar_512_ = new string((char)(i + 'a'), i % 8),
c14_char_512_ = new string((char)(i + 'a'), 512),
c15_text = new string((char)(i + 'a'), 20 + i),
c16_binary_512_ = Enumerable.Repeat <byte>((byte)i, 512).ToArray(),
c17_varbinary_512_ = Enumerable.Repeat <byte>((byte)i, 1 + i % 7).ToArray(),
c18_image = Enumerable.Repeat <byte>((byte)i, i + 10).ToArray(),
c19_nvarchar_512_ = new string((char)(i + 'a'), i),
c20_nchar_512_ = new string((char)(i + 'a'), 512),
c21_ntext = new string((char)(i + 'a'), 20 + i),
c22_uniqueidentifier = new Guid(new string((char)((i % 5) + '0'), 32)),
c23_bigint = (long)i * 10,
c24_varchar_max_ = new string((char)(i + 'A'), 15 + i % 4),
c25_nvarchar_max_ = new string((char)(i + 'A'), 15 + i % 7),
c26_varbinary_max_ = Enumerable.Repeat <byte>((byte)i, 15 + i % 8).ToArray(),
c27_time = new TimeSpan(10, i % 60 + 1, i % 60 + i),
c28_date = new DateTime(2000, i % 8 + 1, i % 8 + 1),
c29_datetime2 = new DateTime(2012, i % 5 + 1, i % 5 + 1, 1, 2, 3),
c30_datetimeoffset = new DateTimeOffset(new DateTime(2030 + i, 1, 2), new TimeSpan(i % 12, i % 60, 0)),
c33_enum = (ArubaEnum)(i % 4),
c34_byteenum = (ArubaByteEnum)(i % 3),
//c35_timestamp
c38_shortenum = (ArubaShortEnum)(i % 3)
};
#if NET452
allTypes.c31_geography = DbGeography.FromText(string.Format("POINT ({0}.0 {0}.0)", i % 8), 4326);
allTypes.c32_geometry = DbGeometry.FromText(string.Format("POINT (1{0}.0 2{0}.0)", i % 8), 32768);
allTypes.c36_geometry_linestring = DbGeometry.FromText(string.Format("LINESTRING (1{0} 2{0}, 1{1} 2{0}, 1{1} 2{1}, 1{0} 2{1}, 1{0} 2{0})", i % 5 + 2, i % 5 + 4), 32768);
allTypes.c37_geometry_polygon = DbGeometry.FromText(string.Format("POLYGON ((1{1} 2{0}, 1{0} 2{0}, 1{0} 2{1}, 1{1} 2{0}))", i % 5 + 3, i % 5 + 4), 32768);
#endif
allTypesList[i] = allTypes;
}
return(allTypesList);
}
private ArubaAllTypes[] InitializeAllTypes()
{
var allTypesList = new ArubaAllTypes[EntitiesCount];
for (var i = 0; i < EntitiesCount; i++)
{
var allTypes = new ArubaAllTypes
{
c2_smallint = (short)i,
c3_tinyint = (byte)i,
c4_bit = i % 2 == 0,
c5_datetime = new DateTime(1990, i % 12 + 1, i % 28 + 1, i % 12, i % 60, i % 60),
c6_smalldatetime = new DateTime(2010, i % 12 + 1, i % 28 + 1, i % 12, 0, 0),
c7_decimal_28_4 = 10 + (decimal)((double)i / 4),
c8_numeric_28_4 = -5 + (decimal)((double)i / 8),
c9_real = (float)i / 3,
c10_float = i + (double)i / 3,
c11_money = i + (decimal)((double)i / 5),
c12_smallmoney = i + (decimal)((double)i / 2),
c13_varchar_512_ = new string((char)(i + 'a'), i % 8),
c14_char_512_ = new string((char)(i + 'a'), 512),
c15_text = new string((char)(i + 'a'), 20 + i),
c16_binary_512_ = Enumerable.Repeat<byte>((byte)i, 512).ToArray(),
c17_varbinary_512_ = Enumerable.Repeat<byte>((byte)i, 1 + i % 7).ToArray(),
c18_image = Enumerable.Repeat<byte>((byte)i, i + 10).ToArray(),
c19_nvarchar_512_ = new string((char)(i + 'a'), i),
c20_nchar_512_ = new string((char)(i + 'a'), 512),
c21_ntext = new string((char)(i + 'a'), 20 + i),
c22_uniqueidentifier = new Guid(new string((char)((i % 5) + '0'), 32)),
c23_bigint = (long)i * 10,
c24_varchar_max_ = new string((char)(i + 'A'), 15 + i % 4),
c25_nvarchar_max_ = new string((char)(i + 'A'), 15 + i % 7),
c26_varbinary_max_ = Enumerable.Repeat<byte>((byte)i, 15 + i % 8).ToArray(),
c27_time = new TimeSpan(10, i % 60 + 1, i % 60 + i),
c28_date = new DateTime(2000, i % 8 + 1, i % 8 + 1),
c29_datetime2 = new DateTime(2012, i % 5 + 1, i % 5 + 1, 1, 2, 3),
c30_datetimeoffset = new DateTimeOffset(new DateTime(2030 + i, 1, 2), new TimeSpan(i % 12, i % 60, 0)),
c31_geography = DbGeography.FromText(string.Format("POINT ({0}.0 {0}.0)", i % 8), 4326),
c32_geometry = DbGeometry.FromText(string.Format("POINT (1{0}.0 2{0}.0)", i % 8), 32768),
c33_enum = (ArubaEnum)(i % 4),
c34_byteenum = (ArubaByteEnum)(i % 3),
//c35_timestamp
c36_geometry_linestring = DbGeometry.FromText(string.Format("LINESTRING (1{0} 2{0}, 1{1} 2{0}, 1{1} 2{1}, 1{0} 2{1}, 1{0} 2{0})", i % 5 + 2, i % 5 + 4), 32768),
c37_geometry_polygon = DbGeometry.FromText(string.Format("POLYGON ((1{1} 2{0}, 1{0} 2{0}, 1{0} 2{1}, 1{1} 2{0}))", i % 5 + 3, i % 5 + 4), 32768),
c38_shortenum = (ArubaShortEnum)(i % 3)
};
allTypesList[i] = allTypes;
}
return allTypesList;
}
private static void UpdateArubaAllTypes(ArubaAllTypes allTypes, decimal value)
{
allTypes.c7_decimal_28_4 = value;
allTypes.c8_numeric_28_4 = value;
allTypes.c11_money = value;
allTypes.c12_smallmoney = value;
}
private static void ValidateSavedValues(ArubaContext context, ArubaAllTypes allTypes, decimal value)
{
var saved = context.AllTypes.AsNoTracking().Single(t => t.c1_int == allTypes.c1_int);
Assert.Equal(value, saved.c7_decimal_28_4);
Assert.Equal(value, saved.c8_numeric_28_4);
Assert.Equal(value, saved.c11_money);
Assert.Equal(value, saved.c12_smallmoney);
}