Entity Framework Core 6 VARCHAR(MAX)

Kevin Marois

Using EF Core 6 Code First. I'm trying to create a Notes field.

entity.Property(e => e.Notes)
.HasColumnName("Notes")
.HasColumnType("varchar");

This becomes varchar(1) in the DB. How do I create a column with varchar(max)?

If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

Victor Nijegorodov

See [https://stackoverflow.com/questions/24224442/what-is-the-proper-usage-of-hascolumntype-and-database-generated\](https://stackoverflow.com/questions/24224442/what-is-the-proper-usage-of-hascolumntype-and-database-generated)

Kevin Marois

Your post did not answer the question

If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

jschell

When I look at the posted link it certainly looks to me like it provides an answer to the question asked. So perhaps you might want to explain how that does not answer your question.