I'm using an ItemGroup to select several Sql-Scripts. Then I want to execute them. Execution works fine, but the problem is, that I have to execute them in a specified order ('cause of dependencies). For this case we made a naming-convention - so all I need is a possibility to sort the selected files in the ItemGroup by name - is this possible?
Here's my ItemGroup:
<ItemGroup>
<SqlFiles Include="$(MSBuildProjectDirectory)\Core\Redirector\RedirectorDB\**\*.sql;$(MSBuildProjectDirectory)\Core\RangeManager\RMDb\**\*.sql;$(MSBuildProjectDirectory)\Core\UserManager\UMRedirectorDB\**\*.sql;$(MSBuildProjectDirectory)\Core\AdminWeb\AWRedirectorDb\**\*.sql">
<DbName>redirector</DbName>
</SqlFiles>
<SqlFiles Include="$(MSBuildProjectDirectory)\Core\UserManager\UmDb\**\*.sql">
<DbName>usermanager</DbName>
</SqlFiles>
<SqlFiles Include="$(MSBuildProjectDirectory)\Core\ProviderManager\PmDb\**\*.sql">
<DbName>providermanager</DbName>
</SqlFiles>
<SqlFiles Include="$(MSBuildProjectDirectory)\Core\AdminWeb\AWMobileDistributor\**\*.sql">
<DbName>mobiledistributor</DbName>
</SqlFiles>
</ItemGroup>