Exemple #1
0
        private DataTable Mapper(IDataReader reader)
        {
            DataTable metaData = _context.CreateDatabasesDataTable();

            while (reader.Read())
            {
                DataRow row = metaData.NewRow();

                //table.Columns.Add("CATALOG_NAME", Type.GetType("System.String"));
                //table.Columns.Add("DESCRIPTION", Type.GetType("System.String"));
                //table.Columns.Add("SCHEMA_NAME", Type.GetType("System.String"));
                //table.Columns.Add("SCHEMA_OWNER", Type.GetType("System.String"));
                //table.Columns.Add("DEFAULT_CHARACTER_SET_CATALOG", Type.GetType("System.String"));
                //table.Columns.Add("DEFAULT_CHARACTER_SET_SCHEMA", Type.GetType("System.String"));
                //table.Columns.Add("DEFAULT_CHARACTER_SET_NAME", Type.GetType("System.String"));

                row["CATALOG_NAME"] = reader.GetString(0).Trim();

                metaData.Rows.Add(row);
            }

            metaData.AcceptChanges();

            return(metaData);
        }