public ActionResult Login()
{
string user = Request["user"].Trim().ToString();
string pwd = Request["pwd"].Trim().ToString();
using (Student3 db = new Student3())
{
#region 导航关系实现lambda
logen list = db.logen.SingleOrDefault(s => s.loge == user);
if (list != null)
{
if (list.pwd == pwd)
{
return(Redirect("~/student/index"));
}
else
{
ViewBag.Error = "密码错误";
return(View("Index"));
}
}
else
{
ViewBag.Error = "用户不存在";
return(View("Index"));
}
#endregion
}
}
// 学生列表显示
public ActionResult Index()
{
//创建数据库访问上下文对象(dbcontext)
//using{}释放资源
using (Student3 db = new Student3())
{
#region 基本查询
//2.通过linq访问对象
//limbda表达式
//var list = db.stuinfo.Where(s => s.Id > 5 && s.Age > 20);
#endregion
#region 联合查询
//通过linqe实现链接查询
//var list = (from s in db.stuinfo
// join c in db.classes
// on s.Id equals c.Id
// select (new StudentviewModel()
// {
// Id = s.Id,
// Name1 = s.Name,
// Mobile1 = s.Mobile,
// Email1 = s.Email,
// Age1 = s.Age,
// ClassName1 = c.ClassName
// })).ToList();
#endregion
#region lambda表达式实现
//var list = (db.stuinfo.Join(db.classes, s => s.Id, c => c.Id, (s, c) => new StudentviewModel()
//{
// Id = s.Id,
// Name1 = s.Name,
// Mobile1 = s.Mobile,
// Email1 = s.Email,
// Age1 = s.Age,
// ClassName1 = c.ClassName
//})).ToList();
#endregion
#region 导航关系实现lambda
var list = (db.stuinfo.Select(s => new StudentviewModel()
{
Id = s.Id,
Name1 = s.Name,
Mobile1 = s.Mobile,
Email1 = s.Email,
Age1 = s.Age,
ClassName1 = s.classes.ClassName
})).ToList();
return(View(list));
#endregion
}
}
