ASP.NET MVC5 - How to enforce Entity Framework to ignore properties in model?

Question

I am using Entity Framework with a code-first approach. I wanted to have a property / attribute in my model but I don't want it to be a column in my database when I perform a migration?

An example model:

public class Class
{
    public int Id { get; set; }

    [Required]
    public int SkillId { get; set; }
    public Skill Skill { get; set; }

    public string SelectedSkills { get; set; }

    public int Repeat { get; set; }
}

In the above example, how can I have the SelectedSkills and Repeat properties without having them as columns in the database?

Can I achieve this using the private keyword?

Thank you

Mr Nobody · Accepted Answer · 2018-01-27 21:25:35Z

6

You can use NotMapped attribute to exclude a field from your model.

using System.ComponentModel.DataAnnotations.Schema;

[NotMapped]
public string SelectedSkills { get; set; }

edited Jan 27, 2018 at 21:25

Mr Nobody

3894 gold badges10 silver badges24 bronze badges

answered Jan 27, 2018 at 3:21

Raj

4,43513 gold badges62 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Haitham Shaddad · Accepted Answer · 2018-01-27 03:24:07Z

1

It seems that you are mixing the view model with the entity model which is wrong.

Your view model should be a separte class which has all the needed properties in the HTML View.

Your entity model should only have the data that need persistence.

So, you have to create another class. ex:

public class Class
{
    public int Id { get; set; }

    [Required]
    public int SkillId { get; set; }
    public Skill Skill { get; set; }
}

public class ClassModel
{
    public int Id { get; set; }

    [Required]
    public int SkillId { get; set; }

    public string SelectedSkills { get; set; }

    public int Repeat { get; set; }
}

If for any reason you must ignore a specific property then you can add annotation [Ignore] or in your data context's OnModelCreating method use the modelBuilder.Entity<Class>().Property(a=>a.Repeat).Ignore();

answered Jan 27, 2018 at 3:24

Haitham Shaddad

4,4662 gold badges16 silver badges23 bronze badges

1 Comment

Mr Nobody Over a year ago

Thank you very much

Collectives™ on Stack Overflow

ASP.NET MVC5 - How to enforce Entity Framework to ignore properties in model?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related