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