GeoMedia C# code snippet to get the warehouse connection's table list

It is useful to programmatically retrieve the list of tables in a GeoMedia warehouse via the connection object. The GeoMedia MetadataService can be called upon to generate the list in a String array. The following C# code snippet shows how this can be done.

The connection object is passed in to the GetTableList method and returns an ArrayList of table names.

using GeoMedia = Intergraph.GeoMedia.GeoMedia;

using PCSS = Intergraph.GeoMedia.PCSS;

using PBasic = Intergraph.GeoMedia.PBasic;

using GDO = Intergraph.GeoMedia.GDO;

using PClient = Intergraph.GeoMedia.PClient;

using PService = Intergraph.GeoMedia.PService;

using GMService = Intergraph.GeoMedia.GMService;

//...etc...

private ArrayList GetTableList(PClient.Connection conn)

{

String[] list = null;

ArrayList tables = new ArrayList();

object oConn = (object)conn;

int mask = 0;

object vTables = null;

GMService.MetadataService metadataSvc = null;

//Create an instance of the GeoMedia MetadataService

metadataSvc = new GMService.MetadataService();

//Pass in the connection object to the MetadataService

metadataSvc.set_Connection(ref oConn);

//Get the connection's list of tables and put them into the vTables array

metadataSvc.GetTables(ref mask, ref vTables);

//copy the table list into an ArrayList and return to the calling function

list = (String [])vTables;

for (int i = 0; i < list.Length; i++)

tables.Add(list[i].ToUpper());

return tables;

}