2 // DataRowExtensions.cs
5 // Atsushi Enomoto <atsushi@ximian.com>
7 // Copyright (C) 2008 Novell, Inc. http://www.novell.com
11 // Permission is hereby granted, free of charge, to any person obtaining
12 // a copy of this software and associated documentation files (the
13 // "Software"), to deal in the Software without restriction, including
14 // without limitation the rights to use, copy, modify, merge, publish,
15 // distribute, sublicense, and/or sell copies of the Software, and to
16 // permit persons to whom the Software is furnished to do so, subject to
17 // the following conditions:
19 // The above copyright notice and this permission notice shall be
20 // included in all copies or substantial portions of the Software.
22 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
23 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
24 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
25 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
26 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
27 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
28 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
32 using System.Runtime.CompilerServices;
36 public static class DataRowExtensions
38 public static T Field<T> (this DataRow row, int columnIndex)
40 return Field<T> (row, columnIndex, DataRowVersion.Current);
43 public static T Field<T> (this DataRow row, int columnIndex, DataRowVersion version)
45 object ret = row [columnIndex, version];
46 if (ret == DBNull.Value) {
47 Type type = typeof (T);
48 Type genericTypeDef = type.IsGenericType ? type.GetGenericTypeDefinition () : null;
49 if (!type.IsValueType || genericTypeDef != null && genericTypeDef == typeof (Nullable <>))
52 throw new StrongTypingException ("Cannot get strong typed value since it is DB null. Please use a nullable type.", null);
58 public static T Field<T> (this DataRow row, string columnName)
60 return Field<T> (row, columnName, DataRowVersion.Current);
63 public static T Field<T> (this DataRow row, string columnName, DataRowVersion version)
65 return Field<T> (row, row.Table.Columns [columnName], version);
68 public static T Field<T> (this DataRow row, DataColumn column)
70 return Field<T> (row, column, DataRowVersion.Current);
73 public static T Field<T> (this DataRow row, DataColumn column, DataRowVersion version)
75 return Field<T> (row, row.Table.Columns.IndexOf (column), version);
78 public static void SetField<T> (this DataRow row, int columnIndex, T value)
80 row [columnIndex] = value;
83 public static void SetField<T> (this DataRow row, string columnName, T value)
85 row [columnName] = value;
88 public static void SetField<T> (this DataRow row, DataColumn column, T value)