create text column with Entity Framework Code First

Question

How can I create a field that is TEXT instead of NVARCHAR? Right now I've got

public string Text { get; set; }

But that always becomes a nvarchar column, I need a Text column

There are a lot of different ways to do this. What is your current approach for configuration of column store types? Are you using ModelBuilder? EF Migrations? Attributes? — mwilson, Dec 02 '13 at 18:47
I'm just starting out with c# and .net. I know how to use EF migrations yea. Isn't there any kind of annotation that I can put on the attribute that makes it a TEXT column? — user3052560, Dec 02 '13 at 18:48
See here: http://stackoverflow.com/a/4913615/328123 Edit: or Moho's answer :) — mwilson, Dec 02 '13 at 18:54

score 43 · Accepted Answer · edited Jun 28 '14 at 14:31

43

[Column(TypeName = "text")]
public string Text { get; set; }

or via Fluent API:

modelBuilder.Entity<YourEntityTypeHere>()
    .Property( e => e.Text)
    .HasColumnType( "text" );

edited Jun 28 '14 at 14:31

Bakudan

answered Dec 02 '13 at 18:54

Moho

1

Which is better and why? – Fortune Jun 03 '18 at 13:46
@OchiFortune The first is to include annotations in your class definition, whereas the second is to specify those attributes in the migration file. – B. León Dec 29 '18 at 15:59

1 Answers1