Way.EntityDB的常用数据库操作

            using ( var db = new MyDbContext("连接字符串", DatabaseType.SqlServer))
            {
                //往数据库insert一条数据（方法一）
                var user = new UserInfo() { 
                    UserName = "YourName",
                    Balance = 0
                };
                db.Insert(user);

                //往数据库insert一条数据（方法二）
                var user2 = new UserInfo()
                {
                    UserName = "YourName",
                    Balance = 0
                };
                db.Update(user2);

                //update数据库里面的记录
                user = db.UserInfo.FirstOrDefault(m => m.UserName == "YourName");
                user.Balance = 100;
                user.Email = "123@qq.com";
                db.Update(user);

                //批量更新、乐观锁
                //下面执行等价于sql语句：update UserInfo set Balance=Balance-100, Amount=Amount-100, Email='' where Balance>=100
                var user = new UserInfo();
                //注意：SetValue语句只能写一句，不能分成两句来写
                user.SetValue(m => m.Balance == m.Balance - 100 && m.Amount == m.Amount - 50);
                user.Email = "";
                if( db.Update(user, m => m.Balance >= 100) > 0 ){
                    //更新成功
                }


                //删除数据
                db.Delete(user);

                //批量删除
                db.Delete<UserInfo>(m => m.Balance < 100);
            }