public List <string> getMemberFirstName() { List <string> allMembersFirstName = new List <string>(); using (var db = new MembersListEntities()) { allMembersFirstName = (from mems in db.members select mems.firstName).ToList(); db.Dispose(); } return(allMembersFirstName); }
public void addToDatabase(string fname, string lname, string sDate, string eDate) { using (var db = new MembersListEntities()) { member newMember = new member { // ID of every new object is one more than the ID of the last object in the table Id = generateID(), firstName = fname, lastName = lname, membershipStartDate = sDate, membershipEndDate = eDate }; db.members.Add(newMember); db.SaveChanges(); db.Dispose(); // I believe the "using" statement renders this redundant but hey, YouTube said so } }