public DataTable ExecuteQuery(string sql, int timeout = -1) { CheckDispose(); var provider = CoreFactory.CreateDbProvider(_databaseId); using (IDbCommand cmd = provider.CreateTextCommand(sql)) { if (timeout > 0) { cmd.CommandTimeout = timeout; } cmd.Connection = _cnn; if (_tx != null) { cmd.Transaction = _tx; } IDbDataAdapter da = provider.CreateAdapter(cmd); DataSet ds = new DataSet(); _affectedRows = da.Fill(ds); return(ds.Tables[0]); } }
public DataTable ExecuteQuery(IDbCommand cmd) { CheckDispose(); var provider = CoreFactory.CreateDbProvider(_databaseId); cmd.Connection = _cnn; if (_tx != null) { cmd.Transaction = _tx; } IDbDataAdapter da = provider.CreateAdapter(cmd); DataSet ds = new DataSet(); _affectedRows = da.Fill(ds); return(ds.Tables[0]); }
public void ExecuteNonQuery(string sql, int timeout = -1) { CheckDispose(); var provider = CoreFactory.CreateDbProvider(_databaseId); using (IDbCommand cmd = provider.CreateTextCommand(sql)) { if (timeout > 0) { cmd.CommandTimeout = timeout; } cmd.Connection = _cnn; if (_tx != null) { cmd.Transaction = _tx; } _affectedRows = cmd.ExecuteNonQuery(); } }
public object ExecuteScalar(string sql, int timeout = -1) { CheckDispose(); var provider = CoreFactory.CreateDbProvider(_databaseId); using (IDbCommand cmd = provider.CreateTextCommand(sql)) { if (timeout > 0) { cmd.CommandTimeout = timeout; } cmd.Connection = _cnn; if (_tx != null) { cmd.Transaction = _tx; } return(cmd.ExecuteScalar()); } }