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

        public string CreateRCodeTableScript(SqlSProcPublishSettings settings) => Invariant(
$@"CREATE TABLE {settings.TableName.ToSqlName(settings.QuoteType)}
(
{SProcColumnName} NVARCHAR(64),
{RCodeColumnName} NVARCHAR(max)
)");

        /// <summary>
        /// Create SQL file that defines table template that will hold R code
        /// </summary>
        internal void CreateRCodeTableFile(SqlSProcPublishSettings settings, EnvDTE.Project targetProject, string targetFolder, EnvDTE.ProjectItem targetProjectItem) {
            var creatTableScriptFile = Path.Combine(targetFolder, CreateRCodeTableScriptName);

            var g = new SProcScriptGenerator(_fs);
            var script = g.CreateRCodeTableScript(settings);

            _fs.WriteAllText(creatTableScriptFile, script);
            targetProjectItem.ProjectItems.AddFromFile(creatTableScriptFile);
        }