Struct SqlServerConnection 

pub struct SqlServerConnection { /* private fields */ }

Implementations

impl SqlServerConnection

pub async fn connect(config: &DatabaseConfig) -> Result<SqlServerConnection>

Open a connection: pre-login, encryption, then login.

pub async fn connect_with( config: &DatabaseConfig, options: SqlServerOptions, ) -> Result<SqlServerConnection>

pub fn is_broken(&self) -> bool

pub fn in_transaction(&self) -> bool

True while a transaction is open, so the pool never hands back a connection that would leak one.

pub async fn simple_query(&mut self, sql: &str) -> Result<QueryResult>

Run a statement with no parameters, as a batch.

Used for DDL and for transaction control, both of which have to run outside sp_executesql — a begin transaction inside a procedure ends when the procedure does.

pub async fn query( &mut self, sql: &str, params: &[Value], ) -> Result<QueryResult>

Run a statement through sp_executesql.

Every statement takes this route, parameters or not, because it is the route where a bound value is a value: the statement text and the parameter declarations are themselves arguments to a stored procedure, so nothing a caller binds is ever concatenated into SQL. A value cannot change the shape of a statement it was never part of.

pub async fn close(self)

Hang up.

TDS has no goodbye token — MS-TDS says a client ends a session by closing the transport — so there is nothing to send first.

Trait Implementations

impl DriverConnection for SqlServerConnection

fn query<'a>( &'a mut self, sql: &'a str, params: &'a [Value], ) -> BoxFuture<'a, Result<QueryResult>>

Run a statement with bound parameters.

fn simple_query<'a>( &'a mut self, sql: &'a str, ) -> BoxFuture<'a, Result<QueryResult>>

Run a statement with no parameters — DDL, and transaction control.

fn is_broken(&self) -> bool

Whether this connection is known to be unusable, so the pool discards it instead of handing it to the next caller.

fn in_transaction(&self) -> bool

Whether a transaction is still open. A connection left inside one must never go back into rotation.

fn close(self: Box<Self>) -> BoxFuture<'static, ()>

Say goodbye politely, then hang up.