Represents a connection to a SQLite database, implementing the IDatabase interface.

Namespace

Interfaces

IDatabase

Base Types

object

Syntax

public class Connection : IDatabase

Remarks

This class provides a generic representation of a database connection and includes methods defined in the IDatabase interface for executing queries and managing transactions.

Constructors

Name	Summary
Connection(string)	Initializes a new instance of the Connection class with SQLite database file details.

Properties

Name	Property Type	Summary
Provider	DatabaseProvider	Gets the database provider type, which is SQLite for this class.

Methods

Name	Return Value	Summary
ExecuteQuery(string, string)	DataSet	Executes a query against the SQLite database and returns the results as a DataSet.
GetConnectionString()	string	Gets the connection string for the SQLite database using provided file path.
TestConnection()	bool	Tests the connection to the SQLite database.