Entity Framework Code First - ignore the base class

Question

I have a model as follows:

public class User : System.Web.Security.MembershipUser
{
public int UserId { get; set; }
    public string SomeProperty { get; set; }
}

When my database is generated, I want the Entity Framework to ignore MemberhipUser and only generate a table named User with two properties from the User class. I tried the following to no avail.

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Ignore<System.Web.Security.MembershipUser>();
}

Answer 1

NotMappedAttribute attribute is your friend:

[MetadataType(typeof(UserMd)]
public class User : System.Web.Security.MembershipUser
{
    ////read description bellow code
    //static User()
    //{
    //  var type = typeof(User);
    //  TypeDescriptor.AddProviderTransparent(
    //    new AssociatedMetadataTypeTypeDescriptionProvider(type), type);
    //}        

    public int UserId { get; set; }
    public string SomeProperty { get; set; }

    internal class UserMd
    {
        [NotMapped]
        public string UserName { get; set; }
    }
}

I'm not sure that the code first processes the metadata automatically by itself, try the above, and if it doesn't work, attach the metadata manually (i.e. uncomment the commented lines).

Update I like the solution above, but if it is too much for you, use StructuralTypeConfiguration<TStructuralType>.Ignore<TProperty> Method:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    var config = modelBuilder.Entity<User>();
    config.Ignore(u => u.UserName);
}

Answer 2

. - , Ignore .

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<User>().Ignore(u => u.ProviderUserKey);
    modelBuilder.Entity<User>().Ignore(u => u.LastActivityDate);
    // and so on for all base class properties
}

- MembershipUser User. User MembershipUser.

public class User
{
    public int UserId { get; set; }
    public string SomeProperty { get; set; }

    public MembershipUser MembershipUser
    {
        get
        {
            // create an instance using the available properties and return
        }
    }
}

:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<User>().Ignore(u => u.MembershipUser);
    modelBuilder.Ignore<System.Web.Security.MembershipUser>();

}