public DataSet ExecuteDataSet(CommandType commandType, string commandText) { dbEntity.Command = DBManagerFactory.GetCommand(dbEntity.ProviderType); this.PrepareCommand(dbEntity.Command, dbEntity.Connection, dbEntity.Transaction, commandType, commandText, dbEntity.Parameters); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter(dbEntity.ProviderType); dataAdapter.SelectCommand = dbEntity.Command; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); dbEntity.Command.Parameters.Clear(); return(dataSet); }
public void ExecuteDataSet(DBSettingEntity dbSetting, Func <DataSet, bool> funcProccessDataSet) { try { using (IDbConnection con = DBManagerFactory.BuilConnection(dbSetting.ProviderType, dbSetting.ConnectionString)) { con.Open(); IDbTransaction idbTransaction = null; if (dbSetting.IsTransaction) { idbTransaction = con.BeginTransaction(); } using (IDbCommand cmd = DBManagerFactory.BuildCommand(dbSetting.ProviderType, con, idbTransaction, dbSetting.CommandType, dbSetting.CommandText)) { this.AttachParameters(cmd, dbSetting.Parameters, dbSetting.ProviderType); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter(dbSetting.ProviderType); dataAdapter.SelectCommand = cmd; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); funcProccessDataSet.Invoke(dataSet); if (idbTransaction != null) { idbTransaction.Commit(); } } } } catch (SqlException ex) { throw this.TranslateException(ex); } }