Entity Framework Custom Annotation
<p>Well, i tried to implement custom annotation for EF 6 just as explained in <a href="https://milinaudara.wordpress.com/2015/02/04/case-sensitive-search-using-entity-framework-with-custom-annotation/" rel="nofollow noreferrer">a tutorial by Milinaudara</a> as it is the first google hit i found. The tutorial is pretty much easy to follow. But, it looked like i will need to add <code>[CaseSensitive]</code> annotation on a column after i ran the first migration - <a href="https://github.com/aspnet/EntityFramework6/blob/15de49003c43365307408b408dc57252847f9803/src/EntityFramework.SqlServer/SqlServerMigrationSqlGenerator.cs#L373" rel="nofollow noreferrer">creating table</a> - and the <code>[CaseSensitive]</code> will be actually executed at a second migration as <a href="https://github.com/aspnet/EntityFramework6/blob/15de49003c43365307408b408dc57252847f9803/src/EntityFramework.SqlServer/SqlServerMigrationSqlGenerator.cs#L477" rel="nofollow noreferrer"><strong>alter table</strong></a> operation. Am I wrong? Because it's what i've experienced so far..</p>

<p>Is it possible for that annotation to be run at table creation? Should i override EF's <code>Generate(CreateTableOperation createTableOperation)</code> method to ensure the <code>[CaseSensitive]</code> annotation actually get applied?</p>