Interface ISqlDatabase
Represents a generic SQL database. Usually SQLite backed.
Namespace: Snowflake.Persistence
Assembly: Snowflake.Framework.Primitives.dll
Syntax
public interface ISqlDatabaseProperties
DatabaseName
Gets the file or connection name.
Declaration
string DatabaseName { get; }Property Value
| Type | Description |
|---|---|
| System.String |
Methods
CreateTable(String, String[])
Creates a table with the given name and column rows
Declaration
void CreateTable(string tableName, params string[] columns)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | tableName | The name of the table. |
| System.String[] | columns | The column directives. |
Execute(Action<IDbConnection>)
Executes an atomic query function on the database.
Declaration
void Execute(Action<IDbConnection> queryFunction)Parameters
| Type | Name | Description |
|---|---|---|
| System.Action<System.Data.IDbConnection> | queryFunction | The query function on the database |
Execute(String, Object)
Executes a parameterized string query given an object representing paramaters.
Declaration
void Execute(string query, object param = null)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | query | The SQL string query |
| System.Object | param | The object containing the parameters |
GetConnection()
Gets a connection to the database
Declaration
IDbConnection GetConnection()Returns
| Type | Description |
|---|---|
| System.Data.IDbConnection |
Query<T>(Func<IDbConnection, T>)
Executes a typed query given a query function that returns the object.
Declaration
T Query<T>(Func<IDbConnection, T> queryFunction)Parameters
| Type | Name | Description |
|---|---|---|
| System.Func<System.Data.IDbConnection, T> | queryFunction | The query function that returns the object |
Returns
| Type | Description |
|---|---|
| T |
Type Parameters
| Name | Description |
|---|---|
| T | The return type of the object |
Query<T>(String, Object)
Executes a string query that returns an enumerable of matching objects.
Declaration
IEnumerable<T> Query<T>(string query, object param = null)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | query | The parameterized string query. |
| System.Object | param | The object containing the parameters |
Returns
| Type | Description |
|---|---|
| System.Collections.Generic.IEnumerable<T> | An enumerable or matching objects |
Type Parameters
| Name | Description |
|---|---|
| T | The return type of the objects |
QueryFirstOrDefault<T>(String, Object)
Returns the first object given the string query, or null if no matching objects found.
Declaration
T QueryFirstOrDefault<T>(string query, object param = null)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | query | The parameterized string query. |
| System.Object | param | The object containing the parameters |
Returns
| Type | Description |
|---|---|
| T | The first object given the string query, or null if no matching objects found. |
Type Parameters
| Name | Description |
|---|---|
| T | The return type of the objects |