Edit Question - KnowledgeHub

Title Body

How do I perform the EXEC task in a "loop" with MSBuild ItemGroups? Instead of repeating this command over and over, like so: <Exec ContinueOnError="false" Command="sqlcmd -S $(ServerName) $(SqlServerUser) -d $(DbName) -v TableName=%22account%22 -i data\add_sql_cache.sql -b" /> <Exec ContinueOnError="false" Command="sqlcmd -S $(ServerName) $(SqlServerUser) -d $(DbName) -v TableName=%22services%22 -i data\add_sql_cache.sql -b" /> <Exec ContinueOnError="false" Command="sqlcmd -S $(ServerName) $(SqlServerUser) -d $(DbName) -v TableName=%22servicesGroup%22 -i data\add_sql_cache.sql -b" /> <Exec ContinueOnError="false" Command="sqlcmd -S $(ServerName) $(SqlServerUser) -d $(DbName) -v TableName=%22servicesCategory%22 -i data\add_sql_cache.sql -b" /> I'd rather define an ItemGroup and just execute a "loop". I've got the ItemGroup down: <ItemGroup> <CachedTables Include="account" /> <CachedTables Include="services" /> <CachedTables Include="servicesGroup" /> <CachedTables Include="servicesCategory" /> But due to MSBuild's amazingly unintuitive syntax, I have no idea how to perform the Exec task in a loop with the ItemGroup above as an input.

Tags (comma-separated) Cancel