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