public IDataReader ExecuteReader(string sql) { LogQuery(sql); ISqlConnection sqlConnection = connectionProvider.Provide <ISqlConnection>(); sqlConnection.Open(); using (ISqlCommand command = sqlConnection.CreateCommand(null)) { command.CommandTimeout = 300000; command.CommandType = CommandType.Text; command.CommandText = sql; return(command.ExecuteReader(CommandBehavior.CloseConnection)); } }
private void ExecuteButtonClick(object window) { try { if (Query.Trim().ToLower().StartsWith("select")) { var table = SqlCommand.ExecuteReader(Query, Parameters.ToList()); ResultTable = table.DefaultView; } else { SqlCommand.ExecuteNonQuery(Query, Parameters.ToList()); ResultTable = null; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public IDataReader ExecuteStoredProcedure(string name, params ParameterDefinition[] parametersDefinitions) { LogExecuteProc(name); ISqlConnection sqlConnection = connectionProvider.Provide <ISqlConnection>(); sqlConnection.Open(); using (ISqlCommand command = sqlConnection.CreateCommand(null)) { command.CommandTimeout = 300000; command.CommandType = CommandType.StoredProcedure; command.CommandText = name; foreach (ParameterDefinition parametersDefinition in parametersDefinitions) { command.Parameters.AddWithValue(parametersDefinition.Name, parametersDefinition.Value, parametersDefinition.IsNullable, parametersDefinition.DbType, parametersDefinition.Size, parametersDefinition.Direction); } if (parametersDefinitions.Where(m => m.Direction > ParameterDirection.Input).Count() > 0) { command.ExecuteNonQuery(); GetParameterCollection(command.Parameters.GetParameter(), parametersDefinitions); } return(command.ExecuteReader(CommandBehavior.CloseConnection)); } }