- exec
ulong exec(Connection conn, string sql)
ulong exec(Connection conn, Prepared prepared)
Execute a one-off SQL command, such as INSERT/UPDATE/CREATE/etc.
- exec
ulong exec(Connection conn, BackwardCompatPrepared prepared)
This function is provided ONLY as a temporary aid in upgrading to mysql-native v2.0.0.
- execImpl
ulong execImpl(Connection conn, ExecQueryImplInfo info)
Common implementation for exec overloads
- execQueryImpl
bool execQueryImpl(Connection conn, ExecQueryImplInfo info, ulong ra)
bool execQueryImpl(Connection conn, ExecQueryImplInfo info)
Internal implementation for the exec and query functions.
- query
ResultRange query(Connection conn, string sql, ColumnSpecialization[] csa)
ResultRange query(Connection conn, Prepared prepared, ColumnSpecialization[] csa)
Execute a one-off SQL SELECT command where you want to deal with the
result set one row at a time.
- query
ResultRange query(Connection conn, BackwardCompatPrepared prepared, ColumnSpecialization[] csa)
This function is provided ONLY as a temporary aid in upgrading to mysql-native v2.0.0.
- queryImpl
ResultRange queryImpl(ColumnSpecialization[] csa, Connection conn, ExecQueryImplInfo info)
Common implementation for query overloads
- queryRow
Nullable!Row queryRow(Connection conn, string sql, ColumnSpecialization[] csa)
Nullable!Row queryRow(Connection conn, Prepared prepared, ColumnSpecialization[] csa)
Execute a one-off SQL SELECT command where you only want the first mysql.result.Row (if any).
- queryRow
Nullable!Row queryRow(Connection conn, BackwardCompatPrepared prepared, ColumnSpecialization[] csa)
This function is provided ONLY as a temporary aid in upgrading to mysql-native v2.0.0.
- queryRowImpl
Nullable!Row queryRowImpl(ColumnSpecialization[] csa, Connection conn, ExecQueryImplInfo info)
Common implementation for querySet overloads.
- queryRowTuple
void queryRowTuple(Connection conn, string sql, T args)
void queryRowTuple(Connection conn, Prepared prepared, T args)
Execute a one-off SQL SELECT command where you only want the first mysql.result.Row,
and place result values into a set of D variables.
- queryRowTuple
void queryRowTuple(Connection conn, BackwardCompatPrepared prepared, T args)
This function is provided ONLY as a temporary aid in upgrading to mysql-native v2.0.0.
- queryRowTupleImpl
void queryRowTupleImpl(Connection conn, ExecQueryImplInfo info, T args)
Common implementation for queryRowTuple overloads.
- queryValue
Nullable!Variant queryValue(Connection conn, string sql, ColumnSpecialization[] csa)
Nullable!Variant queryValue(Connection conn, Prepared prepared, ColumnSpecialization[] csa)
Execute a one-off SQL SELECT command and returns a single value,
the first column of the first row received.
- queryValue
Nullable!Variant queryValue(Connection conn, BackwardCompatPrepared prepared, ColumnSpecialization[] csa)
This function is provided ONLY as a temporary aid in upgrading to mysql-native v2.0.0.
- queryValueImpl
Nullable!Variant queryValueImpl(ColumnSpecialization[] csa, Connection conn, ExecQueryImplInfo info)
Common implementation for queryValue overloads.
Use a DB via plain SQL statements.
Commands that are expected to return a result set - queries - have distinctive methods that are enforced. That is it will be an error to call such a method with an SQL command that does not produce a result set. So for commands like SELECT, use the query functions. For other commands, like INSERT/UPDATE/CREATE/etc, use exec.