EF4 CodeFirst CTP5 nvarchar(max) via attribute

Question

Is there a way to create a custom attribute that will make EF CodeFirst use nvarchar(max) as datatype when assigned to a property of a poco class? I know this is possible via fluent api, but we would like to have all definitions within one place and thats the metadata class.

Fluent API:

modelBuilder.Entity<Event>().Property(p => p.TicketText).HasColumnType("nvarchar(max)");

score 7 · Accepted Answer · answered Feb 22 '11 at 20:25

public class NVarcharMaxAttribute : Attribute { }

public class NVarcharMaxAttributeConvention : AttributeConfigurationConvention<PropertyInfo, StringPropertyConfiguration, NVarcharMaxAttribute> {
    public override void Apply(PropertyInfo memberInfo, StringPropertyConfiguration configuration, NVarcharMaxAttribute attribute) {
        configuration.ColumnType = "nvarchar(max)";
    }
}

protected override void OnModelCreating(ModelBuilder modelBuilder) {
    modelBuilder.Conventions.Add<NVarcharMaxAttributeConvention>();
}

score 5 · Answer 2 · answered Mar 29 '11 at 21:32

5

[System.ComponentModel.DataAnnotations.MaxLength]

answered Mar 29 '11 at 21:32

Kyle

1,172
1
8
23

EF4 CodeFirst CTP5 nvarchar(max) via attribute

2 Answers2