Add a Table from a Geodatabase

Question

Hello everyone, protected override void OnClick() { Geodatabase fileGeodatabase = new Geodatabase(new FileGeodatabaseConnectionPath(new Uri(@"\dep-gisdev idelandsdata lprod\Tidelands_Publication.gdb"))); Table table = fileGeodatabase.OpenDataset<Table>("Composite_Table"); }‍‍‍‍‍ I'm having trouble with C# code for ArcGIS Pro which will add a Table stored on a local Geodatabase in the Table of Contents for ArcGIS Pro. i was able to create some part of the code, but i'm getting an Exception Unhanded Error from Visual Studio stating : ArcGIS.Core.ConstructedOnWrongThreadException: 'This object must be created within the lambda passed to QueuedTask.Run, or on a compatible Sta thread'. I'm using a simple button to execute this code OnClick. Exception.PNG

RichRuh · Accepted Answer

Hi Manny, The short answer is that you need to call geodatabase routines from a special thread using the QueuedTask class. Your code will look like something like this: await QueuedTask.Run( () => { Geodatabase fileGeodatabase = new Geodatabase(new FileGeodatabaseConnectionPath(new Uri(@"\dep-gisdev idelandsdata lprod\Tidelands_Publication.gdb"))); Table table = fileGeodatabase.OpenDataset<Table>("Composite_Table"); }‍‍‍‍‍);‍‍‍‍‍ More details on the Pro threading model can be found in the topic Working with Multithreading in ArcGIS Pro. Some other comments: * Make you sure add memory management to your code, to properly release the Geodatabase and Table objects when you are finished using them. Details for how to do this can be found here. * Once you have opened your table using the code above, you still need to add a StandAloneTable to your Map. This can be accomplished as follows: IStandaloneTableFactory tableFactory = StandaloneTableFactory.Instance; tableFactory.CreateStandaloneTable(table, MapView.Active.Map);‍‍ Again, this needs to be wrapped inside a call to QueuedTask.Run(). I hope this helps, --Rich