public PAGE Get(string pageTitle)
{
using (bikeshopdatabaseEntities dbContext = new bikeshopdatabaseEntities())
{
return(dbContext.PAGEs.FirstOrDefault(p => p.PAGE_TITLE.Equals(pageTitle)));
}
}
public IEnumerable <PAGE> Get()
{
using (bikeshopdatabaseEntities dbContext = new bikeshopdatabaseEntities())
{
return(dbContext.PAGEs.ToList());
}
}
public IEnumerable <METRIC> Get()
{
using (bikeshopdatabaseEntities dbContext = new bikeshopdatabaseEntities())
{
return(dbContext.METRICS.ToList());
}
}
public METRIC Get(string sessionID)
{
using (bikeshopdatabaseEntities dbContext = new bikeshopdatabaseEntities())
{
return(dbContext.METRICS.FirstOrDefault(m => m.SESSION_ID.Equals(sessionID)));
}
}
public USER Get(string userName)
{
using (bikeshopdatabaseEntities dbContext = new bikeshopdatabaseEntities())
{
return(dbContext.USERs.FirstOrDefault(u => u.USERNAME.Equals(userName)));
}
}
