C# Класс AliaSQL.Core.Services.Impl.QueryExecutor

Наследование: IQueryExecutor
Показать файл Открыть проект

Открытые методы

Метод Описание
CheckDatabaseExists ( AliaSQL.Core.Model.ConnectionSettings settings ) : bool
DatabaseVersion ( AliaSQL.Core.Model.ConnectionSettings settings ) : int
ExecuteNonQuery ( AliaSQL.Core.Model.ConnectionSettings settings, string sql, bool includeDatabaseName = false ) : void

Runs queries that are not specific to a database such as Drop, Create, single user mode
ExecuteNonQueryTransactional ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : void

Runs larger queries that may be multiline separated with GO Runs entire sql block in a single transaction that will rollback if any part of the query errors
ExecuteScalarInteger ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : int
GetExecutedScripts ( AliaSQL.Core.Model.ConnectionSettings settings ) : List
GetExecutedTestDataScripts ( AliaSQL.Core.Model.ConnectionSettings settings ) : List
QueryExecutor ( ) : System
QueryExecutor ( IConnectionStringGenerator connectionStringGenerator ) : System
ReadFirstColumnAsStringArray ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : string[]
ScriptSupportsTransactions ( string sql ) : bool

Some commands are not allowed inside transactions http://msdn.microsoft.com/en-us/library/ms191544.aspx

Приватные методы

Метод Описание
SplitSqlStatements ( string sqlScript ) : IEnumerable

Описание методов

CheckDatabaseExists() публичный Метод

public CheckDatabaseExists ( AliaSQL.Core.Model.ConnectionSettings settings ) : bool
settings AliaSQL.Core.Model.ConnectionSettings
Результат bool

DatabaseVersion() публичный Метод

public DatabaseVersion ( AliaSQL.Core.Model.ConnectionSettings settings ) : int
settings AliaSQL.Core.Model.ConnectionSettings
Результат int

ExecuteNonQuery() публичный Метод

Runs queries that are not specific to a database such as Drop, Create, single user mode
public ExecuteNonQuery ( AliaSQL.Core.Model.ConnectionSettings settings, string sql, bool includeDatabaseName = false ) : void
settings AliaSQL.Core.Model.ConnectionSettings
sql string
includeDatabaseName bool
Результат void

ExecuteNonQueryTransactional() публичный Метод

Runs larger queries that may be multiline separated with GO Runs entire sql block in a single transaction that will rollback if any part of the query errors
public ExecuteNonQueryTransactional ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : void
settings AliaSQL.Core.Model.ConnectionSettings
sql string
Результат void

ExecuteScalarInteger() публичный Метод

public ExecuteScalarInteger ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : int
settings AliaSQL.Core.Model.ConnectionSettings
sql string
Результат int

GetExecutedScripts() публичный Метод

public GetExecutedScripts ( AliaSQL.Core.Model.ConnectionSettings settings ) : List
settings AliaSQL.Core.Model.ConnectionSettings
Результат List

GetExecutedTestDataScripts() публичный Метод

public GetExecutedTestDataScripts ( AliaSQL.Core.Model.ConnectionSettings settings ) : List
settings AliaSQL.Core.Model.ConnectionSettings
Результат List

QueryExecutor() публичный Метод

public QueryExecutor ( ) : System
Результат System

QueryExecutor() публичный Метод

public QueryExecutor ( IConnectionStringGenerator connectionStringGenerator ) : System
connectionStringGenerator IConnectionStringGenerator
Результат System

ReadFirstColumnAsStringArray() публичный Метод

public ReadFirstColumnAsStringArray ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : string[]
settings AliaSQL.Core.Model.ConnectionSettings
sql string
Результат string[]

ScriptSupportsTransactions() публичный Метод

Some commands are not allowed inside transactions http://msdn.microsoft.com/en-us/library/ms191544.aspx
public ScriptSupportsTransactions ( string sql ) : bool
sql string
Результат bool