1 2002-10-09 Rodrigo Moya <rodrigo@ximian.com>
3 * list: added System.Data.Odbc files.
5 2002-10-09 Brian Ritchie <brianlritchie@hotmail.com>
7 * System.Data.Odbc/*: added first version of ODBC managed provider.
9 2002-10-07 Gonzalo Paniagua Javier <gonzalo@ximian.com>
11 * System.Data/ConstraintCollection.cs:
12 * System.Data/DataColumnCollection.cs:
13 * System.Data/DataRowCollection.cs:
14 * System.Data/DataTableCollection.cs:
15 * System.Data/InternalDataCollectionBase.cs: made List internal to fix
16 the build with csc. It must be a mcs bug. I will try to get a test case.
18 2002-10-06 Luis Fernandez <luifer@onetel.net.uk>
20 * System.Data/Constraint.cs (AssertConstraint): added overloaded
23 * System.Data/DataColumnCollection.cs: added constraints when needed.
25 * System.Data/DataRow.cs: validate UniqueConstraint's.
27 * System.Data/DataRowCollection.cs (ValidateDataRowInternal): new
28 internal method to validate a given DataRow with respect to the
31 * System.Data/ForeignKeyConstraint.cs (AssertConstraint): stubs for
32 new overloaded method.
34 * System.Data/UniqueConstraint.cs: added implementation.
35 (AseertConstraint): implemented new overloaded method.
37 2002-10-01 Rodrigo Moya <rodrigo@ximian.com>
39 * System.Data.OleDb/OleDbConnection.cs (Open): commented code from
40 last commit, which wasn't supposed to be in CVS yet.
42 2002-10-01 Luis Fernandez <luifer@onetel.net.uk>
44 * System.Data/DataColumn.cs:
45 * System.Data/DataRow.cs:
46 * System.Data/DataRowCollection.cs:
47 * System.Data/DataTable.cs: some fixes and implementation.
49 2002-09-28 Vladimir Vukicevic <vladimir@pobox.com>
51 * System.Data.OleDb/OleDbConnection.cs: Close
52 reader properly in call to ExecuteScalar().
54 2002-09-07 Rodrigo Moya <rodrigo@ximian.com>
56 * System.Data.OleDb/OleDbConnection.cs (Open): changed to use OleDb
57 connection strings, which are then converted to GDA connection
58 strings, instead of using directly GDA data source names.
60 * System.Data.OleDb/libgda.cs: added more needed functions.
62 2002-09-06 Franklin Wise <gracenote@earthlink.net>
64 * System.Data/DataColumn.cs: More flushing out.
66 * System.Data/ForeignKeyConstraint.cs: Implemented GetHashCode()
68 * System.Data/UniqueKeyConstraint.cs: Implemented GetHashCode()
70 * Tests: See Changelog for System.Data/Test
72 2002-09-04 Franklin Wise <gracenote@earthlink.net>
74 * Tests: See Changelog for System.Data/Test
77 System.Data/DataColumnCollectionTest.cs
78 System.Data/DataRowCollectionTest.cs
79 System.Data/DataRowTest.cs
81 * System.Data/DataColumn.cs: Flushing out validation, type conversion for
82 autoincrement. Added lots of TODO's.
83 * System.Data/DataColumnCollection.cs: Wrote out add logic as a comment.
84 Tagged implementation with FIXME tags. Lot's more validation
85 and setup needs to be done, much of which is now tagged as todo's
88 * System.Data/DataRow.cs: Lot's of fixme's added.
90 * System.Data/DataRowCollection.cs: TODO's added.
92 * System.Data/DataTable.cs: Implemented PrimaryKey.
94 * System.Data/UniqueConstraint.cs: Implemented related PrimaryKey
97 2002-08-25 Rodrigo Moya <rodrigo@ximian.com>
99 * System.Data.OleDb/OleDbTransaction.cs (OleDbTransaction): manage
100 correctly the isolation level.
101 (IsolationLevel): likewise.
102 (~OleDbTransaction): implemented.
104 * System.Data.OleDb/libgda.cs: added more needed stuff.
106 2002-08-22 Daniel Morgan <danmorg@sc.rr.com>
108 * System.Data.SqlClient/SqlParameter.cs: flush
110 * System.Data.SqlClient/SqlParameterCollection.cs: fixes
111 for the Item property, IndexOf, and Contains.
113 * Test/SqlSharpCli.cs: added input parameters support.
114 when a query is executed, if a parameter name matches
115 a SQL# internal variable name, it uses that value for the parameter; otherwise,
116 the user is prompted for the parameter value. Currently, it only supports
119 2002-08-21 Rodrigo Moya <rodrigo@ximian.com>
121 * System.Data.OleDb/libgda.cs: adapted to changes in libgda (get_vtype
122 and get_type for GdaValue).
124 * System.Data.OleDb/OleDbDataReader.cs: adapted to changes in
127 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
129 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
131 (Close): set the dataReader to null.
133 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
134 connection's DataReader property to this object.
135 (Close): set it to null here.
136 (Depth, IsDbNull): implemented.
137 (this): implemented the Item property with a string indexer.
139 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
140 ExecuteScalar): do nothing if there's already an open data reader.
142 * System.Data.OleDb/libgda.cs: more API functions.
144 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
145 reader before continuing.
147 2002-08-20 Franklin Wise <gracenote@earthlink.net>
149 * System.Data/System.Data.build: added nowarn:0679
151 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
152 setup to begin implementing. Implemented ctor().
154 * Tests: See System.Data\Test\ChangeLog
157 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
159 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
161 2002-08-19 Franklin Wise <gracenote@earthlink.net>
163 * Tests: See System.Data\Test\ChangeLog
165 * System.Data/UniqueConstraint.cs: More validation.
167 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
168 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
171 * System.Data/DataTable.cs: Added more MonoTODO tags
173 * class/System.Data/.cvsignore: added tmp & Temp
175 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
178 * System.Data/ConstraintCollection.cs: Commented out unused line.
180 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
182 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
184 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
186 (ErrorCode, Message, Source, Errors): implemented.
188 * System.Data.OleDb/OleDbError.cs: implemented the full class.
190 * System.Data.OleDb/libgda.cs: added more libgda functions.
192 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
193 the opened connection.
195 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
197 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
199 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
200 ArrayList after releasing the items.
201 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
202 GetOrdinal, GetString): implemented.
203 (GetDataTypeName): made it get the type from the data model, not from
204 the current value, which could not have been retrieved yet.
205 (GetValue): call the Get* method corresponding with the data type of
206 the requested column.
208 * System.Data.OleDb/libgda.cs: added more libgda functions.
209 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
211 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
212 titles via OleDbDataReader.GetName ().
213 (TestOleDb): create temporary table with a date field.
214 (InsertRow): set current date for the date field.
216 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
218 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
219 GetValue, which will take care of all the work needed.
220 (Close): implemented basic stuff.
221 (~OleDbDataReader): implemented.
223 * System.Data.OleDb/libgda.cs: added more needed functions.
225 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
227 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
229 (TestTransaction): added test for transactions.
231 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
233 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
235 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
236 when there are errors.
237 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
239 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
242 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
244 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
246 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
247 create an empty GdaParameterList.
249 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
250 for NULL before passing them to Marshal.PtrToStructure, which issues
251 an exception if the value is NULL.
253 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
255 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
256 unreachable code to avoid compiler warning.
258 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
260 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
261 (OpenReader): removed internal method.
263 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
264 the list of returned data models.
266 2002-08-15 Franklin Wise <gracenote@earthlink.net>
268 * System.Data/Constraint.cs: Added helper virtual functions
270 * System.Data/ConstraintCollection.cs: Improved constraint removal,
271 validation. Removed specific knowledge of subclasses of
274 * System.Data/DataColumn.cs: Added static helper function to compare
275 if two DataColumn arrays are the same.
277 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
279 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
282 2002-08-13 Franklin Wise <gracenote@earthlink.net>
284 * System.Data/DataRow.cs: Added several fixme tags.
286 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
288 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
289 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
290 to avoid compiler warnings.
292 2002-08-12 Franklin Wise <gracenote@earthlink.net>
294 * System.Data/Constraint.cs: Implemented
296 * System.Data/UniqueConstraint.cs: GetHashCode() &
297 special case Ctor. Still need to be implemented. LAMESPEC tags
300 * System.Data/ConstraintCollection.cs: Clear() &
301 AddRange() need to be finished. Several LAMESPEC tags.
303 * Allow Constraint collection to be created in DataTable.
305 * System.Data/ForeignKeyConstraint: Added a couple of
308 * System.Data/DataColumnCollection New/Added DataColumns now have
311 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
313 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
315 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
316 internal method, since we don't need it.
317 (ExecuteReader): call SetupGdaCommand before executing the command
318 via libgda functions.
319 (ExecuteScalar): implemented.
321 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
322 to OleDbCommand.OpenReader.
323 (GetBoolean): implemented.
325 2002-08-08 Franklin Wise <gracenote@earthlink.net>
327 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
329 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
331 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
334 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
336 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
337 and don't show a warning in Open.
339 * System.Data.OleDb/TestOleDb.cs: added Close.
341 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
343 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
344 ConnectionTimeout, ServerVersion, GdaConnection):
346 (OleDbConnection): call libgda.gda_init on constructor.
348 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
349 which wasn't been called.
351 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
354 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
356 * list: added missing System.Data.OleDb and
357 System.Data.Common files.
359 * System.Data.OleDb/ChangeLog: removed and merged with
360 System.Data's ChangeLog.
362 * System.Data.OleDb/OleDbDataAdapter.cs:
363 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
365 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
367 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
368 (IsClosed, Item, RecordsAffected): implemented some properties.
370 * libgda.cs: added GdaDataModel methods.
372 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
374 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
375 a second argument (ArrayList results).
376 (NextResult): implemented.
378 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
379 pass that to the OleDbDataReader.
380 (OleDbCommand constructor): don't create the ArrayList of results.
381 (GdaResults): removed property.
382 (ExecuteReader): create a temporary ArrayList and pass that to the
383 OleDbDataReader constructor.
385 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
387 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
388 (CreateParameter): implemented IDbCommand methods.
389 (CommandText): don't create many GdaCommand's, only one is needed.
390 (ExecuteNonQuery): set up the internal GDA command object.
391 (ExecuteReader): use correctly the unique GDA command object.
393 * System.Data.OleDb/libgda.cs: added new libgda calls.
395 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
397 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
398 (BeginTransaction): implemented IDbConnection methods.
400 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
402 * list: added System.Data.OleDb files to file list.
404 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
406 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
408 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
409 of the set method for this property.
411 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
412 (MissingSchemaAction): implemented.
414 2002-07-10 Tim Coleman <tim@timcoleman.com>
416 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
417 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
418 * System.Data.OleDb/OleDbError.cs: Added stubbs
419 * System.Data.OleDb/OleDbException.cs: Added stubbs
420 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
421 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
422 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
423 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
424 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
425 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
426 support transaction nesting
427 * System.Data.OleDb/libgda.cs: Added my name to this file
429 2002-07-09 Tim Coleman <tim@timcoleman.com>
431 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
432 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
433 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
434 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
435 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
436 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
437 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
438 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
439 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
440 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
441 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
442 * System.Data.OleDb/OleDbType.cs: Fixed two typos
443 * System.Data.OleDb/libgda.cs: Style changes, added new methods
445 2002-07-09 Tim Coleman <tim@timcoleman.com>
447 * System.Data.build: remove restriction on System.Data.OleDb build
449 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
451 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
452 IsSynchronized): implemented.
454 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
456 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
458 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
459 (Parameters, Transaction, Connection): made these overload
462 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
463 call m_list methods, not own ones.
465 * System.Data.OleDb/OleDbParameter.cs: more implementation.
467 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
469 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
470 Commit, Rollback): implemented.
471 (GdaConnection): added new internal property.
473 * System.Data.OleDb/OleDbParameter.cs:
474 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
477 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
479 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
481 * System.Data.OleDb/libgda.cs: added new libgda API functions.
483 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
484 (BeginTransaction): made it overload IDbConnection methods.
485 (ChangeDatabase): new stub, needs some work on libgda for being
488 (Close): implemented.
489 (CreateCommand): implemented.
490 (GetOleDbSchemaTable): new stub, until I understand what to do here.
491 (Open): implemented basic stuff, which is just supporting connection
492 strings that represent a GDA data source name. More to come.
493 (InfoMessage, StateChange): added events.
495 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
497 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
499 * System.Data.OleDb/libgda.cs: added static constructor.
500 (GdaClient): new static property to get the underlying GdaClient
503 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
504 the static 'libgda' class.
506 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
508 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
510 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
511 (ConnectionString, Connectiontimeout, Database, State):
512 implemented class properties.
513 (BeginTransaction): implemented.
515 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
517 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
519 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
521 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
523 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
525 * list: added missing PostgresTypes.cs file.
527 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
529 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
532 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
534 * System.Data.SqlClient/SqlConnection.cs: modifed -
535 start to implement the interfaces properly and
536 properly doing a Close(), Dispose(), and
539 * Test/SqlSharpCli.cs: modified -
540 add support for MySQL in Mono.Data.MySql
541 and OleDb support in System.Data.OleDb. However,
542 the OleDb support is commented right now.
543 When the program starts up, a shorter help menu should
544 display the most important commands: help and quit
546 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
548 * System.Data.build: exclude System.Data.OleDb files.
550 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
552 * System.Data.SqlClient/SqlCommand.cs: typo
553 should be CommandBehavior.KeyInfo
555 * Test/SqlSharpCli.cs: refactored and added a few more
558 2002-05-27 Tim Coleman <tim@timcoleman.com>
559 * list: update to compile properly (add missing
560 files and switch path delimiter from '\' to '/').
562 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
564 * System.Data/DataRow.cs
565 * System.Data.Common/DbDataAdapter.cs: fix to
566 get Test/TestSqlDataAdapter.cs to work again
568 * Test/TestSqlDataAdapter.cs: removed comment
569 about SqlDataReader:NextResult() not being implemented; it
572 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
574 * System.Data/DataRow.cs: modified
575 support setting of DBNull.Value
576 using the Item indexer this[DataColumn]
578 * System.Data.SqlClient/SqlCommand.cs: modified
579 tweaks to show TODO's for other CommandBehavior.
580 Set AllowDBNull column to true for IsKey row
583 * System.Data.SqlClient/SqlConnection.cs: modified
584 if transaction is in progress when a Close() is called,
585 do a transaction Rollback.
587 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
589 * Test/SqlSharpCli.cs: added file
590 My new toy. SQL# is a command-line tool to enter
591 SQL commands and queries using Mono System.Data.
592 It also serves as a test for Mono System.Data.
594 * System.Data.SqlClient/SqlCommand.cs: modified
595 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
596 should handle the results from SQL Commands and Queries.
597 - Internal class SqlResult should not create schema Table
598 for the result from a SQL Command. Also, set the RecordsRetrieved
599 property for SqlDataReader.
600 - Closing the SqlDataReader should Close() the SqlConnection for
601 a CommandBehavior.CloseConnection.
602 - Set defaults for SqlResult
604 * System.Data.SqlClient/SqlConnection.cs: modified -
605 when SqlDataReader is Close()
606 should Close() the SqlConnection for
607 a CommandBehavior.CloseConnection. Changed internal Property
608 from OpenReader get/set to IsReaderOpen get and created
609 internal methods OpenReader()/CloseReader() for SqlCommand to call.
610 SqlConnection needs to be prevented from doing while SqlDataReader
613 * System.Data.SqlClient/SqlDataReader.cs: modified -
614 call SqlCommand's OpenReader() internal method. get
615 RecordsRetrieved from SqlResult. set/reset default
616 values for SqlDataReader.
618 * Test/PostgresTest.cs
619 * Test/TestExecuteScalar.cs
620 * Test/TestSqlDataReader.cs: modified
621 for the Execute...() methods in SqlCommand
622 to test SQL Queries and Commands
624 * Test/System.Data_test.build: modified
625 exclude new file Test/SqlSharpCli.cs from
628 2002-05-24 Tim Coleman <tim@timcoleman.com>
629 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
630 for get accessors. These should be implemented in derived classes. See
631 SqlDataAdapter for clues.
632 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
633 * System.Data.Common/DataAdapter.cs:
634 * System.Data.Common/DataTableMappingCollection.cs:
635 * System.Data.Common/DataTableMapping.cs:
636 * System.Data.Common/DataColumnMappingCollection.cs:
637 * System.Data.Common/DataColumnMapping.cs:
638 Properly (I hope!) implement all of the appropriate interfaces
642 2002-05-23 Tim Coleman <tim@timcoleman.com>
643 * System.Data.SqlClient/SqlCommand.cs: include
644 the BaseColumnName in the schema table. Was missed before.
645 * System.Data.Common/DbDataAdapter.cs: Use DataTable
646 mappings so that the DataSet and DataTable are more closely tied.
647 Get schema information from the DataTable using GetSchemaTable ()
648 Various other little fixes
649 * System.Data.Common/DataColumnMappingCollection.cs:
650 * System.Data.Common/DataTableMapping.cs:
651 * System.Data.Common/DataTableMappingCollection.cs: Some
652 implementation, enough to be used by DbDataAdapter.
654 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
656 * System.Data.SqlClient/SqlCommand.cs: set
657 the "ProviderType" to the PostgreSQL type oid
659 * System.Data.SqlClient/SqlDataReader.cs: fix
660 for various properties and methods that
661 return meta data: Item indexers this[name] and this[index],
662 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
665 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
667 * System.Data/DataRow.cs: change suggested
668 by tim: in Item indexer, do an EndEdit()
670 * System.Data.SqlClient/SqlCommand.cs: more
671 fixes to SqlResult. After setting each item in
672 the DataRow, do an AcceptChanges() to commit
673 the changes in the DataRow. For DataType, use a Type
674 of System.String since System.Type nor System.Object
677 * Test/TestSqlDataReader.cs
678 * Test/PostgresTest.cs: updated to to be on
679 the way schema table is suppose to work
681 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
683 * System.Data.SqlClient/SqlCommand.cs: more work on
684 building the schema table
686 2002-05-22 Tim Coleman <tim@timcoleman.com>
687 * System.Data.SqlClient/SqlCommand.cs: preliminary work
688 on getting the schema table correctly built.
690 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
692 * System.Data.SqlClient/ParmUtil.cs: added file - to
693 provide utility for conversion of input parameters
695 * System.Data.SqlClient/PostgresTypes.cs: added file -
696 moved the PostgreHelper class to here. May eventually
697 move the internal class PostgresTypes that's inside the
698 SqlConnection to here as well.
699 Handling of PostgreSQL <-> .NET types need to be though
700 out more. Also, the PostgreHelper has a method to convert
701 from .NET types to a string which can be put into used in
702 an SQL statement to execute against a PostgreSQL database.
703 This is the beginnings of parameters support. It currently
704 only supports input parameters. Still need to do output,
705 input/output, and return parameters.
707 * Test/TestSqlParameters.cs: new test to test the input
708 parameters in System.Data.SqlClient against a
711 * System.Data.SqlClient/PostgresLibrary.cs: moved
712 PostgresHelper class to file PostgresTypes.cs. Also
713 moved struct PostgresType there too.
715 * System.Data.SqlClient/SqlCommand.cs: added input
718 * System.Data.SqlClient/SqlParameter.cs: got
721 * System.Data.SqlClient/SqlParameterCollection.cs: got
722 SqlParameterCollection to work
724 * Test/System.Data_test.build: added files to exclude
727 * System.Data.SqlClient/SqlConnection.cs: release resources
730 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
732 * System.Xml: added directory for classes with namespace
733 System.Xml to go into the System.Data.dll assembly
735 * System.Xml/XmlDataDocument: added file
736 for stubbed concrete class XmlDataDocument which
737 inherits from XmlDocument. Its purpose is to provide
738 a W3C XML DOM Document for relational data and interacting
741 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
743 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
744 Text, TableDirect, and StoredProcedure
746 * Test/PostgresTest.cs: changed call to version()
747 stored procedure to use the CommandType of StoredProcedure
749 * Test/TestSqlDataReader.cs: test all the CommandTypes
751 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
753 * System.Data.build: took out all excluded
754 files except the ones in the Test directory
755 because all files compile now. It does not
756 mean they all work or have implementations
759 * System.Data/DataRelationCollection.cs
760 * System.Data/DataTableRelationCollection.cs
761 * System.Data/InternalDataCollectionBase.cs
762 * System.Data.Common/DbDataPermission.cs
763 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
764 * System.Data.SqlClient/SqlClientPermission.cs
765 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
766 to get all System.Data* files to compile.
768 * System.Data.SqlClient/SqlCommand.cs: started coding
769 to prevent SqlConnection and SqlCommand from doing
770 anyting while fetching data using SqlDataReader. Also,
771 started coding to undo this prevention once the
772 SqlDataReader is closed.
774 * System.Data.SqlClient/SqlConnection.cs: get database server
775 version. Started coding to prevent connection from
776 doing anything while fetching data and undo once the reader
777 is closed. Include events SqlInfoMessage and StateChange.
779 * System.Data.SqlClient/SqlDataReader.cs: start coding to
780 prevent connection and command from doing anything while
781 fetching data, and undo when closed.
783 * Test/PostgresTest.cs: added test to get ServerVersion
784 property from SqlConnection
786 2002-05-18 Tim Coleman <tim@timcoleman.com>
787 * System.Data/DataRow.cs: More implementation,
788 as well as boundary checks and small semantic
791 2002-05-18 Tim Coleman <tim@timcoleman.com>
792 * System.Data/DataRow.cs: Try to reduce memory
793 usage by only creating the original and proposed
794 arrays as required in BeginEdit, and then destroying
795 proposed during EndEdit, and original during AcceptChanges.
796 * System.Data.Common/DbDataAdapter.cs: Make the
797 startRecord and maxRecords parameters work correctly.
799 2002-05-18 Tim Coleman <tim@timcoleman.com>
800 * System.Data/DataRow.cs: Move the null check in
801 ItemArray set to above the Invalid Cast check, so
802 that we don't get null reference exceptions.
804 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
806 * System.Data.SqlClient/PostgresLibrary.cs: handle
807 data value from database being NULL
809 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
810 allow multiple result sets. Added new internal class
811 SqlResult to pass result set data from SqlCommand
814 * System.Data.SqlClient/SqlDataReader.cs: allow
815 multiple result sets.
817 * System.Data.SqlClient/SqlConnection.cs: moved
818 things around. Implement IDisposable.
820 * Test/TestSqlDataReader.cs: test for execution
821 of multiple result sets and display the results
822 of these multiple results sets
824 * Test/TestSqlDataAdapter.cs: tweaks
826 2002-05-17 Tim Coleman <tim@timcoleman.com>
827 * System.Data.Common/DbDataAdapter.cs:
828 - More implementation of Fill methods
829 - Get rid of isDirty flag, because we can just check
831 - Do *not* remove DataTables before Filling them
832 - Implicitly open the connection before doing a Fill
833 if it does not exist.
834 * System.Data.SqlClient/SqlDataAdapter.cs:
836 * System.Data/DataTableCollection.cs:
837 - Add DataSet to internal, undocumented constructor
838 - When a table is created, set its DataSet property
839 - Default table name for creation is "Table1" (see .NET)
840 - Inherit the ArrayList list from InternalDataCollecitonBase
841 and maintain a hashtable between table names and
843 * System.Data/DataTable.cs:
844 - Add internal dataSet field. This is used by
845 DataTableCollection when the DataTable is constructed.
846 * System.Data/DataSet.cs:
847 - Pass a reference to the DataSet when constructing the
850 2002-05-16 Tim Coleman <tim@timcoleman.com>
851 * System.Data.Common/DbDataAdapter.cs:
852 Use table.Rows.Add (itemArray) instead of
853 table.Rows.Add (thisRow) to provide better
855 * System.Data/DataRowCollection.cs:
856 Some implementation of this class.
857 * System.Data/InternalDataCollectionBase.cs:
858 Some implementation. Most notably, this now
859 has an enumerator so we can use foreach (DataRow row in table.Rows)
861 * System.Data/DataTable.cs:
862 Since DataRowCollection now accepts a DataTable in
863 its internal constructor, we must pass one in.
865 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
867 * Test/TestSqlDataAdapter.cs: added new test
868 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
869 DataRowCollection, and DataRow. It tests retrieving data
870 based on a SQL SELECT query. This test is based on Tim Coleman's
873 2002-05-16 Tim Coleman <tim@timcoleman.com>
874 * System.Data.Common/DbDataAdapter.cs:
875 Use table.Rows.Add (thisRow) instead of
876 table.ImportRow (thisRow)
877 * System.Data/DataRowCollection.cs:
878 Construct the ArrayList before using it
880 2002-05-16 Tim Coleman <tim@timcoleman.com>
881 * System.Data/DataTable.cs:
882 Construct the DataRowCollection in the DataTable
883 constructor. Otherwise, it's a null reference.
885 2002-05-16 Tim Coleman <tim@timcoleman.com>
886 * System.Data.SqlClient/SqlDataReader.cs:
887 Modify GetValues to use Array.Copy() to copy
888 the results from fields to values, rather than
889 an assignment, which results in loss of data.
891 2002-05-16 Tim Coleman <tim@timcoleman.com>
892 * System.Data/DataRow.cs:
893 More implementation and documentation. It should
894 work more like expected, although there is no way
895 to demonstrate this well yet. DataTable requires
898 2002-05-15 Tim Coleman <tim@timcoleman.com>
899 * System.Data/DataRow.cs:
900 Minor tweaks as I determine exactly how to
901 implement this class.
904 2002-05-14 Duncan Mak <duncan@ximian.com>
906 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
908 2002-05-14 Tim Coleman
909 * System.Data/DataRow.cs:
910 * System.Data/DataRowBuilder.cs:
911 * System.Data/DataTable.cs:
912 More implementation of these classes. DataRow
913 can now (possibly) do some useful things.
914 Still not sure what DataRowBuilder is all about,
915 other than passing a DataTable in.
917 2002-05-14 Tim Coleman
918 * System.Data/DataRowBuilder.cs:
919 Add stubb for this internal class.
921 2002-05-13 Tim Coleman
922 * System.Data.Common/DbDataAdapter.cs:
923 The maxRecords check was not correct.
925 2002-05-13 Tim Coleman
926 * System.Data/DataTableCollection.cs:
927 Fix an issue when adding a DataTable and size == 0.
928 Now explicitly checks if size > 0 before doing Array.Copy ()
929 * System.Data.Common/DbDataAdapter.cs:
930 Move closer to a working implementation.
931 Make the IDbCommand fields protected so that they can
933 * System.Data.SqlClient/SqlDataAdapter.cs:
934 This should inherit the IDbCommands instead of having its
935 own. An explicit cast is used to force conversion between
936 IDbCommand and SqlCommand
938 2002-05-13 Tim Coleman
939 * System.Data.Common/DataTableMappingCollection.cs:
940 Some implementation to allow progress with DbDataAdapter
942 2002-05-13 Tim Coleman
943 * System.Data.Common/DbDataAdapter.cs:
944 Modify to not break compile.
946 2002-05-13 Tim Coleman
948 include SqlDataAdapter, SqlRowUpdatedEventArgs,
949 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
950 SqlRowUpdatingEventHandler in the build.
952 2002-05-13 Tim Coleman
953 * System.Data.Common/DbDataAdapter.cs:
955 * System.Data.Common/DataAdapter.cs:
956 Correction of some of the stubbing, as well as a
957 little bit more implementation
959 2002-05-11 Tim Coleman
960 * System.Data.SqlClient/SqlDataAdapter.cs:
961 * System.Data.Common/DbDataAdapter.cs:
962 Moved methods that weren't supposed to
963 be in SqlDataAdapter out. They should be implemented
967 2002-05-11 Tim Coleman
968 * System.Data.SqlClient/SqlDataAdapter.cs:
969 some implementation of this class. Note
970 that none of the functionality has been
971 tested yet, but I felt it should be checked
972 in at this point as it compiles.
973 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
974 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
975 Modified so that they will compile properly.
976 Needed to include SqlDataAdapter in the build.
978 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
980 * System.Data/DataTable.cs (Clear): implemented.
981 (DataTable): removed repeated code in constructors, and call the
982 basic constructor from the others.
984 * System.Data/DataColumn.cs: some tweaks.
986 * System.Data/DataRow.cs (RowState): implemented.
987 (CancelEdit): set rowState property back to Unchanged.
988 (RejectChanges): call CancelEdit.
989 (Delete): set rowState to Deleted.
991 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
993 * System.Data.build: added copy of System.Data.dll to Test directory
994 for easy testing. Also, added clean for it too.
996 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
997 from PostgreSQL data type to .NET type.
999 * System.Data.SqlClient/SqlDataReader.cs: beginnings
1000 handling of a NULL value from the database
1002 * Test/PostgresTest.cs: added tests for NULL values retrieved
1005 * Test/ReadPostgresData.cs
1006 * Test/TestExecuteScalar.cs
1007 * Test/TestSqlDataReader.cs
1008 * Test/TestSqlException.cs
1009 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
1010 "postgres". These tests may eventually be removed since they
1013 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
1015 * System.Data.build: removed reference to non-existant
1016 TestDataColumn.cs file.
1018 * System.Data/DataSet.cs: added some implementation.
1020 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
1022 * System.Data.SqlClient/PostgresLibrary.cs: got
1023 PostgreSQL data types time, date, timestamp (DateTime like)
1024 mapped to .NET System.DateTime working based
1025 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
1026 Also mapped pg type boolean to .net Boolean
1028 * SqlClient/SqlConnection.cs: run SQL command to set
1031 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
1032 added tests for aggregates min(), max(), sum(), count(). could
1033 not get avg() to work due to some formatting error; someone claimed
1034 that it was my locale settings. added tests for SELECT of columns
1035 of type boolean, float, double, date, time, and timestamp. They
1036 have not been fully tested, but its a start.
1038 2002-05-09 Tim Coleman <tim@timcoleman.com>
1039 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
1040 addition, subtraction, and multiplication for the
1041 SqlDecimal type, as well as modification of some other
1042 operations. More to come on this one.
1044 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
1046 * Test/System.Data_test.build: excluded TestDataColumn, which
1047 should be replaced with a nunit test.
1049 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
1051 2002-05-07 Tim Coleman <tim@timcoleman.com>
1065 Fix the broken build I made before. Bad
1068 2002-05-07 Tim Coleman <tim@timcoleman.com>
1070 Fix a symantic error I made in SqlString
1071 Equals where I copied and pasted wrongly
1073 2002-05-07 Tim Coleman <tim@timcoleman.com>
1078 * SqlCompareOptions.cs:
1089 Implement CompareTo, Equals, and String conversions
1092 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1094 * Test/PostgresTest.cs: modified to run completely. There
1095 are many TODOs in System.Data, so not all data types are
1096 included in the SELECT SQL query. Also, I made it to where
1098 using "host=localhost;dbname=test;user=postgres"
1099 instead of my userid and password. When more types are included,
1102 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1104 * Test/PostgresTest.cs: added - ported
1105 libgda postgres-test.c originally by
1106 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
1109 2002-05-05 Tim Coleman <tim@timcoleman.com>
1110 * System.Data.SqlTypes/SqlBinary.cs:
1111 * System.Data.SqlTypes/SqlBoolean.cs:
1112 * System.Data.SqlTypes/SqlByte.cs:
1113 * System.Data.SqlTypes/SqlDateTime.cs:
1114 * System.Data.SqlTypes/SqlDecimal.cs:
1115 * System.Data.SqlTypes/SqlDouble.cs:
1116 * System.Data.SqlTypes/SqlGuid.cs:
1117 * System.Data.SqlTypes/SqlInt16.cs:
1118 * System.Data.SqlTypes/SqlInt32.cs:
1119 * System.Data.SqlTypes/SqlInt64.cs:
1120 * System.Data.SqlTypes/SqlMoney.cs:
1121 * System.Data.SqlTypes/SqlSingle.cs:
1122 * System.Data.SqlTypes/SqlString.cs:
1123 More implementation, and code clean-up for consistency.
1124 Also, I had implemented many conversions as explicit
1125 that should have been implicit. This should remove
1126 many of the red X's and green pluses from the
1127 System.Data.SqlTypes namespace.
1129 2002-05-05 Miguel de Icaza <miguel@ximian.com>
1131 * System.Data/DataSet.cs: Remove [Serializable] attributes from
1132 methods, those only apply to structs or classes.
1134 Stub out ISerializable, ISupportInitialize, and IListSource methods
1136 * System.Data/DataRowView.cs: Stub out interface methods for
1137 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
1139 * System.Data/DataView.cs: Comment out non-implemented
1142 * System.Data/DataViewSettingsCollection.cs: Type cast variables
1143 to the correct type to make it compile.
1145 * System.Data/DataViewSettings.cs: remove reference to
1146 non-existance type ApplyDefaultSort, it is a boolean.
1149 2002-05-05 Tim Coleman <tim@timcoleman.com>
1150 * System.Data.SqlTypes/SqlBinary.cs:
1151 * System.Data.SqlTypes/SqlBoolean.cs:
1152 * System.Data.SqlTypes/SqlByte.cs:
1153 * System.Data.SqlTypes/SqlDecimal.cs:
1154 * System.Data.SqlTypes/SqlDouble.cs:
1155 * System.Data.SqlTypes/SqlGuid.cs:
1156 * System.Data.SqlTypes/SqlInt16.cs:
1157 * System.Data.SqlTypes/SqlInt32.cs:
1158 * System.Data.SqlTypes/SqlInt64.cs:
1159 * System.Data.SqlTypes/SqlMoney.cs:
1160 * System.Data.SqlTypes/SqlSingle.cs:
1161 * System.Data.SqlTypes/SqlString.cs:
1162 Various fixes, including adding the SqlNullValueException
1163 when trying to retrieve the value of a null SqlType,
1164 and when casting values, a Null of type A converts to a
1167 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1169 * System.Data.SqlClient/PostgresLibrary.cs
1170 * System.Data.SqlClient/SqlCommand.cs
1171 * System.Data.SqlClient/SqlConnection.cs
1172 * System.Data.SqlClient/SqlDataReader.cs
1173 oid should not be hard coded because they
1174 can change from one version of PostgreSQL
1175 to the next. Use the typname's instead.
1176 The PostgreSQL type data retrieves
1177 at database connection time. Any unimplemented
1178 types just default to string. These were things
1179 suggested by Gonzalo.
1181 * Test/ReadPostgresData.cs - stuff
1182 * Test/TestSqlDataReader.cs - stuff
1184 * System.Data.SqlTypes/SqlInt32.cs - added a using
1186 2002-05-03 Tim Coleman <tim@timcoleman.com>
1187 * System.Data.build: Fix the build so that test depends on build
1189 2002-05-03 Tim Coleman <tim@timcoleman.com>
1190 * System.Data.SqlTypes/SqlByte.cs:
1191 * System.Data.SqlTypes/SqlDateTime.cs:
1192 * System.Data.SqlTypes/SqlDecimal.cs:
1193 * System.Data.SqlTypes/SqlDouble.cs:
1194 * System.Data.SqlTypes/SqlGuid.cs:
1195 * System.Data.SqlTypes/SqlInt16.cs:
1196 * System.Data.SqlTypes/SqlInt64.cs:
1197 * System.Data.SqlTypes/SqlMoney.cs:
1198 * System.Data.SqlTypes/SqlSingle.cs:
1199 These files were mysteriously excluded from the last
1200 patch I made and sent to Rodrigo
1201 * System.Data.build: include the System.Data.SqlTypes in the build
1203 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1205 * System.Data.build: removed comments
1207 * System.Data.SqlClient/PostgresLibrary.cs: changed
1208 the hard-coded PostgreSQL oid type int's to using an
1209 enum. Also, added PostgreSQL bpchar (character) type.
1211 * Test/TestSqlDataReader.cs: updated test
1212 to include new bpchar PostgreSQL type
1214 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1216 * System.Data.SqlTypes/SqlBinary.cs:
1217 * System.Data.SqlTypes/SqlBoolean.cs:
1218 * System.Data.SqlTypes/SqlInt32.cs:
1219 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1220 Tim Coleman <tcoleman@opentext.com>.
1222 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1224 * Test/TestExecuteScalar.cs: added test for
1225 method ExecuteScalar in class SqlCommand.
1227 * System.Data/DataColumnCollection.cs - it should
1228 inherit properties from base InternalDataCollectionBase
1229 and use them instead of overriding them, such as, List.
1231 * System.Data/DataColumn.cs
1232 * System.Data/DataTable.cs: tweaks to retrieve
1233 meta data from the database
1235 * System.Data.SqlClient/PostgresLibrary.cs -
1236 added method OidToType to convert PostgreSQL oid type
1237 to System.Type. Renamed method OidTypeToSystem
1238 to ConvertPgTypeToSystem for converting the data value
1239 from a PostgreSQL type to a .NET System type.
1241 * System.Data.SqlClient/SqlCommand.cs: implemented
1242 method ExecuteReader which returns a SqlDataReader
1243 for a light forward only read only result set.
1244 It works on types int4 ==> Int32 and
1245 varchar ==> String. Other types
1248 * System.Data.SqlClient/SqlConnection.cs: added comment
1250 * System.Data.SqlClient/SqlDataReader.cs: implemented
1251 class. It works, but still lots to do.
1253 * Test/ReadPostgresData.cs: stuff
1255 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1256 to display meta data and the data
1258 2002-05-03 Duncan Mak <duncan@ximian.com>
1260 * TODO: Took out all the Exceptions. They should be all done now.
1262 * System.Data/ConstraintException.cs:
1263 * System.Data/DBConcurrencyException.cs:
1264 * System.Data/DataException.cs:
1265 * System.Data/DeletedRowInaccessibleException.cs:
1266 * System.Data/DuplicateNameException.cs:
1267 * System.Data/EvaluateException.cs:
1268 * System.Data/InRowChangingEventException.cs:
1269 * System.Data/InvalidConstraintException.cs:
1270 * System.Data/InvalidExpressionException.cs:
1271 * System.Data/MissingPrimaryKeyException.cs:
1272 * System.Data/NoNullAllowedException.cs:
1273 * System.Data/ReadOnlyException.cs:
1274 * System.Data/RowNotInTableException.cs:
1275 * System.Data/StrongTypingException.cs:
1276 * System.Data/SyntaxErrorException.cs:
1277 * System.Data/TypeDataSetGeneratorException.cs:
1278 * System.Data/VersionNotFoundException.cs: Added to CVS.
1280 * System.Data.SqlTypes/SqlNullValueException.cs:
1281 * System.Data.SqlTypes/SqlTruncateException.cs:
1282 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1284 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1286 * System.Data/DataViewSettingCollection.cs: implemented.
1288 * System.Data/DataRowView.cs: new stubs.
1290 * System.Data.SqlTypes/SqlByte.cs:
1291 * System.Data.SqlTypes/SqlDateTime.cs:
1292 * System.Data.SqlTypes/SqlDecimal.cs:
1293 * System.Data.SqlTypes/SqlDouble.cs:
1294 * System.Data.SqlTypes/SqlGuid.cs:
1295 * System.Data.SqlTypes/SqlInt16.cs:
1296 * System.Data.SqlTypes/SqlInt64.cs:
1297 * System.Data.SqlTypes/SqlMoney.cs:
1298 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1299 by Tim Coleman <tcoleman@opentext.com>
1301 * System.Data.build: excluded newly-added files.
1303 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1305 * System.Data.SqlClient/PostgresLibrary.cs: included new
1306 internal class that will be a helper class in using
1307 PostgreSQL. PostgresLibrary is used for the
1308 pinvoke methods to the PostgreSQL Client
1309 native C library libpq while the class PostgresHelper
1310 is used for wrapper or helper methods. It currently only
1311 has one static method OidTypeToSystem in converting
1312 PostgreSQL types to .NET System.<type>s, such as,
1313 a PostgreSQL int8 becomes a .NET System.Int64.
1314 Only a few types have been added, such as, int2,
1315 int4, int8, varchar, text, bool, and char. Other types
1318 * System.Data.SqlClient/SqlCommand.cs: implemented
1319 method ExecuteScalar which allows us to do aggregate
1320 functions, such as, count, avg, min, max, and sum. We
1321 also are able to retrieve the result, convert it to the .NET type
1322 as an object. The user of the returned object must explicitly cast.
1324 * Test/ReadPostgresData.cs: updated sample
1325 to help us learn to retrieve data in System.Data.SqlClient
1328 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1330 * System.Data.build: added /nowarn: nnnn arguments
1331 so you will not get a ton of warnings. The warnings
1332 being excluded are: 1595, 0067, 0109, 0169, and 0649
1334 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1336 * System.Data.build: modified to exclude more
1337 files from the build
1339 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1341 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1344 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1345 by John Dugaw <jdugaw@unizenconsulting.com>.
1347 * System.Data.build: excluded new files from build.
1349 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1351 * Test/ReadPostgresData.cs: added - Uses the
1352 PostgresLibrary to retrieve a recordset.
1353 This is not meant to be used in Production, but as a
1354 learning aid in coding
1355 class System.Data.SqlClient.SqlDataReader.
1356 This sample does work.
1358 * Test/TestSqlDataReader.cs: added - used
1359 to test SqlDataReader (does not work yet)
1360 Forgot to add to ChangeLog on last commit.
1362 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1364 * System.Data/DataViewSetting.cs: new class.
1366 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1368 * System.Data/DataViewManager.cs: new class.
1370 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1371 don't have implementation.
1373 * System.Data.SqlTypes/SqlInt32.cs:
1374 * System.Data.SqlTypes/SqlString.cs:
1375 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1376 these are strctures.
1378 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1381 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1383 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1384 for correctly hiding parent class' members.
1385 (AddRange): use 'override' keyword on overriden method.
1387 (Contains): likewise.
1388 (IndexOf): likewise.
1389 (OnCollectionChanged): likewise.
1390 (OnCollectionChanging): likewise.
1391 (RemoveCore): likewise.
1393 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1395 * System.Data/DataSet.cs: added missing 'using's.
1397 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1399 * System.Data/DataSet.cs:
1400 * System.Data/DataTableCollection.cs:
1401 * System.Data/DataView.cs: compilation fixes on Linux.
1403 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1405 * System.Data/DataRelation.cs
1406 * System.Data/ForeignKeyConstraint.cs
1407 * System.Data/UniqueConstraint.cs: added more stubs
1409 * System.Data/DataTableRelationCollection.cs: added back to cvs
1410 and modified for compile errors. DataRelationCollection is an
1411 abstract class and there must be a class that implements for
1412 DataTable/DataSet. DataTableRelationCollection was changed
1413 to an internal class.
1415 * System.Data.build: modified - new files added
1416 also wanted to include files/classes in the build
1417 so we can get a compilable forward read only result set.
1418 It compiles now using csc/nant with warnings, but this
1419 is a start for adding functionality for the result set.
1420 Classes associated with/and DataSet are still excluded.
1422 * TODO: modified - updated to do list for System.Data
1424 * System.Data/Constraint.cs
1425 * System.Data/ConstraintCollection.cs
1426 * System.Data/DataRelationCollection.cs
1427 * System.Data/DataRow.cs
1428 * System.Data/DataRowChangeEventArgs.cs
1429 * System.Data/DataRowCollection.cs
1430 * System.Data/DataTable.cs
1431 * System.Data/DataTableCollection.cs
1432 * System.Data/InternalDataCollectionBase.cs
1433 * System.Data/PropertyCollection.cs: modified -
1434 changes to compile SqlDataReader/DataTable and
1437 * System.Data/IDbCommand.cs
1438 * System.Data.SqlClient/SqlCommand.cs: modified -
1439 un-commented overloaded methods ExecuteReader
1440 which returns a SqlDataReader
1442 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1444 * System.Data/DataTableCollection.cs: more implementation.
1445 (Count): added 'override' keyword, as pointer out by Martin.
1447 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1448 only call Array.Copy when there is really stuff to be copied.
1449 (CopyTo): don't create the temporary array, it's not needed.
1451 * System.Data.build: excluded newly added file from build.
1453 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1455 * System.Data/DataTableRelationCollection.cs: removed, it's not
1456 on MS SDK documentation.
1458 * System.Data/DataTableCollection.cs: new class.
1460 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1462 * System.Data/DataRowChangeEventArgs.cs
1463 * System.Data/DataRowCollection.cs
1464 * System.Data/DataView.cs
1465 * System.Data/PropertyCollection.cs: added new stubs
1467 * System.Data.build: modified - added new files to exclude
1470 * TODO: modified - removed files from TODO list
1471 that were stubbed above
1473 * System.Data/DataColumn.cs
1474 * System.Data/DataRow.cs: modified - various tweaks
1475 and added internal method SetTable to set the reference
1478 * System.Data/DataSet.cs: modified - class was not
1481 * System.Data/DataTable.cs: modified - temporarily commented
1482 DataSet and DataView references - trying to compile a SqlDataReader,
1483 DataTable, and dependencies for a forward read-only result set.
1484 SqlDataAdapter, DataSet, and DataView will come later once we can get
1485 a forward read only result set working.
1487 * System.Data/IDataRecord.cs: modified - source code lines should
1490 * System.Data/InternalDataCollectionBase.cs: modified - started
1491 implementing this base class for collection of data rows,
1492 columns, tables, relations, and constraints
1494 * System.Data.SqlClient/SqlException.cs: modified -
1495 call base(message) so a unhandled exception displays
1496 the message of a SQL error instead of the
1497 default SystemException message
1499 * Test/TestSqlException.cs: modified -
1500 handle the rollback properly for a SqlException on a
1503 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1505 * System.Data.build: modified - added new
1506 files to exclude from build
1508 * System.Data/Constraint.cs
1509 * System.Data/ConstraintCollection.cs
1510 * System.Data/InternalDataCollectionBase.cs: added -
1511 stubs which are needed to build DataTable.cs
1513 * TODO: modified - added more classes TODO and
1514 added more stuff TODO, such as, create script
1515 to create test database monotestdb for testing
1516 classes in System.Data
1518 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1520 * System.Data.Common/DataAdapter.cs:
1521 * System.Data.Common/DataColumnMappingCollection.cs:
1522 * System.Data.Common/DataTableMappingCollection.cs:
1523 * System.Data.Common/DbDataPermission.cs:
1524 * System.Data.Common/DbDataPermissionAttribute.cs: some
1525 compilation errors fixed.
1527 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1529 * TODO: modified - added classes TODO, and
1530 a poor attempt at System.Data plan
1532 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1534 * ChangeLog: modified - put tabs where they belong
1536 * System.Data.SqlClient/SqlDataReader.cs
1537 * System.Data/DataColumn.cs: modified - compile errors
1538 trying to compile SqlDataAdapter and dependencies
1540 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1542 * System.Data.SqlTypes/SqlBoolean.cs
1543 * System.Data.SqlTypes/SqlCompareOptions.cs
1544 * System.Data.SqlTypes/SqlInt32.cs
1545 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1547 * System.Data/DataTable.cs
1548 * System.Data.SqlClient/SqlCommand.cs
1549 * System.Data.SqlClient/SqlConnection.cs
1550 * System.Data.SqlClient/SqlError.cs
1551 * System.Data.SqlClient/SqlTransaction.cs: modified -
1554 * System.Data.SqlClient/SqlException.cs: modified -
1555 missing Message on indexer for Message property
1557 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1559 * System.Data.SqlClient/SqlCommand.cs: modified - to
1560 compile using mcs. This problem is
1561 returning a stronger type in csc vs. msc
1563 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1564 can not do a using PGconn = IntPtr; and then declare
1565 with PGconn pgConn = IntPtr.Zero;
1566 Thiw works under csc though. Had to comment using and
1567 changed declaration to IntPtr pgConn = IntPtr.Zero;
1568 Also, got rid of compile warnings for hostaddr and port.
1570 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1571 rid of compile warnings. Commented MonoTODO attribute because mcs
1572 doesn't seem to work with C# array property indexer (Item)
1575 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1576 commented MonoTODO attribute for indexer for mcs compiling
1578 * Test/TestSqlIsolationLevel.cs:
1579 * Test/TestSqlInsert.cs:
1580 * Test/TestSqlException.cs: modified -
1581 removed extra ExecuteNonQuery which caused two inserted rows
1583 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1585 * System.Data/StateChangeEventArgs.cs - added
1586 needed to compile System.Data.dll with mcs.
1588 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1590 * System.Data.OleDb: added directory - for OleDb database
1593 * System.Data.SqlClient/SqlClientPermission.cs
1594 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1595 * System.Data.SqlClient/SqlCommandBuilder.cs
1596 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1597 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1598 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1599 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1600 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1601 * Test/TestSqlException.cs
1602 * Test/TestSqlIsolationLevel.cs: added - more tests
1604 * System.Data.build: modified - added new files - excludes these too
1606 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1608 * System.Data.SqlClient/SqlConnection.cs
1609 * System.Data.SqlClient/SqlCommand.cs
1610 * System.Data.SqlClient/SqlTransaction.cs
1611 * System.Data.SqlClient/SqlException.cs
1612 * System.Data.SqlClient/SqlErrorCollection.cs
1613 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1614 exception/error handling. SqlConnection(connectionString)
1615 constructor should not automatically connect.
1617 * System.Data.SqlClient/SqlDataReader.cs
1618 * System.Data.SqlClient/SqlDataAdapter.cs
1619 * System.Data.SqlClient/SqlParameter.cs
1620 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1621 added using System.ComponentModel;
1623 * Test/TestSqlInsert.cs: modified - to use transaction
1625 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1627 * System.Data/DataRow.cs: new skeletons.
1629 * System.Data.Common/DataAdapter.cs:
1630 * System.Data.Common/DataColumnMapping.cs:
1631 * System.Data.Common/DataColumnMappingCollection.cs:
1632 * System.Data.Common/DataTableMapping.cs:
1633 * System.Data.Common/DataTableMappingCollection.cs:
1634 * System.Data.Common/DbDataAdapter.cs:
1635 * System.Data.Common/RowUpdatedEventArgs.cs:
1636 * System.Data.SqlClient/SqlDataAdapter.cs:
1637 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1640 * System.Data.Common/DbDataRecord.cs:
1641 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1644 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1646 * Test/TestSqlInsert.cs: modified - do
1647 a SQL DELETE before SQL INSERT of row so you can use this
1650 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1651 IsolationLevel for PostgreSQL is ReadCommitted. However,
1652 PostgreSQL allows Serializable as well.
1653 (Thanks to Gonzalo for that!)
1655 * System.Data.SqlClient/SqlConnection.cs: modified
1656 * System.Data.SqlClient/SqlCommand.cs: modified
1657 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1658 working; however, we still need to implement SQL errors
1659 and exceptions to properly handle transactions. Also, added
1660 status and error message support from the PostgreSQL database.
1661 Currently, this does a Console.WriteLine() to display the
1662 status and error messages, but this is a TODO
1663 for SQL errors and exceptions.
1665 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1666 attribute for System.Data.dll assembly
1668 * System.Data/IDbCommand.cs: modified - commented
1669 overloaded method ExecuteReader
1670 so System.Data.SqlClient.SqlCommand can compile
1672 * System.Data/IDbCommand.cs: modified
1673 * System.Data/IDbConnection.cs: modified - added using System;
1674 * System.Data/IDataParameter.cs
1676 * System.Data.build: modified - build classes
1677 in System.Data.SqlClient and exclude others in System.Data
1679 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1680 parameter data type from IntPtr to enum ExecStatusType
1682 * ChangeLog: modified - corrected previous entries in log
1684 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1686 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1687 implementation. Still missing some stuff.
1689 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1691 * System.Data.SqlClient/SqlConnection.cs: modified - got
1692 to compile, run, and connect to PostgreSQL database
1694 * System.Data.SqlClient/SqlCommand.cs: modified - got
1695 to compile, run, and execute a SQL INSERT command
1696 which successfully inserted a row
1697 into the PostgreSQL database
1699 * System.Data.SqlClient/SqlTransaction.cs: modified
1700 * System.Data.SqlClient/SqlParameter.cs: modified
1701 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1702 * System.Data.SqlClient/SqlError.cs: modified
1703 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1704 * System.Data.SqlClient/SqlException.cs: modified
1705 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1707 * System.Data.SqlClient/SqlAdapter: modified
1708 * System.Data.SqlClient/SqlReader: modified - add more stubs
1710 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1712 * Test/TestSqlInsert.cs: added
1714 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1716 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1717 class SqlConnecition
1718 * System.Data.SqlClient/SqlErrorCollection.cs: added
1719 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1721 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1723 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1724 * System.Data.IDbTransaction: Added Interface to IDisposable.
1725 * System.Data.IDbCommand: Fixed Capitalization of class name.
1726 * System.Data.IDbConnection: Fixed Capitalization of class name.
1728 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1730 * System.Data.Common/DbDataPermissionAttribute.cs:
1731 * System.Data.Common/DataAdapter.cs:
1732 * System.Data.Common/DataColumnMapping.cs:
1733 * System.Data.Common/DbDataPermission.cs: added some implementation.
1735 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1737 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1738 syntax, as pointed out by Levent Camlibel.
1740 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1742 * System.Data.SqlTypes/SqlBinary.cs:
1743 * System.Data.SqlTypes/INullable.cs: new skeletons.
1745 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1747 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1748 contains all calls the the PostgreSQL client library, to be used
1749 everywhere in System.Data.SqlClient.
1751 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1753 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1756 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1758 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1760 * System.Data.Common/DbDataRecord.cs:
1761 * System.Data.Common/DbEnumerator.cs:
1762 * System.Data.Common/RowUpdatedEventArgs.cs:
1763 * System.Data.Common/RowUpdatingEventArgs.cs:
1764 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1766 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1768 * System.Data.Common/DataTableMappingCollection.cs:
1769 * System.Data.Common/DbDataAdapter.cs:
1770 * System.Data.Common/DbDataPermission.cs:
1771 * System.Data.Common/DataTableMapping.cs: new skeletons.
1773 * System.Data.SqlClient/SqlDataAdapter.cs:
1774 * System.Data.SqlClient/SqlDataReader.cs:
1775 * System.Data.SqlClient/SqlErrors.cs:
1776 * System.Data.SqlClient/SqlError.cs:
1777 * System.Data.SqlClient/SqlException.cs:
1778 * System.Data.SqlClient/SqlParameter.cs:
1779 * System.Data.SqlClient/SqlParameterCollection.cs:
1780 * System.Data.SqlClient/SqlTransaction.cs:
1781 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1783 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1785 * System.Data.Common/DataColumnMapping.cs:
1786 * System.Data.Common/DataColumnMappingCollection.cs:
1787 * System.Data.Common/DataAdapter.cs: created skeletons.
1789 * System.Data.build: exclude new directories from build.
1791 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1793 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1795 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1796 implemented (2 methods).
1798 2002-03-24 Duncan Mak <duncan@ximian.com>
1800 * System.Data.build: Excluded System.Data.SqlClient from the build.
1801 The stubs are incomplete and they are stopping the build.
1803 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1805 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1807 * System.Data.SqlClient/*: added skeletons for the SQL managed
1808 provider for ADO.Net, to be based initially in PostgreSQL.
1810 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1812 Changed the Namespace on some Enums from mono.System.Data to System.Data
1814 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1816 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1817 default name if the ColumnName is null.
1818 * DataSet.cs : Added
1819 * DataTable.cs : Added
1820 * DataRelationCollection.cs : Added
1821 * DataTableRelationCollection.cs : Added
1822 * DataColumn : Added
1824 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1826 * DataColumnChangeEventArgs.cs : Added
1827 * DataColumnCollection.cs : Added
1829 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1831 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1832 * Updated all Enums, Interfaces, and Delegates in System.Data