C# (CSharp) SQL CDBS Examples

Example #1

File: CDBS.cs Project: andreyV512/rag

 public static void Close()
 {
     if (Instance == null)
     {
         return;
     }
     Instance.sqlConnection.Close();
     Instance.sqlConnection.Dispose();
     Instance = null;
 }

Example #2

File: CDBS.cs Project: andreyV512/rag

 public static void RollBack()
 {
     if (Instance == null)
     {
         Instance = new CDBS();
     }
     if (Instance.tr != null)
     {
         Instance.tr.Rollback();
         Instance.tr.Dispose();
         Instance.tr = null;
     }
 }

Example #3

File: CDBS.cs Project: andreyV512/rag

 public static void Commit()
 {
     if (Instance == null)
     {
         Instance = new CDBS();
     }
     if (Instance.tr != null)
     {
         Instance.tr.Commit();
         Instance.tr.Dispose();
         Instance.tr = null;
     }
 }

Example #4

File: CDBS.cs Project: andreyV512/rag

 public static void BeginTransaction()
 {
     if (Instance == null)
     {
         Instance = new CDBS();
     }
     if (Instance.tr != null)
     {
         Instance.tr.Commit();
         Instance.tr.Dispose();
     }
     Instance.tr = Instance.sqlConnection.BeginTransaction();
 }

Example #5

File: CDBS.cs Project: andreyV512/rag

 public static void Create(string _fname_udl)
 {
     Instance = new CDBS(_fname_udl);
 }