public int ExecuteNonQuery(string SQL, params KeyValuePair <string, object>[] Parameters) { try { if (connection.SqlConnection == null) { #pragma warning disable CA1303 // Do not pass literals as localized parameters throw new Exception("Can not execute queryn on closed connection"); #pragma warning restore CA1303 // Do not pass literals as localized parameters } using var cmd = connection.SqlConnection.CreateCommand(); cmd.Transaction = defaultTransaction; #pragma warning disable CA2100 // Review SQL queries for security vulnerabilities cmd.CommandText = connection.SubstParamSymb( SQLDBConnection.Pack(SQL) ); #pragma warning restore CA2100 // Review SQL queries for security vulnerabilities cmd.Parameters.Clear(); SQLDBConnection.BindParameters(cmd, Parameters); var res = cmd.ExecuteNonQuery(); return(res); } catch (Exception ex) { throw new Exception($"Error in SQL:\n{SQL}\n{ex.Message}"); } }
public TransactionHelper(SQLDBConnection con, IsolationLevel isolation, bool NoTransaction = false) { if (con == null || !con.IsConnected || con.SqlConnection == null) { #pragma warning disable CA1303 // Do not pass literals as localized parameters throw new Exception("Can not open transaction on closed connection"); #pragma warning restore CA1303 // Do not pass literals as localized parameters } connection = con; defaultTransaction = NoTransaction ? null : con.SqlConnection.BeginTransaction(isolation); con.CurrentTransaction = defaultTransaction; }
public ORMLite(SQLDBConnection con) { this.con = con; }
public ORMDBSchemaGenerator(SQLDBConnection con, Logger?log) { Logger = log; db = con; }