2 // System.Data.SqlClient.DbEnumerator.cs
5 // Tim Coleman (tim@timcoleman.com)
7 // Copyright (C) Tim Coleman, 2002
11 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
13 // Permission is hereby granted, free of charge, to any person obtaining
14 // a copy of this software and associated documentation files (the
15 // "Software"), to deal in the Software without restriction, including
16 // without limitation the rights to use, copy, modify, merge, publish,
17 // distribute, sublicense, and/or sell copies of the Software, and to
18 // permit persons to whom the Software is furnished to do so, subject to
19 // the following conditions:
21 // The above copyright notice and this permission notice shall be
22 // included in all copies or substantial portions of the Software.
24 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
25 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
26 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
27 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
28 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
29 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
30 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
34 using System.Collections;
35 using System.ComponentModel;
38 namespace System.Data.Common {
39 public class DbEnumerator : IEnumerator
46 FieldNameLookup lookup;
53 public DbEnumerator (IDataReader reader)
54 : this (reader, false)
58 public DbEnumerator (IDataReader reader, bool closeReader)
61 this.closeReader = closeReader;
62 this.lookup = new FieldNameLookup ();
63 this.fieldCount = reader.FieldCount;
64 LoadSchema (reader.GetSchemaTable ());
67 #endregion // Constructors
71 public object Current {
73 object[] values = new object[fieldCount];
74 reader.GetValues (values);
75 return new DbDataRecord (schema, values, lookup);
79 #endregion // Properties
83 private void LoadSchema (DataTable schemaTable)
85 schema = new SchemaInfo [fieldCount];
87 foreach (DataRow row in schemaTable.Rows) {
88 SchemaInfo columnSchema = new SchemaInfo ();
90 lookup.Add ((string) row["ColumnName"]);
92 columnSchema.AllowDBNull = (bool) row ["AllowDBNull"];
93 columnSchema.ColumnName = row ["ColumnName"].ToString ();
94 columnSchema.ColumnOrdinal = (int) row ["ColumnOrdinal"];
95 columnSchema.ColumnSize = (int) row ["ColumnSize"];
96 columnSchema.DataTypeName = reader.GetDataTypeName (index);
97 columnSchema.FieldType = reader.GetFieldType (index);
98 columnSchema.IsReadOnly = (bool) row ["IsReadOnly"];
99 columnSchema.TableName = row ["BaseTableName"].ToString ();
101 if (row ["NumericPrecision"] != DBNull.Value)
102 columnSchema.NumericPrecision = Convert.ToByte (row ["NumericPrecision"]);
104 columnSchema.NumericPrecision = Convert.ToByte (0);
106 if (row ["NumericScale"] != DBNull.Value)
107 columnSchema.NumericScale = Convert.ToByte (row ["NumericScale"]);
109 columnSchema.NumericScale = Convert.ToByte (0);
111 schema [index] = columnSchema;
116 public bool MoveNext ()
125 [EditorBrowsable (EditorBrowsableState.Never)]
128 throw new NotSupportedException ();
131 #endregion // Methods