Class SQLQuery

Namespace

Anvil.API

Assembly

NWN.Anvil.dll

A SQL Query.

public sealed class SQLQuery : EngineStructure, IDisposable

Inheritance

object

EngineStructure

SQLQuery

Implements

IDisposable

Inherited Members

EngineStructure.IsValid

EngineStructure.Dispose()

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

CollectionExtensions.SafeYield<T>(T?)

CollectionExtensions.Yield<T>(T)

Properties

Columns

Gets the name of the columns declared as a part of this query.

Error

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

Result

Gets the result of this query.
NOTE: If Results have been enumerated, this will be the last enumerated value.

Results

Gets the results of this query.
NOTE: Results can only be enumerated once. Be careful with usage of LINQ extensions and loops.

StructureId

Methods

BindParam(string, NwObject)

Binds the specified parameter with the specified value.

BindParam(string, int)

Binds the specified parameter with the specified value.

BindParam(string, Vector3)

Binds the specified parameter with the specified value.

BindParam(string, float)

Binds the specified parameter with the specified value.

BindParam(string, string)

Binds the specified parameter with the specified value.

Execute()

Executes this query.

Reset(bool)

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.

Operators

implicit operator SQLQuery(nint)