How to ignore a property when using Entity Framework Code First

Question

Entity Framework Code First will auto-create a table in the database base based on the Model.

Is there an attribute that will avoid this?

score 138 · Accepted Answer · edited Jan 08 '13 at 00:23

138

Add the [System.ComponentModel.DataAnnotations.Schema.NotMapped] attribute to the property.

edited Jan 08 '13 at 00:23

Kirk Woll

76,112
22
180
195

answered May 13 '12 at 14:17

SLaks

868,454
176
1,908
1,964

Does this has the benefit (over fluent declaration) that annotated properties will (or should) be ignored by other data mappers/serializers, such as JSON serializers? – David Kirkland Sep 16 '14 at 12:37

score 55 · Answer 2 · edited May 23 '17 at 12:26

55

Per the accepted answer and similar question/answer, in addition to [NotMapped] you can also specify it using the Fluent API:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
   modelBuilder.Entity<TheModelAffected>().Ignore(t => t.TheIgnoredProperty);
   base.OnModelCreating(modelBuilder);
}

edited May 23 '17 at 12:26

Community

1
1

answered Dec 31 '13 at 20:24

drzaus

24,171
16
142
201

score 17 · Answer 3 · edited Nov 25 '16 at 16:42

17

[NotMapped] is the short version if you like conciseness. And of course, you would add:

using System.ComponentModel.DataAnnotations.Schema;

to your class.

edited Nov 25 '16 at 16:42

SharpC

6,974
4
45
40

answered Mar 11 '15 at 17:56

cyclical

395
4
14

How to ignore a property when using Entity Framework Code First

3 Answers3

Linked

Related