接EF查询两个表全部信息文档
EF查询两个表
添加
编写DAL中ArtideDAO 代码如下
using Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace DAL
{
public class ArtideDAO
{
MyDBEntities db = new MyDBEntities();
/// <summary>
/// 查询Artide表和Catelog里的全部信息
/// </summary>
/// <returns></returns>
public object Select()
{
var reslut = from a in db.Artide
join c in db.Catelog
on a.Catelogid equals c.ID
select new {
编号 = a.ID, 标题 = a.Title, 作者 = a.Author, 发布时间 = a.PushDate,
内容 = a.Conent, 类别 = c.Name, 备注 = c.Comment };
return reslut;
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="artide"></param>
/// <returns></returns>
public int Add(Artide artide)
{
db.Artide.Add(artide);
int count = db.SaveChanges();
return count;
}
}