public void Does_not_match_composite_dependent_PK_for_unique_FK_if_order_mismatched()
{
var fkProperty1 = DependentTypeWithCompositeKey.Metadata.FindPrimaryKey().Properties[0];
var fkProperty2 = DependentTypeWithCompositeKey.Metadata.FindPrimaryKey().Properties[1];
DependentTypeWithCompositeKey.PrimaryKey(new[] { fkProperty2.Name, fkProperty1.Name }, ConfigurationSource.Explicit);
var relationshipBuilder = DependentTypeWithCompositeKey.Relationship(
PrincipalTypeWithCompositeKey, "NavProp", "InverseReferenceNav", ConfigurationSource.Convention)
.HasPrincipalKey(PrincipalTypeWithCompositeKey.Metadata.FindPrimaryKey().Properties, ConfigurationSource.DataAnnotation)
.IsUnique(true, ConfigurationSource.DataAnnotation);
Assert.Same(relationshipBuilder, new ForeignKeyPropertyDiscoveryConvention().Apply(relationshipBuilder));
var fk = (IForeignKey)relationshipBuilder.Metadata;
Assert.Same(fk, DependentTypeWithCompositeKey.Metadata.GetForeignKeys().Single());
Assert.Equal(2, fk.Properties.Count);
Assert.NotSame(fkProperty1, fk.Properties[0]);
Assert.NotSame(fkProperty2, fk.Properties[1]);
Assert.NotSame(fkProperty1, fk.Properties[1]);
Assert.NotSame(fkProperty2, fk.Properties[0]);
Assert.Same(CompositePrimaryKey[0], fk.PrincipalKey.Properties[0]);
Assert.Same(CompositePrimaryKey[1], fk.PrincipalKey.Properties[1]);
Assert.True(fk.IsUnique);
Assert.False(fk.IsRequired);
}
public void Does_not_match_composite_dependent_PK_for_non_unique_FK()
{
DependentTypeWithCompositeKey.PrimaryKey(
new[] { DependentEntityWithCompositeKey.NavPropIdProperty, DependentEntityWithCompositeKey.NavPropNameProperty },
ConfigurationSource.Explicit);
var relationshipBuilder = DependentTypeWithCompositeKey.Relationship(
PrincipalTypeWithCompositeKey,
"NavProp",
null,
ConfigurationSource.Convention)
.IsUnique(false, ConfigurationSource.DataAnnotation);
Assert.Same(relationshipBuilder, new ForeignKeyPropertyDiscoveryConvention().Apply(relationshipBuilder));
var fk = (IForeignKey)relationshipBuilder.Metadata;
Assert.Same(fk, DependentTypeWithCompositeKey.Metadata.GetForeignKeys().Single());
Assert.Equal("NavProp" + CompositePrimaryKey[0].Name + "1", fk.Properties[0].Name);
Assert.Equal("NavProp" + CompositePrimaryKey[1].Name + "1", fk.Properties[1].Name);
Assert.Same(CompositePrimaryKey[0], fk.PrincipalKey.Properties[0]);
Assert.Same(CompositePrimaryKey[1], fk.PrincipalKey.Properties[1]);
Assert.False(fk.IsUnique);
Assert.False(fk.IsRequired);
}
public void Does_not_override_explicit_composite_foreign_key_created_using_given_properties()
{
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.NavPropIdProperty, ConfigurationSource.Convention);
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.NavPropNameProperty, ConfigurationSource.Convention);
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.PrincipalEntityWithCompositeKeyIdProperty, ConfigurationSource.Convention);
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.PrincipalEntityWithCompositeKeyNameProperty, ConfigurationSource.Convention);
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.IdProperty, ConfigurationSource.Convention);
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.NameProperty, ConfigurationSource.Convention);
var fkProperty1 = DependentTypeWithCompositeKey.Property("No!No!", typeof(int), ConfigurationSource.Convention);
var fkProperty2 = DependentTypeWithCompositeKey.Property("No!No!2", typeof(string), ConfigurationSource.Convention);
fkProperty2.IsRequired(true, ConfigurationSource.Convention);
var relationshipBuilder = DependentTypeWithCompositeKey.Relationship(
PrincipalTypeWithCompositeKey,
"NavProp",
null,
ConfigurationSource.Explicit)
.HasForeignKey(new[] { fkProperty1.Metadata, fkProperty2.Metadata }, ConfigurationSource.Explicit);
Assert.Same(relationshipBuilder, new ForeignKeyPropertyDiscoveryConvention().Apply(relationshipBuilder));
var fk = (IForeignKey)relationshipBuilder.Metadata;
Assert.Same(fk, DependentTypeWithCompositeKey.Metadata.GetForeignKeys().Single());
Assert.Same(fkProperty1.Metadata, fk.Properties[0]);
Assert.Same(fkProperty2.Metadata, fk.Properties[1]);
Assert.Same(CompositePrimaryKey[0], fk.PrincipalKey.Properties[0]);
Assert.Same(CompositePrimaryKey[1], fk.PrincipalKey.Properties[1]);
Assert.False(fk.IsUnique);
}
public void Matches_composite_dependent_PK_for_unique_FK()
{
var fkProperty1 = DependentTypeWithCompositeKey.Metadata.FindPrimaryKey().Properties[0];
var fkProperty2 = DependentTypeWithCompositeKey.Metadata.FindPrimaryKey().Properties[1];
var relationshipBuilder = DependentTypeWithCompositeKey.Relationship(
PrincipalTypeWithCompositeKey,
"NavProp",
"InverseReferenceNav", ConfigurationSource.Convention)
.IsUnique(true, ConfigurationSource.DataAnnotation)
.DependentEntityType(DependentTypeWithCompositeKey, ConfigurationSource.DataAnnotation);
var newRelationshipBuilder = new ForeignKeyPropertyDiscoveryConvention().Apply(relationshipBuilder);
Assert.NotSame(relationshipBuilder, newRelationshipBuilder);
var fk = (IForeignKey)DependentTypeWithCompositeKey.Metadata.GetForeignKeys().Single();
Assert.Same(fk, newRelationshipBuilder.Metadata);
Assert.Same(fkProperty1, fk.Properties[0]);
Assert.Same(fkProperty2, fk.Properties[1]);
Assert.Same(PrincipalTypeWithCompositeKey.Metadata.FindPrimaryKey(), fk.PrincipalKey);
Assert.True(fk.IsUnique);
Assert.True(fk.IsRequired);
}
public void Matches_PK_name_properties()
{
var fkProperty1 = DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.IdProperty, ConfigurationSource.Convention);
var fkProperty2 = DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.NameProperty, ConfigurationSource.Convention);
fkProperty2.IsRequired(true, ConfigurationSource.Convention);
var relationshipBuilder = DependentTypeWithCompositeKey.Relationship(
PrincipalTypeWithCompositeKey,
"NavProp",
null,
ConfigurationSource.Convention);
var newRelationshipBuilder = new ForeignKeyPropertyDiscoveryConvention().Apply(relationshipBuilder);
Assert.NotSame(relationshipBuilder, newRelationshipBuilder);
var fk = (IForeignKey)DependentTypeWithCompositeKey.Metadata.GetForeignKeys().Single();
Assert.Same(fk, newRelationshipBuilder.Metadata);
Assert.Same(fkProperty1.Metadata, fk.Properties[0]);
Assert.Same(fkProperty2.Metadata, fk.Properties[1]);
Assert.Same(CompositePrimaryKey[0], fk.PrincipalKey.Properties[0]);
Assert.Same(CompositePrimaryKey[1], fk.PrincipalKey.Properties[1]);
}
public void Does_not_match_properties_with_different_base_names()
{
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.NavPropIdProperty, ConfigurationSource.Convention);
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.PrincipalEntityWithCompositeKeyNameProperty, ConfigurationSource.Convention);
DependentTypeWithCompositeKey.Property(DependentEntityWithCompositeKey.IdProperty, ConfigurationSource.Convention);
var relationshipBuilder = DependentTypeWithCompositeKey.Relationship(
PrincipalTypeWithCompositeKey,
DependentTypeWithCompositeKey,
"NavProp",
null,
null,
null,
ConfigurationSource.Convention,
false);
Assert.Same(relationshipBuilder, new ForeignKeyPropertyDiscoveryConvention().Apply(relationshipBuilder));
var fk = (IForeignKey)relationshipBuilder.Metadata;
Assert.Same(fk, DependentTypeWithCompositeKey.Metadata.GetForeignKeys().Single());
Assert.Same(CompositePrimaryKey[0], fk.PrincipalKey.Properties[0]);
Assert.Same(CompositePrimaryKey[1], fk.PrincipalKey.Properties[1]);
Assert.False(fk.IsUnique);
Assert.False(fk.IsRequired);
}
