使用Entity Framework查询,添加
1.创建数据库,创建数据表(需要设置主键),添加测试数据
2.创建一个ASP.NET Web工程
3.添加实体数据模型,与数据库建立连接
4.添加一个Web窗体,对其进行窗体编辑
5.对其进行编码
查询数据表中的数据
EF join 方法
先实例化映射数据库,然后进行连表查询,再绑定数据
protected void Page_Load(object sender, EventArgs e)
{
ChangeDBEntities db = new ChangeDBEntities();
//var result = from a in db.Article
// join Catelog in db.Catelog on a.Catelogid equals Catelog.id
// select new { Title = a.Title, Content = a.Content, Author = a.Author, Catelog = Catelog.Name };
//this.Repeater1.DataSource = result.ToList();
//延迟加载
//this.Repeater1.DataSource = db.Article.ToList();
this.Repeater1.DataBind();
}
添加数据
先实例化,添加你所要添加的内容
protected void Button1_Click(object sender, EventArgs e)
{
ChangeDBEntities cdb = new ChangeDBEntities();
Article a = new Article();
a.Title = "C";
a.Content = "C语言是最好的语言";
a.Author = "张三";
a.Catelogid=2;
cdb.Article.Add(a);
int i = cdb.SaveChanges();
//Catelog c = new Catelog();
//c.Name = "张三";
//c.Comment = "张冠李戴";
//cdb.Catelog.Add(c);
//int i = cdb.SaveChanges();
if (i > 0)
{
Response.Write("<script>alert('添加成功')</script>");
}
}