public Class1() { db2019EventsStudentEntities = new Db2019EventsStudentEntities(); //student only alcool db2019EventsStudentEntities.Drink.Where(d => d.DrinkType.AlcoholContent != 0).Select(d => d.MemberId).Distinct().ToList(); //student event free db2019EventsStudentEntities.Participation.Where(p => p.Credit == 0).Select(p => p.MemberId).Distinct().ToList(); }
public static List <DrinkTypeModel> Get() { using (var context = new Db2019EventsStudentEntities()) { return(context.DrinkType.Select(d => new DrinkTypeModel() { Decription = d.Description, Id = d.Id, AlcoholContent = (double)d.AlcoholContent }).ToList()); } }
public EventService() { context = new Db2019EventsStudentEntities(); }