public IList<TDBHost> SelectAll() { var returns = new List<TDBHost>(); var dt = SqlDbAccess.GetInstance().GetTable("select * from TDBHost"); foreach (DataRow dr in dt.Rows) { var tDBHost = new TDBHost(); tDBHost.FromDataRow(dr); returns.Add(tDBHost); } return returns; }