Merge pull request sqlkata#419 from sqlkata/fix/get-dictionnary-async…

…-null fix GetDictionaryAsync returns null https://github.com/sqlkata/queryb…
TianCaibailei · Oct 7, 2020 · 4f74f04 · 4f74f04
2 parents 92eaeb0 + 2bcaac1
commit 4f74f04
Showing 1 changed file with 5 additions and 3 deletions.
diff --git a/SqlKata.Execution/QueryFactory.cs b/SqlKata.Execution/QueryFactory.cs
@@ -107,12 +107,14 @@ public IEnumerable<IDictionary<string, object>> GetDictionary(Query query, IDbTr
         {
             var compiled = CompileAndLog(query);
 
-            return this.Connection.Query(
+            var result = this.Connection.Query(
                 compiled.Sql,
                 compiled.NamedBindings,
                 transaction: transaction,
                 commandTimeout: timeout ?? this.QueryTimeout
-            ) as IEnumerable<IDictionary<string, object>>;
+            );
+
+            return result.Cast<IDictionary<string, object>>();
         }
 
         public async Task<IEnumerable<IDictionary<string, object>>> GetDictionaryAsync(Query query, IDbTransaction transaction = null, int? timeout = null)
@@ -126,7 +128,7 @@ public async Task<IEnumerable<IDictionary<string, object>>> GetDictionaryAsync(Q
                 commandTimeout: timeout ?? this.QueryTimeout
             );
 
-            return result as IEnumerable<IDictionary<string, object>>;
+            return result.Cast<IDictionary<string, object>>();
         }
 
         public IEnumerable<dynamic> Get(Query query, IDbTransaction transaction = null, int? timeout = null)