.Net开源数据库设计工具Mr.EForLinq(EF6.1)教程（一）

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace LinqTest1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            using (var db = new Test.DB.TestDB(@"data source=""F:\SqliteLinqTest\TestDB""", EntityDB.DatabaseType.Sqlite))
            {
                //开始事务
                db.BeginTransaction();
                try
                {
                    //添加数据
                    var user = new Test.UserInfo();
                    user.UserName = "张三";
                    user.Password = "123";
                    db.Update(user);
                    Debug.WriteLine("张三的id是" + user.id);


                    //更新数据
                    var zhangSan = (from m in db.UserInfo
                                    where m.UserName == "张三"
                                    select m).FirstOrDefault();
                    zhangSan.Password = "678";
                    db.Update(zhangSan);


                    //删除数据
                    var data = db.UserInfo.FirstOrDefault(m => m.UserName == "李四");
                    if (data != null)
                    {
                        db.Delete(data);
                    }


                    //提交事务
                    db.CommitTransaction();
                }
                catch
                {
                    //回滚事务
                    db.RollbackTransaction();
                    throw;
                }
            }

        }
    }
}