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();

        }