Class Database
Represent access to ORM features.
For executing query and materializing models see:
IDatabase
IQuery<T>
Inheritance
System.Object
Database
Assembly: Kros.KORM.dll
Syntax
public class Database : IDatabase, IDisposable
Constructors
Database(KormConnectionSettings)
Initializes a new instance of the Database class.
Declaration
public Database(KormConnectionSettings connectionString)
Parameters
Database(KormConnectionSettings, IQueryProviderFactory)
Initializes a new instance of the Database class.
Declaration
public Database(KormConnectionSettings connectionString, IQueryProviderFactory queryProviderFactory)
Parameters
Database(DbConnection)
Initializes a new instance of the Database class.
Declaration
public Database(DbConnection activeConnection)
Parameters
Type |
Name |
Description |
System.Data.Common.DbConnection |
activeConnection |
The active connection.
|
Initializes a new instance of the Database class.
Declaration
public Database(DbConnection activeConnection, IModelMapper modelMapper)
Parameters
Type |
Name |
Description |
System.Data.Common.DbConnection |
activeConnection |
The active connection.
|
IModelMapper |
modelMapper |
Model mapper, which will be used for mapping Object to Relation database.
|
Database(DbConnection, IQueryProviderFactory)
Initializes a new instance of the Database class.
Declaration
public Database(DbConnection activeConnection, IQueryProviderFactory queryProviderFactory)
Parameters
Type |
Name |
Description |
System.Data.Common.DbConnection |
activeConnection |
The active connection.
|
IQueryProviderFactory |
queryProviderFactory |
The query provider factory, which know create query provider.
|
Database(String)
Initializes a new instance of the Database class.
Declaration
public Database(string connectionString)
Parameters
Type |
Name |
Description |
System.String |
connectionString |
Connection string.
|
Properties
Builder
Declaration
public static IDatabaseBuilder Builder { get; }
Property Value
DatabaseMapper
Gets the database mapper, which has mapping information for all tables in database
Declaration
public static IDatabaseMapper DatabaseMapper { get; }
Property Value
DbProviderFactory
Declaration
public DbProviderFactory DbProviderFactory { get; }
Property Value
Type |
Description |
System.Data.Common.DbProviderFactory |
|
DefaultModelFactory
Gets or sets the default model factory, which will be used for instanting and filling object from Ado.
Declaration
public static IModelFactory DefaultModelFactory { get; set; }
Property Value
DefaultModelMapper
Gets or sets the default model mapper, which will be used for mapping Object to Relation database.
Declaration
public static IModelMapper DefaultModelMapper { get; set; }
Property Value
Log
Gets or sets the logging delegate.
Declaration
public static Action<string> Log { get; set; }
Property Value
Type |
Description |
System.Action<System.String> |
|
ModelBuilder
Gets the model builder for materializing data from ado to models.
Declaration
public IModelBuilder ModelBuilder { get; }
Property Value
Methods
BeginTransaction()
Declaration
public ITransaction BeginTransaction()
Returns
BeginTransaction(IsolationLevel)
Declaration
public ITransaction BeginTransaction(IsolationLevel isolationLevel)
Parameters
Type |
Name |
Description |
System.Data.IsolationLevel |
isolationLevel |
|
Returns
CreateBulkInsert()
Creates instance of Kros.Data.BulkActions.IBulkInsert.
Declaration
public IBulkInsert CreateBulkInsert()
Returns
Type |
Description |
Kros.Data.BulkActions.IBulkInsert |
Instance of Kros.Data.BulkActions.IBulkInsert.
|
CreateBulkUpdate()
Creates instance of Kros.Data.BulkActions.IBulkUpdate.
Declaration
public IBulkUpdate CreateBulkUpdate()
Returns
Type |
Description |
Kros.Data.BulkActions.IBulkUpdate |
Instance of Kros.Data.BulkActions.IBulkUpdate.
|
Dispose()
Declaration
Dispose(Boolean)
Declaration
protected virtual void Dispose(bool disposing)
Parameters
Type |
Name |
Description |
System.Boolean |
disposing |
|
ExecuteNonQuery(String)
Declaration
public int ExecuteNonQuery(string query)
Parameters
Type |
Name |
Description |
System.String |
query |
|
Returns
Type |
Description |
System.Int32 |
|
ExecuteNonQuery(String, CommandParameterCollection)
Declaration
public int ExecuteNonQuery(string query, CommandParameterCollection parameters)
Parameters
Returns
Type |
Description |
System.Int32 |
|
ExecuteNonQueryAsync(String, CommandParameterCollection, CancellationToken)
Declaration
public Task<int> ExecuteNonQueryAsync(string query, CommandParameterCollection parameters, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.String |
query |
|
CommandParameterCollection |
parameters |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Int32> |
|
ExecuteNonQueryAsync(String, CancellationToken)
Declaration
public Task<int> ExecuteNonQueryAsync(string query, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.String |
query |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Int32> |
|
ExecuteNonQueryAsync(String, CancellationToken, Object[])
Declaration
public Task<int> ExecuteNonQueryAsync(string query, CancellationToken cancellationToken = default(CancellationToken), params object[] parameters)
Parameters
Type |
Name |
Description |
System.String |
query |
|
System.Threading.CancellationToken |
cancellationToken |
|
System.Object[] |
parameters |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Int32> |
|
ExecuteScalar(String)
Executes the query, and returns the first column of the first row in the result set returned by the query.
Additional columns or rows are ignored.
Declaration
public string ExecuteScalar(string query)
Parameters
Type |
Name |
Description |
System.String |
query |
Arbitrary SQL query.
|
Returns
Type |
Description |
System.String |
The first column of the first row in the result set, or null if the result
set is empty. Returns a maximum of 2033 characters.
|
ExecuteScalar(String, Object[])
Executes the query, and returns the first column of the first row in the result set returned by the query.
Additional columns or rows are ignored.
Declaration
public string ExecuteScalar(string query, params object[] args)
Parameters
Type |
Name |
Description |
System.String |
query |
Arbitrary SQL query.
|
System.Object[] |
args |
The query parameters.
|
Returns
Type |
Description |
System.String |
The first column of the first row in the result set, or null if the result
set is empty. Returns a maximum of 2033 characters.
|
ExecuteScalar<TResult>(String)
Executes the query, and returns the first column of the first row in the result set returned by the query.
Additional columns or rows are ignored.
Declaration
public TResult? ExecuteScalar<TResult>(string query)
where TResult : struct
Parameters
Type |
Name |
Description |
System.String |
query |
Arbitrary SQL query.
|
Returns
Type |
Description |
System.Nullable<TResult> |
The first column of the first row in the result set, or null if the result
set is empty. Returns a maximum of 2033 characters.
|
Type Parameters
ExecuteScalar<TResult>(String, Object[])
Executes the query, and returns the first column of the first row in the result set returned by the query.
Additional columns or rows are ignored.
Declaration
public TResult? ExecuteScalar<TResult>(string query, params object[] args)
where TResult : struct
Parameters
Type |
Name |
Description |
System.String |
query |
Arbitrary SQL query.
|
System.Object[] |
args |
The query parameters.
|
Returns
Type |
Description |
System.Nullable<TResult> |
The first column of the first row in the result set, or null if the result
set is empty. Returns a maximum of 2033 characters.
|
Type Parameters
ExecuteStoredProcedure<TResult>(String)
Declaration
public TResult ExecuteStoredProcedure<TResult>(string storedProcedureName)
Parameters
Type |
Name |
Description |
System.String |
storedProcedureName |
|
Returns
Type Parameters
ExecuteStoredProcedure<TResult>(String, CommandParameterCollection)
Declaration
public TResult ExecuteStoredProcedure<TResult>(string storedProcedureName, CommandParameterCollection parameters)
Parameters
Returns
Type Parameters
InitDatabaseForIdGenerator()
Declaration
public void InitDatabaseForIdGenerator()
Query<T>()
Gets the query builder for T creating and executing query for obtains models.
Declaration
public IQuery<T> Query<T>()
Returns
Type Parameters
Name |
Description |
T |
Type of model, for which querying.
|
Implements
Extension Methods
See Also