MsSql

version(Windows)
class MsSql : Database {}

Constructors

this
this(string connectionString)

auto db = new MsSql("Driver={SQL Server Native Client 10.0};Server=<host>[\\<optional-instance-name>];Database=dbtest;Trusted_Connection=Yes")

Destructor

A destructor is present on this object, but not explicitly documented in the source.

Inherited Members

From Database

queryImpl
ResultSet queryImpl(string sql, Variant[] args)

Actually implements the query for the database. The query() method below might be easier to use.

escape
string escape(string sqlData)

Escapes data for inclusion into an sql string literal

escapeBinaryString
string escapeBinaryString(const(ubyte)[] sqlData)

Escapes binary data for inclusion into a sql string. Note that unlike escape, the returned string here SHOULD include the quotes.

startTransaction
void startTransaction()

query to start a transaction, only here because sqlite is apparently different in syntax...

query
ResultSet query(string sql, T t)

Just executes a query. It supports placeholders for parameters

sysTimeToValue
string sysTimeToValue(SysTime )

turns a systime into a value understandable by the target database as a timestamp to be concated into a query. so it should be quoted and escaped etc as necessary

Meta