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