Beispiel #1
0
        public void MysqlExecuteScalarTra()
        {
            MyDapperPower.DbConnection("server=localhost;port=3306;user id=root;password=Aa82078542;database=testmysql;SslMode=none", "mysql", "mysql");
            UserLocalDAL userLocalDAL = new UserLocalDAL();
            var          commandText  = $"select status from {EntityHelper.CallName<UserLocal>()} where id = @id";
            var          commandText2 = $"update {EntityHelper.CallName<UserLocal>()} set status = 5 where id = @id";

            using (var transactionScope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
            {
                using (var connection = userLocalDAL.Connection)
                {
                    int id      = 22;
                    var result1 = userLocalDAL.ExecuteScalar <int>(connection, commandText2, new { id });
                    var result2 = userLocalDAL.ExecuteScalar <int>(connection, commandText, new { id });
                    Assert.Equal(5, result2);
                }
            }
        }
Beispiel #2
0
        public void MysqlExecuteScalar()
        {
            MyDapperPower.DbConnection("server=localhost;port=3306;user id=root;password=Aa82078542;database=testmysql;SslMode=none", "mysql", "mysql");
            UserLocalDAL userLocalDAL = new UserLocalDAL();
            var          commandText  = $"select * from {EntityHelper.CallName<UserLocal>()} where id = @id";
            int          id           = 21;
            var          result       = userLocalDAL.ExecuteScalar <int>(commandText, new { id });

            Assert.Equal(id, result);
        }