Class SqliteDatabase

Inheritance
System.Object
SqliteDatabase
Implements
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Snowflake.Persistence
Assembly: Snowflake.Framework.dll
Syntax
public class SqliteDatabase : ISqlDatabase

Constructors

SqliteDatabase(String)

Declaration
public SqliteDatabase(string fileName)
Parameters
Type Name Description
System.String fileName

Properties

DatabaseName

Declaration
public string DatabaseName { get; }
Property Value
Type Description
System.String

Methods

CreateTable(String, String[])

Creates a table in the database

Declaration
public void CreateTable(string tableName, params string[] columns)
Parameters
Type Name Description
System.String tableName

The name of the table to create
System.String[] columns

The names of the columns to create

Execute(Action<IDbConnection>)

Executes on a new connection to the database. The connection will be safely closed after the operation.

Declaration
public void Execute(Action<IDbConnection> queryFunction)
Parameters
Type Name Description
System.Action<System.Data.IDbConnection> queryFunction

A function to query the database using the opened connection

Execute(String, Object)

Executes on a new connection to the database. The connection will be safely closed after the operation.

Declaration
public void Execute(string query, object param = null)
Parameters
Type Name Description
System.String query

The SQL query to execute
System.Object param

The query parameters

GetConnection()

Declaration
public IDbConnection GetConnection()
Returns
Type Description
System.Data.IDbConnection

Query<T>(Func<IDbConnection, T>)

Queries on a new connection to the database. The connection will be safely closed after the operation.

Declaration
public T Query<T>(Func<IDbConnection, T> queryFunction)
Parameters
Type Name Description
System.Func<System.Data.IDbConnection, T> queryFunction

A function to query the database using the opened connection
Returns
Type Description
T

The requested data.
Type Parameters
Name Description
T

The type the query will return

Query<T>(String, Object)

Queries on a new connection to the database. The connection will be safely closed after the operation.

Declaration
public IEnumerable<T> Query<T>(string query, object param = null)
Parameters
Type Name Description
System.String query

The SQL query to execute
System.Object param

The query parameters
Returns
Type Description
System.Collections.Generic.IEnumerable<T>

The requested data.
Type Parameters
Name Description
T

The type the query will return

QueryFirstOrDefault<T>(String, Object)

Executes a single row query The connection will be safely closed after the operation.

Declaration
public T QueryFirstOrDefault<T>(string query, object param = null)
Parameters
Type Name Description
System.String query

The SQL query to execute
System.Object param

The query parameters
Returns
Type Description
T

The requested data, or null if not present.
Type Parameters
Name Description
T

The type the query will return

Implements