Class FirebirdSQLDataProvider

Namespace

combit.Reporting.DataProviders

Assembly

combit.ListLabel31.CrossPlatform.FirebirdConnectionDataProvider.dll

Provider for FirebirdSQL, see https://www.firebirdsql.org/en/net-provider/

[Serializable]
public sealed class FirebirdSQLDataProvider : DbConnectionDataProvider, IDataProvider, ICanHandleUsedIdentifiers, IDisposable, ISupportsLogger, ISerializable

Inheritance

object

DbConnectionDataProvider

FirebirdSQLDataProvider

Implements

IDataProvider

ICanHandleUsedIdentifiers

IDisposable

ISupportsLogger

ISerializable

Inherited Members

DbConnectionDataProvider.Dispose()

DbConnectionDataProvider.Support1to1Sortings

DbConnectionDataProvider.SetLogger(ILlLogger, bool)

DbConnectionDataProvider.DefineTable

DbConnectionDataProvider.TranslateFilterSyntax

DbConnectionDataProvider.ExecuteDbCommand

DbConnectionDataProvider.AddDbCommand

DbConnectionDataProvider.InitializationCompleted

DbConnectionDataProvider.SupportGetParentRow

DbConnectionDataProvider.SupportSorting

DbConnectionDataProvider.MinimalSelect

DbConnectionDataProvider.CancelBeforeClose

DbConnectionDataProvider.SupportsAnyBaseTable

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

The FirebirdSQLDataProvider class extends DbConnectionDataProvider to provide connectivity to FirebirdSQL databases using the .NET provider. It retrieves schema information from the database and builds commands for retrieving data. It also supports custom filter syntax translation and native aggregate function mapping.

Constructors

FirebirdSQLDataProvider(IDbConnection)

Initializes a new instance of the FirebirdSQLDataProvider class using the specified database connection.

public FirebirdSQLDataProvider(IDbConnection connection)

Parameters

connection IDbConnection

An IDbConnection instance representing a FirebirdSQL connection.

Properties

SupportedElementTypes

Gets or sets the supported element types (e.g. tables) for the database connection.

public DbConnectionElementTypes SupportedElementTypes { get; set; }

Property Value

DbConnectionElementTypes

SupportsAdvancedFiltering

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

public override bool SupportsAdvancedFiltering { get; set; }

Property Value

bool

Methods

GetNativeAggregateFunctionName(NativeAggregateFunction)

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

protected override string GetNativeAggregateFunctionName(NativeAggregateFunction function)

Parameters

function NativeAggregateFunction

The aggregate function to be mapped.

Returns

string

The native aggregate function name as used by FirebirdSQL, or null for unsupported functions.

Init()

Initializes the data provider by retrieving table and relation schema information from the FirebirdSQL database.

protected override void Init()

Remarks

This method retrieves a list of tables from the system catalog and then builds commands to select all data from each table. It then retrieves relation information from the schema and adds relations accordingly. Custom filter syntax translation and native aggregate function mapping are also provided.

OnTranslateFilterSyntax(object, TranslateFilterSyntaxEventArgs)

Translates filter syntax from List & Label expressions to FirebirdSQL-specific syntax.

protected override void OnTranslateFilterSyntax(object sender, TranslateFilterSyntaxEventArgs e)

Parameters

sender object

The source of the filter translation request.

e TranslateFilterSyntaxEventArgs

A TranslateFilterSyntaxEventArgs object that contains the event data.