/// <summary>
/// Install a schema into a database.
/// </summary>
/// <param name="connection">The connection to use.</param>
/// <param name="sql"the SQL to install.</param>
private static void Install(DbConnection connection, IEnumerable<string> sql)
{
SchemaInstaller installer = new SchemaInstaller(connection);
SchemaObjectCollection schema = new SchemaObjectCollection();
if (sql != null)
{
foreach (string s in sql)
{
// azure doesn't support xml index, so lets comment those out
if (s.Contains("XML INDEX") && connection.IsAzure())
continue;
schema.Add(s);
}
}
installer.Install("test", schema);
}