It seems that in most of the examples in the book, the queries issued through the DAL return at least one or more records. In my case, I have a method which queries the database for 'Players' based on first name and last name. Sometimes, no players are returned, and when this happens I'm getting an exception when trying to convert the database data to en entity object as outlined in the book.
Specifically, I'm getting an exception in the GetPlayerFromReader method as I try to build the entity object:
public override PlayerDetails GetPlayerByFirstNameLastName(string firstName, string lastName)
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
SqlCommand cmd = new SqlCommand("Sheets_GetPlayerByFirstNameLastName", cn);
cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = firstName;
cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = lastName;
cmd.CommandType = CommandType.StoredProcedure;
protected virtual PlayerDetails GetPlayerFromReader(IDataReader reader)
PlayerDetails player = new PlayerDetails(
The exception I get says: "Invalid attempt to read when no data is present." because no records are returned.
Should I be checking the 'depth' property of the Reader object here to see if there is any data before creating the Player entity object?