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 131 · Accepted Answer · edited Jan 08 '13 at 00:23

131

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

edited Jan 08 '13 at 00:23

Kirk Woll

73,473
21
178
189

answered May 13 '12 at 14:17

SLaks

837,282
173
1,862
1,933

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 53 · Answer 2 · edited May 23 '17 at 12:26

53

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

23,063
16
132
194

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

16

[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,220
4
42
39

answered Mar 11 '15 at 17:56

cyclical

385
5
14

How to ignore a property when using Entity Framework Code First

3 Answers3

Linked