All pastes #22988 Raw Edit

Something

public text v1 · immutable
#22988 ·published 2005-09-15 14:30 UTC
rendered paste body
        public static void GenXmlSchemas()
        {
            NpgsqlConnection Connection = new NpgsqlConnection(GenConnectionString());
            NpgsqlDataAdapter gAdapter = new Npgsql.NpgsqlDataAdapter(
                "SELECT * FROM \"groups\"",
                Connection);
            NpgsqlDataAdapter uAdapter = new Npgsql.NpgsqlDataAdapter(
                "SELECT * FROM \"users\"",
                Connection);
            NpgsqlDataAdapter tAdapter = new Npgsql.NpgsqlDataAdapter(
                "SELECT * FROM \"terms\"",
                Connection);
            //Npgsql.NpgsqlCommandBuilder b = new Npgsql.NpgsqlCommandBuilder(adapter);
            DataSet ds = new DataSet();
            gAdapter.Fill(ds);
            uAdapter.Fill(ds);
            tAdapter.Fill(ds);
            ds.WriteXmlSchema("/tmp/tukia.xsd");
        }