使用ADO.net实体数据模型

1.最简单的新建

2.从数据库导入

3.实例化对象使用linq对数据进行操作。

几个所包含的linq语句实例：

Entities.Personal.Any(m => m.PerID == openId && m.PerForPub == 110)

 

Entities.XsPosts.Where(m => m.OpenId == openid && m.Status.HasValue && m.Status.Value == 1)
.OrderByDescending(m => m.Id)
.Select(m => m.Id).Take(1);

wxEntities.PersonalWXes.Where(m => m.PerID == requestMessage.FromUserName && (m.PerForPub == 62 || m.PerForPub == 104 || m.PerForPub == 103))
.Select(m => new { m.PerForPub });

 

增加一条记录

_wxEntities.XsPosts.Add(new XsPost
{
OpenId = openid,
TrueName = trueName,
CreateTime = DateTime.Now,
Status = 1,
Mobile = mobile,
HomeAddress = address
});
try
{
_wxEntities.SaveChanges();
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}

 

转载于:https://www.cnblogs.com/BlackCherry/p/4555308.html