blob: acd1a7f42342d855ab0e29ce7de472c75edc840d (
plain)
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
|
System.Data TODO List
=====================
Update this file as needed...
* To get ExecuteReader() in a SqlCommand object to return
a SqlDataReader object which can Read() data and get a String or
Int32 from the database. Other types can be done later.
A class (SqlDataReader) that implements IDataReader/IDataRecord
only has one row in memory at a time.
In order to do this, we need to compile and edit these classes:
SqlDataReader DataTable DataRowCollection DataRow
DataColumnCollection DataColumn
DataConstraintCollection DataConstraint
DataRelationCollection DataRelation
DataTableCollection
and dependencies...
System.Data.Common classes that need to be implemented:
- implement DataAdapter.cs
- implement DataColumnMapping.cs
- implement DataColumnMappingCollection.cs
- implement DataTableMapping.cs
- implement DataTableMappingCollection.cs
- implement DbDataAdapter.cs
- implement DbDataPermission.cs
- implement DbDataPermissionAttribute.cs
- implement RowUpdatedEventArgs.cs
- implement RowUpdatingEventArgs.cs
The following classes implement InternalDataCollectionBase:
* DataRowCollection
* DataColumnCollection
* DataTableCollection
* DataRelationCollection - an abstract class used by DataTable and DataSet
* ConstraintCollection
DataTableRelationCollection is an internal class that implements DataRelationCollection
and is used by DataTable for parent/child relations. Don't know if it will/will not
be used by DataSet.
Other classes, structs, etc. that are missing:
DataRowView
DataSysDescriptionAttribute
DataViewManager
DataViewSetting
FillErrorEventArgs
MergeFailedEventArgs
TypedDataSetGenerator
The additional System.Data.SqlTypes classes need to be implemented:
SqlByte
SqlDataTime
SqlDecimal
SqlDouble
SqlGuid
SqlInt16
SqlInt64
SqlMoney
SqlSingle
* provide a standard scheme for storing
connection string data
* allow Execute methods in SqlCommand to
call a stored procedure
* Create a script for testing System.Data:
- calls script to create
a test database named monotestdb
- set up nunit for testing System.Data
- set up System.Data.Config or some other
file to hold connection strings and other
configuration settings for the testing System.Data
- any other stuff needed...
* get SqlParameter/SqlParameterCollection
working so you can:
- for queries/commands that have parameters:
o input
o output
o return
o input/output
- call a stored procedure with parameters
* be able to return a XmlReader from
using method ExecuteXmlReader of
a SqlCommand object
* get SqlDataAdapter/DataSet working
* Create Library for PInvoking into libgda
This will be used by System.Data.OleDb classes
* Begin System.Data.OleDb classes:
- OleDbConnection
- OleDbCommand
- OleDbTransaction
* Do more of the OleDb classes to
retrieve a OleDbDataReader object
from a query (SELECT FROM):
- OleDbDataReader
- others...
* Do more OleDb classes for DataSet:
- OleDbDataAdapter
- others...
* Security Audit of System.Data
* Create a MySQL ADO.NET Provider
* Create an Oracle ADO.NET Provider
* Create an Interbase ADO.NET Provider
* Create a Sybase ADO.NET Provider (TDS?)
* Create an IBM UDB DB2 ADO.NET Provider
* Create other ADO.NET providers...
Integration
===========
* get System.Data to work with ASP.NET's
System.Web.UI.WebControls.DataGrid
* get System.Data to work with GUI
System.Windows.Forms.DataGrid
|
