SQLiteConnectionPath Constructor

In This Topic

Initializes a new instance of the SQLiteConnectionPath class.

Syntax

C#
Visual Basic (Declaration)

public SQLiteConnectionPath( 
   Uri path
)

Public Function New( _
   ByVal path As Uri _
)

Parameters

path: A valid path to a SQLite database that ends with either a '.sqlite' or '.gpkg' extension.

Exceptions

Exception	Description
System.ArgumentNullException	path is null.
System.ArgumentException	The path in path does not end with either a '.sqlite' or '.gpkg' extension.

Example

Create QueryDescription from a query for an SQLite Database table

public async Task SqliteQueryDescription()
{
    await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() =>
    {
        using (Database database = new Database(new SQLiteConnectionPath(new Uri("Path\\To\\Sqlite\\Database\\USA.sqlite"))))
        {
            QueryDescription washingtonCitiesQueryDescription = database.GetQueryDescription("select OBJECTID, Shape, CITY_FIPS, CITY_NAME, STATE_FIPS, STATE_CITY, TYPE, CAPITAL from main.cities where STATE_NAME='Washington'", "WashingtonCities");

            using (Table washingtonTable = database.OpenTable(washingtonCitiesQueryDescription))
            {
                // Use washingtonTable.
            }
        }
    });
}

Requirements

Target Platforms: Windows 11, Windows 10

ArcGIS Pro version: 3 or higher.

Reference

SQLiteConnectionPath Class
SQLiteConnectionPath Members

Send feedback