(Context: I'm relatively new to .NET and new to C#)
I have a UI that allows the user to perform a lookup of a record from the database. Once they select a record from the lookup, I need to display all of the field values for that record on the UI. The record contains around 45 fields.
I was thinking that I would pass a DataSet by Ref to my data access class which would retrieve the data for the record, fill the DataSet, and then return it back to the UI class to populate fields on the form.
Is this best practice? Or is there a different, more proper way of handling this type of data retrieval?