As you execute the query
"SELECT * FROM `Families`, `Members` WHERE `Families`.`FamilyId`='123' AND `Members`.`FamilyId`='123'"
You join the to tables Families and Members into 1 result set.
The output result will be
FamilyId,City,Phone,FamilyId,Birtdate
Ending up with 5 column on each row returned.
In your while loop you can then do:
while (reader.Read())
{
FamiliesObject f = new FamiliesObject((int)reader[0], (string)reader[1], (string)reader[2]);
MembersObject m = new MembersObject((int)reader[3], (DateTime)reader[4]);
}
You have to create FamiliesObject and MembersObject class. And FamiliesObject could look like this.
public class FamiliesObject
{
public int FamilyId;
public string City;
public string Phone;
public FamiliesObject(int familyId, string city, string phone)
{
this.FamilyId = familyId;
this.City = city;
this.Phone = phone;
}
}
Hope you get the idea :-)