Using NVarChar in asp.net core

Question

I'm creating a model for an existing database. How do I use nvarchar(max) as an attribute to my property? Do I use an extension to my attribute? Or is it entirely different.

The SQL Server database is using a datatype of nvarchar(max).

[MaxLength + ???]
public string Bucket { get; set; }

Answer 1

Try this:

Column(TypeName = "nvarchar(MAX)")]
public string Bucket { get; set; }

Answer 2

You can use the attribute as suggested by @JOSEFtw but it's also possible to do with the fluent API if that's how you're defining other properties.

modelBuilder.Entity<YourType>()
                    .Property(p => p.Bucket)
                    .HasColumnType("nvarchar(max)");