sqlproj file ordering
It appears that if a Programmable Object, such as a stored procedure is created.
And then a migration script is created shortly therafter with dependency on that programmable object...
When Deployment of the release artifact occurs on a DB that hasn't had recent updates applied, then the migration script will not execute the sproc because the sproc is being deployed at the same time and the programmable objects get deployed after everything else.
This is the case even if the .sqlproj SCA file has the scripts in the appropriate order.
How can we fix that?