1 2002-10-07 Gonzalo Paniagua Javier <gonzalo@ximian.com>
3 * System.Data/ConstraintCollection.cs:
4 * System.Data/DataColumnCollection.cs:
5 * System.Data/DataRowCollection.cs:
6 * System.Data/DataTableCollection.cs:
7 * System.Data/InternalDataCollectionBase.cs: made List internal to fix
8 the build with csc. It must be a mcs bug. I will try to get a test case.
10 2002-10-06 Luis Fernandez <luifer@onetel.net.uk>
12 * System.Data/Constraint.cs (AssertConstraint): added overloaded
15 * System.Data/DataColumnCollection.cs: added constraints when needed.
17 * System.Data/DataRow.cs: validate UniqueConstraint's.
19 * System.Data/DataRowCollection.cs (ValidateDataRowInternal): new
20 internal method to validate a given DataRow with respect to the
23 * System.Data/ForeignKeyConstraint.cs (AssertConstraint): stubs for
24 new overloaded method.
26 * System.Data/UniqueConstraint.cs: added implementation.
27 (AseertConstraint): implemented new overloaded method.
29 2002-10-01 Rodrigo Moya <rodrigo@ximian.com>
31 * System.Data.OleDb/OleDbConnection.cs (Open): commented code from
32 last commit, which wasn't supposed to be in CVS yet.
34 2002-10-01 Luis Fernandez <luifer@onetel.net.uk>
36 * System.Data/DataColumn.cs:
37 * System.Data/DataRow.cs:
38 * System.Data/DataRowCollection.cs:
39 * System.Data/DataTable.cs: some fixes and implementation.
41 2002-09-28 Vladimir Vukicevic <vladimir@pobox.com>
43 * System.Data.OleDb/OleDbConnection.cs: Close
44 reader properly in call to ExecuteScalar().
46 2002-09-07 Rodrigo Moya <rodrigo@ximian.com>
48 * System.Data.OleDb/OleDbConnection.cs (Open): changed to use OleDb
49 connection strings, which are then converted to GDA connection
50 strings, instead of using directly GDA data source names.
52 * System.Data.OleDb/libgda.cs: added more needed functions.
54 2002-09-06 Franklin Wise <gracenote@earthlink.net>
56 * System.Data/DataColumn.cs: More flushing out.
58 * System.Data/ForeignKeyConstraint.cs: Implemented GetHashCode()
60 * System.Data/UniqueKeyConstraint.cs: Implemented GetHashCode()
62 * Tests: See Changelog for System.Data/Test
64 2002-09-04 Franklin Wise <gracenote@earthlink.net>
66 * Tests: See Changelog for System.Data/Test
69 System.Data/DataColumnCollectionTest.cs
70 System.Data/DataRowCollectionTest.cs
71 System.Data/DataRowTest.cs
73 * System.Data/DataColumn.cs: Flushing out validation, type conversion for
74 autoincrement. Added lots of TODO's.
75 * System.Data/DataColumnCollection.cs: Wrote out add logic as a comment.
76 Tagged implementation with FIXME tags. Lot's more validation
77 and setup needs to be done, much of which is now tagged as todo's
80 * System.Data/DataRow.cs: Lot's of fixme's added.
82 * System.Data/DataRowCollection.cs: TODO's added.
84 * System.Data/DataTable.cs: Implemented PrimaryKey.
86 * System.Data/UniqueConstraint.cs: Implemented related PrimaryKey
89 2002-08-25 Rodrigo Moya <rodrigo@ximian.com>
91 * System.Data.OleDb/OleDbTransaction.cs (OleDbTransaction): manage
92 correctly the isolation level.
93 (IsolationLevel): likewise.
94 (~OleDbTransaction): implemented.
96 * System.Data.OleDb/libgda.cs: added more needed stuff.
98 2002-08-22 Daniel Morgan <danmorg@sc.rr.com>
100 * System.Data.SqlClient/SqlParameter.cs: flush
102 * System.Data.SqlClient/SqlParameterCollection.cs: fixes
103 for the Item property, IndexOf, and Contains.
105 * Test/SqlSharpCli.cs: added input parameters support.
106 when a query is executed, if a parameter name matches
107 a SQL# internal variable name, it uses that value for the parameter; otherwise,
108 the user is prompted for the parameter value. Currently, it only supports
111 2002-08-21 Rodrigo Moya <rodrigo@ximian.com>
113 * System.Data.OleDb/libgda.cs: adapted to changes in libgda (get_vtype
114 and get_type for GdaValue).
116 * System.Data.OleDb/OleDbDataReader.cs: adapted to changes in
119 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
121 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
123 (Close): set the dataReader to null.
125 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
126 connection's DataReader property to this object.
127 (Close): set it to null here.
128 (Depth, IsDbNull): implemented.
129 (this): implemented the Item property with a string indexer.
131 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
132 ExecuteScalar): do nothing if there's already an open data reader.
134 * System.Data.OleDb/libgda.cs: more API functions.
136 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
137 reader before continuing.
139 2002-08-20 Franklin Wise <gracenote@earthlink.net>
141 * System.Data/System.Data.build: added nowarn:0679
143 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
144 setup to begin implementing. Implemented ctor().
146 * Tests: See System.Data\Test\ChangeLog
149 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
151 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
153 2002-08-19 Franklin Wise <gracenote@earthlink.net>
155 * Tests: See System.Data\Test\ChangeLog
157 * System.Data/UniqueConstraint.cs: More validation.
159 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
160 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
163 * System.Data/DataTable.cs: Added more MonoTODO tags
165 * class/System.Data/.cvsignore: added tmp & Temp
167 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
170 * System.Data/ConstraintCollection.cs: Commented out unused line.
172 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
174 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
176 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
178 (ErrorCode, Message, Source, Errors): implemented.
180 * System.Data.OleDb/OleDbError.cs: implemented the full class.
182 * System.Data.OleDb/libgda.cs: added more libgda functions.
184 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
185 the opened connection.
187 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
189 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
191 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
192 ArrayList after releasing the items.
193 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
194 GetOrdinal, GetString): implemented.
195 (GetDataTypeName): made it get the type from the data model, not from
196 the current value, which could not have been retrieved yet.
197 (GetValue): call the Get* method corresponding with the data type of
198 the requested column.
200 * System.Data.OleDb/libgda.cs: added more libgda functions.
201 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
203 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
204 titles via OleDbDataReader.GetName ().
205 (TestOleDb): create temporary table with a date field.
206 (InsertRow): set current date for the date field.
208 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
210 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
211 GetValue, which will take care of all the work needed.
212 (Close): implemented basic stuff.
213 (~OleDbDataReader): implemented.
215 * System.Data.OleDb/libgda.cs: added more needed functions.
217 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
219 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
221 (TestTransaction): added test for transactions.
223 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
225 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
227 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
228 when there are errors.
229 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
231 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
234 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
236 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
238 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
239 create an empty GdaParameterList.
241 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
242 for NULL before passing them to Marshal.PtrToStructure, which issues
243 an exception if the value is NULL.
245 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
247 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
248 unreachable code to avoid compiler warning.
250 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
252 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
253 (OpenReader): removed internal method.
255 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
256 the list of returned data models.
258 2002-08-15 Franklin Wise <gracenote@earthlink.net>
260 * System.Data/Constraint.cs: Added helper virtual functions
262 * System.Data/ConstraintCollection.cs: Improved constraint removal,
263 validation. Removed specific knowledge of subclasses of
266 * System.Data/DataColumn.cs: Added static helper function to compare
267 if two DataColumn arrays are the same.
269 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
271 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
274 2002-08-13 Franklin Wise <gracenote@earthlink.net>
276 * System.Data/DataRow.cs: Added several fixme tags.
278 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
280 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
281 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
282 to avoid compiler warnings.
284 2002-08-12 Franklin Wise <gracenote@earthlink.net>
286 * System.Data/Constraint.cs: Implemented
288 * System.Data/UniqueConstraint.cs: GetHashCode() &
289 special case Ctor. Still need to be implemented. LAMESPEC tags
292 * System.Data/ConstraintCollection.cs: Clear() &
293 AddRange() need to be finished. Several LAMESPEC tags.
295 * Allow Constraint collection to be created in DataTable.
297 * System.Data/ForeignKeyConstraint: Added a couple of
300 * System.Data/DataColumnCollection New/Added DataColumns now have
303 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
305 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
307 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
308 internal method, since we don't need it.
309 (ExecuteReader): call SetupGdaCommand before executing the command
310 via libgda functions.
311 (ExecuteScalar): implemented.
313 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
314 to OleDbCommand.OpenReader.
315 (GetBoolean): implemented.
317 2002-08-08 Franklin Wise <gracenote@earthlink.net>
319 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
321 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
323 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
326 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
328 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
329 and don't show a warning in Open.
331 * System.Data.OleDb/TestOleDb.cs: added Close.
333 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
335 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
336 ConnectionTimeout, ServerVersion, GdaConnection):
338 (OleDbConnection): call libgda.gda_init on constructor.
340 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
341 which wasn't been called.
343 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
346 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
348 * list: added missing System.Data.OleDb and
349 System.Data.Common files.
351 * System.Data.OleDb/ChangeLog: removed and merged with
352 System.Data's ChangeLog.
354 * System.Data.OleDb/OleDbDataAdapter.cs:
355 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
357 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
359 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
360 (IsClosed, Item, RecordsAffected): implemented some properties.
362 * libgda.cs: added GdaDataModel methods.
364 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
366 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
367 a second argument (ArrayList results).
368 (NextResult): implemented.
370 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
371 pass that to the OleDbDataReader.
372 (OleDbCommand constructor): don't create the ArrayList of results.
373 (GdaResults): removed property.
374 (ExecuteReader): create a temporary ArrayList and pass that to the
375 OleDbDataReader constructor.
377 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
379 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
380 (CreateParameter): implemented IDbCommand methods.
381 (CommandText): don't create many GdaCommand's, only one is needed.
382 (ExecuteNonQuery): set up the internal GDA command object.
383 (ExecuteReader): use correctly the unique GDA command object.
385 * System.Data.OleDb/libgda.cs: added new libgda calls.
387 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
389 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
390 (BeginTransaction): implemented IDbConnection methods.
392 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
394 * list: added System.Data.OleDb files to file list.
396 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
398 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
400 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
401 of the set method for this property.
403 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
404 (MissingSchemaAction): implemented.
406 2002-07-10 Tim Coleman <tim@timcoleman.com>
408 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
409 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
410 * System.Data.OleDb/OleDbError.cs: Added stubbs
411 * System.Data.OleDb/OleDbException.cs: Added stubbs
412 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
413 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
414 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
415 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
416 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
417 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
418 support transaction nesting
419 * System.Data.OleDb/libgda.cs: Added my name to this file
421 2002-07-09 Tim Coleman <tim@timcoleman.com>
423 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
424 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
425 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
426 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
427 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
428 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
429 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
430 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
431 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
432 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
433 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
434 * System.Data.OleDb/OleDbType.cs: Fixed two typos
435 * System.Data.OleDb/libgda.cs: Style changes, added new methods
437 2002-07-09 Tim Coleman <tim@timcoleman.com>
439 * System.Data.build: remove restriction on System.Data.OleDb build
441 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
443 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
444 IsSynchronized): implemented.
446 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
448 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
450 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
451 (Parameters, Transaction, Connection): made these overload
454 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
455 call m_list methods, not own ones.
457 * System.Data.OleDb/OleDbParameter.cs: more implementation.
459 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
461 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
462 Commit, Rollback): implemented.
463 (GdaConnection): added new internal property.
465 * System.Data.OleDb/OleDbParameter.cs:
466 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
469 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
471 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
473 * System.Data.OleDb/libgda.cs: added new libgda API functions.
475 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
476 (BeginTransaction): made it overload IDbConnection methods.
477 (ChangeDatabase): new stub, needs some work on libgda for being
480 (Close): implemented.
481 (CreateCommand): implemented.
482 (GetOleDbSchemaTable): new stub, until I understand what to do here.
483 (Open): implemented basic stuff, which is just supporting connection
484 strings that represent a GDA data source name. More to come.
485 (InfoMessage, StateChange): added events.
487 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
489 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
491 * System.Data.OleDb/libgda.cs: added static constructor.
492 (GdaClient): new static property to get the underlying GdaClient
495 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
496 the static 'libgda' class.
498 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
500 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
502 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
503 (ConnectionString, Connectiontimeout, Database, State):
504 implemented class properties.
505 (BeginTransaction): implemented.
507 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
509 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
511 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
513 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
515 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
517 * list: added missing PostgresTypes.cs file.
519 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
521 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
524 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
526 * System.Data.SqlClient/SqlConnection.cs: modifed -
527 start to implement the interfaces properly and
528 properly doing a Close(), Dispose(), and
531 * Test/SqlSharpCli.cs: modified -
532 add support for MySQL in Mono.Data.MySql
533 and OleDb support in System.Data.OleDb. However,
534 the OleDb support is commented right now.
535 When the program starts up, a shorter help menu should
536 display the most important commands: help and quit
538 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
540 * System.Data.build: exclude System.Data.OleDb files.
542 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
544 * System.Data.SqlClient/SqlCommand.cs: typo
545 should be CommandBehavior.KeyInfo
547 * Test/SqlSharpCli.cs: refactored and added a few more
550 2002-05-27 Tim Coleman <tim@timcoleman.com>
551 * list: update to compile properly (add missing
552 files and switch path delimiter from '\' to '/').
554 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
556 * System.Data/DataRow.cs
557 * System.Data.Common/DbDataAdapter.cs: fix to
558 get Test/TestSqlDataAdapter.cs to work again
560 * Test/TestSqlDataAdapter.cs: removed comment
561 about SqlDataReader:NextResult() not being implemented; it
564 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
566 * System.Data/DataRow.cs: modified
567 support setting of DBNull.Value
568 using the Item indexer this[DataColumn]
570 * System.Data.SqlClient/SqlCommand.cs: modified
571 tweaks to show TODO's for other CommandBehavior.
572 Set AllowDBNull column to true for IsKey row
575 * System.Data.SqlClient/SqlConnection.cs: modified
576 if transaction is in progress when a Close() is called,
577 do a transaction Rollback.
579 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
581 * Test/SqlSharpCli.cs: added file
582 My new toy. SQL# is a command-line tool to enter
583 SQL commands and queries using Mono System.Data.
584 It also serves as a test for Mono System.Data.
586 * System.Data.SqlClient/SqlCommand.cs: modified
587 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
588 should handle the results from SQL Commands and Queries.
589 - Internal class SqlResult should not create schema Table
590 for the result from a SQL Command. Also, set the RecordsRetrieved
591 property for SqlDataReader.
592 - Closing the SqlDataReader should Close() the SqlConnection for
593 a CommandBehavior.CloseConnection.
594 - Set defaults for SqlResult
596 * System.Data.SqlClient/SqlConnection.cs: modified -
597 when SqlDataReader is Close()
598 should Close() the SqlConnection for
599 a CommandBehavior.CloseConnection. Changed internal Property
600 from OpenReader get/set to IsReaderOpen get and created
601 internal methods OpenReader()/CloseReader() for SqlCommand to call.
602 SqlConnection needs to be prevented from doing while SqlDataReader
605 * System.Data.SqlClient/SqlDataReader.cs: modified -
606 call SqlCommand's OpenReader() internal method. get
607 RecordsRetrieved from SqlResult. set/reset default
608 values for SqlDataReader.
610 * Test/PostgresTest.cs
611 * Test/TestExecuteScalar.cs
612 * Test/TestSqlDataReader.cs: modified
613 for the Execute...() methods in SqlCommand
614 to test SQL Queries and Commands
616 * Test/System.Data_test.build: modified
617 exclude new file Test/SqlSharpCli.cs from
620 2002-05-24 Tim Coleman <tim@timcoleman.com>
621 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
622 for get accessors. These should be implemented in derived classes. See
623 SqlDataAdapter for clues.
624 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
625 * System.Data.Common/DataAdapter.cs:
626 * System.Data.Common/DataTableMappingCollection.cs:
627 * System.Data.Common/DataTableMapping.cs:
628 * System.Data.Common/DataColumnMappingCollection.cs:
629 * System.Data.Common/DataColumnMapping.cs:
630 Properly (I hope!) implement all of the appropriate interfaces
634 2002-05-23 Tim Coleman <tim@timcoleman.com>
635 * System.Data.SqlClient/SqlCommand.cs: include
636 the BaseColumnName in the schema table. Was missed before.
637 * System.Data.Common/DbDataAdapter.cs: Use DataTable
638 mappings so that the DataSet and DataTable are more closely tied.
639 Get schema information from the DataTable using GetSchemaTable ()
640 Various other little fixes
641 * System.Data.Common/DataColumnMappingCollection.cs:
642 * System.Data.Common/DataTableMapping.cs:
643 * System.Data.Common/DataTableMappingCollection.cs: Some
644 implementation, enough to be used by DbDataAdapter.
646 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
648 * System.Data.SqlClient/SqlCommand.cs: set
649 the "ProviderType" to the PostgreSQL type oid
651 * System.Data.SqlClient/SqlDataReader.cs: fix
652 for various properties and methods that
653 return meta data: Item indexers this[name] and this[index],
654 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
657 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
659 * System.Data/DataRow.cs: change suggested
660 by tim: in Item indexer, do an EndEdit()
662 * System.Data.SqlClient/SqlCommand.cs: more
663 fixes to SqlResult. After setting each item in
664 the DataRow, do an AcceptChanges() to commit
665 the changes in the DataRow. For DataType, use a Type
666 of System.String since System.Type nor System.Object
669 * Test/TestSqlDataReader.cs
670 * Test/PostgresTest.cs: updated to to be on
671 the way schema table is suppose to work
673 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
675 * System.Data.SqlClient/SqlCommand.cs: more work on
676 building the schema table
678 2002-05-22 Tim Coleman <tim@timcoleman.com>
679 * System.Data.SqlClient/SqlCommand.cs: preliminary work
680 on getting the schema table correctly built.
682 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
684 * System.Data.SqlClient/ParmUtil.cs: added file - to
685 provide utility for conversion of input parameters
687 * System.Data.SqlClient/PostgresTypes.cs: added file -
688 moved the PostgreHelper class to here. May eventually
689 move the internal class PostgresTypes that's inside the
690 SqlConnection to here as well.
691 Handling of PostgreSQL <-> .NET types need to be though
692 out more. Also, the PostgreHelper has a method to convert
693 from .NET types to a string which can be put into used in
694 an SQL statement to execute against a PostgreSQL database.
695 This is the beginnings of parameters support. It currently
696 only supports input parameters. Still need to do output,
697 input/output, and return parameters.
699 * Test/TestSqlParameters.cs: new test to test the input
700 parameters in System.Data.SqlClient against a
703 * System.Data.SqlClient/PostgresLibrary.cs: moved
704 PostgresHelper class to file PostgresTypes.cs. Also
705 moved struct PostgresType there too.
707 * System.Data.SqlClient/SqlCommand.cs: added input
710 * System.Data.SqlClient/SqlParameter.cs: got
713 * System.Data.SqlClient/SqlParameterCollection.cs: got
714 SqlParameterCollection to work
716 * Test/System.Data_test.build: added files to exclude
719 * System.Data.SqlClient/SqlConnection.cs: release resources
722 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
724 * System.Xml: added directory for classes with namespace
725 System.Xml to go into the System.Data.dll assembly
727 * System.Xml/XmlDataDocument: added file
728 for stubbed concrete class XmlDataDocument which
729 inherits from XmlDocument. Its purpose is to provide
730 a W3C XML DOM Document for relational data and interacting
733 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
735 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
736 Text, TableDirect, and StoredProcedure
738 * Test/PostgresTest.cs: changed call to version()
739 stored procedure to use the CommandType of StoredProcedure
741 * Test/TestSqlDataReader.cs: test all the CommandTypes
743 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
745 * System.Data.build: took out all excluded
746 files except the ones in the Test directory
747 because all files compile now. It does not
748 mean they all work or have implementations
751 * System.Data/DataRelationCollection.cs
752 * System.Data/DataTableRelationCollection.cs
753 * System.Data/InternalDataCollectionBase.cs
754 * System.Data.Common/DbDataPermission.cs
755 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
756 * System.Data.SqlClient/SqlClientPermission.cs
757 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
758 to get all System.Data* files to compile.
760 * System.Data.SqlClient/SqlCommand.cs: started coding
761 to prevent SqlConnection and SqlCommand from doing
762 anyting while fetching data using SqlDataReader. Also,
763 started coding to undo this prevention once the
764 SqlDataReader is closed.
766 * System.Data.SqlClient/SqlConnection.cs: get database server
767 version. Started coding to prevent connection from
768 doing anything while fetching data and undo once the reader
769 is closed. Include events SqlInfoMessage and StateChange.
771 * System.Data.SqlClient/SqlDataReader.cs: start coding to
772 prevent connection and command from doing anything while
773 fetching data, and undo when closed.
775 * Test/PostgresTest.cs: added test to get ServerVersion
776 property from SqlConnection
778 2002-05-18 Tim Coleman <tim@timcoleman.com>
779 * System.Data/DataRow.cs: More implementation,
780 as well as boundary checks and small semantic
783 2002-05-18 Tim Coleman <tim@timcoleman.com>
784 * System.Data/DataRow.cs: Try to reduce memory
785 usage by only creating the original and proposed
786 arrays as required in BeginEdit, and then destroying
787 proposed during EndEdit, and original during AcceptChanges.
788 * System.Data.Common/DbDataAdapter.cs: Make the
789 startRecord and maxRecords parameters work correctly.
791 2002-05-18 Tim Coleman <tim@timcoleman.com>
792 * System.Data/DataRow.cs: Move the null check in
793 ItemArray set to above the Invalid Cast check, so
794 that we don't get null reference exceptions.
796 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
798 * System.Data.SqlClient/PostgresLibrary.cs: handle
799 data value from database being NULL
801 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
802 allow multiple result sets. Added new internal class
803 SqlResult to pass result set data from SqlCommand
806 * System.Data.SqlClient/SqlDataReader.cs: allow
807 multiple result sets.
809 * System.Data.SqlClient/SqlConnection.cs: moved
810 things around. Implement IDisposable.
812 * Test/TestSqlDataReader.cs: test for execution
813 of multiple result sets and display the results
814 of these multiple results sets
816 * Test/TestSqlDataAdapter.cs: tweaks
818 2002-05-17 Tim Coleman <tim@timcoleman.com>
819 * System.Data.Common/DbDataAdapter.cs:
820 - More implementation of Fill methods
821 - Get rid of isDirty flag, because we can just check
823 - Do *not* remove DataTables before Filling them
824 - Implicitly open the connection before doing a Fill
825 if it does not exist.
826 * System.Data.SqlClient/SqlDataAdapter.cs:
828 * System.Data/DataTableCollection.cs:
829 - Add DataSet to internal, undocumented constructor
830 - When a table is created, set its DataSet property
831 - Default table name for creation is "Table1" (see .NET)
832 - Inherit the ArrayList list from InternalDataCollecitonBase
833 and maintain a hashtable between table names and
835 * System.Data/DataTable.cs:
836 - Add internal dataSet field. This is used by
837 DataTableCollection when the DataTable is constructed.
838 * System.Data/DataSet.cs:
839 - Pass a reference to the DataSet when constructing the
842 2002-05-16 Tim Coleman <tim@timcoleman.com>
843 * System.Data.Common/DbDataAdapter.cs:
844 Use table.Rows.Add (itemArray) instead of
845 table.Rows.Add (thisRow) to provide better
847 * System.Data/DataRowCollection.cs:
848 Some implementation of this class.
849 * System.Data/InternalDataCollectionBase.cs:
850 Some implementation. Most notably, this now
851 has an enumerator so we can use foreach (DataRow row in table.Rows)
853 * System.Data/DataTable.cs:
854 Since DataRowCollection now accepts a DataTable in
855 its internal constructor, we must pass one in.
857 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
859 * Test/TestSqlDataAdapter.cs: added new test
860 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
861 DataRowCollection, and DataRow. It tests retrieving data
862 based on a SQL SELECT query. This test is based on Tim Coleman's
865 2002-05-16 Tim Coleman <tim@timcoleman.com>
866 * System.Data.Common/DbDataAdapter.cs:
867 Use table.Rows.Add (thisRow) instead of
868 table.ImportRow (thisRow)
869 * System.Data/DataRowCollection.cs:
870 Construct the ArrayList before using it
872 2002-05-16 Tim Coleman <tim@timcoleman.com>
873 * System.Data/DataTable.cs:
874 Construct the DataRowCollection in the DataTable
875 constructor. Otherwise, it's a null reference.
877 2002-05-16 Tim Coleman <tim@timcoleman.com>
878 * System.Data.SqlClient/SqlDataReader.cs:
879 Modify GetValues to use Array.Copy() to copy
880 the results from fields to values, rather than
881 an assignment, which results in loss of data.
883 2002-05-16 Tim Coleman <tim@timcoleman.com>
884 * System.Data/DataRow.cs:
885 More implementation and documentation. It should
886 work more like expected, although there is no way
887 to demonstrate this well yet. DataTable requires
890 2002-05-15 Tim Coleman <tim@timcoleman.com>
891 * System.Data/DataRow.cs:
892 Minor tweaks as I determine exactly how to
893 implement this class.
896 2002-05-14 Duncan Mak <duncan@ximian.com>
898 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
900 2002-05-14 Tim Coleman
901 * System.Data/DataRow.cs:
902 * System.Data/DataRowBuilder.cs:
903 * System.Data/DataTable.cs:
904 More implementation of these classes. DataRow
905 can now (possibly) do some useful things.
906 Still not sure what DataRowBuilder is all about,
907 other than passing a DataTable in.
909 2002-05-14 Tim Coleman
910 * System.Data/DataRowBuilder.cs:
911 Add stubb for this internal class.
913 2002-05-13 Tim Coleman
914 * System.Data.Common/DbDataAdapter.cs:
915 The maxRecords check was not correct.
917 2002-05-13 Tim Coleman
918 * System.Data/DataTableCollection.cs:
919 Fix an issue when adding a DataTable and size == 0.
920 Now explicitly checks if size > 0 before doing Array.Copy ()
921 * System.Data.Common/DbDataAdapter.cs:
922 Move closer to a working implementation.
923 Make the IDbCommand fields protected so that they can
925 * System.Data.SqlClient/SqlDataAdapter.cs:
926 This should inherit the IDbCommands instead of having its
927 own. An explicit cast is used to force conversion between
928 IDbCommand and SqlCommand
930 2002-05-13 Tim Coleman
931 * System.Data.Common/DataTableMappingCollection.cs:
932 Some implementation to allow progress with DbDataAdapter
934 2002-05-13 Tim Coleman
935 * System.Data.Common/DbDataAdapter.cs:
936 Modify to not break compile.
938 2002-05-13 Tim Coleman
940 include SqlDataAdapter, SqlRowUpdatedEventArgs,
941 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
942 SqlRowUpdatingEventHandler in the build.
944 2002-05-13 Tim Coleman
945 * System.Data.Common/DbDataAdapter.cs:
947 * System.Data.Common/DataAdapter.cs:
948 Correction of some of the stubbing, as well as a
949 little bit more implementation
951 2002-05-11 Tim Coleman
952 * System.Data.SqlClient/SqlDataAdapter.cs:
953 * System.Data.Common/DbDataAdapter.cs:
954 Moved methods that weren't supposed to
955 be in SqlDataAdapter out. They should be implemented
959 2002-05-11 Tim Coleman
960 * System.Data.SqlClient/SqlDataAdapter.cs:
961 some implementation of this class. Note
962 that none of the functionality has been
963 tested yet, but I felt it should be checked
964 in at this point as it compiles.
965 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
966 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
967 Modified so that they will compile properly.
968 Needed to include SqlDataAdapter in the build.
970 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
972 * System.Data/DataTable.cs (Clear): implemented.
973 (DataTable): removed repeated code in constructors, and call the
974 basic constructor from the others.
976 * System.Data/DataColumn.cs: some tweaks.
978 * System.Data/DataRow.cs (RowState): implemented.
979 (CancelEdit): set rowState property back to Unchanged.
980 (RejectChanges): call CancelEdit.
981 (Delete): set rowState to Deleted.
983 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
985 * System.Data.build: added copy of System.Data.dll to Test directory
986 for easy testing. Also, added clean for it too.
988 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
989 from PostgreSQL data type to .NET type.
991 * System.Data.SqlClient/SqlDataReader.cs: beginnings
992 handling of a NULL value from the database
994 * Test/PostgresTest.cs: added tests for NULL values retrieved
997 * Test/ReadPostgresData.cs
998 * Test/TestExecuteScalar.cs
999 * Test/TestSqlDataReader.cs
1000 * Test/TestSqlException.cs
1001 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
1002 "postgres". These tests may eventually be removed since they
1005 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
1007 * System.Data.build: removed reference to non-existant
1008 TestDataColumn.cs file.
1010 * System.Data/DataSet.cs: added some implementation.
1012 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
1014 * System.Data.SqlClient/PostgresLibrary.cs: got
1015 PostgreSQL data types time, date, timestamp (DateTime like)
1016 mapped to .NET System.DateTime working based
1017 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
1018 Also mapped pg type boolean to .net Boolean
1020 * SqlClient/SqlConnection.cs: run SQL command to set
1023 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
1024 added tests for aggregates min(), max(), sum(), count(). could
1025 not get avg() to work due to some formatting error; someone claimed
1026 that it was my locale settings. added tests for SELECT of columns
1027 of type boolean, float, double, date, time, and timestamp. They
1028 have not been fully tested, but its a start.
1030 2002-05-09 Tim Coleman <tim@timcoleman.com>
1031 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
1032 addition, subtraction, and multiplication for the
1033 SqlDecimal type, as well as modification of some other
1034 operations. More to come on this one.
1036 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
1038 * Test/System.Data_test.build: excluded TestDataColumn, which
1039 should be replaced with a nunit test.
1041 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
1043 2002-05-07 Tim Coleman <tim@timcoleman.com>
1057 Fix the broken build I made before. Bad
1060 2002-05-07 Tim Coleman <tim@timcoleman.com>
1062 Fix a symantic error I made in SqlString
1063 Equals where I copied and pasted wrongly
1065 2002-05-07 Tim Coleman <tim@timcoleman.com>
1070 * SqlCompareOptions.cs:
1081 Implement CompareTo, Equals, and String conversions
1084 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1086 * Test/PostgresTest.cs: modified to run completely. There
1087 are many TODOs in System.Data, so not all data types are
1088 included in the SELECT SQL query. Also, I made it to where
1090 using "host=localhost;dbname=test;user=postgres"
1091 instead of my userid and password. When more types are included,
1094 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1096 * Test/PostgresTest.cs: added - ported
1097 libgda postgres-test.c originally by
1098 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
1101 2002-05-05 Tim Coleman <tim@timcoleman.com>
1102 * System.Data.SqlTypes/SqlBinary.cs:
1103 * System.Data.SqlTypes/SqlBoolean.cs:
1104 * System.Data.SqlTypes/SqlByte.cs:
1105 * System.Data.SqlTypes/SqlDateTime.cs:
1106 * System.Data.SqlTypes/SqlDecimal.cs:
1107 * System.Data.SqlTypes/SqlDouble.cs:
1108 * System.Data.SqlTypes/SqlGuid.cs:
1109 * System.Data.SqlTypes/SqlInt16.cs:
1110 * System.Data.SqlTypes/SqlInt32.cs:
1111 * System.Data.SqlTypes/SqlInt64.cs:
1112 * System.Data.SqlTypes/SqlMoney.cs:
1113 * System.Data.SqlTypes/SqlSingle.cs:
1114 * System.Data.SqlTypes/SqlString.cs:
1115 More implementation, and code clean-up for consistency.
1116 Also, I had implemented many conversions as explicit
1117 that should have been implicit. This should remove
1118 many of the red X's and green pluses from the
1119 System.Data.SqlTypes namespace.
1121 2002-05-05 Miguel de Icaza <miguel@ximian.com>
1123 * System.Data/DataSet.cs: Remove [Serializable] attributes from
1124 methods, those only apply to structs or classes.
1126 Stub out ISerializable, ISupportInitialize, and IListSource methods
1128 * System.Data/DataRowView.cs: Stub out interface methods for
1129 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
1131 * System.Data/DataView.cs: Comment out non-implemented
1134 * System.Data/DataViewSettingsCollection.cs: Type cast variables
1135 to the correct type to make it compile.
1137 * System.Data/DataViewSettings.cs: remove reference to
1138 non-existance type ApplyDefaultSort, it is a boolean.
1141 2002-05-05 Tim Coleman <tim@timcoleman.com>
1142 * System.Data.SqlTypes/SqlBinary.cs:
1143 * System.Data.SqlTypes/SqlBoolean.cs:
1144 * System.Data.SqlTypes/SqlByte.cs:
1145 * System.Data.SqlTypes/SqlDecimal.cs:
1146 * System.Data.SqlTypes/SqlDouble.cs:
1147 * System.Data.SqlTypes/SqlGuid.cs:
1148 * System.Data.SqlTypes/SqlInt16.cs:
1149 * System.Data.SqlTypes/SqlInt32.cs:
1150 * System.Data.SqlTypes/SqlInt64.cs:
1151 * System.Data.SqlTypes/SqlMoney.cs:
1152 * System.Data.SqlTypes/SqlSingle.cs:
1153 * System.Data.SqlTypes/SqlString.cs:
1154 Various fixes, including adding the SqlNullValueException
1155 when trying to retrieve the value of a null SqlType,
1156 and when casting values, a Null of type A converts to a
1159 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1161 * System.Data.SqlClient/PostgresLibrary.cs
1162 * System.Data.SqlClient/SqlCommand.cs
1163 * System.Data.SqlClient/SqlConnection.cs
1164 * System.Data.SqlClient/SqlDataReader.cs
1165 oid should not be hard coded because they
1166 can change from one version of PostgreSQL
1167 to the next. Use the typname's instead.
1168 The PostgreSQL type data retrieves
1169 at database connection time. Any unimplemented
1170 types just default to string. These were things
1171 suggested by Gonzalo.
1173 * Test/ReadPostgresData.cs - stuff
1174 * Test/TestSqlDataReader.cs - stuff
1176 * System.Data.SqlTypes/SqlInt32.cs - added a using
1178 2002-05-03 Tim Coleman <tim@timcoleman.com>
1179 * System.Data.build: Fix the build so that test depends on build
1181 2002-05-03 Tim Coleman <tim@timcoleman.com>
1182 * System.Data.SqlTypes/SqlByte.cs:
1183 * System.Data.SqlTypes/SqlDateTime.cs:
1184 * System.Data.SqlTypes/SqlDecimal.cs:
1185 * System.Data.SqlTypes/SqlDouble.cs:
1186 * System.Data.SqlTypes/SqlGuid.cs:
1187 * System.Data.SqlTypes/SqlInt16.cs:
1188 * System.Data.SqlTypes/SqlInt64.cs:
1189 * System.Data.SqlTypes/SqlMoney.cs:
1190 * System.Data.SqlTypes/SqlSingle.cs:
1191 These files were mysteriously excluded from the last
1192 patch I made and sent to Rodrigo
1193 * System.Data.build: include the System.Data.SqlTypes in the build
1195 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1197 * System.Data.build: removed comments
1199 * System.Data.SqlClient/PostgresLibrary.cs: changed
1200 the hard-coded PostgreSQL oid type int's to using an
1201 enum. Also, added PostgreSQL bpchar (character) type.
1203 * Test/TestSqlDataReader.cs: updated test
1204 to include new bpchar PostgreSQL type
1206 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1208 * System.Data.SqlTypes/SqlBinary.cs:
1209 * System.Data.SqlTypes/SqlBoolean.cs:
1210 * System.Data.SqlTypes/SqlInt32.cs:
1211 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1212 Tim Coleman <tcoleman@opentext.com>.
1214 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1216 * Test/TestExecuteScalar.cs: added test for
1217 method ExecuteScalar in class SqlCommand.
1219 * System.Data/DataColumnCollection.cs - it should
1220 inherit properties from base InternalDataCollectionBase
1221 and use them instead of overriding them, such as, List.
1223 * System.Data/DataColumn.cs
1224 * System.Data/DataTable.cs: tweaks to retrieve
1225 meta data from the database
1227 * System.Data.SqlClient/PostgresLibrary.cs -
1228 added method OidToType to convert PostgreSQL oid type
1229 to System.Type. Renamed method OidTypeToSystem
1230 to ConvertPgTypeToSystem for converting the data value
1231 from a PostgreSQL type to a .NET System type.
1233 * System.Data.SqlClient/SqlCommand.cs: implemented
1234 method ExecuteReader which returns a SqlDataReader
1235 for a light forward only read only result set.
1236 It works on types int4 ==> Int32 and
1237 varchar ==> String. Other types
1240 * System.Data.SqlClient/SqlConnection.cs: added comment
1242 * System.Data.SqlClient/SqlDataReader.cs: implemented
1243 class. It works, but still lots to do.
1245 * Test/ReadPostgresData.cs: stuff
1247 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1248 to display meta data and the data
1250 2002-05-03 Duncan Mak <duncan@ximian.com>
1252 * TODO: Took out all the Exceptions. They should be all done now.
1254 * System.Data/ConstraintException.cs:
1255 * System.Data/DBConcurrencyException.cs:
1256 * System.Data/DataException.cs:
1257 * System.Data/DeletedRowInaccessibleException.cs:
1258 * System.Data/DuplicateNameException.cs:
1259 * System.Data/EvaluateException.cs:
1260 * System.Data/InRowChangingEventException.cs:
1261 * System.Data/InvalidConstraintException.cs:
1262 * System.Data/InvalidExpressionException.cs:
1263 * System.Data/MissingPrimaryKeyException.cs:
1264 * System.Data/NoNullAllowedException.cs:
1265 * System.Data/ReadOnlyException.cs:
1266 * System.Data/RowNotInTableException.cs:
1267 * System.Data/StrongTypingException.cs:
1268 * System.Data/SyntaxErrorException.cs:
1269 * System.Data/TypeDataSetGeneratorException.cs:
1270 * System.Data/VersionNotFoundException.cs: Added to CVS.
1272 * System.Data.SqlTypes/SqlNullValueException.cs:
1273 * System.Data.SqlTypes/SqlTruncateException.cs:
1274 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1276 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1278 * System.Data/DataViewSettingCollection.cs: implemented.
1280 * System.Data/DataRowView.cs: new stubs.
1282 * System.Data.SqlTypes/SqlByte.cs:
1283 * System.Data.SqlTypes/SqlDateTime.cs:
1284 * System.Data.SqlTypes/SqlDecimal.cs:
1285 * System.Data.SqlTypes/SqlDouble.cs:
1286 * System.Data.SqlTypes/SqlGuid.cs:
1287 * System.Data.SqlTypes/SqlInt16.cs:
1288 * System.Data.SqlTypes/SqlInt64.cs:
1289 * System.Data.SqlTypes/SqlMoney.cs:
1290 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1291 by Tim Coleman <tcoleman@opentext.com>
1293 * System.Data.build: excluded newly-added files.
1295 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1297 * System.Data.SqlClient/PostgresLibrary.cs: included new
1298 internal class that will be a helper class in using
1299 PostgreSQL. PostgresLibrary is used for the
1300 pinvoke methods to the PostgreSQL Client
1301 native C library libpq while the class PostgresHelper
1302 is used for wrapper or helper methods. It currently only
1303 has one static method OidTypeToSystem in converting
1304 PostgreSQL types to .NET System.<type>s, such as,
1305 a PostgreSQL int8 becomes a .NET System.Int64.
1306 Only a few types have been added, such as, int2,
1307 int4, int8, varchar, text, bool, and char. Other types
1310 * System.Data.SqlClient/SqlCommand.cs: implemented
1311 method ExecuteScalar which allows us to do aggregate
1312 functions, such as, count, avg, min, max, and sum. We
1313 also are able to retrieve the result, convert it to the .NET type
1314 as an object. The user of the returned object must explicitly cast.
1316 * Test/ReadPostgresData.cs: updated sample
1317 to help us learn to retrieve data in System.Data.SqlClient
1320 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1322 * System.Data.build: added /nowarn: nnnn arguments
1323 so you will not get a ton of warnings. The warnings
1324 being excluded are: 1595, 0067, 0109, 0169, and 0649
1326 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1328 * System.Data.build: modified to exclude more
1329 files from the build
1331 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1333 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1336 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1337 by John Dugaw <jdugaw@unizenconsulting.com>.
1339 * System.Data.build: excluded new files from build.
1341 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1343 * Test/ReadPostgresData.cs: added - Uses the
1344 PostgresLibrary to retrieve a recordset.
1345 This is not meant to be used in Production, but as a
1346 learning aid in coding
1347 class System.Data.SqlClient.SqlDataReader.
1348 This sample does work.
1350 * Test/TestSqlDataReader.cs: added - used
1351 to test SqlDataReader (does not work yet)
1352 Forgot to add to ChangeLog on last commit.
1354 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1356 * System.Data/DataViewSetting.cs: new class.
1358 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1360 * System.Data/DataViewManager.cs: new class.
1362 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1363 don't have implementation.
1365 * System.Data.SqlTypes/SqlInt32.cs:
1366 * System.Data.SqlTypes/SqlString.cs:
1367 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1368 these are strctures.
1370 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1373 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1375 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1376 for correctly hiding parent class' members.
1377 (AddRange): use 'override' keyword on overriden method.
1379 (Contains): likewise.
1380 (IndexOf): likewise.
1381 (OnCollectionChanged): likewise.
1382 (OnCollectionChanging): likewise.
1383 (RemoveCore): likewise.
1385 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1387 * System.Data/DataSet.cs: added missing 'using's.
1389 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1391 * System.Data/DataSet.cs:
1392 * System.Data/DataTableCollection.cs:
1393 * System.Data/DataView.cs: compilation fixes on Linux.
1395 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1397 * System.Data/DataRelation.cs
1398 * System.Data/ForeignKeyConstraint.cs
1399 * System.Data/UniqueConstraint.cs: added more stubs
1401 * System.Data/DataTableRelationCollection.cs: added back to cvs
1402 and modified for compile errors. DataRelationCollection is an
1403 abstract class and there must be a class that implements for
1404 DataTable/DataSet. DataTableRelationCollection was changed
1405 to an internal class.
1407 * System.Data.build: modified - new files added
1408 also wanted to include files/classes in the build
1409 so we can get a compilable forward read only result set.
1410 It compiles now using csc/nant with warnings, but this
1411 is a start for adding functionality for the result set.
1412 Classes associated with/and DataSet are still excluded.
1414 * TODO: modified - updated to do list for System.Data
1416 * System.Data/Constraint.cs
1417 * System.Data/ConstraintCollection.cs
1418 * System.Data/DataRelationCollection.cs
1419 * System.Data/DataRow.cs
1420 * System.Data/DataRowChangeEventArgs.cs
1421 * System.Data/DataRowCollection.cs
1422 * System.Data/DataTable.cs
1423 * System.Data/DataTableCollection.cs
1424 * System.Data/InternalDataCollectionBase.cs
1425 * System.Data/PropertyCollection.cs: modified -
1426 changes to compile SqlDataReader/DataTable and
1429 * System.Data/IDbCommand.cs
1430 * System.Data.SqlClient/SqlCommand.cs: modified -
1431 un-commented overloaded methods ExecuteReader
1432 which returns a SqlDataReader
1434 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1436 * System.Data/DataTableCollection.cs: more implementation.
1437 (Count): added 'override' keyword, as pointer out by Martin.
1439 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1440 only call Array.Copy when there is really stuff to be copied.
1441 (CopyTo): don't create the temporary array, it's not needed.
1443 * System.Data.build: excluded newly added file from build.
1445 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1447 * System.Data/DataTableRelationCollection.cs: removed, it's not
1448 on MS SDK documentation.
1450 * System.Data/DataTableCollection.cs: new class.
1452 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1454 * System.Data/DataRowChangeEventArgs.cs
1455 * System.Data/DataRowCollection.cs
1456 * System.Data/DataView.cs
1457 * System.Data/PropertyCollection.cs: added new stubs
1459 * System.Data.build: modified - added new files to exclude
1462 * TODO: modified - removed files from TODO list
1463 that were stubbed above
1465 * System.Data/DataColumn.cs
1466 * System.Data/DataRow.cs: modified - various tweaks
1467 and added internal method SetTable to set the reference
1470 * System.Data/DataSet.cs: modified - class was not
1473 * System.Data/DataTable.cs: modified - temporarily commented
1474 DataSet and DataView references - trying to compile a SqlDataReader,
1475 DataTable, and dependencies for a forward read-only result set.
1476 SqlDataAdapter, DataSet, and DataView will come later once we can get
1477 a forward read only result set working.
1479 * System.Data/IDataRecord.cs: modified - source code lines should
1482 * System.Data/InternalDataCollectionBase.cs: modified - started
1483 implementing this base class for collection of data rows,
1484 columns, tables, relations, and constraints
1486 * System.Data.SqlClient/SqlException.cs: modified -
1487 call base(message) so a unhandled exception displays
1488 the message of a SQL error instead of the
1489 default SystemException message
1491 * Test/TestSqlException.cs: modified -
1492 handle the rollback properly for a SqlException on a
1495 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1497 * System.Data.build: modified - added new
1498 files to exclude from build
1500 * System.Data/Constraint.cs
1501 * System.Data/ConstraintCollection.cs
1502 * System.Data/InternalDataCollectionBase.cs: added -
1503 stubs which are needed to build DataTable.cs
1505 * TODO: modified - added more classes TODO and
1506 added more stuff TODO, such as, create script
1507 to create test database monotestdb for testing
1508 classes in System.Data
1510 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1512 * System.Data.Common/DataAdapter.cs:
1513 * System.Data.Common/DataColumnMappingCollection.cs:
1514 * System.Data.Common/DataTableMappingCollection.cs:
1515 * System.Data.Common/DbDataPermission.cs:
1516 * System.Data.Common/DbDataPermissionAttribute.cs: some
1517 compilation errors fixed.
1519 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1521 * TODO: modified - added classes TODO, and
1522 a poor attempt at System.Data plan
1524 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1526 * ChangeLog: modified - put tabs where they belong
1528 * System.Data.SqlClient/SqlDataReader.cs
1529 * System.Data/DataColumn.cs: modified - compile errors
1530 trying to compile SqlDataAdapter and dependencies
1532 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1534 * System.Data.SqlTypes/SqlBoolean.cs
1535 * System.Data.SqlTypes/SqlCompareOptions.cs
1536 * System.Data.SqlTypes/SqlInt32.cs
1537 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1539 * System.Data/DataTable.cs
1540 * System.Data.SqlClient/SqlCommand.cs
1541 * System.Data.SqlClient/SqlConnection.cs
1542 * System.Data.SqlClient/SqlError.cs
1543 * System.Data.SqlClient/SqlTransaction.cs: modified -
1546 * System.Data.SqlClient/SqlException.cs: modified -
1547 missing Message on indexer for Message property
1549 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1551 * System.Data.SqlClient/SqlCommand.cs: modified - to
1552 compile using mcs. This problem is
1553 returning a stronger type in csc vs. msc
1555 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1556 can not do a using PGconn = IntPtr; and then declare
1557 with PGconn pgConn = IntPtr.Zero;
1558 Thiw works under csc though. Had to comment using and
1559 changed declaration to IntPtr pgConn = IntPtr.Zero;
1560 Also, got rid of compile warnings for hostaddr and port.
1562 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1563 rid of compile warnings. Commented MonoTODO attribute because mcs
1564 doesn't seem to work with C# array property indexer (Item)
1567 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1568 commented MonoTODO attribute for indexer for mcs compiling
1570 * Test/TestSqlIsolationLevel.cs:
1571 * Test/TestSqlInsert.cs:
1572 * Test/TestSqlException.cs: modified -
1573 removed extra ExecuteNonQuery which caused two inserted rows
1575 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1577 * System.Data/StateChangeEventArgs.cs - added
1578 needed to compile System.Data.dll with mcs.
1580 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1582 * System.Data.OleDb: added directory - for OleDb database
1585 * System.Data.SqlClient/SqlClientPermission.cs
1586 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1587 * System.Data.SqlClient/SqlCommandBuilder.cs
1588 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1589 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1590 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1591 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1592 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1593 * Test/TestSqlException.cs
1594 * Test/TestSqlIsolationLevel.cs: added - more tests
1596 * System.Data.build: modified - added new files - excludes these too
1598 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1600 * System.Data.SqlClient/SqlConnection.cs
1601 * System.Data.SqlClient/SqlCommand.cs
1602 * System.Data.SqlClient/SqlTransaction.cs
1603 * System.Data.SqlClient/SqlException.cs
1604 * System.Data.SqlClient/SqlErrorCollection.cs
1605 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1606 exception/error handling. SqlConnection(connectionString)
1607 constructor should not automatically connect.
1609 * System.Data.SqlClient/SqlDataReader.cs
1610 * System.Data.SqlClient/SqlDataAdapter.cs
1611 * System.Data.SqlClient/SqlParameter.cs
1612 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1613 added using System.ComponentModel;
1615 * Test/TestSqlInsert.cs: modified - to use transaction
1617 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1619 * System.Data/DataRow.cs: new skeletons.
1621 * System.Data.Common/DataAdapter.cs:
1622 * System.Data.Common/DataColumnMapping.cs:
1623 * System.Data.Common/DataColumnMappingCollection.cs:
1624 * System.Data.Common/DataTableMapping.cs:
1625 * System.Data.Common/DataTableMappingCollection.cs:
1626 * System.Data.Common/DbDataAdapter.cs:
1627 * System.Data.Common/RowUpdatedEventArgs.cs:
1628 * System.Data.SqlClient/SqlDataAdapter.cs:
1629 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1632 * System.Data.Common/DbDataRecord.cs:
1633 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1636 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1638 * Test/TestSqlInsert.cs: modified - do
1639 a SQL DELETE before SQL INSERT of row so you can use this
1642 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1643 IsolationLevel for PostgreSQL is ReadCommitted. However,
1644 PostgreSQL allows Serializable as well.
1645 (Thanks to Gonzalo for that!)
1647 * System.Data.SqlClient/SqlConnection.cs: modified
1648 * System.Data.SqlClient/SqlCommand.cs: modified
1649 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1650 working; however, we still need to implement SQL errors
1651 and exceptions to properly handle transactions. Also, added
1652 status and error message support from the PostgreSQL database.
1653 Currently, this does a Console.WriteLine() to display the
1654 status and error messages, but this is a TODO
1655 for SQL errors and exceptions.
1657 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1658 attribute for System.Data.dll assembly
1660 * System.Data/IDbCommand.cs: modified - commented
1661 overloaded method ExecuteReader
1662 so System.Data.SqlClient.SqlCommand can compile
1664 * System.Data/IDbCommand.cs: modified
1665 * System.Data/IDbConnection.cs: modified - added using System;
1666 * System.Data/IDataParameter.cs
1668 * System.Data.build: modified - build classes
1669 in System.Data.SqlClient and exclude others in System.Data
1671 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1672 parameter data type from IntPtr to enum ExecStatusType
1674 * ChangeLog: modified - corrected previous entries in log
1676 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1678 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1679 implementation. Still missing some stuff.
1681 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1683 * System.Data.SqlClient/SqlConnection.cs: modified - got
1684 to compile, run, and connect to PostgreSQL database
1686 * System.Data.SqlClient/SqlCommand.cs: modified - got
1687 to compile, run, and execute a SQL INSERT command
1688 which successfully inserted a row
1689 into the PostgreSQL database
1691 * System.Data.SqlClient/SqlTransaction.cs: modified
1692 * System.Data.SqlClient/SqlParameter.cs: modified
1693 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1694 * System.Data.SqlClient/SqlError.cs: modified
1695 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1696 * System.Data.SqlClient/SqlException.cs: modified
1697 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1699 * System.Data.SqlClient/SqlAdapter: modified
1700 * System.Data.SqlClient/SqlReader: modified - add more stubs
1702 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1704 * Test/TestSqlInsert.cs: added
1706 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1708 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1709 class SqlConnecition
1710 * System.Data.SqlClient/SqlErrorCollection.cs: added
1711 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1713 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1715 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1716 * System.Data.IDbTransaction: Added Interface to IDisposable.
1717 * System.Data.IDbCommand: Fixed Capitalization of class name.
1718 * System.Data.IDbConnection: Fixed Capitalization of class name.
1720 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1722 * System.Data.Common/DbDataPermissionAttribute.cs:
1723 * System.Data.Common/DataAdapter.cs:
1724 * System.Data.Common/DataColumnMapping.cs:
1725 * System.Data.Common/DbDataPermission.cs: added some implementation.
1727 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1729 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1730 syntax, as pointed out by Levent Camlibel.
1732 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1734 * System.Data.SqlTypes/SqlBinary.cs:
1735 * System.Data.SqlTypes/INullable.cs: new skeletons.
1737 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1739 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1740 contains all calls the the PostgreSQL client library, to be used
1741 everywhere in System.Data.SqlClient.
1743 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1745 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1748 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1750 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1752 * System.Data.Common/DbDataRecord.cs:
1753 * System.Data.Common/DbEnumerator.cs:
1754 * System.Data.Common/RowUpdatedEventArgs.cs:
1755 * System.Data.Common/RowUpdatingEventArgs.cs:
1756 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1758 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1760 * System.Data.Common/DataTableMappingCollection.cs:
1761 * System.Data.Common/DbDataAdapter.cs:
1762 * System.Data.Common/DbDataPermission.cs:
1763 * System.Data.Common/DataTableMapping.cs: new skeletons.
1765 * System.Data.SqlClient/SqlDataAdapter.cs:
1766 * System.Data.SqlClient/SqlDataReader.cs:
1767 * System.Data.SqlClient/SqlErrors.cs:
1768 * System.Data.SqlClient/SqlError.cs:
1769 * System.Data.SqlClient/SqlException.cs:
1770 * System.Data.SqlClient/SqlParameter.cs:
1771 * System.Data.SqlClient/SqlParameterCollection.cs:
1772 * System.Data.SqlClient/SqlTransaction.cs:
1773 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1775 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1777 * System.Data.Common/DataColumnMapping.cs:
1778 * System.Data.Common/DataColumnMappingCollection.cs:
1779 * System.Data.Common/DataAdapter.cs: created skeletons.
1781 * System.Data.build: exclude new directories from build.
1783 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1785 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1787 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1788 implemented (2 methods).
1790 2002-03-24 Duncan Mak <duncan@ximian.com>
1792 * System.Data.build: Excluded System.Data.SqlClient from the build.
1793 The stubs are incomplete and they are stopping the build.
1795 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1797 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1799 * System.Data.SqlClient/*: added skeletons for the SQL managed
1800 provider for ADO.Net, to be based initially in PostgreSQL.
1802 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1804 Changed the Namespace on some Enums from mono.System.Data to System.Data
1806 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1808 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1809 default name if the ColumnName is null.
1810 * DataSet.cs : Added
1811 * DataTable.cs : Added
1812 * DataRelationCollection.cs : Added
1813 * DataTableRelationCollection.cs : Added
1814 * DataColumn : Added
1816 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1818 * DataColumnChangeEventArgs.cs : Added
1819 * DataColumnCollection.cs : Added
1821 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1823 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1824 * Updated all Enums, Interfaces, and Delegates in System.Data