Implement internal OpenConnectionAsync and BeginTransactionAsync

7k8m · 7k8m · commit fb6f3261cc44 · 2020-08-20T14:59:37.000Z
diff --git a/DirectSQL/Database.cs b/DirectSQL/Database.cs
@@ -88,7 +88,7 @@ public async Task<Database<C,T,CMD,R,P>> ProcessAsync(AsyncConnectExecution<C> e
         {
             using (var connection = CreateConnection())
             {
-                connection.Open();
+                await OpenConnectionAsync(connection);
                 await execute(connection);
             }
             return this;
@@ -139,6 +139,25 @@ public Database<C,T,CMD,R,P> Process(SqlExecution<C,T> execute)
         /// <returns></returns>
         protected abstract C CreateConnection();
 
+        /// <summary>
+        /// Open Connection asynchrously
+        /// </summary>
+        private async static Task<C> OpenConnectionAsync(C conn){
+            var task = Task.Run(() => { conn.Open(); });
+            await task;
+            return conn;
+        }
+
+        /// <summary>
+        /// Begin Transaction asynchronously
+        /// </summary>
+        private async static Task<T> BeginTransactionAsync(C conn){
+            T tran = default(T);
+            var task = Task.Run(() => { tran = (T) conn.BeginTransaction();});
+            await task;
+            return tran;
+        }
+
         /// <summary>
         /// Execute a sql like update / insert
         /// </summary>
@@ -747,7 +766,7 @@ public static async Task TransactionAsync(
             C connection, 
             AsyncSqlExecution<C,T> execute)
         {
-            using (var transaction = (T) connection.BeginTransaction())
+            using (var transaction = await BeginTransactionAsync(connection))
             {
                 try
                 {
