public List <string> GetStationNames() { using (SubwayEntities context = DbContextFactory.Create()) { IQueryable <Daejeon> query = from x in context.Daejeons select x; var q = query.Select(x => new { x.역번호, x.역명 }).Distinct().OrderBy(x => x.역번호); return(q.Select(x => x.역명).ToList()); } }
public static SubwayEntities Create() { //string connectionString = "metadata=res://*/Subway.csdl|res://*/Subway.ssdl|res://*/Subway.msl;provider=System.Data.SqlClient;provider connection string=\";data source=.;initial catalog=Subway;persist security info=True;user id=sa;password=a1234a;MultipleActiveResultSets=True;App=EntityFramework\";"; string connectionString = "metadata=res://*/Subway.csdl|res://*/Subway.ssdl|res://*/Subway.msl;provider=System.Data.SqlClient;provider connection string=\";data source=10.10.14.99;initial catalog=Subway;persist security info=True;user id=sa;password=3512;MultipleActiveResultSets=True;App=EntityFramework\";"; SubwayEntities context = new SubwayEntities(connectionString); //context.Database.Log = x => Debug.WriteLine(x); return(context); }
public List <int?> GetPassengers(Expression <Func <Daejeon, bool> > predicate = null) { using (SubwayEntities context = DbContextFactory.Create()) { IQueryable <Daejeon> query = from x in context.Daejeons select x; if (predicate != null) { query = query.Where(predicate); } var r = query.GroupBy(x => new { x.요일, x.구분 }).OrderBy(x => x.Key).Select(x => x.Sum(y => y.승객수)); return(r.ToList()); } }
public List <Daejeon> GetAll(Expression <Func <Daejeon, bool> > predicate = null) { using (SubwayEntities context = DbContextFactory.Create()) { IQueryable <Daejeon> query = context.Set <Daejeon>(); if (predicate != null) { query = query.Where(predicate); } var list = query.ToList(); return(list); } }