Example #1
0
        /// <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();
                }
            }
        }