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;
}