实践MVC+Entity framework+Enterprise Library（2）

接着昨天的，先讲讲Entity framework

创建实体之后，在代码中这么写

DbMVCEntities context = new DbMVCEntities();

nt count = (from e in context.Usr

where e.username == username

where e.password == password

select e).Count();

接着通过count来判断User表中时候有相应的值

这个是查询

下面是新建

Usr newUser = new Usr();

newUser.username = username;

newUser.password = password;

newUser.Email = email;

context.AddToUsr(newUser);

context.SaveChanges();

 

更新

Usr user = context.Usr.FirstOrDefault(e => e.username == username);

if (user != null)

{

user.password = newPassword;

context.SaveChanges();

TempData["Message"] = string.Format("用?户?名?为?{0}的?用?户?修?改?密?码?成?功?!", username);

return RedirectToAction("LogInSuccess", "DBAccount");

}

 

对share中的LogOnUserControl进行了修改

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl" %>

<%

    if (Request.Cookies["username"]!=null) {

%>

        Welcome <b><%= Html.Encode(Request.Cookies["username"].Value)%></b>!

[ <%= Html.ActionLink("Log Off", "LogOff", "DbAccount")%> ]

<%

    }

else {

%> 

[ <%= Html.ActionLink("Log On", "Login", "DbAccount") %> ]

<%

    }

%>

 

今天讲的就是这些

主要是Entity framework+linq，进行数据的增删改查

MVC的确是个好东西！