C# linq to sql

仅供参考 /// <summary>        /// OR映射 并且集成于DataContext类 DataContext Linq 的主入口点        /// </summary>        DataClassesDataContext text = new DataClassesDataContext(@"server=.;Uid=sa;Pwd=******;Database=**");首先先建立OR映射，若不建立or映射只能使用linqtosql select的方法select private void getDate()        {            /*             * Table<> 标示基础数据库中的表类型             */                Table<ACCESS_ROLE_ACR> tables = text.GetTable<ACCESS_ROLE_ACR>();                dataGridView1.DataSource = from t in tables                                           select new { ID = t.ID, Acr_ID = t.ACCESS_ROLE_CD, func_id = t.LAST_UPD_BY, Date = t.CREATED_BY, ACCESS_ROLE_CD = t.ACCESS_ROLE_CD };        }add  private void button1_Click(object sender, EventArgs e)        {            ACCESS_ROLE_ACR ta = new ACCESS_ROLE_ACR();            ta.ACCESS_ROLE_CD = this.textBox1.Text.Trim().ToString();            ta.LAST_UPD_DATE = DateTime.Now;            text.ACCESS_ROLE_ACR.InsertOnSubmit(new ACCESS_ROLE_ACR            {                ACCESS_ROLE_CD = "1",                CREATION_DATE = DateTime.Now,                LAST_UPD_BY = 1,                STS_CD = "1",                VER_NO = 1,                ID = 2,                LAST_UPD_DATE = DateTime.Now,                CREATED_BY = 4            });            text.SubmitChanges();            getDate();        } update private void button3_Click(object sender, EventArgs e)        {            var endit = text.ACCESS_ROLE_ACR.SingleOrDefault<ACCESS_ROLE_ACR>(s => s.ID == int.Parse(textBox1.Text.Trim().ToString()));            if (endit!=null)            {                endit.ACCESS_ROLE_CD = this.textBox2.Text.Trim();                text.SubmitChanges();                getDate();            }            else            {                MessageBox.Show("ID is null or error");            }        }  delete  private void button2_Click(object sender, EventArgs e)        {            var lamer = from a in text.ACCESS_ROLE_ACR                        where a.LAST_UPD_BY == int.Parse(this.textBox1.Text.Trim().ToString())                        select a;            text.ACCESS_ROLE_ACR.DeleteAllOnSubmit(lamer);            text.SubmitChanges();            getDate();        }