LINQ to SQL公共基类 demo
public Form1() { InitializeComponent(); } private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //XtraForm1 frm = new XtraForm1(); //frm.ShowDialog(); var old = DbFactory<Users>.Instance.GetSingle(f => f.UserID == 2); old.TrueName = DateTime.Now.ToString(); DbFactory<Users>.Instance.Update(); } private void Form1_Load(object sender, EventArgs e) { var list = DbFactory<Users>.Instance.GetAll().Take(10); this.gridControl1.DataSource = list; } private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { } private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { string msg = DbFactory<Users>.Instance.GetSingle(f => f.UserID == 1).UserName; DevExpress.XtraEditors.XtraMessageBox.Show(msg); } private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { Form1_Load(null, null); } private void barButtonItem7_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var msg = DbFactory<Notice>.Instance.GetSingle().NoticeTitle; DevExpress.XtraEditors.XtraMessageBox.Show(msg); }