Microsoft.VisualStudio.R.Package.Sql.Publish.SProcScriptGenerator.CreateStoredProcedureScripts C# (CSharp) Method

CreateStoredProcedureScripts() public method

Creates code for stored procedures
public CreateStoredProcedureScripts ( SqlSProcPublishSettings settings, IEnumerable sprocFiles ) : SProcMap
settings SqlSProcPublishSettings
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;
        }

Usage Example

示例#1
0
        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);
        }
All Usage Examples Of Microsoft.VisualStudio.R.Package.Sql.Publish.SProcScriptGenerator::CreateStoredProcedureScripts