Exemplos de EdFi.DataMartViews SqlUtil em C# (CSharp)

Exemplo n.º 1

Arquivo: ViewCreator.cs Projeto: gxclarke/Ed-Fi-Data-Mart-Views

 private DbContext GetContext()
 {
     return(SqlUtil.GetContext(_connectionString));
 }

Exemplo n.º 2

Arquivo: ViewCreator.cs Projeto: gxclarke/Ed-Fi-Data-Mart-Views

        private void CreateView(string schema, string viewName, string sql)
        {
            string statement = $"CREATE VIEW {ToQualified(schema, viewName)} WITH SCHEMABINDING AS\n{sql};";

            SqlUtil.ExecuteCommand(_connectionString, statement);
        }