1 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
3 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
5 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
6 ArrayList after releasing the items.
7 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
8 GetOrdinal, GetString): implemented.
9 (GetDataTypeName): made it get the type from the data model, not from
10 the current value, which could not have been retrieved yet.
11 (GetValue): call the Get* method corresponding with the data type of
14 * System.Data.OleDb/libgda.cs: added more libgda functions.
15 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
17 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
18 titles via OleDbDataReader.GetName ().
19 (TestOleDb): create temporary table with a date field.
20 (InsertRow): set current date for the date field.
22 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
24 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
25 GetValue, which will take care of all the work needed.
26 (Close): implemented basic stuff.
27 (~OleDbDataReader): implemented.
29 * System.Data.OleDb/libgda.cs: added more needed functions.
31 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
33 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
35 (TestTransaction): added test for transactions.
37 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
39 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
41 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
42 when there are errors.
43 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
45 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
48 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
50 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
52 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
53 create an empty GdaParameterList.
55 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
56 for NULL before passing them to Marshal.PtrToStructure, which issues
57 an exception if the value is NULL.
59 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
61 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
62 unreachable code to avoid compiler warning.
64 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
66 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
67 (OpenReader): removed internal method.
69 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
70 the list of returned data models.
72 2002-08-15 Franklin Wise <gracenote@earthlink.net>
74 * System.Data/Constraint.cs: Added helper virtual functions
76 * System.Data/ConstraintCollection.cs: Improved constraint removal,
77 validation. Removed specific knowledge of subclasses of
80 * System.Data/DataColumn.cs: Added static helper function to compare
81 if two DataColumn arrays are the same.
83 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
85 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
88 2002-08-13 Franklin Wise <gracenote@earthlink.net>
90 * System.Data/DataRow.cs: Added several fixme tags.
92 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
94 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
95 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
96 to avoid compiler warnings.
98 2002-08-12 Franklin Wise <gracenote@earthlink.net>
100 * System.Data/Constraint.cs: Implemented
102 * System.Data/UniqueConstraint.cs: GetHashCode() &
103 special case Ctor. Still need to be implemented. LAMESPEC tags
106 * System.Data/ConstraintCollection.cs: Clear() &
107 AddRange() need to be finished. Several LAMESPEC tags.
109 * Allow Constraint collection to be created in DataTable.
111 * System.Data/ForeignKeyConstraint: Added a couple of
114 * System.Data/DataColumnCollection New/Added DataColumns now have
117 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
119 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
121 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
122 internal method, since we don't need it.
123 (ExecuteReader): call SetupGdaCommand before executing the command
124 via libgda functions.
125 (ExecuteScalar): implemented.
127 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
128 to OleDbCommand.OpenReader.
129 (GetBoolean): implemented.
131 2002-08-08 Franklin Wise <gracenote@earthlink.net>
133 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
135 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
137 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
140 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
142 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
143 and don't show a warning in Open.
145 * System.Data.OleDb/TestOleDb.cs: added Close.
147 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
149 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
150 ConnectionTimeout, ServerVersion, GdaConnection):
152 (OleDbConnection): call libgda.gda_init on constructor.
154 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
155 which wasn't been called.
157 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
160 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
162 * list: added missing System.Data.OleDb and
163 System.Data.Common files.
165 * System.Data.OleDb/ChangeLog: removed and merged with
166 System.Data's ChangeLog.
168 * System.Data.OleDb/OleDbDataAdapter.cs:
169 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
171 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
173 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
174 (IsClosed, Item, RecordsAffected): implemented some properties.
176 * libgda.cs: added GdaDataModel methods.
178 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
180 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
181 a second argument (ArrayList results).
182 (NextResult): implemented.
184 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
185 pass that to the OleDbDataReader.
186 (OleDbCommand constructor): don't create the ArrayList of results.
187 (GdaResults): removed property.
188 (ExecuteReader): create a temporary ArrayList and pass that to the
189 OleDbDataReader constructor.
191 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
193 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
194 (CreateParameter): implemented IDbCommand methods.
195 (CommandText): don't create many GdaCommand's, only one is needed.
196 (ExecuteNonQuery): set up the internal GDA command object.
197 (ExecuteReader): use correctly the unique GDA command object.
199 * System.Data.OleDb/libgda.cs: added new libgda calls.
201 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
203 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
204 (BeginTransaction): implemented IDbConnection methods.
206 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
208 * list: added System.Data.OleDb files to file list.
210 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
212 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
214 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
215 of the set method for this property.
217 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
218 (MissingSchemaAction): implemented.
220 2002-07-10 Tim Coleman <tim@timcoleman.com>
222 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
223 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
224 * System.Data.OleDb/OleDbError.cs: Added stubbs
225 * System.Data.OleDb/OleDbException.cs: Added stubbs
226 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
227 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
228 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
229 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
230 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
231 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
232 support transaction nesting
233 * System.Data.OleDb/libgda.cs: Added my name to this file
235 2002-07-09 Tim Coleman <tim@timcoleman.com>
237 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
238 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
239 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
240 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
241 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
242 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
243 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
244 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
245 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
246 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
247 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
248 * System.Data.OleDb/OleDbType.cs: Fixed two typos
249 * System.Data.OleDb/libgda.cs: Style changes, added new methods
251 2002-07-09 Tim Coleman <tim@timcoleman.com>
253 * System.Data.build: remove restriction on System.Data.OleDb build
255 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
257 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
258 IsSynchronized): implemented.
260 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
262 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
264 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
265 (Parameters, Transaction, Connection): made these overload
268 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
269 call m_list methods, not own ones.
271 * System.Data.OleDb/OleDbParameter.cs: more implementation.
273 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
275 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
276 Commit, Rollback): implemented.
277 (GdaConnection): added new internal property.
279 * System.Data.OleDb/OleDbParameter.cs:
280 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
283 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
285 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
287 * System.Data.OleDb/libgda.cs: added new libgda API functions.
289 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
290 (BeginTransaction): made it overload IDbConnection methods.
291 (ChangeDatabase): new stub, needs some work on libgda for being
294 (Close): implemented.
295 (CreateCommand): implemented.
296 (GetOleDbSchemaTable): new stub, until I understand what to do here.
297 (Open): implemented basic stuff, which is just supporting connection
298 strings that represent a GDA data source name. More to come.
299 (InfoMessage, StateChange): added events.
301 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
303 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
305 * System.Data.OleDb/libgda.cs: added static constructor.
306 (GdaClient): new static property to get the underlying GdaClient
309 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
310 the static 'libgda' class.
312 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
314 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
316 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
317 (ConnectionString, Connectiontimeout, Database, State):
318 implemented class properties.
319 (BeginTransaction): implemented.
321 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
323 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
325 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
327 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
329 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
331 * list: added missing PostgresTypes.cs file.
333 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
335 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
338 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
340 * System.Data.SqlClient/SqlConnection.cs: modifed -
341 start to implement the interfaces properly and
342 properly doing a Close(), Dispose(), and
345 * Test/SqlSharpCli.cs: modified -
346 add support for MySQL in Mono.Data.MySql
347 and OleDb support in System.Data.OleDb. However,
348 the OleDb support is commented right now.
349 When the program starts up, a shorter help menu should
350 display the most important commands: help and quit
352 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
354 * System.Data.build: exclude System.Data.OleDb files.
356 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
358 * System.Data.SqlClient/SqlCommand.cs: typo
359 should be CommandBehavior.KeyInfo
361 * Test/SqlSharpCli.cs: refactored and added a few more
364 2002-05-27 Tim Coleman <tim@timcoleman.com>
365 * list: update to compile properly (add missing
366 files and switch path delimiter from '\' to '/').
368 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
370 * System.Data/DataRow.cs
371 * System.Data.Common/DbDataAdapter.cs: fix to
372 get Test/TestSqlDataAdapter.cs to work again
374 * Test/TestSqlDataAdapter.cs: removed comment
375 about SqlDataReader:NextResult() not being implemented; it
378 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
380 * System.Data/DataRow.cs: modified
381 support setting of DBNull.Value
382 using the Item indexer this[DataColumn]
384 * System.Data.SqlClient/SqlCommand.cs: modified
385 tweaks to show TODO's for other CommandBehavior.
386 Set AllowDBNull column to true for IsKey row
389 * System.Data.SqlClient/SqlConnection.cs: modified
390 if transaction is in progress when a Close() is called,
391 do a transaction Rollback.
393 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
395 * Test/SqlSharpCli.cs: added file
396 My new toy. SQL# is a command-line tool to enter
397 SQL commands and queries using Mono System.Data.
398 It also serves as a test for Mono System.Data.
400 * System.Data.SqlClient/SqlCommand.cs: modified
401 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
402 should handle the results from SQL Commands and Queries.
403 - Internal class SqlResult should not create schema Table
404 for the result from a SQL Command. Also, set the RecordsRetrieved
405 property for SqlDataReader.
406 - Closing the SqlDataReader should Close() the SqlConnection for
407 a CommandBehavior.CloseConnection.
408 - Set defaults for SqlResult
410 * System.Data.SqlClient/SqlConnection.cs: modified -
411 when SqlDataReader is Close()
412 should Close() the SqlConnection for
413 a CommandBehavior.CloseConnection. Changed internal Property
414 from OpenReader get/set to IsReaderOpen get and created
415 internal methods OpenReader()/CloseReader() for SqlCommand to call.
416 SqlConnection needs to be prevented from doing while SqlDataReader
419 * System.Data.SqlClient/SqlDataReader.cs: modified -
420 call SqlCommand's OpenReader() internal method. get
421 RecordsRetrieved from SqlResult. set/reset default
422 values for SqlDataReader.
424 * Test/PostgresTest.cs
425 * Test/TestExecuteScalar.cs
426 * Test/TestSqlDataReader.cs: modified
427 for the Execute...() methods in SqlCommand
428 to test SQL Queries and Commands
430 * Test/System.Data_test.build: modified
431 exclude new file Test/SqlSharpCli.cs from
434 2002-05-24 Tim Coleman <tim@timcoleman.com>
435 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
436 for get accessors. These should be implemented in derived classes. See
437 SqlDataAdapter for clues.
438 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
439 * System.Data.Common/DataAdapter.cs:
440 * System.Data.Common/DataTableMappingCollection.cs:
441 * System.Data.Common/DataTableMapping.cs:
442 * System.Data.Common/DataColumnMappingCollection.cs:
443 * System.Data.Common/DataColumnMapping.cs:
444 Properly (I hope!) implement all of the appropriate interfaces
448 2002-05-23 Tim Coleman <tim@timcoleman.com>
449 * System.Data.SqlClient/SqlCommand.cs: include
450 the BaseColumnName in the schema table. Was missed before.
451 * System.Data.Common/DbDataAdapter.cs: Use DataTable
452 mappings so that the DataSet and DataTable are more closely tied.
453 Get schema information from the DataTable using GetSchemaTable ()
454 Various other little fixes
455 * System.Data.Common/DataColumnMappingCollection.cs:
456 * System.Data.Common/DataTableMapping.cs:
457 * System.Data.Common/DataTableMappingCollection.cs: Some
458 implementation, enough to be used by DbDataAdapter.
460 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
462 * System.Data.SqlClient/SqlCommand.cs: set
463 the "ProviderType" to the PostgreSQL type oid
465 * System.Data.SqlClient/SqlDataReader.cs: fix
466 for various properties and methods that
467 return meta data: Item indexers this[name] and this[index],
468 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
471 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
473 * System.Data/DataRow.cs: change suggested
474 by tim: in Item indexer, do an EndEdit()
476 * System.Data.SqlClient/SqlCommand.cs: more
477 fixes to SqlResult. After setting each item in
478 the DataRow, do an AcceptChanges() to commit
479 the changes in the DataRow. For DataType, use a Type
480 of System.String since System.Type nor System.Object
483 * Test/TestSqlDataReader.cs
484 * Test/PostgresTest.cs: updated to to be on
485 the way schema table is suppose to work
487 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
489 * System.Data.SqlClient/SqlCommand.cs: more work on
490 building the schema table
492 2002-05-22 Tim Coleman <tim@timcoleman.com>
493 * System.Data.SqlClient/SqlCommand.cs: preliminary work
494 on getting the schema table correctly built.
496 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
498 * System.Data.SqlClient/ParmUtil.cs: added file - to
499 provide utility for conversion of input parameters
501 * System.Data.SqlClient/PostgresTypes.cs: added file -
502 moved the PostgreHelper class to here. May eventually
503 move the internal class PostgresTypes that's inside the
504 SqlConnection to here as well.
505 Handling of PostgreSQL <-> .NET types need to be though
506 out more. Also, the PostgreHelper has a method to convert
507 from .NET types to a string which can be put into used in
508 an SQL statement to execute against a PostgreSQL database.
509 This is the beginnings of parameters support. It currently
510 only supports input parameters. Still need to do output,
511 input/output, and return parameters.
513 * Test/TestSqlParameters.cs: new test to test the input
514 parameters in System.Data.SqlClient against a
517 * System.Data.SqlClient/PostgresLibrary.cs: moved
518 PostgresHelper class to file PostgresTypes.cs. Also
519 moved struct PostgresType there too.
521 * System.Data.SqlClient/SqlCommand.cs: added input
524 * System.Data.SqlClient/SqlParameter.cs: got
527 * System.Data.SqlClient/SqlParameterCollection.cs: got
528 SqlParameterCollection to work
530 * Test/System.Data_test.build: added files to exclude
533 * System.Data.SqlClient/SqlConnection.cs: release resources
536 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
538 * System.Xml: added directory for classes with namespace
539 System.Xml to go into the System.Data.dll assembly
541 * System.Xml/XmlDataDocument: added file
542 for stubbed concrete class XmlDataDocument which
543 inherits from XmlDocument. Its purpose is to provide
544 a W3C XML DOM Document for relational data and interacting
547 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
549 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
550 Text, TableDirect, and StoredProcedure
552 * Test/PostgresTest.cs: changed call to version()
553 stored procedure to use the CommandType of StoredProcedure
555 * Test/TestSqlDataReader.cs: test all the CommandTypes
557 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
559 * System.Data.build: took out all excluded
560 files except the ones in the Test directory
561 because all files compile now. It does not
562 mean they all work or have implementations
565 * System.Data/DataRelationCollection.cs
566 * System.Data/DataTableRelationCollection.cs
567 * System.Data/InternalDataCollectionBase.cs
568 * System.Data.Common/DbDataPermission.cs
569 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
570 * System.Data.SqlClient/SqlClientPermission.cs
571 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
572 to get all System.Data* files to compile.
574 * System.Data.SqlClient/SqlCommand.cs: started coding
575 to prevent SqlConnection and SqlCommand from doing
576 anyting while fetching data using SqlDataReader. Also,
577 started coding to undo this prevention once the
578 SqlDataReader is closed.
580 * System.Data.SqlClient/SqlConnection.cs: get database server
581 version. Started coding to prevent connection from
582 doing anything while fetching data and undo once the reader
583 is closed. Include events SqlInfoMessage and StateChange.
585 * System.Data.SqlClient/SqlDataReader.cs: start coding to
586 prevent connection and command from doing anything while
587 fetching data, and undo when closed.
589 * Test/PostgresTest.cs: added test to get ServerVersion
590 property from SqlConnection
592 2002-05-18 Tim Coleman <tim@timcoleman.com>
593 * System.Data/DataRow.cs: More implementation,
594 as well as boundary checks and small semantic
597 2002-05-18 Tim Coleman <tim@timcoleman.com>
598 * System.Data/DataRow.cs: Try to reduce memory
599 usage by only creating the original and proposed
600 arrays as required in BeginEdit, and then destroying
601 proposed during EndEdit, and original during AcceptChanges.
602 * System.Data.Common/DbDataAdapter.cs: Make the
603 startRecord and maxRecords parameters work correctly.
605 2002-05-18 Tim Coleman <tim@timcoleman.com>
606 * System.Data/DataRow.cs: Move the null check in
607 ItemArray set to above the Invalid Cast check, so
608 that we don't get null reference exceptions.
610 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
612 * System.Data.SqlClient/PostgresLibrary.cs: handle
613 data value from database being NULL
615 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
616 allow multiple result sets. Added new internal class
617 SqlResult to pass result set data from SqlCommand
620 * System.Data.SqlClient/SqlDataReader.cs: allow
621 multiple result sets.
623 * System.Data.SqlClient/SqlConnection.cs: moved
624 things around. Implement IDisposable.
626 * Test/TestSqlDataReader.cs: test for execution
627 of multiple result sets and display the results
628 of these multiple results sets
630 * Test/TestSqlDataAdapter.cs: tweaks
632 2002-05-17 Tim Coleman <tim@timcoleman.com>
633 * System.Data.Common/DbDataAdapter.cs:
634 - More implementation of Fill methods
635 - Get rid of isDirty flag, because we can just check
637 - Do *not* remove DataTables before Filling them
638 - Implicitly open the connection before doing a Fill
639 if it does not exist.
640 * System.Data.SqlClient/SqlDataAdapter.cs:
642 * System.Data/DataTableCollection.cs:
643 - Add DataSet to internal, undocumented constructor
644 - When a table is created, set its DataSet property
645 - Default table name for creation is "Table1" (see .NET)
646 - Inherit the ArrayList list from InternalDataCollecitonBase
647 and maintain a hashtable between table names and
649 * System.Data/DataTable.cs:
650 - Add internal dataSet field. This is used by
651 DataTableCollection when the DataTable is constructed.
652 * System.Data/DataSet.cs:
653 - Pass a reference to the DataSet when constructing the
656 2002-05-16 Tim Coleman <tim@timcoleman.com>
657 * System.Data.Common/DbDataAdapter.cs:
658 Use table.Rows.Add (itemArray) instead of
659 table.Rows.Add (thisRow) to provide better
661 * System.Data/DataRowCollection.cs:
662 Some implementation of this class.
663 * System.Data/InternalDataCollectionBase.cs:
664 Some implementation. Most notably, this now
665 has an enumerator so we can use foreach (DataRow row in table.Rows)
667 * System.Data/DataTable.cs:
668 Since DataRowCollection now accepts a DataTable in
669 its internal constructor, we must pass one in.
671 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
673 * Test/TestSqlDataAdapter.cs: added new test
674 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
675 DataRowCollection, and DataRow. It tests retrieving data
676 based on a SQL SELECT query. This test is based on Tim Coleman's
679 2002-05-16 Tim Coleman <tim@timcoleman.com>
680 * System.Data.Common/DbDataAdapter.cs:
681 Use table.Rows.Add (thisRow) instead of
682 table.ImportRow (thisRow)
683 * System.Data/DataRowCollection.cs:
684 Construct the ArrayList before using it
686 2002-05-16 Tim Coleman <tim@timcoleman.com>
687 * System.Data/DataTable.cs:
688 Construct the DataRowCollection in the DataTable
689 constructor. Otherwise, it's a null reference.
691 2002-05-16 Tim Coleman <tim@timcoleman.com>
692 * System.Data.SqlClient/SqlDataReader.cs:
693 Modify GetValues to use Array.Copy() to copy
694 the results from fields to values, rather than
695 an assignment, which results in loss of data.
697 2002-05-16 Tim Coleman <tim@timcoleman.com>
698 * System.Data/DataRow.cs:
699 More implementation and documentation. It should
700 work more like expected, although there is no way
701 to demonstrate this well yet. DataTable requires
704 2002-05-15 Tim Coleman <tim@timcoleman.com>
705 * System.Data/DataRow.cs:
706 Minor tweaks as I determine exactly how to
707 implement this class.
710 2002-05-14 Duncan Mak <duncan@ximian.com>
712 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
714 2002-05-14 Tim Coleman
715 * System.Data/DataRow.cs:
716 * System.Data/DataRowBuilder.cs:
717 * System.Data/DataTable.cs:
718 More implementation of these classes. DataRow
719 can now (possibly) do some useful things.
720 Still not sure what DataRowBuilder is all about,
721 other than passing a DataTable in.
723 2002-05-14 Tim Coleman
724 * System.Data/DataRowBuilder.cs:
725 Add stubb for this internal class.
727 2002-05-13 Tim Coleman
728 * System.Data.Common/DbDataAdapter.cs:
729 The maxRecords check was not correct.
731 2002-05-13 Tim Coleman
732 * System.Data/DataTableCollection.cs:
733 Fix an issue when adding a DataTable and size == 0.
734 Now explicitly checks if size > 0 before doing Array.Copy ()
735 * System.Data.Common/DbDataAdapter.cs:
736 Move closer to a working implementation.
737 Make the IDbCommand fields protected so that they can
739 * System.Data.SqlClient/SqlDataAdapter.cs:
740 This should inherit the IDbCommands instead of having its
741 own. An explicit cast is used to force conversion between
742 IDbCommand and SqlCommand
744 2002-05-13 Tim Coleman
745 * System.Data.Common/DataTableMappingCollection.cs:
746 Some implementation to allow progress with DbDataAdapter
748 2002-05-13 Tim Coleman
749 * System.Data.Common/DbDataAdapter.cs:
750 Modify to not break compile.
752 2002-05-13 Tim Coleman
754 include SqlDataAdapter, SqlRowUpdatedEventArgs,
755 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
756 SqlRowUpdatingEventHandler in the build.
758 2002-05-13 Tim Coleman
759 * System.Data.Common/DbDataAdapter.cs:
761 * System.Data.Common/DataAdapter.cs:
762 Correction of some of the stubbing, as well as a
763 little bit more implementation
765 2002-05-11 Tim Coleman
766 * System.Data.SqlClient/SqlDataAdapter.cs:
767 * System.Data.Common/DbDataAdapter.cs:
768 Moved methods that weren't supposed to
769 be in SqlDataAdapter out. They should be implemented
773 2002-05-11 Tim Coleman
774 * System.Data.SqlClient/SqlDataAdapter.cs:
775 some implementation of this class. Note
776 that none of the functionality has been
777 tested yet, but I felt it should be checked
778 in at this point as it compiles.
779 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
780 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
781 Modified so that they will compile properly.
782 Needed to include SqlDataAdapter in the build.
784 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
786 * System.Data/DataTable.cs (Clear): implemented.
787 (DataTable): removed repeated code in constructors, and call the
788 basic constructor from the others.
790 * System.Data/DataColumn.cs: some tweaks.
792 * System.Data/DataRow.cs (RowState): implemented.
793 (CancelEdit): set rowState property back to Unchanged.
794 (RejectChanges): call CancelEdit.
795 (Delete): set rowState to Deleted.
797 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
799 * System.Data.build: added copy of System.Data.dll to Test directory
800 for easy testing. Also, added clean for it too.
802 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
803 from PostgreSQL data type to .NET type.
805 * System.Data.SqlClient/SqlDataReader.cs: beginnings
806 handling of a NULL value from the database
808 * Test/PostgresTest.cs: added tests for NULL values retrieved
811 * Test/ReadPostgresData.cs
812 * Test/TestExecuteScalar.cs
813 * Test/TestSqlDataReader.cs
814 * Test/TestSqlException.cs
815 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
816 "postgres". These tests may eventually be removed since they
819 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
821 * System.Data.build: removed reference to non-existant
822 TestDataColumn.cs file.
824 * System.Data/DataSet.cs: added some implementation.
826 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
828 * System.Data.SqlClient/PostgresLibrary.cs: got
829 PostgreSQL data types time, date, timestamp (DateTime like)
830 mapped to .NET System.DateTime working based
831 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
832 Also mapped pg type boolean to .net Boolean
834 * SqlClient/SqlConnection.cs: run SQL command to set
837 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
838 added tests for aggregates min(), max(), sum(), count(). could
839 not get avg() to work due to some formatting error; someone claimed
840 that it was my locale settings. added tests for SELECT of columns
841 of type boolean, float, double, date, time, and timestamp. They
842 have not been fully tested, but its a start.
844 2002-05-09 Tim Coleman <tim@timcoleman.com>
845 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
846 addition, subtraction, and multiplication for the
847 SqlDecimal type, as well as modification of some other
848 operations. More to come on this one.
850 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
852 * Test/System.Data_test.build: excluded TestDataColumn, which
853 should be replaced with a nunit test.
855 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
857 2002-05-07 Tim Coleman <tim@timcoleman.com>
871 Fix the broken build I made before. Bad
874 2002-05-07 Tim Coleman <tim@timcoleman.com>
876 Fix a symantic error I made in SqlString
877 Equals where I copied and pasted wrongly
879 2002-05-07 Tim Coleman <tim@timcoleman.com>
884 * SqlCompareOptions.cs:
895 Implement CompareTo, Equals, and String conversions
898 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
900 * Test/PostgresTest.cs: modified to run completely. There
901 are many TODOs in System.Data, so not all data types are
902 included in the SELECT SQL query. Also, I made it to where
904 using "host=localhost;dbname=test;user=postgres"
905 instead of my userid and password. When more types are included,
908 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
910 * Test/PostgresTest.cs: added - ported
911 libgda postgres-test.c originally by
912 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
915 2002-05-05 Tim Coleman <tim@timcoleman.com>
916 * System.Data.SqlTypes/SqlBinary.cs:
917 * System.Data.SqlTypes/SqlBoolean.cs:
918 * System.Data.SqlTypes/SqlByte.cs:
919 * System.Data.SqlTypes/SqlDateTime.cs:
920 * System.Data.SqlTypes/SqlDecimal.cs:
921 * System.Data.SqlTypes/SqlDouble.cs:
922 * System.Data.SqlTypes/SqlGuid.cs:
923 * System.Data.SqlTypes/SqlInt16.cs:
924 * System.Data.SqlTypes/SqlInt32.cs:
925 * System.Data.SqlTypes/SqlInt64.cs:
926 * System.Data.SqlTypes/SqlMoney.cs:
927 * System.Data.SqlTypes/SqlSingle.cs:
928 * System.Data.SqlTypes/SqlString.cs:
929 More implementation, and code clean-up for consistency.
930 Also, I had implemented many conversions as explicit
931 that should have been implicit. This should remove
932 many of the red X's and green pluses from the
933 System.Data.SqlTypes namespace.
935 2002-05-05 Miguel de Icaza <miguel@ximian.com>
937 * System.Data/DataSet.cs: Remove [Serializable] attributes from
938 methods, those only apply to structs or classes.
940 Stub out ISerializable, ISupportInitialize, and IListSource methods
942 * System.Data/DataRowView.cs: Stub out interface methods for
943 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
945 * System.Data/DataView.cs: Comment out non-implemented
948 * System.Data/DataViewSettingsCollection.cs: Type cast variables
949 to the correct type to make it compile.
951 * System.Data/DataViewSettings.cs: remove reference to
952 non-existance type ApplyDefaultSort, it is a boolean.
955 2002-05-05 Tim Coleman <tim@timcoleman.com>
956 * System.Data.SqlTypes/SqlBinary.cs:
957 * System.Data.SqlTypes/SqlBoolean.cs:
958 * System.Data.SqlTypes/SqlByte.cs:
959 * System.Data.SqlTypes/SqlDecimal.cs:
960 * System.Data.SqlTypes/SqlDouble.cs:
961 * System.Data.SqlTypes/SqlGuid.cs:
962 * System.Data.SqlTypes/SqlInt16.cs:
963 * System.Data.SqlTypes/SqlInt32.cs:
964 * System.Data.SqlTypes/SqlInt64.cs:
965 * System.Data.SqlTypes/SqlMoney.cs:
966 * System.Data.SqlTypes/SqlSingle.cs:
967 * System.Data.SqlTypes/SqlString.cs:
968 Various fixes, including adding the SqlNullValueException
969 when trying to retrieve the value of a null SqlType,
970 and when casting values, a Null of type A converts to a
973 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
975 * System.Data.SqlClient/PostgresLibrary.cs
976 * System.Data.SqlClient/SqlCommand.cs
977 * System.Data.SqlClient/SqlConnection.cs
978 * System.Data.SqlClient/SqlDataReader.cs
979 oid should not be hard coded because they
980 can change from one version of PostgreSQL
981 to the next. Use the typname's instead.
982 The PostgreSQL type data retrieves
983 at database connection time. Any unimplemented
984 types just default to string. These were things
985 suggested by Gonzalo.
987 * Test/ReadPostgresData.cs - stuff
988 * Test/TestSqlDataReader.cs - stuff
990 * System.Data.SqlTypes/SqlInt32.cs - added a using
992 2002-05-03 Tim Coleman <tim@timcoleman.com>
993 * System.Data.build: Fix the build so that test depends on build
995 2002-05-03 Tim Coleman <tim@timcoleman.com>
996 * System.Data.SqlTypes/SqlByte.cs:
997 * System.Data.SqlTypes/SqlDateTime.cs:
998 * System.Data.SqlTypes/SqlDecimal.cs:
999 * System.Data.SqlTypes/SqlDouble.cs:
1000 * System.Data.SqlTypes/SqlGuid.cs:
1001 * System.Data.SqlTypes/SqlInt16.cs:
1002 * System.Data.SqlTypes/SqlInt64.cs:
1003 * System.Data.SqlTypes/SqlMoney.cs:
1004 * System.Data.SqlTypes/SqlSingle.cs:
1005 These files were mysteriously excluded from the last
1006 patch I made and sent to Rodrigo
1007 * System.Data.build: include the System.Data.SqlTypes in the build
1009 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1011 * System.Data.build: removed comments
1013 * System.Data.SqlClient/PostgresLibrary.cs: changed
1014 the hard-coded PostgreSQL oid type int's to using an
1015 enum. Also, added PostgreSQL bpchar (character) type.
1017 * Test/TestSqlDataReader.cs: updated test
1018 to include new bpchar PostgreSQL type
1020 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1022 * System.Data.SqlTypes/SqlBinary.cs:
1023 * System.Data.SqlTypes/SqlBoolean.cs:
1024 * System.Data.SqlTypes/SqlInt32.cs:
1025 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1026 Tim Coleman <tcoleman@opentext.com>.
1028 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1030 * Test/TestExecuteScalar.cs: added test for
1031 method ExecuteScalar in class SqlCommand.
1033 * System.Data/DataColumnCollection.cs - it should
1034 inherit properties from base InternalDataCollectionBase
1035 and use them instead of overriding them, such as, List.
1037 * System.Data/DataColumn.cs
1038 * System.Data/DataTable.cs: tweaks to retrieve
1039 meta data from the database
1041 * System.Data.SqlClient/PostgresLibrary.cs -
1042 added method OidToType to convert PostgreSQL oid type
1043 to System.Type. Renamed method OidTypeToSystem
1044 to ConvertPgTypeToSystem for converting the data value
1045 from a PostgreSQL type to a .NET System type.
1047 * System.Data.SqlClient/SqlCommand.cs: implemented
1048 method ExecuteReader which returns a SqlDataReader
1049 for a light forward only read only result set.
1050 It works on types int4 ==> Int32 and
1051 varchar ==> String. Other types
1054 * System.Data.SqlClient/SqlConnection.cs: added comment
1056 * System.Data.SqlClient/SqlDataReader.cs: implemented
1057 class. It works, but still lots to do.
1059 * Test/ReadPostgresData.cs: stuff
1061 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1062 to display meta data and the data
1064 2002-05-03 Duncan Mak <duncan@ximian.com>
1066 * TODO: Took out all the Exceptions. They should be all done now.
1068 * System.Data/ConstraintException.cs:
1069 * System.Data/DBConcurrencyException.cs:
1070 * System.Data/DataException.cs:
1071 * System.Data/DeletedRowInaccessibleException.cs:
1072 * System.Data/DuplicateNameException.cs:
1073 * System.Data/EvaluateException.cs:
1074 * System.Data/InRowChangingEventException.cs:
1075 * System.Data/InvalidConstraintException.cs:
1076 * System.Data/InvalidExpressionException.cs:
1077 * System.Data/MissingPrimaryKeyException.cs:
1078 * System.Data/NoNullAllowedException.cs:
1079 * System.Data/ReadOnlyException.cs:
1080 * System.Data/RowNotInTableException.cs:
1081 * System.Data/StrongTypingException.cs:
1082 * System.Data/SyntaxErrorException.cs:
1083 * System.Data/TypeDataSetGeneratorException.cs:
1084 * System.Data/VersionNotFoundException.cs: Added to CVS.
1086 * System.Data.SqlTypes/SqlNullValueException.cs:
1087 * System.Data.SqlTypes/SqlTruncateException.cs:
1088 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1090 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1092 * System.Data/DataViewSettingCollection.cs: implemented.
1094 * System.Data/DataRowView.cs: new stubs.
1096 * System.Data.SqlTypes/SqlByte.cs:
1097 * System.Data.SqlTypes/SqlDateTime.cs:
1098 * System.Data.SqlTypes/SqlDecimal.cs:
1099 * System.Data.SqlTypes/SqlDouble.cs:
1100 * System.Data.SqlTypes/SqlGuid.cs:
1101 * System.Data.SqlTypes/SqlInt16.cs:
1102 * System.Data.SqlTypes/SqlInt64.cs:
1103 * System.Data.SqlTypes/SqlMoney.cs:
1104 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1105 by Tim Coleman <tcoleman@opentext.com>
1107 * System.Data.build: excluded newly-added files.
1109 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1111 * System.Data.SqlClient/PostgresLibrary.cs: included new
1112 internal class that will be a helper class in using
1113 PostgreSQL. PostgresLibrary is used for the
1114 pinvoke methods to the PostgreSQL Client
1115 native C library libpq while the class PostgresHelper
1116 is used for wrapper or helper methods. It currently only
1117 has one static method OidTypeToSystem in converting
1118 PostgreSQL types to .NET System.<type>s, such as,
1119 a PostgreSQL int8 becomes a .NET System.Int64.
1120 Only a few types have been added, such as, int2,
1121 int4, int8, varchar, text, bool, and char. Other types
1124 * System.Data.SqlClient/SqlCommand.cs: implemented
1125 method ExecuteScalar which allows us to do aggregate
1126 functions, such as, count, avg, min, max, and sum. We
1127 also are able to retrieve the result, convert it to the .NET type
1128 as an object. The user of the returned object must explicitly cast.
1130 * Test/ReadPostgresData.cs: updated sample
1131 to help us learn to retrieve data in System.Data.SqlClient
1134 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1136 * System.Data.build: added /nowarn: nnnn arguments
1137 so you will not get a ton of warnings. The warnings
1138 being excluded are: 1595, 0067, 0109, 0169, and 0649
1140 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1142 * System.Data.build: modified to exclude more
1143 files from the build
1145 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1147 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1150 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1151 by John Dugaw <jdugaw@unizenconsulting.com>.
1153 * System.Data.build: excluded new files from build.
1155 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1157 * Test/ReadPostgresData.cs: added - Uses the
1158 PostgresLibrary to retrieve a recordset.
1159 This is not meant to be used in Production, but as a
1160 learning aid in coding
1161 class System.Data.SqlClient.SqlDataReader.
1162 This sample does work.
1164 * Test/TestSqlDataReader.cs: added - used
1165 to test SqlDataReader (does not work yet)
1166 Forgot to add to ChangeLog on last commit.
1168 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1170 * System.Data/DataViewSetting.cs: new class.
1172 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1174 * System.Data/DataViewManager.cs: new class.
1176 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1177 don't have implementation.
1179 * System.Data.SqlTypes/SqlInt32.cs:
1180 * System.Data.SqlTypes/SqlString.cs:
1181 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1182 these are strctures.
1184 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1187 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1189 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1190 for correctly hiding parent class' members.
1191 (AddRange): use 'override' keyword on overriden method.
1193 (Contains): likewise.
1194 (IndexOf): likewise.
1195 (OnCollectionChanged): likewise.
1196 (OnCollectionChanging): likewise.
1197 (RemoveCore): likewise.
1199 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1201 * System.Data/DataSet.cs: added missing 'using's.
1203 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1205 * System.Data/DataSet.cs:
1206 * System.Data/DataTableCollection.cs:
1207 * System.Data/DataView.cs: compilation fixes on Linux.
1209 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1211 * System.Data/DataRelation.cs
1212 * System.Data/ForeignKeyConstraint.cs
1213 * System.Data/UniqueConstraint.cs: added more stubs
1215 * System.Data/DataTableRelationCollection.cs: added back to cvs
1216 and modified for compile errors. DataRelationCollection is an
1217 abstract class and there must be a class that implements for
1218 DataTable/DataSet. DataTableRelationCollection was changed
1219 to an internal class.
1221 * System.Data.build: modified - new files added
1222 also wanted to include files/classes in the build
1223 so we can get a compilable forward read only result set.
1224 It compiles now using csc/nant with warnings, but this
1225 is a start for adding functionality for the result set.
1226 Classes associated with/and DataSet are still excluded.
1228 * TODO: modified - updated to do list for System.Data
1230 * System.Data/Constraint.cs
1231 * System.Data/ConstraintCollection.cs
1232 * System.Data/DataRelationCollection.cs
1233 * System.Data/DataRow.cs
1234 * System.Data/DataRowChangeEventArgs.cs
1235 * System.Data/DataRowCollection.cs
1236 * System.Data/DataTable.cs
1237 * System.Data/DataTableCollection.cs
1238 * System.Data/InternalDataCollectionBase.cs
1239 * System.Data/PropertyCollection.cs: modified -
1240 changes to compile SqlDataReader/DataTable and
1243 * System.Data/IDbCommand.cs
1244 * System.Data.SqlClient/SqlCommand.cs: modified -
1245 un-commented overloaded methods ExecuteReader
1246 which returns a SqlDataReader
1248 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1250 * System.Data/DataTableCollection.cs: more implementation.
1251 (Count): added 'override' keyword, as pointer out by Martin.
1253 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1254 only call Array.Copy when there is really stuff to be copied.
1255 (CopyTo): don't create the temporary array, it's not needed.
1257 * System.Data.build: excluded newly added file from build.
1259 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1261 * System.Data/DataTableRelationCollection.cs: removed, it's not
1262 on MS SDK documentation.
1264 * System.Data/DataTableCollection.cs: new class.
1266 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1268 * System.Data/DataRowChangeEventArgs.cs
1269 * System.Data/DataRowCollection.cs
1270 * System.Data/DataView.cs
1271 * System.Data/PropertyCollection.cs: added new stubs
1273 * System.Data.build: modified - added new files to exclude
1276 * TODO: modified - removed files from TODO list
1277 that were stubbed above
1279 * System.Data/DataColumn.cs
1280 * System.Data/DataRow.cs: modified - various tweaks
1281 and added internal method SetTable to set the reference
1284 * System.Data/DataSet.cs: modified - class was not
1287 * System.Data/DataTable.cs: modified - temporarily commented
1288 DataSet and DataView references - trying to compile a SqlDataReader,
1289 DataTable, and dependencies for a forward read-only result set.
1290 SqlDataAdapter, DataSet, and DataView will come later once we can get
1291 a forward read only result set working.
1293 * System.Data/IDataRecord.cs: modified - source code lines should
1296 * System.Data/InternalDataCollectionBase.cs: modified - started
1297 implementing this base class for collection of data rows,
1298 columns, tables, relations, and constraints
1300 * System.Data.SqlClient/SqlException.cs: modified -
1301 call base(message) so a unhandled exception displays
1302 the message of a SQL error instead of the
1303 default SystemException message
1305 * Test/TestSqlException.cs: modified -
1306 handle the rollback properly for a SqlException on a
1309 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1311 * System.Data.build: modified - added new
1312 files to exclude from build
1314 * System.Data/Constraint.cs
1315 * System.Data/ConstraintCollection.cs
1316 * System.Data/InternalDataCollectionBase.cs: added -
1317 stubs which are needed to build DataTable.cs
1319 * TODO: modified - added more classes TODO and
1320 added more stuff TODO, such as, create script
1321 to create test database monotestdb for testing
1322 classes in System.Data
1324 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1326 * System.Data.Common/DataAdapter.cs:
1327 * System.Data.Common/DataColumnMappingCollection.cs:
1328 * System.Data.Common/DataTableMappingCollection.cs:
1329 * System.Data.Common/DbDataPermission.cs:
1330 * System.Data.Common/DbDataPermissionAttribute.cs: some
1331 compilation errors fixed.
1333 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1335 * TODO: modified - added classes TODO, and
1336 a poor attempt at System.Data plan
1338 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1340 * ChangeLog: modified - put tabs where they belong
1342 * System.Data.SqlClient/SqlDataReader.cs
1343 * System.Data/DataColumn.cs: modified - compile errors
1344 trying to compile SqlDataAdapter and dependencies
1346 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1348 * System.Data.SqlTypes/SqlBoolean.cs
1349 * System.Data.SqlTypes/SqlCompareOptions.cs
1350 * System.Data.SqlTypes/SqlInt32.cs
1351 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1353 * System.Data/DataTable.cs
1354 * System.Data.SqlClient/SqlCommand.cs
1355 * System.Data.SqlClient/SqlConnection.cs
1356 * System.Data.SqlClient/SqlError.cs
1357 * System.Data.SqlClient/SqlTransaction.cs: modified -
1360 * System.Data.SqlClient/SqlException.cs: modified -
1361 missing Message on indexer for Message property
1363 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1365 * System.Data.SqlClient/SqlCommand.cs: modified - to
1366 compile using mcs. This problem is
1367 returning a stronger type in csc vs. msc
1369 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1370 can not do a using PGconn = IntPtr; and then declare
1371 with PGconn pgConn = IntPtr.Zero;
1372 Thiw works under csc though. Had to comment using and
1373 changed declaration to IntPtr pgConn = IntPtr.Zero;
1374 Also, got rid of compile warnings for hostaddr and port.
1376 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1377 rid of compile warnings. Commented MonoTODO attribute because mcs
1378 doesn't seem to work with C# array property indexer (Item)
1381 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1382 commented MonoTODO attribute for indexer for mcs compiling
1384 * Test/TestSqlIsolationLevel.cs:
1385 * Test/TestSqlInsert.cs:
1386 * Test/TestSqlException.cs: modified -
1387 removed extra ExecuteNonQuery which caused two inserted rows
1389 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1391 * System.Data/StateChangeEventArgs.cs - added
1392 needed to compile System.Data.dll with mcs.
1394 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1396 * System.Data.OleDb: added directory - for OleDb database
1399 * System.Data.SqlClient/SqlClientPermission.cs
1400 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1401 * System.Data.SqlClient/SqlCommandBuilder.cs
1402 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1403 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1404 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1405 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1406 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1407 * Test/TestSqlException.cs
1408 * Test/TestSqlIsolationLevel.cs: added - more tests
1410 * System.Data.build: modified - added new files - excludes these too
1412 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1414 * System.Data.SqlClient/SqlConnection.cs
1415 * System.Data.SqlClient/SqlCommand.cs
1416 * System.Data.SqlClient/SqlTransaction.cs
1417 * System.Data.SqlClient/SqlException.cs
1418 * System.Data.SqlClient/SqlErrorCollection.cs
1419 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1420 exception/error handling. SqlConnection(connectionString)
1421 constructor should not automatically connect.
1423 * System.Data.SqlClient/SqlDataReader.cs
1424 * System.Data.SqlClient/SqlDataAdapter.cs
1425 * System.Data.SqlClient/SqlParameter.cs
1426 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1427 added using System.ComponentModel;
1429 * Test/TestSqlInsert.cs: modified - to use transaction
1431 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1433 * System.Data/DataRow.cs: new skeletons.
1435 * System.Data.Common/DataAdapter.cs:
1436 * System.Data.Common/DataColumnMapping.cs:
1437 * System.Data.Common/DataColumnMappingCollection.cs:
1438 * System.Data.Common/DataTableMapping.cs:
1439 * System.Data.Common/DataTableMappingCollection.cs:
1440 * System.Data.Common/DbDataAdapter.cs:
1441 * System.Data.Common/RowUpdatedEventArgs.cs:
1442 * System.Data.SqlClient/SqlDataAdapter.cs:
1443 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1446 * System.Data.Common/DbDataRecord.cs:
1447 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1450 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1452 * Test/TestSqlInsert.cs: modified - do
1453 a SQL DELETE before SQL INSERT of row so you can use this
1456 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1457 IsolationLevel for PostgreSQL is ReadCommitted. However,
1458 PostgreSQL allows Serializable as well.
1459 (Thanks to Gonzalo for that!)
1461 * System.Data.SqlClient/SqlConnection.cs: modified
1462 * System.Data.SqlClient/SqlCommand.cs: modified
1463 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1464 working; however, we still need to implement SQL errors
1465 and exceptions to properly handle transactions. Also, added
1466 status and error message support from the PostgreSQL database.
1467 Currently, this does a Console.WriteLine() to display the
1468 status and error messages, but this is a TODO
1469 for SQL errors and exceptions.
1471 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1472 attribute for System.Data.dll assembly
1474 * System.Data/IDbCommand.cs: modified - commented
1475 overloaded method ExecuteReader
1476 so System.Data.SqlClient.SqlCommand can compile
1478 * System.Data/IDbCommand.cs: modified
1479 * System.Data/IDbConnection.cs: modified - added using System;
1480 * System.Data/IDataParameter.cs
1482 * System.Data.build: modified - build classes
1483 in System.Data.SqlClient and exclude others in System.Data
1485 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1486 parameter data type from IntPtr to enum ExecStatusType
1488 * ChangeLog: modified - corrected previous entries in log
1490 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1492 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1493 implementation. Still missing some stuff.
1495 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1497 * System.Data.SqlClient/SqlConnection.cs: modified - got
1498 to compile, run, and connect to PostgreSQL database
1500 * System.Data.SqlClient/SqlCommand.cs: modified - got
1501 to compile, run, and execute a SQL INSERT command
1502 which successfully inserted a row
1503 into the PostgreSQL database
1505 * System.Data.SqlClient/SqlTransaction.cs: modified
1506 * System.Data.SqlClient/SqlParameter.cs: modified
1507 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1508 * System.Data.SqlClient/SqlError.cs: modified
1509 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1510 * System.Data.SqlClient/SqlException.cs: modified
1511 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1513 * System.Data.SqlClient/SqlAdapter: modified
1514 * System.Data.SqlClient/SqlReader: modified - add more stubs
1516 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1518 * Test/TestSqlInsert.cs: added
1520 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1522 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1523 class SqlConnecition
1524 * System.Data.SqlClient/SqlErrorCollection.cs: added
1525 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1527 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1529 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1530 * System.Data.IDbTransaction: Added Interface to IDisposable.
1531 * System.Data.IDbCommand: Fixed Capitalization of class name.
1532 * System.Data.IDbConnection: Fixed Capitalization of class name.
1534 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1536 * System.Data.Common/DbDataPermissionAttribute.cs:
1537 * System.Data.Common/DataAdapter.cs:
1538 * System.Data.Common/DataColumnMapping.cs:
1539 * System.Data.Common/DbDataPermission.cs: added some implementation.
1541 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1543 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1544 syntax, as pointed out by Levent Camlibel.
1546 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1548 * System.Data.SqlTypes/SqlBinary.cs:
1549 * System.Data.SqlTypes/INullable.cs: new skeletons.
1551 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1553 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1554 contains all calls the the PostgreSQL client library, to be used
1555 everywhere in System.Data.SqlClient.
1557 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1559 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1562 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1564 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1566 * System.Data.Common/DbDataRecord.cs:
1567 * System.Data.Common/DbEnumerator.cs:
1568 * System.Data.Common/RowUpdatedEventArgs.cs:
1569 * System.Data.Common/RowUpdatingEventArgs.cs:
1570 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1572 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1574 * System.Data.Common/DataTableMappingCollection.cs:
1575 * System.Data.Common/DbDataAdapter.cs:
1576 * System.Data.Common/DbDataPermission.cs:
1577 * System.Data.Common/DataTableMapping.cs: new skeletons.
1579 * System.Data.SqlClient/SqlDataAdapter.cs:
1580 * System.Data.SqlClient/SqlDataReader.cs:
1581 * System.Data.SqlClient/SqlErrors.cs:
1582 * System.Data.SqlClient/SqlError.cs:
1583 * System.Data.SqlClient/SqlException.cs:
1584 * System.Data.SqlClient/SqlParameter.cs:
1585 * System.Data.SqlClient/SqlParameterCollection.cs:
1586 * System.Data.SqlClient/SqlTransaction.cs:
1587 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1589 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1591 * System.Data.Common/DataColumnMapping.cs:
1592 * System.Data.Common/DataColumnMappingCollection.cs:
1593 * System.Data.Common/DataAdapter.cs: created skeletons.
1595 * System.Data.build: exclude new directories from build.
1597 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1599 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1601 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1602 implemented (2 methods).
1604 2002-03-24 Duncan Mak <duncan@ximian.com>
1606 * System.Data.build: Excluded System.Data.SqlClient from the build.
1607 The stubs are incomplete and they are stopping the build.
1609 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1611 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1613 * System.Data.SqlClient/*: added skeletons for the SQL managed
1614 provider for ADO.Net, to be based initially in PostgreSQL.
1616 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1618 Changed the Namespace on some Enums from mono.System.Data to System.Data
1620 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1622 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1623 default name if the ColumnName is null.
1624 * DataSet.cs : Added
1625 * DataTable.cs : Added
1626 * DataRelationCollection.cs : Added
1627 * DataTableRelationCollection.cs : Added
1628 * DataColumn : Added
1630 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1632 * DataColumnChangeEventArgs.cs : Added
1633 * DataColumnCollection.cs : Added
1635 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1637 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1638 * Updated all Enums, Interfaces, and Delegates in System.Data