public CreateStoredProcedureScripts ( |
||
settings | ||
sprocFiles | IEnumerable |
|
return | SProcMap |
public SProcMap CreateStoredProcedureScripts(SqlSProcPublishSettings settings, IEnumerable<string> sprocFiles) {
var sprocMap = new SProcMap();
foreach (var rFilePath in sprocFiles) {
var sprocName = _fs.GetSProcNameFromTemplate(rFilePath);
if (!string.IsNullOrEmpty(sprocName)) {
string template;
if (settings.CodePlacement == RCodePlacement.Inline) {
template = FillSprocInlineTemplate(rFilePath, sprocName);
} else {
template = FillSprocTableTemplate(rFilePath, sprocName, settings.TableName, settings.QuoteType);
}
if (!string.IsNullOrEmpty(template)) {
sprocMap[sprocName] = template;
}
}
}
return sprocMap;
}
private void CreateDacPac(SqlSProcPublishSettings settings, IEnumerable <string> sprocFiles, string dacpacPath) { var project = _pss.GetSelectedProject <IVsHierarchy>()?.GetDTEProject(); var g = new SProcScriptGenerator(_fs); var sprocMap = g.CreateStoredProcedureScripts(settings, sprocFiles); var builder = _dacServices.GetBuilder(_appShell); builder.Build(dacpacPath, project.Name, sprocMap.Scripts); }