C# 클래스 ALFA.MySQLDatabase

This class encapsulates database access for ALFA CLR scripts that uses an independent MySQL connection. N.B. Most code should NOT use a MySQLDatabase object, because doing so may monopolize a valuable connection pool connection. Use ALFA.ALFADatabase instead for most SQL accesses UNLESS they must be done from a dedicated thread context, like the ACR_ServerCommunicator GameWorldManager query thread.
상속: IALFADatabase, IDisposable
파일 보기 프로젝트 열기: ALandFarAway/ALFA-Base-Resources 1 사용 예제들

공개 메소드들

메소드 설명
ACR_IncrementStatistic ( string Statistic ) : void

Increment a global tracking statistic counter stored in the database (if statistic tracking was enabled).
ACR_SQLEncodeSpecialChars ( string s ) : string

This routine escapes characters for a SQL query.
ACR_SQLExecute ( string SQL ) : void

This routine performs a synchronous SQL query. If there were pending asynchronous queries in the queue, the pending queries are drained first. The query must not return any results.
ACR_SQLFetch ( ) : bool

This routine fetches the next rowset from the database.
ACR_SQLGetAffectedRows ( ) : int

This routine returns the number of rows affected by a query.
ACR_SQLGetData ( ) : string

This routine returns the first column of data from the current SQL rowset.
ACR_SQLGetData ( int ColumnIndex ) : string

This routine returns the specified column of data from the current SQL rowset.
ACR_SQLQuery ( string SQL ) : void

This routine performs a synchronous SQL query. If there were pending asynchronous queries in the queue, the pending queries are drained first.
Dispose ( ) : void

Dispose the object.
MySQLDatabase ( string ConnectionString = null, bool Dedicated = false ) : System

Create a new database object (which can be shared by multiple script objects).

비공개 메소드들

메소드 설명
Dispose ( bool Disposing ) : void

Dispose the object.
ForceLoadMySQL ( ) : void

This method forces MySQL.Data.dll to be loaded and linked.
LinkToMySQLAssembly ( string ConnectionString = null, bool Dedicated = false ) : void

This method links to the MySQL assembly, ensuring that the assembly is loaded. If necessary the assembly is loaded from the NWNX4 installation directory.
LinkToMySQLAssembly_AssemblyResolve ( object sender, ResolveEventArgs args ) : Assembly

This assembly resolve handler is designed to handle a failure to resolve the MySQL.Data.dll assembly. It returns the pre-loaded assembly for linkage.

메소드 상세

ACR_IncrementStatistic() 공개 메소드

Increment a global tracking statistic counter stored in the database (if statistic tracking was enabled).
public ACR_IncrementStatistic ( string Statistic ) : void
Statistic string Supplies the counter name.
리턴 void

ACR_SQLEncodeSpecialChars() 공개 메소드

This routine escapes characters for a SQL query.
public ACR_SQLEncodeSpecialChars ( string s ) : string
s string Supplies the string to escape.
리턴 string

ACR_SQLExecute() 공개 메소드

This routine performs a synchronous SQL query. If there were pending asynchronous queries in the queue, the pending queries are drained first. The query must not return any results.
public ACR_SQLExecute ( string SQL ) : void
SQL string Supplies the SQL query text to execute.
리턴 void

ACR_SQLFetch() 공개 메소드

This routine fetches the next rowset from the database.
public ACR_SQLFetch ( ) : bool
리턴 bool

ACR_SQLGetAffectedRows() 공개 메소드

This routine returns the number of rows affected by a query.
public ACR_SQLGetAffectedRows ( ) : int
리턴 int

ACR_SQLGetData() 공개 메소드

This routine returns the first column of data from the current SQL rowset.
public ACR_SQLGetData ( ) : string
리턴 string

ACR_SQLGetData() 공개 메소드

This routine returns the specified column of data from the current SQL rowset.
public ACR_SQLGetData ( int ColumnIndex ) : string
ColumnIndex int Supplies the zero-based column index to /// retrieve.
리턴 string

ACR_SQLQuery() 공개 메소드

This routine performs a synchronous SQL query. If there were pending asynchronous queries in the queue, the pending queries are drained first.
public ACR_SQLQuery ( string SQL ) : void
SQL string Supplies the SQL query text to execute.
리턴 void

Dispose() 공개 메소드

Dispose the object.
public Dispose ( ) : void
리턴 void

MySQLDatabase() 공개 메소드

Create a new database object (which can be shared by multiple script objects).
public MySQLDatabase ( string ConnectionString = null, bool Dedicated = false ) : System
ConnectionString string Optionally supplies an overload /// connection string. If null, the default string is built from the /// NWNX MySQL plugin's configuration file.
Dedicated bool Supplies true if the database object is to /// use a dedicated connection.
리턴 System