Extended AddParameter to support DataTable objects

JeremyCaney · JeremyCaney · commit 0cd250611a55 · 2020-05-28T16:05:32.000-07:00
This is needed to support user-defined table-valued types in SQL server, as exposed via the new `AttributeValuesDataTable` (313fe71) and `TopicListDataTable` (7a37dc9).
diff --git a/OnTopic.Data.Sql/SqlCommandExtensions.cs b/OnTopic.Data.Sql/SqlCommandExtensions.cs
@@ -81,6 +81,15 @@ internal static void AddParameter(this SqlCommand command, string sqlParameter,
     internal static void AddParameter(this SqlCommand command, string sqlParameter, DateTime fieldValue)
       => AddParameter(command, sqlParameter, fieldValue, SqlDbType.DateTime);
 
+    /// <summary>
+    ///   Wrapper function that adds a SQL parameter to a command object.
+    /// </summary>
+    /// <param name="command">The SQL command object.</param>
+    /// <param name="sqlParameter">The SQL parameter.</param>
+    /// <param name="fieldValue">The SQL field value.</param>
+    internal static void AddParameter(this SqlCommand command, string sqlParameter, DataTable fieldValue)
+      => AddParameter(command, sqlParameter, fieldValue, SqlDbType.Structured);
+
     /// <summary>
     ///   Wrapper function that adds a SQL parameter to a command object.
     /// </summary>
@@ -145,6 +154,7 @@ private static void AddParameter(
           SqlDbType.DateTime    => (DateTime)fieldValue,
           SqlDbType.Int         => (int)fieldValue,
           SqlDbType.Xml         => (string)fieldValue,
+          SqlDbType.Structured  => (DataTable)fieldValue,
           _                     => (string)fieldValue,
         };
       }
