I know I can add a Data Annotation to each property to set it's column type to
VARCHAR but I have hundreds of columns I want to be
VARCHAR instead of
NVARCHAR is there some way to setup EF6 to make this the default?
Looking up EF conventions, I think you can do something like this:
modelBuilder.Properties<string>().Configure(c => c.HasColumnType("varchar"));
I largely ripped this off from http://msdn.microsoft.com/en-us/data/jj819164#order and haven't tested it.
[Edit:] As @Shimmy points out in the comments, there's also
c => c.IsUnicode(false) which appears to do the same thing without hardcoding a column type.