Hi,
I am trying to execute a query on sql database.I am using ArcgisPro ,Net SDK. I followed the example on the documentation. However I got the method is not implemented exception.
Is this method really not implemented? or did I miss something.
Thanks much for help.
Here is my code:
using Geodatabase geodatabase = new Geodatabase(connectionProperties);
// Use the geodatabase
QueryDef getMapListQueryDef = new QueryDef
{
SubFields = "FMB4_LatestWellStatusPackageProduct.Name,T_Well.Latitude, T_Well.Longitude, T_WELL.EPSG_NO",
Tables = "FMB4_LatestWellStatusPackageProduct,T_Well ,FMB_Product ",
WhereClause = "FMB4_LatestWellStatusPackageProduct.Well_ID=T_Well.ID AND FMB4_LatestWellStatusPackageProduct.ProductID=FMB_Product.ID AND[FMB4_LatestWellStatusPackageProduct.R_WELL_STATUS_ID <> 210 AND FMB_Product.Name ='" + fmbProduct+"'",
};
using (RowCursor rowCursor = geodatabase.Evaluate(getMapListQueryDef, false))
{
while (rowCursor.MoveNext())
{
using (Row row = rowCursor.Current)
{
string wellname = Convert.ToString(row["Name"]);
codeList.Add(wellname);
}
}
}