3.使用实体映射操作sql

来源：互联网发布：淘宝图片空间免费领取编辑：程序博客网时间：2024/05/17 23:16

同样是增删改查，首先创建数据库，我创建的是userDate,让后使用vs的组建创建该表的实体即创建LING TO SQL CLASS,操作起来比hibernate容易多了，

查询

        protected void Page_Load(object sender, EventArgs e)        {            connstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;            dc = new UserDataDataContext(connstr);            Table<UserDate> dcs = dc.GetTable<UserDate>();            GridView1.DataSource =(from UserData in dcs where UserData.address !=null && UserData.address != "" select UserData).Distinct();            GridView1.DataBind();            Label1.Text = "查询成功";        }

增加

        protected void Button1_Click(object sender, EventArgs e)        {             UserDate user = new UserDate();            user.address = "汕尾";            user.phone = 0660;            user.name = "XXX";            user.image = "2324.jpg";            dc.UserDates.InsertOnSubmit(user);            dc.SubmitChanges();            Table<UserDate> dcs = dc.GetTable<UserDate>();            GridView1.DataSource = (from UserData in dcs where UserData.address != null && UserData.address != "" select UserData).Distinct();            GridView1.DataBind();        }

删除

        protected void Button2_Click(object sender, EventArgs e)        {            IQueryable<UserDate> query = (from UserData in dc.UserDates where UserData.phone == 660 select UserData).Distinct();             foreach(UserDate user in query){                dc.UserDates.DeleteOnSubmit(user);            }            dc.SubmitChanges();            GridView1.DataSource = (from UserData in dc.UserDates select UserData).Distinct();            GridView1.DataBind();        }

改

        protected void Button3_Click(object sender, EventArgs e)        {            IQueryable<UserDate> query = (from UserData in dc.UserDates where UserData.phone == 660 select UserData).Distinct();            foreach (UserDate user in query)            {                user.phone = 110;            }            dc.SubmitChanges();            GridView1.DataSource = (from UserData in dc.UserDates select UserData).Distinct();            GridView1.DataBind();        }    }

0 0