public DataSet ExecuteQuery(string sql, IQueryParameter parameter) { using (var command = GetCommand()) { command.Connection = _connection; command.CommandText = sql; foreach (var item in parameter.Get()) { command.Parameters.Add(GetParameter(item)); } return(FillDataSet(command)); } }
public void ExecuteCommand(string sql, IQueryParameter parameter) { using (var command = GetCommand()) { command.Connection = _connection; command.CommandText = sql; foreach (var item in parameter.Get()) { command.Parameters.Add(GetParameter(item)); } command.ExecuteNonQuery(); } }