LinQ To SQL(增，删，改，查)

//插入数据
        Tbl_CH chm = new Tbl_CH()  //Tbl_CH 为表名
        {
            EgNumber = "OYZH",
            MName = "欧阳震华"
        };
        it.dt.Tbl_CH.InsertOnSubmit(chm);
        it.dt.SubmitChanges();

        //删除数据 where 可跟多个条件 "并且"用&&  "或者"用 || 

        int cout = 0;
        try
        {
            Tbl_CH tc = new Tbl_CH();
            tc = it.dt.Tbl_CH.Single(p => p.id == 165);//查找单个实例
            it.dt.Tbl_CH.DeleteOnSubmit(tc);
            it.dt.SubmitChanges();
            cout = 1;
        }
        catch (Exception x)
        {
            cout = 0;
        }
        if (cout > 0)
        {
            Response.Write("成功");
        }
        else
        {
            Response.Write("失败");
        }
        //更新
        Tbl_CH uptbl = new Tbl_CH();
        uptbl = it.dt.Tbl_CH.Single(p => p.id == 13);
        uptbl.EgNumber = "YCL";
        it.dt.SubmitChanges();

 var kk = from cc in it.dt.CRM_CUSTOMER
                 join cls in it.dt.CRM_Linkman
                 on cc.CustomerID equals cls.CustomerID
                 into bb
                 from bbb in bb.DefaultIfEmpty()
                 select new
                 {
                     customerName = cc.NAME,
                     linkName = bbb != null ? bbb.NAME : "",
                 };