C# (CSharp) Microsoft.VisualStudio.R.Package.Sql.Publish SProcScriptGenerator.CreateStoredProcedureScripts примеры использования

CreateStoredProcedureScripts() публичный Метод

Creates code for stored procedures

public CreateStoredProcedureScripts ( SqlSProcPublishSettings settings, IEnumerable sprocFiles ) : SProcMap
settings	SqlSProcPublishSettings
sprocFiles	IEnumerable
Результат	SProcMap

Пример #1

        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);
        }

Пример #2

Файл: SProcProjectFilesGenerator.cs Проект: Microsoft/RTVS

        private SProcMap CreateStoredProcedureFiles(SqlSProcPublishSettings settings, IEnumerable<string> sprocFiles, string targetFolder, EnvDTE.ProjectItem targetProjectItem) {
            var g = new SProcScriptGenerator(_fs);

            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;
        }

Пример #3

        private SProcMap CreateStoredProcedureFiles(SqlSProcPublishSettings settings, IEnumerable <string> sprocFiles, string targetFolder, EnvDTE.ProjectItem targetProjectItem)
        {
            var g = new SProcScriptGenerator(_fs);

            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);
        }

Пример #4

Файл: SProcPublisher.cs Проект: Microsoft/RTVS

 private void CreateDacPac(SqlSProcPublishSettings settings, IEnumerable<string> sprocFiles, string dacpacPath) {
     var project = _pss.GetSelectedProject<IVsHierarchy>()?.GetDTEProject();
     if (project != null) {
         var g = new SProcScriptGenerator(_fs);
         var sprocMap = g.CreateStoredProcedureScripts(settings, sprocFiles);
         var builder = _dacServices.GetBuilder();
         builder.Build(dacpacPath, project.Name, sprocMap.Scripts);
     }
 }