public void CreateView(DatabaseObjectName tableName, DatabaseObjectName viewName) { if (tableName == null) throw new ArgumentNullException(nameof(tableName)); if (viewName == null) throw new ArgumentNullException(nameof(viewName)); var definition = new TableBackedViewDefinition(viewName, tableName); using (var connection = new SqlConnection(connectionString)) { connection.Execute(new TableBackedViewCreateSqlGenerator().Sql(definition)); } }
public string Sql(TableBackedViewDefinition definition) { if (definition == null) throw new ArgumentNullException("definition"); return string.Format(CreateViewFormat, definition.Name.Qualified, definition.BackingTable.Qualified); }