Table of Contents

Class SQLiteConnectionDataProvider

Namespace
combit.Reporting.DataProviders
Assembly
combit.ListLabel31.CrossPlatform.dll

Provider for SQLite connection, http://sqlite.phxsoftware.com/. Tested with version 1.0.92.0.

[Serializable]
public class SQLiteConnectionDataProvider : DbConnectionDataProvider, IDataProvider, ICanHandleUsedIdentifiers, IDisposable, ISupportsLogger, ISerializable
Inheritance
SQLiteConnectionDataProvider
Implements
Derived
Inherited Members

Remarks

This data provider supports connections to SQLite databases using the System.Data.SQLite provider. It retrieves database schema information (tables and views) and automatically builds table and relation definitions.

Constructors

SQLiteConnectionDataProvider(IDbConnection)

Initializes a new instance of the SQLiteConnectionDataProvider class with the specified connection.

public SQLiteConnectionDataProvider(IDbConnection connection)

Parameters

connection IDbConnection

An IDbConnection instance. The connection object must be of type System.Data.SQLite.SQLiteConnection.

Exceptions

ListLabelException

Thrown if the connection object is not of the expected type.

SQLiteConnectionDataProvider(SerializationInfo, StreamingContext)

Initializes a new instance of the SQLiteConnectionDataProvider class from serialized data.

protected SQLiteConnectionDataProvider(SerializationInfo info, StreamingContext context)

Parameters

info SerializationInfo

The SerializationInfo containing the serialized object data.

context StreamingContext

The StreamingContext that contains contextual information about the source or destination.

SQLiteConnectionDataProvider(string)

Initializes a new instance of the SQLiteConnectionDataProvider class using the specified connection string.

public SQLiteConnectionDataProvider(string connectionString)

Parameters

connectionString string

The connection string used to open the SQLite connection.

Properties

SupportedElementTypes

Gets or sets the supported DbConnectionElementTypes for the database connection.

public DbConnectionElementTypes SupportedElementTypes { get; set; }

Property Value

DbConnectionElementTypes

Remarks

This property indicates which element types (tables, views) are supported by this data provider.

SupportsAdvancedFiltering

Gets or sets a value indicating whether advanced filtering is supported by the data provider.

public override bool SupportsAdvancedFiltering { get; set; }

Property Value

bool

Methods

GetNativeAggregateFunctionName(NativeAggregateFunction)

Gets the native aggregate function name for the specified aggregate function instance.

protected override string GetNativeAggregateFunctionName(NativeAggregateFunction functionInstance)

Parameters

functionInstance NativeAggregateFunction

An instance of the native aggregate function.

Returns

string

The native aggregate function name as defined by SQLite.

Init()

Initializes the data provider by retrieving the schema information from the database.

protected override void Init()

Remarks

This method retrieves information about tables and views using the GetSchema method of the connection. It then creates commands for each table and analyzes the SQL definition to detect foreign key relationships.

OnTranslateFilterSyntax(object, TranslateFilterSyntaxEventArgs)

Translates filter syntax from the data provider into SQLite-specific filter syntax.

protected override void OnTranslateFilterSyntax(object sender, TranslateFilterSyntaxEventArgs e)

Parameters

sender object

The source of the filter translation request.

e TranslateFilterSyntaxEventArgs

A TranslateFilterSyntaxEventArgs that contains the event data.