SQLiteConnectionPath Constructor

In This Topic

Initializes a new instance of the SQLiteConnectionPath class.

Syntax

Visual Basic (Declaration)
C#

Public Function New( _
   ByVal path As Uri _
)

public SQLiteConnectionPath( 
   Uri path
)

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

{
  await 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 Home, Pro, Enterprise (64 bit)

ArcGIS Pro version: 3.0 or higher.

Reference

SQLiteConnectionPath Class
SQLiteConnectionPath Members

Send feedback