I have to implement GetSchemaTable

Anwind

Anwind

Well-known member
Joined
Nov 6, 2021
Messages
48
Programming Experience
1-3
I have to implement GetSchemaTable: 
C#
public class ListDataReader<T> : IDataReader
        where T : class
{
    #region Private fields
    private IEnumerator<T> _iterator;
    private List<PropertyInfo> _properties = new List<PropertyInfo>();
    #endregion

    #region Public properties
    #endregion

    #region Constructors
    public ListDataReader(IEnumerable<T> list)
    {
        this._iterator = list.GetEnumerator();

        _properties.AddRange(
            typeof(T).GetProperties(
                BindingFlags.GetProperty |
                BindingFlags.Instance |
                BindingFlags.Public |
                BindingFlags.DeclaredOnly
                )
            );
    }
    #endregion

    #region IDataReader implementation
    public int Depth { get; }
    public bool IsClosed { get; }
    public int RecordsAffected { get; }

    public void Close()
    {
        _iterator.Dispose();
    }

    public DataTable GetSchemaTable()
    {
        throw new NotImplementedException();
    }

    public bool NextResult()
    {
        throw new NotImplementedException();
    }

    public bool Read()
    {
        return _iterator.MoveNext();
    }
    #endregion

    #region IDisposable implementation
    public void Dispose()
    {
        Close();
    }
    #endregion

    #region IDataRecord
    public string GetName(int i)
    {
        return _properties[i].Name;
    }

    public string GetDataTypeName(int i)
    {
        throw new NotImplementedException();
    }

    public Type GetFieldType(int i)
    {
        return _properties[i].PropertyType;
    }

    public object GetValue(int i)
    {
        return _properties[i].GetValue(_iterator.Current, null);
    }

    public int GetValues(object[] values)
    {
        int numberOfCopiedValues = Math.Max(_properties.Count, values.Length);

        for (int i = 0; i < numberOfCopiedValues; i++)
        {
            values[i] = GetValue(i);
        }

        return numberOfCopiedValues;
    }

    public int GetOrdinal(string name)
    {
        var index = _properties.FindIndex(p => p.Name == name);

        return index;
    }

    public bool GetBoolean(int i)
    {
        return (bool) GetValue(i);
    }

    public byte GetByte(int i)
    {
        return (byte) GetValue(i);
    }

    public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
    {
        throw new NotImplementedException();
    }

    public char GetChar(int i)
    {
        return (char) GetValue(i);
    }

    public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
    {
        throw new NotImplementedException();
    }

    public Guid GetGuid(int i)
    {
        return (Guid) GetValue(i);
    }

    public short GetInt16(int i)
    {
        return (short) GetValue(i);
    }

    public int GetInt32(int i)
    {
        return (int) GetValue(i);
    }

    public long GetInt64(int i)
    {
        return (long) GetValue(i);
    }

    public float GetFloat(int i)
    {
        return (float) GetValue(i);
    }

    public double GetDouble(int i)
    {
        return (double) GetValue(i);
    }

    public string GetString(int i)
    {
        return (string) GetValue(i);
    }

    public decimal GetDecimal(int i)
    {
        return (decimal) GetValue(i);
    }

    public DateTime GetDateTime(int i)
    {
        return (DateTime) GetValue(i);
    }

    public IDataReader GetData(int i)
    {
        throw new NotImplementedException();
    }

    public bool IsDBNull(int i)
    {
        return GetValue(i) == null;
    }

    public int FieldCount
    {
        get { return _properties.Count; }
    }

    object IDataRecord.this[int i]
    {
        get { return GetValue(i); }
    }

    object IDataRecord.this[string name]
    {
        get { return GetValue(GetOrdinal(name)); }
    }
    #endregion
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
public class ListDataReader<T> : IDataReader
        where T : class
{
    #region Private fields
    private IEnumerator<T> _iterator;
    private List<PropertyInfo> _properties = new List<PropertyInfo>();
    #endregion
 
    #region Public properties
    #endregion
 
    #region Constructors
    public ListDataReader(IEnumerable<T> list)
    {
        this._iterator = list.GetEnumerator();
 
        _properties.AddRange(
            typeof(T).GetProperties(
                BindingFlags.GetProperty |
                BindingFlags.Instance |
                BindingFlags.Public |
                BindingFlags.DeclaredOnly
                )
            );
    }
    #endregion
 
    #region IDataReader implementation
    public int Depth { get; }
    public bool IsClosed { get; }
    public int RecordsAffected { get; }
 
    public void Close()
    {
        _iterator.Dispose();
    }
 
    public DataTable GetSchemaTable()
    {
        throw new NotImplementedException();
    }
 
    public bool NextResult()
    {
        throw new NotImplementedException();
    }
 
    public bool Read()
    {
        return _iterator.MoveNext();
    }
    #endregion
 
    #region IDisposable implementation
    public void Dispose()
    {
        Close();
    }
    #endregion
 
    #region IDataRecord
    public string GetName(int i)
    {
        return _properties[i].Name;
    }
 
    public string GetDataTypeName(int i)
    {
        throw new NotImplementedException();
    }
 
    public Type GetFieldType(int i)
    {
        return _properties[i].PropertyType;
    }
 
    public object GetValue(int i)
    {
        return _properties[i].GetValue(_iterator.Current, null);
    }
 
    public int GetValues(object[] values)
    {
        int numberOfCopiedValues = Math.Max(_properties.Count, values.Length);
 
        for (int i = 0; i < numberOfCopiedValues; i++)
        {
            values[i] = GetValue(i);
        }
 
        return numberOfCopiedValues;
    }
 
    public int GetOrdinal(string name)
    {
        var index = _properties.FindIndex(p => p.Name == name);
 
        return index;
    }
 
    public bool GetBoolean(int i)
    {
        return (bool) GetValue(i);
    }
 
    public byte GetByte(int i)
    {
        return (byte) GetValue(i);
    }
 
    public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
    {
        throw new NotImplementedException();
    }
 
    public char GetChar(int i)
    {
        return (char) GetValue(i);
    }
 
    public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
    {
        throw new NotImplementedException();
    }
 
    public Guid GetGuid(int i)
    {
        return (Guid) GetValue(i);
    }
 
    public short GetInt16(int i)
    {
        return (short) GetValue(i);
    }
 
    public int GetInt32(int i)
    {
        return (int) GetValue(i);
    }
 
    public long GetInt64(int i)
    {
        return (long) GetValue(i);
    }
 
    public float GetFloat(int i)
    {
        return (float) GetValue(i);
    }
 
    public double GetDouble(int i)
    {
        return (double) GetValue(i);
    }
 
    public string GetString(int i)
    {
        return (string) GetValue(i);
    }
 
    public decimal GetDecimal(int i)
    {
        return (decimal) GetValue(i);
    }
 
    public DateTime GetDateTime(int i)
    {
        return (DateTime) GetValue(i);
    }
 
    public IDataReader GetData(int i)
    {
        throw new NotImplementedException();
    }
 
    public bool IsDBNull(int i)
    {
        return GetValue(i) == null;
    }
 
    public int FieldCount
    {
        get { return _properties.Count; }
    }
 
    object IDataRecord.this[int i]
    {
        get { return GetValue(i); }
    }
 
    object IDataRecord.this[string name]
    {
        get { return GetValue(GetOrdinal(name)); }
    }
    #endregion
}

C#: 
using (IDataReader reader = new ListDataReader<Client>(clients))
{
    while (reader.Read())
    {
        ...
}


I have to implement GetSchemaTable Function.
Please Teach me. PLEASE...
 
Last edited:
Sort by date Sort by votes
Anwind said:
I have to implement GetSchemaTable: 
C#
public class ListDataReader<T> : IDataReader
        where T : class
{
    #region Private fields
    private IEnumerator<T> _iterator;
    private List<PropertyInfo> _properties = new List<PropertyInfo>();
    #endregion

    #region Public properties
    #endregion

    #region Constructors
    public ListDataReader(IEnumerable<T> list)
    {
        this._iterator = list.GetEnumerator();

        _properties.AddRange(
            typeof(T).GetProperties(
                BindingFlags.GetProperty |
                BindingFlags.Instance |
                BindingFlags.Public |
                BindingFlags.DeclaredOnly
                )
            );
    }
    #endregion

    #region IDataReader implementation
    public int Depth { get; }
    public bool IsClosed { get; }
    public int RecordsAffected { get; }

    public void Close()
    {
        _iterator.Dispose();
    }

    public DataTable GetSchemaTable()
    {
        throw new NotImplementedException();
    }

    public bool NextResult()
    {
        throw new NotImplementedException();
    }

    public bool Read()
    {
        return _iterator.MoveNext();
    }
    #endregion

    #region IDisposable implementation
    public void Dispose()
    {
        Close();
    }
    #endregion

    #region IDataRecord
    public string GetName(int i)
    {
        return _properties[i].Name;
    }

    public string GetDataTypeName(int i)
    {
        throw new NotImplementedException();
    }

    public Type GetFieldType(int i)
    {
        return _properties[i].PropertyType;
    }

    public object GetValue(int i)
    {
        return _properties[i].GetValue(_iterator.Current, null);
    }

    public int GetValues(object[] values)
    {
        int numberOfCopiedValues = Math.Max(_properties.Count, values.Length);

        for (int i = 0; i < numberOfCopiedValues; i++)
        {
            values[i] = GetValue(i);
        }

        return numberOfCopiedValues;
    }

    public int GetOrdinal(string name)
    {
        var index = _properties.FindIndex(p => p.Name == name);

        return index;
    }

    public bool GetBoolean(int i)
    {
        return (bool) GetValue(i);
    }

    public byte GetByte(int i)
    {
        return (byte) GetValue(i);
    }

    public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
    {
        throw new NotImplementedException();
    }

    public char GetChar(int i)
    {
        return (char) GetValue(i);
    }

    public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
    {
        throw new NotImplementedException();
    }

    public Guid GetGuid(int i)
    {
        return (Guid) GetValue(i);
    }

    public short GetInt16(int i)
    {
        return (short) GetValue(i);
    }

    public int GetInt32(int i)
    {
        return (int) GetValue(i);
    }

    public long GetInt64(int i)
    {
        return (long) GetValue(i);
    }

    public float GetFloat(int i)
    {
        return (float) GetValue(i);
    }

    public double GetDouble(int i)
    {
        return (double) GetValue(i);
    }

    public string GetString(int i)
    {
        return (string) GetValue(i);
    }

    public decimal GetDecimal(int i)
    {
        return (decimal) GetValue(i);
    }

    public DateTime GetDateTime(int i)
    {
        return (DateTime) GetValue(i);
    }

    public IDataReader GetData(int i)
    {
        throw new NotImplementedException();
    }

    public bool IsDBNull(int i)
    {
        return GetValue(i) == null;
    }

    public int FieldCount
    {
        get { return _properties.Count; }
    }

    object IDataRecord.this[int i]
    {
        get { return GetValue(i); }
    }

    object IDataRecord.this[string name]
    {
        get { return GetValue(GetOrdinal(name)); }
    }
    #endregion
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
public class ListDataReader<T> : IDataReader
        where T : class
{
    #region Private fields
    private IEnumerator<T> _iterator;
    private List<PropertyInfo> _properties = new List<PropertyInfo>();
    #endregion
 
    #region Public properties
    #endregion
 
    #region Constructors
    public ListDataReader(IEnumerable<T> list)
    {
        this._iterator = list.GetEnumerator();
 
        _properties.AddRange(
            typeof(T).GetProperties(
                BindingFlags.GetProperty |
                BindingFlags.Instance |
                BindingFlags.Public |
                BindingFlags.DeclaredOnly
                )
            );
    }
    #endregion
 
    #region IDataReader implementation
    public int Depth { get; }
    public bool IsClosed { get; }
    public int RecordsAffected { get; }
 
    public void Close()
    {
        _iterator.Dispose();
    }
 
    public DataTable GetSchemaTable()
    {
        throw new NotImplementedException();
    }
 
    public bool NextResult()
    {
        throw new NotImplementedException();
    }
 
    public bool Read()
    {
        return _iterator.MoveNext();
    }
    #endregion
 
    #region IDisposable implementation
    public void Dispose()
    {
        Close();
    }
    #endregion
 
    #region IDataRecord
    public string GetName(int i)
    {
        return _properties[i].Name;
    }
 
    public string GetDataTypeName(int i)
    {
        throw new NotImplementedException();
    }
 
    public Type GetFieldType(int i)
    {
        return _properties[i].PropertyType;
    }
 
    public object GetValue(int i)
    {
        return _properties[i].GetValue(_iterator.Current, null);
    }
 
    public int GetValues(object[] values)
    {
        int numberOfCopiedValues = Math.Max(_properties.Count, values.Length);
 
        for (int i = 0; i < numberOfCopiedValues; i++)
        {
            values[i] = GetValue(i);
        }
 
        return numberOfCopiedValues;
    }
 
    public int GetOrdinal(string name)
    {
        var index = _properties.FindIndex(p => p.Name == name);
 
        return index;
    }
 
    public bool GetBoolean(int i)
    {
        return (bool) GetValue(i);
    }
 
    public byte GetByte(int i)
    {
        return (byte) GetValue(i);
    }
 
    public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
    {
        throw new NotImplementedException();
    }
 
    public char GetChar(int i)
    {
        return (char) GetValue(i);
    }
 
    public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
    {
        throw new NotImplementedException();
    }
 
    public Guid GetGuid(int i)
    {
        return (Guid) GetValue(i);
    }
 
    public short GetInt16(int i)
    {
        return (short) GetValue(i);
    }
 
    public int GetInt32(int i)
    {
        return (int) GetValue(i);
    }
 
    public long GetInt64(int i)
    {
        return (long) GetValue(i);
    }
 
    public float GetFloat(int i)
    {
        return (float) GetValue(i);
    }
 
    public double GetDouble(int i)
    {
        return (double) GetValue(i);
    }
 
    public string GetString(int i)
    {
        return (string) GetValue(i);
    }
 
    public decimal GetDecimal(int i)
    {
        return (decimal) GetValue(i);
    }
 
    public DateTime GetDateTime(int i)
    {
        return (DateTime) GetValue(i);
    }
 
    public IDataReader GetData(int i)
    {
        throw new NotImplementedException();
    }
 
    public bool IsDBNull(int i)
    {
        return GetValue(i) == null;
    }
 
    public int FieldCount
    {
        get { return _properties.Count; }
    }
 
    object IDataRecord.this[int i]
    {
        get { return GetValue(i); }
    }
 
    object IDataRecord.this[string name]
    {
        get { return GetValue(GetOrdinal(name)); }
    }
    #endregion
}

C#: 
using (IDataReader reader = new ListDataReader<Client>(clients))
{
    while (reader.Read())
    {
        ...
}


I have to implement GetSchemaTable Function.
Please Teach me. PLEASE...
Click to expand...

You put little to no effort into looking for the answer, and it is painfully obvious. Why bother learning how to code if you refuse to do the work?
 
Upvote 0 Downvote
What is the actual problem? You should know that every time you say "please teach me" it is so annoying that you make it less likely that anyone will help. I'm giving you one more chance. Don't just dump a big wad of code and say "please teach me". Explain your specific problem. Do you understand what GetSchemaTable is supposed to do? What exactly are you starting with? What do you understand and what not? Have you looked at the implementation for other data readers? Be specific.
 
Upvote 0 Downvote
If a Nissan engineer could just copy and paste code from StackOverflow and put it into multiple Nissan on-screen displays, and get paid big bucks for it, why not other developers? :)
 
Upvote 0 Downvote
I've often said that my co didn't hire a developer, they just hired a semi-intelligent adapter between google and their problem
 
Upvote 0 Downvote

Similar threads

yrstruly
  • Question
C# in Script Task of SSIS
Replies
3
Views
814
yrstruly
yrstruly
SiamIT
  • Question
Issue With Unicode Dictionary
Replies
8
Views
731
SiamIT
SiamIT
E
  • Question
Datagrid Row Edit get value changed and all values.
Replies
3
Views
3K
Skydiver
Skydiver
L
  • Question
Circular reference To a model but needs to Parent in child for display
Replies
4
Views
2K
cjard
cjard
Trol00311
  • Question
Facade design pattern
Replies
2
Views
1K
jmcilhinney
J

Share this page

Latest posts

Back
Top Bottom