public virtual void Columns_have_expected_data_types() { var actual = BuiltInDataTypesSqlCeTest.QueryForColumnTypes(CreateContext()); const string expected = @"BinaryForeignKeyDataType.BinaryKeyDataTypeId ---> [nullable varbinary] [MaxLength = 512] BinaryForeignKeyDataType.Id ---> [varbinary] [MaxLength = 4] BinaryKeyDataType.Id ---> [varbinary] [MaxLength = 512] BuiltInDataTypes.Enum16 ---> [varbinary] [MaxLength = 2] BuiltInDataTypes.Enum32 ---> [varbinary] [MaxLength = 4] BuiltInDataTypes.Enum64 ---> [varbinary] [MaxLength = 8] BuiltInDataTypes.Enum8 ---> [varbinary] [MaxLength = 1] BuiltInDataTypes.EnumS8 ---> [varbinary] [MaxLength = 1] BuiltInDataTypes.EnumU16 ---> [varbinary] [MaxLength = 2] BuiltInDataTypes.EnumU32 ---> [varbinary] [MaxLength = 4] BuiltInDataTypes.EnumU64 ---> [varbinary] [MaxLength = 8] BuiltInDataTypes.Id ---> [varbinary] [MaxLength = 4] BuiltInDataTypes.PartitionId ---> [varbinary] [MaxLength = 4] BuiltInDataTypes.TestBoolean ---> [varbinary] [MaxLength = 1] BuiltInDataTypes.TestByte ---> [varbinary] [MaxLength = 1] BuiltInDataTypes.TestCharacter ---> [varbinary] [MaxLength = 2] BuiltInDataTypes.TestDateTime ---> [varbinary] [MaxLength = 8] BuiltInDataTypes.TestDateTimeOffset ---> [varbinary] [MaxLength = 12] BuiltInDataTypes.TestDecimal ---> [varbinary] [MaxLength = 16] BuiltInDataTypes.TestDouble ---> [varbinary] [MaxLength = 8] BuiltInDataTypes.TestInt16 ---> [varbinary] [MaxLength = 2] BuiltInDataTypes.TestInt32 ---> [varbinary] [MaxLength = 4] BuiltInDataTypes.TestInt64 ---> [varbinary] [MaxLength = 8] BuiltInDataTypes.TestSignedByte ---> [varbinary] [MaxLength = 1] BuiltInDataTypes.TestSingle ---> [varbinary] [MaxLength = 4] BuiltInDataTypes.TestTimeSpan ---> [varbinary] [MaxLength = 8] BuiltInDataTypes.TestUnsignedInt16 ---> [varbinary] [MaxLength = 2] BuiltInDataTypes.TestUnsignedInt32 ---> [varbinary] [MaxLength = 4] BuiltInDataTypes.TestUnsignedInt64 ---> [varbinary] [MaxLength = 8] BuiltInDataTypesShadow.Enum16 ---> [varbinary] [MaxLength = 2] BuiltInDataTypesShadow.Enum32 ---> [varbinary] [MaxLength = 4] BuiltInDataTypesShadow.Enum64 ---> [varbinary] [MaxLength = 8] BuiltInDataTypesShadow.Enum8 ---> [varbinary] [MaxLength = 1] BuiltInDataTypesShadow.EnumS8 ---> [varbinary] [MaxLength = 1] BuiltInDataTypesShadow.EnumU16 ---> [varbinary] [MaxLength = 2] BuiltInDataTypesShadow.EnumU32 ---> [varbinary] [MaxLength = 4] BuiltInDataTypesShadow.EnumU64 ---> [varbinary] [MaxLength = 8] BuiltInDataTypesShadow.Id ---> [varbinary] [MaxLength = 4] BuiltInDataTypesShadow.PartitionId ---> [varbinary] [MaxLength = 4] BuiltInDataTypesShadow.TestBoolean ---> [varbinary] [MaxLength = 1] BuiltInDataTypesShadow.TestByte ---> [varbinary] [MaxLength = 1] BuiltInDataTypesShadow.TestCharacter ---> [varbinary] [MaxLength = 2] BuiltInDataTypesShadow.TestDateTime ---> [varbinary] [MaxLength = 8] BuiltInDataTypesShadow.TestDateTimeOffset ---> [varbinary] [MaxLength = 12] BuiltInDataTypesShadow.TestDecimal ---> [varbinary] [MaxLength = 16] BuiltInDataTypesShadow.TestDouble ---> [varbinary] [MaxLength = 8] BuiltInDataTypesShadow.TestInt16 ---> [varbinary] [MaxLength = 2] BuiltInDataTypesShadow.TestInt32 ---> [varbinary] [MaxLength = 4] BuiltInDataTypesShadow.TestInt64 ---> [varbinary] [MaxLength = 8] BuiltInDataTypesShadow.TestSignedByte ---> [varbinary] [MaxLength = 1] BuiltInDataTypesShadow.TestSingle ---> [varbinary] [MaxLength = 4] BuiltInDataTypesShadow.TestTimeSpan ---> [varbinary] [MaxLength = 8] BuiltInDataTypesShadow.TestUnsignedInt16 ---> [varbinary] [MaxLength = 2] BuiltInDataTypesShadow.TestUnsignedInt32 ---> [varbinary] [MaxLength = 4] BuiltInDataTypesShadow.TestUnsignedInt64 ---> [varbinary] [MaxLength = 8] BuiltInNullableDataTypes.Enum16 ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypes.Enum32 ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypes.Enum64 ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypes.Enum8 ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypes.EnumS8 ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypes.EnumU16 ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypes.EnumU32 ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypes.EnumU64 ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypes.Id ---> [varbinary] [MaxLength = 4] BuiltInNullableDataTypes.PartitionId ---> [varbinary] [MaxLength = 4] BuiltInNullableDataTypes.TestByteArray ---> [nullable image] [MaxLength = 1073741823] BuiltInNullableDataTypes.TestNullableBoolean ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypes.TestNullableByte ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypes.TestNullableCharacter ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypes.TestNullableDateTime ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypes.TestNullableDateTimeOffset ---> [nullable varbinary] [MaxLength = 12] BuiltInNullableDataTypes.TestNullableDecimal ---> [nullable varbinary] [MaxLength = 16] BuiltInNullableDataTypes.TestNullableDouble ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypes.TestNullableInt16 ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypes.TestNullableInt32 ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypes.TestNullableInt64 ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypes.TestNullableSignedByte ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypes.TestNullableSingle ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypes.TestNullableTimeSpan ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypes.TestNullableUnsignedInt16 ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypes.TestNullableUnsignedInt32 ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypes.TestNullableUnsignedInt64 ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypes.TestString ---> [nullable image] [MaxLength = 1073741823] BuiltInNullableDataTypesShadow.Enum16 ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypesShadow.Enum32 ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypesShadow.Enum64 ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypesShadow.Enum8 ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypesShadow.EnumS8 ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypesShadow.EnumU16 ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypesShadow.EnumU32 ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypesShadow.EnumU64 ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypesShadow.Id ---> [varbinary] [MaxLength = 4] BuiltInNullableDataTypesShadow.PartitionId ---> [varbinary] [MaxLength = 4] BuiltInNullableDataTypesShadow.TestByteArray ---> [nullable image] [MaxLength = 1073741823] BuiltInNullableDataTypesShadow.TestNullableBoolean ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypesShadow.TestNullableByte ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypesShadow.TestNullableCharacter ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypesShadow.TestNullableDateTime ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypesShadow.TestNullableDateTimeOffset ---> [nullable varbinary] [MaxLength = 12] BuiltInNullableDataTypesShadow.TestNullableDecimal ---> [nullable varbinary] [MaxLength = 16] BuiltInNullableDataTypesShadow.TestNullableDouble ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypesShadow.TestNullableInt16 ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypesShadow.TestNullableInt32 ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypesShadow.TestNullableInt64 ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypesShadow.TestNullableSignedByte ---> [nullable varbinary] [MaxLength = 1] BuiltInNullableDataTypesShadow.TestNullableSingle ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypesShadow.TestNullableTimeSpan ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypesShadow.TestNullableUnsignedInt16 ---> [nullable varbinary] [MaxLength = 2] BuiltInNullableDataTypesShadow.TestNullableUnsignedInt32 ---> [nullable varbinary] [MaxLength = 4] BuiltInNullableDataTypesShadow.TestNullableUnsignedInt64 ---> [nullable varbinary] [MaxLength = 8] BuiltInNullableDataTypesShadow.TestString ---> [nullable image] [MaxLength = 1073741823] EmailTemplate.Id ---> [varbinary] [MaxLength = 16] EmailTemplate.TemplateType ---> [varbinary] [MaxLength = 4] MaxLengthDataTypes.ByteArray5 ---> [nullable varbinary] [MaxLength = 5] MaxLengthDataTypes.ByteArray9000 ---> [nullable image] [MaxLength = 1073741823] MaxLengthDataTypes.Id ---> [varbinary] [MaxLength = 4] MaxLengthDataTypes.String3 ---> [nullable varbinary] [MaxLength = 3] MaxLengthDataTypes.String9000 ---> [nullable image] [MaxLength = 1073741823] StringForeignKeyDataType.Id ---> [varbinary] [MaxLength = 4] StringForeignKeyDataType.StringKeyDataTypeId ---> [nullable varbinary] [MaxLength = 512] StringKeyDataType.Id ---> [varbinary] [MaxLength = 512] UnicodeDataTypes.Id ---> [varbinary] [MaxLength = 4] UnicodeDataTypes.StringAnsi ---> [nullable image] [MaxLength = 1073741823] UnicodeDataTypes.StringAnsi3 ---> [nullable varbinary] [MaxLength = 3] UnicodeDataTypes.StringAnsi9000 ---> [nullable image] [MaxLength = 1073741823] UnicodeDataTypes.StringDefault ---> [nullable image] [MaxLength = 1073741823] UnicodeDataTypes.StringUnicode ---> [nullable image] [MaxLength = 1073741823] "; Assert.Equal(expected, actual, ignoreLineEndingDifferences: true); }
public virtual void Columns_have_expected_data_types() { var actual = BuiltInDataTypesSqlCeTest.QueryForColumnTypes(CreateContext()); const string expected = @"BinaryForeignKeyDataType.BinaryKeyDataTypeId ---> [nullable varbinary] [MaxLength = 512] BinaryForeignKeyDataType.Id ---> [int] [Precision = 10] BinaryKeyDataType.Id ---> [varbinary] [MaxLength = 512] BuiltInDataTypes.Enum16 ---> [bigint] [Precision = 19] BuiltInDataTypes.Enum32 ---> [bigint] [Precision = 19] BuiltInDataTypes.Enum64 ---> [bigint] [Precision = 19] BuiltInDataTypes.Enum8 ---> [nvarchar] [MaxLength = 4000] BuiltInDataTypes.EnumS8 ---> [nvarchar] [MaxLength = 24] BuiltInDataTypes.EnumU16 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypes.EnumU32 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypes.EnumU64 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypes.Id ---> [int] [Precision = 10] BuiltInDataTypes.PartitionId ---> [bigint] [Precision = 19] BuiltInDataTypes.TestBoolean ---> [nvarchar] [MaxLength = 4] BuiltInDataTypes.TestByte ---> [int] [Precision = 10] BuiltInDataTypes.TestCharacter ---> [int] [Precision = 10] BuiltInDataTypes.TestDateTime ---> [bigint] [Precision = 19] BuiltInDataTypes.TestDateTimeOffset ---> [bigint] [Precision = 19] BuiltInDataTypes.TestDecimal ---> [varbinary] [MaxLength = 16] BuiltInDataTypes.TestDouble ---> [numeric] [Precision = 26 Scale = 16] BuiltInDataTypes.TestInt16 ---> [bigint] [Precision = 19] BuiltInDataTypes.TestInt32 ---> [bigint] [Precision = 19] BuiltInDataTypes.TestInt64 ---> [bigint] [Precision = 19] BuiltInDataTypes.TestSignedByte ---> [numeric] [Precision = 18 Scale = 2] BuiltInDataTypes.TestSingle ---> [float] [Precision = 53] BuiltInDataTypes.TestTimeSpan ---> [float] [Precision = 53] BuiltInDataTypes.TestUnsignedInt16 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypes.TestUnsignedInt32 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypes.TestUnsignedInt64 ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.Enum16 ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.Enum32 ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.Enum64 ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.Enum8 ---> [nvarchar] [MaxLength = 4000] BuiltInDataTypesShadow.EnumS8 ---> [nvarchar] [MaxLength = 4000] BuiltInDataTypesShadow.EnumU16 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypesShadow.EnumU32 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypesShadow.EnumU64 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypesShadow.Id ---> [int] [Precision = 10] BuiltInDataTypesShadow.PartitionId ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.TestBoolean ---> [nvarchar] [MaxLength = 4000] BuiltInDataTypesShadow.TestByte ---> [int] [Precision = 10] BuiltInDataTypesShadow.TestCharacter ---> [int] [Precision = 10] BuiltInDataTypesShadow.TestDateTime ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.TestDateTimeOffset ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.TestDecimal ---> [varbinary] [MaxLength = 16] BuiltInDataTypesShadow.TestDouble ---> [numeric] [Precision = 26 Scale = 16] BuiltInDataTypesShadow.TestInt16 ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.TestInt32 ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.TestInt64 ---> [bigint] [Precision = 19] BuiltInDataTypesShadow.TestSignedByte ---> [numeric] [Precision = 18 Scale = 2] BuiltInDataTypesShadow.TestSingle ---> [float] [Precision = 53] BuiltInDataTypesShadow.TestTimeSpan ---> [float] [Precision = 53] BuiltInDataTypesShadow.TestUnsignedInt16 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypesShadow.TestUnsignedInt32 ---> [numeric] [Precision = 20 Scale = 0] BuiltInDataTypesShadow.TestUnsignedInt64 ---> [bigint] [Precision = 19] BuiltInNullableDataTypes.Enum16 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.Enum32 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.Enum64 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.Enum8 ---> [nullable nvarchar] [MaxLength = 4000] BuiltInNullableDataTypes.EnumS8 ---> [nullable nvarchar] [MaxLength = 4000] BuiltInNullableDataTypes.EnumU16 ---> [nullable numeric] [Precision = 20 Scale = 0] BuiltInNullableDataTypes.EnumU32 ---> [nullable numeric] [Precision = 20 Scale = 0] BuiltInNullableDataTypes.EnumU64 ---> [nullable numeric] [Precision = 20 Scale = 0] BuiltInNullableDataTypes.Id ---> [int] [Precision = 10] BuiltInNullableDataTypes.PartitionId ---> [bigint] [Precision = 19] BuiltInNullableDataTypes.TestByteArray ---> [nullable image] [MaxLength = 1073741823] BuiltInNullableDataTypes.TestNullableBoolean ---> [nullable nvarchar] [MaxLength = 4000] BuiltInNullableDataTypes.TestNullableByte ---> [nullable int] [Precision = 10] BuiltInNullableDataTypes.TestNullableCharacter ---> [nullable int] [Precision = 10] BuiltInNullableDataTypes.TestNullableDateTime ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.TestNullableDateTimeOffset ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.TestNullableDecimal ---> [nullable varbinary] [MaxLength = 16] BuiltInNullableDataTypes.TestNullableDouble ---> [nullable numeric] [Precision = 26 Scale = 16] BuiltInNullableDataTypes.TestNullableInt16 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.TestNullableInt32 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.TestNullableInt64 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.TestNullableSignedByte ---> [nullable numeric] [Precision = 18 Scale = 2] BuiltInNullableDataTypes.TestNullableSingle ---> [nullable float] [Precision = 53] BuiltInNullableDataTypes.TestNullableTimeSpan ---> [nullable float] [Precision = 53] BuiltInNullableDataTypes.TestNullableUnsignedInt16 ---> [nullable numeric] [Precision = 20 Scale = 0] BuiltInNullableDataTypes.TestNullableUnsignedInt32 ---> [nullable numeric] [Precision = 20 Scale = 0] BuiltInNullableDataTypes.TestNullableUnsignedInt64 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypes.TestString ---> [nullable nvarchar] [MaxLength = 4000] BuiltInNullableDataTypesShadow.Enum16 ---> [nullable smallint] [Precision = 5] BuiltInNullableDataTypesShadow.Enum32 ---> [nullable int] [Precision = 10] BuiltInNullableDataTypesShadow.Enum64 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypesShadow.Enum8 ---> [nullable tinyint] [Precision = 3] BuiltInNullableDataTypesShadow.EnumS8 ---> [nullable smallint] [Precision = 5] BuiltInNullableDataTypesShadow.EnumU16 ---> [nullable int] [Precision = 10] BuiltInNullableDataTypesShadow.EnumU32 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypesShadow.EnumU64 ---> [nullable numeric] [Precision = 20 Scale = 0] BuiltInNullableDataTypesShadow.Id ---> [int] [Precision = 10] BuiltInNullableDataTypesShadow.PartitionId ---> [int] [Precision = 10] BuiltInNullableDataTypesShadow.TestByteArray ---> [nullable image] [MaxLength = 1073741823] BuiltInNullableDataTypesShadow.TestNullableBoolean ---> [nullable bit] [Precision = 1 Scale = 0] BuiltInNullableDataTypesShadow.TestNullableByte ---> [nullable tinyint] [Precision = 3] BuiltInNullableDataTypesShadow.TestNullableCharacter ---> [nullable nvarchar] [MaxLength = 1] BuiltInNullableDataTypesShadow.TestNullableDateTime ---> [nullable datetime] [Precision = 23 Scale = 3] BuiltInNullableDataTypesShadow.TestNullableDateTimeOffset ---> [nullable nvarchar] [MaxLength = 48] BuiltInNullableDataTypesShadow.TestNullableDecimal ---> [nullable numeric] [Precision = 18 Scale = 2] BuiltInNullableDataTypesShadow.TestNullableDouble ---> [nullable float] [Precision = 53] BuiltInNullableDataTypesShadow.TestNullableInt16 ---> [nullable smallint] [Precision = 5] BuiltInNullableDataTypesShadow.TestNullableInt32 ---> [nullable int] [Precision = 10] BuiltInNullableDataTypesShadow.TestNullableInt64 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypesShadow.TestNullableSignedByte ---> [nullable smallint] [Precision = 5] BuiltInNullableDataTypesShadow.TestNullableSingle ---> [nullable real] [Precision = 24] BuiltInNullableDataTypesShadow.TestNullableTimeSpan ---> [nullable nvarchar] [MaxLength = 48] BuiltInNullableDataTypesShadow.TestNullableUnsignedInt16 ---> [nullable int] [Precision = 10] BuiltInNullableDataTypesShadow.TestNullableUnsignedInt32 ---> [nullable bigint] [Precision = 19] BuiltInNullableDataTypesShadow.TestNullableUnsignedInt64 ---> [nullable numeric] [Precision = 20 Scale = 0] BuiltInNullableDataTypesShadow.TestString ---> [nullable nvarchar] [MaxLength = 4000] EmailTemplate.Id ---> [uniqueidentifier] EmailTemplate.TemplateType ---> [int] [Precision = 10] Load.Fuel ---> [float] [Precision = 53] Load.LoadId ---> [int] [Precision = 10] MaxLengthDataTypes.ByteArray5 ---> [nullable varbinary] [MaxLength = 7] MaxLengthDataTypes.ByteArray9000 ---> [nullable nvarchar] [MaxLength = 4000] MaxLengthDataTypes.Id ---> [int] [Precision = 10] MaxLengthDataTypes.String3 ---> [nullable nvarchar] [MaxLength = 12] MaxLengthDataTypes.String9000 ---> [nullable varbinary] [MaxLength = 4000] NonNullableDependent.Id ---> [int] [Precision = 10] NonNullableDependent.PrincipalId ---> [int] [Precision = 10] NullablePrincipal.Id ---> [int] [Precision = 10] Person.Id ---> [int] [Precision = 10] Person.Name ---> [nullable nvarchar] [MaxLength = 4000] Person.SSN ---> [nullable int] [Precision = 10] StringForeignKeyDataType.Id ---> [int] [Precision = 10] StringForeignKeyDataType.StringKeyDataTypeId ---> [nullable nvarchar] [MaxLength = 256] StringKeyDataType.Id ---> [nvarchar] [MaxLength = 256] StringListDataType.Id ---> [int] [Precision = 10] StringListDataType.Strings ---> [nullable nvarchar] [MaxLength = 4000] UnicodeDataTypes.Id ---> [int] [Precision = 10] UnicodeDataTypes.StringAnsi ---> [nullable nvarchar] [MaxLength = 4000] UnicodeDataTypes.StringAnsi3 ---> [nullable nvarchar] [MaxLength = 3] UnicodeDataTypes.StringAnsi9000 ---> [nullable nvarchar] [MaxLength = 4000] UnicodeDataTypes.StringDefault ---> [nullable nvarchar] [MaxLength = 4000] UnicodeDataTypes.StringUnicode ---> [nullable nvarchar] [MaxLength = 4000] User.Email ---> [nullable nvarchar] [MaxLength = 4000] User.Id ---> [uniqueidentifier] "; Assert.Equal(expected, actual, ignoreLineEndingDifferences: true); }