We are rewriting some existing ArcObject code for ArcGIS Pro. We have now some code which uses a IQueryDef to run some select statement against a IWorkspace object.
The code looks something link this:
var queryDef = workspace.CreateQueryDef();
queryDef.Tables = "mytable";
queryDef.SubFields = "name, value1, value2";
queryDef.WhereClause = "refId in (1,2,3)";
queryDef.PostfixClause = " order by value1";
var cursor = queryDef.Evaluate();
I was now wondering, how we can achive the same with the ArcGIS Pro SDK.
We do not have support for QueryDefs yet. But the above can be achieved using the QueryFilter and Search on the corresponding table (as long as Joins or Aggregates are not involved).
Please see ProConcepts Geodatabase · Esri/arcgis-pro-sdk Wiki · GitHub for an example.
We have it in our backlog as one of the high(er) priority items and looking to include it in a future release.
This might not be too helpful, but there it is.