CUBRID学习笔记 33 net事务 cubrid教程示例

 

 

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102

conn.BeginTransaction();   string sql = "create table t(idx integer)"; using (CUBRIDCommand command = new CUBRIDCommand(sql, conn)) {     command.ExecuteNonQuery(); }   conn.Rollback();   conn.BeginTransaction();   sql = "create table t(idx integer, a varchar(20))"; using (CUBRIDCommand command = new CUBRIDCommand(sql, conn)) {     command.ExecuteNonQuery(); }   conn.Commit();<br><br><br><br> //Here is a complete example: using CUBRID.Data.CUBRIDClient; using System.Diagnostics;   namespace TransactionExample {     class Program     {         private static void ExecuteSQL(string sql, CUBRIDConnection conn)         {             using (CUBRIDCommand cmd = new CUBRIDCommand(sql, conn))             {                 cmd.ExecuteNonQuery();             }         }           private static int GetTablesCount(string tableName, CUBRIDConnection conn)         {             int count = 0;             string sql = "select count(*) from db_class where class_name = '" + tableName + "'";               using (CUBRIDCommand cmd = new CUBRIDCommand(sql, conn))             {                 count = (int)cmd.ExecuteScalar();             }               return count;         }           static void Main(string[] args)         {             CUBRIDConnectionStringBuilder sb = new CUBRIDConnectionStringBuilder("localhost", "demodb", "public", "", "33000");             using (CUBRIDConnection conn = new CUBRIDConnection(sb.GetConnectionString()))             {                 conn.Open();                 ExecuteSQL("drop table if exists t", conn);                   conn.BeginTransaction();                   string sql = "create table t(idx integer)";                 using (CUBRIDCommand command = new CUBRIDCommand(sql, conn))                 {                     command.ExecuteNonQuery();                 }                   int tablesCount = GetTablesCount("t", conn);                 Debug.Assert(tablesCount == 1);                   conn.Rollback();                   //Verify the table does not exist                 tablesCount = GetTablesCount("t", conn);                 Debug.Assert(tablesCount == 0);                   conn.BeginTransaction();                   sql = "create table t(idx integer)";                 using (CUBRIDCommand command = new CUBRIDCommand(sql, conn))                 {                     command.ExecuteNonQuery();                 }                   tablesCount = GetTablesCount("t", conn);                 Debug.Assert(tablesCount == 1);                   conn.Commit();                   tablesCount = GetTablesCount("t", conn);                 Debug.Assert(tablesCount == 1);                   conn.BeginTransaction();                   ExecuteSQL("drop table t", conn);                   conn.Commit();                   tablesCount = GetTablesCount("t", conn);                 Debug.Assert(tablesCount == 0);                 conn.Close();             }         }     } }