How to do longtext with code first approach

Question

I am trying to generate longtext type database column using an Entity Framework code-first approach. I already used Column(TypeName = "longtext") data annotation but I am getting error

Column, parameter, or variable #3: Cannot find data type LONGTEXT.

My code:

public class MyText
{
    [Key]
    public int Id { get; set; }

    [Column(TypeName = "longtext")]
    public string Txt { get; set; }
}

Any idea how I can generate a longtext column then?

Answer 1

here you go - pretty straight forward...

public class MyText
{
    [Key]
    public int Id { get; set; }

    //leaving this blank it will give you nvarchar(MAX)
    public string Txt { get; set; }
}