public List<Contact> Contact_SelectAll(){ string sql = string.Format(@" select * from Contact "); List<Contact> contactList = new List<Contact>(); Database db = DatabaseFactory.CreateDatabase("MySqlDatabaseTest"); DbCommand dbCommand = db.GetSqlStringCommand(sql); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { Contact contact = new Contact(); contact.ID = (int) dataReader["ContactID"]; contact.FirstName = dataReader["ContactFName"].ToString(); contact.LastName = dataReader["ContactLName"].ToString(); contactList.Add(contact); } } return contactList;}
Remember Me
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, sup, u