CIMSqlQueryDataConnection Class

In This Topic

Represents a SQL query data connection.

Object Model

Syntax

C#
Visual Basic (Declaration)

public class CIMSqlQueryDataConnection : CIMDataConnection, System.ComponentModel.INotifyPropertyChanged, System.Xml.Serialization.IXmlSerializable

Public Class CIMSqlQueryDataConnection 
   Inherits CIMDataConnection
   Implements System.ComponentModel.INotifyPropertyChanged, System.Xml.Serialization.IXmlSerializable

Example

Create a query layer

await QueuedTask.Run(() =>
{
  Map map = MapView.Active.Map;
  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"
  };
  FeatureLayer flyr = LayerFactory.Instance.CreateLayer<FeatureLayer>(lcp, map);
});

Create a query layer

await QueuedTask.Run(() =>
{
  Map map = MapView.Active.Map;
  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"
  };
  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, Windows 10, Windows 8.1

Reference

CIMSqlQueryDataConnection Members
ArcGIS.Core.CIM Namespace

Send feedback