public ConnectionSqlOutputStream(DbConnection conn, DbTransaction trans, ISqlDialect dialect, ICancelableProcessCallback cancelable = null)
{
m_conn = conn;
m_dialect = dialect;
m_trans = trans;
_cancelable = cancelable;
}
public SqlGeneratorModel(IConnectionProvider provider, TextWriter stream, GenerateSql options, DatabaseInfo database, ICancelableProcessCallback cancelable, Action <string> logger)
{
_cancelable = cancelable;
_provider = provider;
_logger = logger;
_factory = _provider.Factory;
_sqlo = new SqlOutputStream(_factory.CreateDialect(), stream, new SqlFormatProperties());
_dmp = _factory.CreateDumper(_sqlo, new SqlFormatProperties());
_options = options;
_database = database;
_dialectCaps = _factory.DialectCaps;
FillWorkingSets();
}
public static void ExecuteNonQuery(this DbConnection conn, string sql, DbTransaction trans, int?timeout, ICancelableProcessCallback cancelable = null)
{
if (String.IsNullOrEmpty(sql))
{
return;
}
if (sql.StartsWith("@use"))
{
string[] items = sql.Split(' ');
conn.ChangeDatabase(items[1].Trim());
}
else
{
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
if (timeout != null)
{
cmd.CommandTimeout = timeout.Value;
}
if (trans != null)
{
cmd.Transaction = trans;
}
cancelable?.AddCancelMethod(cmd, cmd.Cancel);
cmd.ExecuteNonQueryEx();
cancelable?.RemoveCancelMethod(cmd);
}
}
}
public static void ExecuteNonQuery(this DbConnection conn, string sql, ICancelableProcessCallback cancelable = null)
{
ExecuteNonQuery(conn, sql, null, null, cancelable);
}
