I am aware that I may set the column type for each property by adding a Data Annotation.
however, I want to write hundreds more columns.
in place of
Is there a way to configure EF6 so that this is the default setting?
I believe you can implement something like this after researching EF conventions:
modelBuilder.Properties<string>().Configure(c => c.HasColumnType("varchar"));
This is essentially a copycat of http://msdn.microsoft.com/en-us/data/jj819164#order, and it hasn't been put to the test.
As @Shimmy notes in the comments, in addition to
c => c.IsUnicode(false)
It seems to accomplish the same goal without a column type being hardcoded.