private SProcMap CreateStoredProcedureFiles(SqlSProcPublishSettings settings, EnvDTE.Project targetProject, string targetFolder, EnvDTE.ProjectItem targetProjectItem) { var g = new SProcScriptGenerator(_fs); var sprocFiles = targetProject.GetSProcFiles(_pss); var sprocMap = g.CreateStoredProcedureScripts(settings, sprocFiles); foreach (var name in sprocMap) { var template = sprocMap[name]; if (!string.IsNullOrEmpty(template)) { var sprocFile = Path.ChangeExtension(Path.Combine(targetFolder, name), ".sql"); _fs.WriteAllText(sprocFile, template); targetProjectItem.ProjectItems.AddFromFile(sprocFile); } } return(sprocMap); }