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