The problem I am trying to solve is adding Stored Procedures, Functions, Views to a Code First approach. I know this is done in DB projects (Database First approach) and at the end of the day both processes call the same underlying SQL creation command so why not in Code First also. I know currently you have to modify the file to add them to the Up() but I think we need a more robust way of doing this which i think would help adoption of code first over db first.

A few options I think would be cool is figuring out a way to do it in a class type, or in something similar to the IEntityTypeConfiguration and subsequent builder it uses, or even just naturally looking to a default location for files that contain a one item per file situation. So if you had a file called MyFirstProc.SQL and inside that file is the code itself without the whole CREATE or ALTER, or having it but just know if it changes from one migration to another then change it to a ALTER or DELETE depending on the action that occurs.