A SQL Query. More...

Inheritance diagram for Anvil.API.SQLQuery:

Collaboration diagram for Anvil.API.SQLQuery:

Public Member Functions
void	BindParam (string param, float value)
	Binds the specified parameter with the specified value.

void	BindParam (string param, int value)
	Binds the specified parameter with the specified value.

void	BindParam (string param, NwObject value)
	Binds the specified parameter with the specified value.

void	BindParam (string param, string value)
	Binds the specified parameter with the specified value.

void	BindParam (string param, Vector3 value)
	Binds the specified parameter with the specified value.

void	Execute ()
	Executes this query.

void	Reset (bool clearBinds=false)
	Reset this sqlquery, readying it for re-execution after results have been fetched. Existing BindParam values are kept, unless the clearBinds argument is set to true.

Public Member Functions inherited from Anvil.API.EngineStructure
void	Dispose ()

Static Public Member Functions
static implicit	operator SQLQuery (IntPtr intPtr)

Static Public Member Functions inherited from Anvil.API.EngineStructure
static implicit	operator IntPtr (EngineStructure engineStructure)

Properties
string[]	Columns `[get]`
	Gets the name of the columns declared as a part of this query.

string	Error `[get]`
	Returns "" if the last Sql command succeeded; or a human-readable error otherwise. Additionally, all SQL errors are sent to all connected players.

SQLResult?	Result `[get]`
	Gets the result of this query. NOTE: If Results have been enumerated, this will be the last enumerated value.

IEnumerable< SQLResult >	Results `[get]`
	Gets the results of this query. NOTE: Results can only be enumerated once. Be careful with usage of LINQ extensions and loops.

override int	StructureId `[get]`

Properties inherited from Anvil.API.EngineStructure
bool	IsValid `[get]`
	Gets if this object is valid.

int	StructureId `[get]`

Additional Inherited Members
Protected Member Functions inherited from Anvil.API.EngineStructure
	EngineStructure (IntPtr handle, bool memoryOwn)

Detailed Description

A SQL Query.