3.使用实体映射操作sql

同样是增删改查，首先创建数据库，我创建的是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();
        }
    }