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
}
}
