A newer version of this page is available. Switch to the current version.

SqlGeometryDataAdapter.ConnectionString Property

Gets or sets the connection string to a SQL database.

Namespace: DevExpress.Xpf.Map

Assembly: DevExpress.Xpf.Map.v18.2.dll


public string ConnectionString { get; set; }

Property Value

Type Description

A String value.


To load shapes from a SQL Geometry datasource, do the following.

  1. Create a SqlGeometryDataAdapter object and assign it to the VectorLayer.Data property.
  2. Specify the SqlGeometryDataAdapter.ConnectionString, SqlGeometryDataAdapter.SpatialDataMember and SqlGeometryDataAdapter.SqlText properties.

All table fields of the SQL data table loaded from the database will be provided as attributes values for each SqlGeometryItem object generated by the SqlGeometryDataAdapter.

Imports System
Imports System.IO
Imports System.Windows

Namespace SqlGeometryDataAdapterExample
    Partial Public Class MainWindow
        Inherits Window

        Private Const dbPath As String = "..\..\..\Data\SQLG.mdf"

        Private connectionString_Renamed As String = "Data Source=(local);AttachDbFileName=" & Path.GetFullPath(Path.Combine(System.Reflection.Assembly.GetEntryAssembly().Location, dbPath)) & ";Database=SqlGeometryDemoDB;Integrated Security=True;MultipleActiveResultSets=True"
        Public ReadOnly Property ConnectionString() As String
                Return connectionString_Renamed
            End Get
        End Property

        Public Sub New()
            Me.DataContext = ConnectionString
        End Sub
    End Class
End Namespace
See Also