/// <summary> /// Generate the CREATE SCHEMA statements. /// </summary> /// <param name="dt"></param> private static void GenerateSchemaScript(DataTable dt) { var path = Path.Combine( _params[Parameters.OtherWorkPath].ToString(), Constants.CreateSchemas); var view = new DataView(dt); var distinct = view.ToTable(true, "schema_name"); using (var sw = new StreamWriter(path, false, Encoding.Default)) { sw.WriteUseDb(); foreach (var row in distinct.Rows.Cast<DataRow>() .Where(row => !row[0].ToString().Equals(Constants.PgDefaultSchema))) { sw.WriteLine("CREATE SCHEMA [" + row[0] + "];"); sw.WriteLine("GO"); sw.WriteLine(); } } }