SqlGeometryDataAdapter Class

The data adapter that allows generating map items from a geometry datasource.

Namespace: DevExpress.Xpf.Map

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

Declaration

C#

public class SqlGeometryDataAdapter :
    SqlGeometryDataAdapterBase

VB.NET

Public Class SqlGeometryDataAdapter
    Inherits SqlGeometryDataAdapterBase

Remarks

For more information about this data adapter, refer to the Load Vector Data from a SQL Geometry Field of the Data Table topic.

Example

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.

Note

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.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-load-shapes-from-a-sql-geometry-datasource-t180275.

MainWindow.xaml.vb

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
            Get
                Return connectionString_Renamed
            End Get
        End Property

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

MainWindow.xaml

<Window
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:dxm="http://schemas.devexpress.com/winfx/2008/xaml/map"
        x:Class="SqlGeometryDataAdapterExample.MainWindow"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
        <dxm:MapControl>
            <dxm:VectorLayer>
                <dxm:VectorLayer.ShapeTitleOptions>
                    <dxm:ShapeTitleOptions Pattern="{}{TextCol}"
                                           Visible="True"/>
                </dxm:VectorLayer.ShapeTitleOptions>
                <dxm:SqlGeometryDataAdapter SqlText = "SELECT [id],[GeomCol1],[TextCol] FROM [dbo].[DemoTable]" 
                                            SpatialDataMember = "GeomCol1" ConnectionString="{Binding}"/>
            </dxm:VectorLayer>
        </dxm:MapControl>
    </Grid>
</Window>

MainWindow.xaml.cs

using System;
using System.IO;
using System.Windows;

namespace SqlGeometryDataAdapterExample {
    public partial class MainWindow : Window {
        const string dbPath = "..\\..\\..\\Data\\SQLG.mdf";

        string connectionString = "Data Source=(local);AttachDbFileName=" +
            Path.GetFullPath(Path.Combine(System.Reflection.Assembly.GetEntryAssembly().Location, dbPath)) +
            ";Database=SqlGeometryDemoDB;Integrated Security=True;MultipleActiveResultSets=True";
        public String ConnectionString { get { return connectionString; } }

        public MainWindow() {
            InitializeComponent();
            this.DataContext = ConnectionString;
        }
    }
}

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SqlGeometryDataAdapter class.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-load-shapes-from-a-sql-geometry-datasource-t180275/VB/SqlGeometryDataAdapterExample/MainWindow.xaml#L14

</dxm:VectorLayer.ShapeTitleOptions>
<dxm:SqlGeometryDataAdapter SqlText = "SELECT [id],[GeomCol1],[TextCol] FROM [dbo].[DemoTable]"
                            SpatialDataMember = "GeomCol1" ConnectionString="{Binding}"/>

Inheritance

Object

DispatcherObject

DependencyObject

Freezable

MapDependencyObject

MapDataAdapterBase

CoordinateSystemDataAdapterBase

SqlGeometryDataAdapterBase

SqlGeometryDataAdapter