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")

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

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