C# Class AliaSQL.Core.Services.Impl.QueryExecutor

Inheritance: IQueryExecutor

Afficher le fichier Open project: ClearMeasure/AliaSQL

Méthodes publiques

Méthode	Description
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

Private Methods

Méthode	Description
SplitSqlStatements ( string sqlScript ) : IEnumerable

Method Details

CheckDatabaseExists() public méthode

public CheckDatabaseExists ( AliaSQL.Core.Model.ConnectionSettings settings ) : bool
settings	AliaSQL.Core.Model.ConnectionSettings
Résultat	bool

DatabaseVersion() public méthode

public DatabaseVersion ( AliaSQL.Core.Model.ConnectionSettings settings ) : int
settings	AliaSQL.Core.Model.ConnectionSettings
Résultat	int

ExecuteNonQuery() public méthode

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
Résultat	void

ExecuteNonQueryTransactional() public méthode

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
Résultat	void

ExecuteScalarInteger() public méthode

public ExecuteScalarInteger ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : int
settings	AliaSQL.Core.Model.ConnectionSettings
sql	string
Résultat	int

GetExecutedScripts() public méthode

public GetExecutedScripts ( AliaSQL.Core.Model.ConnectionSettings settings ) : List
settings	AliaSQL.Core.Model.ConnectionSettings
Résultat	List

GetExecutedTestDataScripts() public méthode

public GetExecutedTestDataScripts ( AliaSQL.Core.Model.ConnectionSettings settings ) : List
settings	AliaSQL.Core.Model.ConnectionSettings
Résultat	List

QueryExecutor() public méthode

public QueryExecutor ( ) : System
Résultat	System

QueryExecutor() public méthode

public QueryExecutor ( IConnectionStringGenerator connectionStringGenerator ) : System
connectionStringGenerator	IConnectionStringGenerator
Résultat	System

ReadFirstColumnAsStringArray() public méthode

public ReadFirstColumnAsStringArray ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : string[]
settings	AliaSQL.Core.Model.ConnectionSettings
sql	string
Résultat	string[]

ScriptSupportsTransactions() public méthode

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

public ScriptSupportsTransactions ( string sql ) : bool
sql	string
Résultat	bool