CIMSqlQueryDataConnection Class
In This Topic
Represents a SQL query data connection.
Object Model
Syntax
Public Class CIMSqlQueryDataConnection Inherits CIMDataConnection Implements System.ComponentModel.INotifyPropertyChanged, System.Xml.Serialization.IXmlSerializable
public class CIMSqlQueryDataConnection : CIMDataConnection, System.ComponentModel.INotifyPropertyChanged, System.Xml.Serialization.IXmlSerializable
Example
Create a query layer
{
Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri(@"C:\Connections\mySDE.sde")));
CIMSqlQueryDataConnection sqldc = new CIMSqlQueryDataConnection()
{
WorkspaceConnectionString = geodatabase.GetConnectionString(),
GeometryType = esriGeometryType.esriGeometryPolygon,
OIDFields = "OBJECTID",
Srid = "102008",
SqlQuery = "select * from MySDE.dbo.STATES",
Dataset = "States"
};
var lcp = new LayerCreationParams(sqldc)
{
Name = "States"
};
//Note: Needs QueuedTask to run
FeatureLayer flyr = LayerFactory.Instance.CreateLayer<FeatureLayer>(lcp, map);
}
Inheritance Hierarchy
System.Object
ArcGIS.Core.CIM.CIMObject
ArcGIS.Core.CIM.CIMDataConnection
ArcGIS.Core.CIM.CIMSqlQueryDataConnection
Requirements
Target Platforms: Windows 11 Home, Pro, Enterprise (64 bit)
ArcGIS Pro version: 3.0 or higher.
See Also