Currently I am creating QueryLayer using ArcGIS.Core.Data functionality where I retrieve data from an Oracle database, utilizing the Database, and DatabaseConnectionProperties class etc.
It works! However, it is relatively slow, and I think it has something to do with the way the SDK connects and reads the database in question.
For simple retrieving of unique values from a database table I am not using Esri classes any more, but went with Oracle.ManagedDataAccess. It is a drastic change in response time doing so, and my "customers" love it.
Hence, I would like to use Oracle.ManagedDataAccess to query the database, retrieve the data and use them to create a FeatureClass, and FeatureLayer.
Retrieving the data is not the problem, but creating the FeatureClass is.
Currently I am creating the FeatureClass through the OpenTable method of the ArcGIS.Core.Data Database class. That means I am back to square one, because I have to establish the connection through the AGP SDK.
Is there a way to use Oracle.ManagedDataAccess to create QueryLayer?
Solved! Go to Solution.
Thomas-
There's no way to directly create a FeatureClass/FeatureLayer from a data structure returned from an Oracle API.
Some ideas:
I hope this helps.
--Rich
Thomas-
There's no way to directly create a FeatureClass/FeatureLayer from a data structure returned from an Oracle API.
Some ideas:
I hope this helps.
--Rich
Thanks Rich,
I will try the plugin datasource way.