コード例 #1
0
 /// <summary>
 /// Converts collection of keyvaluepair of int and bool for use to pass as table valued parameter.
 /// Stored procedure parameter must be of type tt_int_bit.
 /// </summary>
 /// <param name="values">Dictionary of int and bool</param>
 /// <returns>DictionaryIntStringCollection type that implements IEnumerable SqlDataRecord</returns>
 public static object ToTableType(this IEnumerable <KeyValuePair <int, bool> > values)
 {
     if ((values == null) || (values.Count() == 0))
     {
         return(IntBoolCollection.EmptyTable);
     }
     else
     {
         IntBoolCollection collection = new IntBoolCollection();
         foreach (var item in values)
         {
             collection.Add(item);
         }
         return(collection);
     }
 }
コード例 #2
0
 /// <summary>
 /// Converts dictionary of int and bool for use to pass as table valued parameter.
 /// Stored procedure parameter must be of type tt_int_bit.
 /// </summary>
 /// <param name="values">Dictionary of int and bool</param>
 /// <returns>DictionaryIntStringCollection type that implements IEnumerable SqlDataRecord</returns>
 public static object ToTableType(this Dictionary <int, bool> values)
 {
     if ((values == null) || (values.Count == 0))
     {
         return(IntBoolCollection.EmptyTable);
     }
     else
     {
         IntBoolCollection collection = new IntBoolCollection();
         foreach (var item in values)
         {
             collection.Add(new KeyValuePair <int, bool>(item.Key, item.Value));
         }
         return(collection);
     }
 }