1 2002-10-06 Luis Fernandez <luifer@onetel.net.uk>
3 * System.Data/Constraint.cs (AssertConstraint): added overloaded
6 * System.Data/DataColumnCollection.cs: added constraints when needed.
8 * System.Data/DataRow.cs: validate UniqueConstraint's.
10 * System.Data/DataRowCollection.cs (ValidateDataRowInternal): new
11 internal method to validate a given DataRow with respect to the
14 * System.Data/ForeignKeyConstraint.cs (AssertConstraint): stubs for
15 new overloaded method.
17 * System.Data/UniqueConstraint.cs: added implementation.
18 (AseertConstraint): implemented new overloaded method.
20 2002-10-01 Rodrigo Moya <rodrigo@ximian.com>
22 * System.Data.OleDb/OleDbConnection.cs (Open): commented code from
23 last commit, which wasn't supposed to be in CVS yet.
25 2002-10-01 Luis Fernandez <luifer@onetel.net.uk>
27 * System.Data/DataColumn.cs:
28 * System.Data/DataRow.cs:
29 * System.Data/DataRowCollection.cs:
30 * System.Data/DataTable.cs: some fixes and implementation.
32 2002-09-28 Vladimir Vukicevic <vladimir@pobox.com>
34 * System.Data.OleDb/OleDbConnection.cs: Close
35 reader properly in call to ExecuteScalar().
37 2002-09-07 Rodrigo Moya <rodrigo@ximian.com>
39 * System.Data.OleDb/OleDbConnection.cs (Open): changed to use OleDb
40 connection strings, which are then converted to GDA connection
41 strings, instead of using directly GDA data source names.
43 * System.Data.OleDb/libgda.cs: added more needed functions.
45 2002-09-06 Franklin Wise <gracenote@earthlink.net>
47 * System.Data/DataColumn.cs: More flushing out.
49 * System.Data/ForeignKeyConstraint.cs: Implemented GetHashCode()
51 * System.Data/UniqueKeyConstraint.cs: Implemented GetHashCode()
53 * Tests: See Changelog for System.Data/Test
55 2002-09-04 Franklin Wise <gracenote@earthlink.net>
57 * Tests: See Changelog for System.Data/Test
60 System.Data/DataColumnCollectionTest.cs
61 System.Data/DataRowCollectionTest.cs
62 System.Data/DataRowTest.cs
64 * System.Data/DataColumn.cs: Flushing out validation, type conversion for
65 autoincrement. Added lots of TODO's.
66 * System.Data/DataColumnCollection.cs: Wrote out add logic as a comment.
67 Tagged implementation with FIXME tags. Lot's more validation
68 and setup needs to be done, much of which is now tagged as todo's
71 * System.Data/DataRow.cs: Lot's of fixme's added.
73 * System.Data/DataRowCollection.cs: TODO's added.
75 * System.Data/DataTable.cs: Implemented PrimaryKey.
77 * System.Data/UniqueConstraint.cs: Implemented related PrimaryKey
80 2002-08-25 Rodrigo Moya <rodrigo@ximian.com>
82 * System.Data.OleDb/OleDbTransaction.cs (OleDbTransaction): manage
83 correctly the isolation level.
84 (IsolationLevel): likewise.
85 (~OleDbTransaction): implemented.
87 * System.Data.OleDb/libgda.cs: added more needed stuff.
89 2002-08-22 Daniel Morgan <danmorg@sc.rr.com>
91 * System.Data.SqlClient/SqlParameter.cs: flush
93 * System.Data.SqlClient/SqlParameterCollection.cs: fixes
94 for the Item property, IndexOf, and Contains.
96 * Test/SqlSharpCli.cs: added input parameters support.
97 when a query is executed, if a parameter name matches
98 a SQL# internal variable name, it uses that value for the parameter; otherwise,
99 the user is prompted for the parameter value. Currently, it only supports
102 2002-08-21 Rodrigo Moya <rodrigo@ximian.com>
104 * System.Data.OleDb/libgda.cs: adapted to changes in libgda (get_vtype
105 and get_type for GdaValue).
107 * System.Data.OleDb/OleDbDataReader.cs: adapted to changes in
110 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
112 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
114 (Close): set the dataReader to null.
116 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
117 connection's DataReader property to this object.
118 (Close): set it to null here.
119 (Depth, IsDbNull): implemented.
120 (this): implemented the Item property with a string indexer.
122 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
123 ExecuteScalar): do nothing if there's already an open data reader.
125 * System.Data.OleDb/libgda.cs: more API functions.
127 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
128 reader before continuing.
130 2002-08-20 Franklin Wise <gracenote@earthlink.net>
132 * System.Data/System.Data.build: added nowarn:0679
134 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
135 setup to begin implementing. Implemented ctor().
137 * Tests: See System.Data\Test\ChangeLog
140 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
142 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
144 2002-08-19 Franklin Wise <gracenote@earthlink.net>
146 * Tests: See System.Data\Test\ChangeLog
148 * System.Data/UniqueConstraint.cs: More validation.
150 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
151 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
154 * System.Data/DataTable.cs: Added more MonoTODO tags
156 * class/System.Data/.cvsignore: added tmp & Temp
158 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
161 * System.Data/ConstraintCollection.cs: Commented out unused line.
163 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
165 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
167 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
169 (ErrorCode, Message, Source, Errors): implemented.
171 * System.Data.OleDb/OleDbError.cs: implemented the full class.
173 * System.Data.OleDb/libgda.cs: added more libgda functions.
175 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
176 the opened connection.
178 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
180 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
182 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
183 ArrayList after releasing the items.
184 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
185 GetOrdinal, GetString): implemented.
186 (GetDataTypeName): made it get the type from the data model, not from
187 the current value, which could not have been retrieved yet.
188 (GetValue): call the Get* method corresponding with the data type of
189 the requested column.
191 * System.Data.OleDb/libgda.cs: added more libgda functions.
192 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
194 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
195 titles via OleDbDataReader.GetName ().
196 (TestOleDb): create temporary table with a date field.
197 (InsertRow): set current date for the date field.
199 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
201 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
202 GetValue, which will take care of all the work needed.
203 (Close): implemented basic stuff.
204 (~OleDbDataReader): implemented.
206 * System.Data.OleDb/libgda.cs: added more needed functions.
208 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
210 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
212 (TestTransaction): added test for transactions.
214 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
216 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
218 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
219 when there are errors.
220 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
222 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
225 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
227 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
229 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
230 create an empty GdaParameterList.
232 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
233 for NULL before passing them to Marshal.PtrToStructure, which issues
234 an exception if the value is NULL.
236 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
238 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
239 unreachable code to avoid compiler warning.
241 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
243 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
244 (OpenReader): removed internal method.
246 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
247 the list of returned data models.
249 2002-08-15 Franklin Wise <gracenote@earthlink.net>
251 * System.Data/Constraint.cs: Added helper virtual functions
253 * System.Data/ConstraintCollection.cs: Improved constraint removal,
254 validation. Removed specific knowledge of subclasses of
257 * System.Data/DataColumn.cs: Added static helper function to compare
258 if two DataColumn arrays are the same.
260 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
262 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
265 2002-08-13 Franklin Wise <gracenote@earthlink.net>
267 * System.Data/DataRow.cs: Added several fixme tags.
269 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
271 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
272 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
273 to avoid compiler warnings.
275 2002-08-12 Franklin Wise <gracenote@earthlink.net>
277 * System.Data/Constraint.cs: Implemented
279 * System.Data/UniqueConstraint.cs: GetHashCode() &
280 special case Ctor. Still need to be implemented. LAMESPEC tags
283 * System.Data/ConstraintCollection.cs: Clear() &
284 AddRange() need to be finished. Several LAMESPEC tags.
286 * Allow Constraint collection to be created in DataTable.
288 * System.Data/ForeignKeyConstraint: Added a couple of
291 * System.Data/DataColumnCollection New/Added DataColumns now have
294 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
296 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
298 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
299 internal method, since we don't need it.
300 (ExecuteReader): call SetupGdaCommand before executing the command
301 via libgda functions.
302 (ExecuteScalar): implemented.
304 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
305 to OleDbCommand.OpenReader.
306 (GetBoolean): implemented.
308 2002-08-08 Franklin Wise <gracenote@earthlink.net>
310 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
312 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
314 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
317 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
319 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
320 and don't show a warning in Open.
322 * System.Data.OleDb/TestOleDb.cs: added Close.
324 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
326 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
327 ConnectionTimeout, ServerVersion, GdaConnection):
329 (OleDbConnection): call libgda.gda_init on constructor.
331 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
332 which wasn't been called.
334 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
337 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
339 * list: added missing System.Data.OleDb and
340 System.Data.Common files.
342 * System.Data.OleDb/ChangeLog: removed and merged with
343 System.Data's ChangeLog.
345 * System.Data.OleDb/OleDbDataAdapter.cs:
346 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
348 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
350 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
351 (IsClosed, Item, RecordsAffected): implemented some properties.
353 * libgda.cs: added GdaDataModel methods.
355 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
357 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
358 a second argument (ArrayList results).
359 (NextResult): implemented.
361 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
362 pass that to the OleDbDataReader.
363 (OleDbCommand constructor): don't create the ArrayList of results.
364 (GdaResults): removed property.
365 (ExecuteReader): create a temporary ArrayList and pass that to the
366 OleDbDataReader constructor.
368 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
370 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
371 (CreateParameter): implemented IDbCommand methods.
372 (CommandText): don't create many GdaCommand's, only one is needed.
373 (ExecuteNonQuery): set up the internal GDA command object.
374 (ExecuteReader): use correctly the unique GDA command object.
376 * System.Data.OleDb/libgda.cs: added new libgda calls.
378 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
380 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
381 (BeginTransaction): implemented IDbConnection methods.
383 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
385 * list: added System.Data.OleDb files to file list.
387 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
389 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
391 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
392 of the set method for this property.
394 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
395 (MissingSchemaAction): implemented.
397 2002-07-10 Tim Coleman <tim@timcoleman.com>
399 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
400 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
401 * System.Data.OleDb/OleDbError.cs: Added stubbs
402 * System.Data.OleDb/OleDbException.cs: Added stubbs
403 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
404 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
405 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
406 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
407 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
408 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
409 support transaction nesting
410 * System.Data.OleDb/libgda.cs: Added my name to this file
412 2002-07-09 Tim Coleman <tim@timcoleman.com>
414 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
415 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
416 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
417 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
418 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
419 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
420 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
421 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
422 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
423 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
424 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
425 * System.Data.OleDb/OleDbType.cs: Fixed two typos
426 * System.Data.OleDb/libgda.cs: Style changes, added new methods
428 2002-07-09 Tim Coleman <tim@timcoleman.com>
430 * System.Data.build: remove restriction on System.Data.OleDb build
432 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
434 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
435 IsSynchronized): implemented.
437 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
439 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
441 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
442 (Parameters, Transaction, Connection): made these overload
445 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
446 call m_list methods, not own ones.
448 * System.Data.OleDb/OleDbParameter.cs: more implementation.
450 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
452 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
453 Commit, Rollback): implemented.
454 (GdaConnection): added new internal property.
456 * System.Data.OleDb/OleDbParameter.cs:
457 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
460 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
462 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
464 * System.Data.OleDb/libgda.cs: added new libgda API functions.
466 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
467 (BeginTransaction): made it overload IDbConnection methods.
468 (ChangeDatabase): new stub, needs some work on libgda for being
471 (Close): implemented.
472 (CreateCommand): implemented.
473 (GetOleDbSchemaTable): new stub, until I understand what to do here.
474 (Open): implemented basic stuff, which is just supporting connection
475 strings that represent a GDA data source name. More to come.
476 (InfoMessage, StateChange): added events.
478 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
480 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
482 * System.Data.OleDb/libgda.cs: added static constructor.
483 (GdaClient): new static property to get the underlying GdaClient
486 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
487 the static 'libgda' class.
489 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
491 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
493 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
494 (ConnectionString, Connectiontimeout, Database, State):
495 implemented class properties.
496 (BeginTransaction): implemented.
498 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
500 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
502 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
504 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
506 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
508 * list: added missing PostgresTypes.cs file.
510 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
512 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
515 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
517 * System.Data.SqlClient/SqlConnection.cs: modifed -
518 start to implement the interfaces properly and
519 properly doing a Close(), Dispose(), and
522 * Test/SqlSharpCli.cs: modified -
523 add support for MySQL in Mono.Data.MySql
524 and OleDb support in System.Data.OleDb. However,
525 the OleDb support is commented right now.
526 When the program starts up, a shorter help menu should
527 display the most important commands: help and quit
529 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
531 * System.Data.build: exclude System.Data.OleDb files.
533 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
535 * System.Data.SqlClient/SqlCommand.cs: typo
536 should be CommandBehavior.KeyInfo
538 * Test/SqlSharpCli.cs: refactored and added a few more
541 2002-05-27 Tim Coleman <tim@timcoleman.com>
542 * list: update to compile properly (add missing
543 files and switch path delimiter from '\' to '/').
545 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
547 * System.Data/DataRow.cs
548 * System.Data.Common/DbDataAdapter.cs: fix to
549 get Test/TestSqlDataAdapter.cs to work again
551 * Test/TestSqlDataAdapter.cs: removed comment
552 about SqlDataReader:NextResult() not being implemented; it
555 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
557 * System.Data/DataRow.cs: modified
558 support setting of DBNull.Value
559 using the Item indexer this[DataColumn]
561 * System.Data.SqlClient/SqlCommand.cs: modified
562 tweaks to show TODO's for other CommandBehavior.
563 Set AllowDBNull column to true for IsKey row
566 * System.Data.SqlClient/SqlConnection.cs: modified
567 if transaction is in progress when a Close() is called,
568 do a transaction Rollback.
570 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
572 * Test/SqlSharpCli.cs: added file
573 My new toy. SQL# is a command-line tool to enter
574 SQL commands and queries using Mono System.Data.
575 It also serves as a test for Mono System.Data.
577 * System.Data.SqlClient/SqlCommand.cs: modified
578 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
579 should handle the results from SQL Commands and Queries.
580 - Internal class SqlResult should not create schema Table
581 for the result from a SQL Command. Also, set the RecordsRetrieved
582 property for SqlDataReader.
583 - Closing the SqlDataReader should Close() the SqlConnection for
584 a CommandBehavior.CloseConnection.
585 - Set defaults for SqlResult
587 * System.Data.SqlClient/SqlConnection.cs: modified -
588 when SqlDataReader is Close()
589 should Close() the SqlConnection for
590 a CommandBehavior.CloseConnection. Changed internal Property
591 from OpenReader get/set to IsReaderOpen get and created
592 internal methods OpenReader()/CloseReader() for SqlCommand to call.
593 SqlConnection needs to be prevented from doing while SqlDataReader
596 * System.Data.SqlClient/SqlDataReader.cs: modified -
597 call SqlCommand's OpenReader() internal method. get
598 RecordsRetrieved from SqlResult. set/reset default
599 values for SqlDataReader.
601 * Test/PostgresTest.cs
602 * Test/TestExecuteScalar.cs
603 * Test/TestSqlDataReader.cs: modified
604 for the Execute...() methods in SqlCommand
605 to test SQL Queries and Commands
607 * Test/System.Data_test.build: modified
608 exclude new file Test/SqlSharpCli.cs from
611 2002-05-24 Tim Coleman <tim@timcoleman.com>
612 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
613 for get accessors. These should be implemented in derived classes. See
614 SqlDataAdapter for clues.
615 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
616 * System.Data.Common/DataAdapter.cs:
617 * System.Data.Common/DataTableMappingCollection.cs:
618 * System.Data.Common/DataTableMapping.cs:
619 * System.Data.Common/DataColumnMappingCollection.cs:
620 * System.Data.Common/DataColumnMapping.cs:
621 Properly (I hope!) implement all of the appropriate interfaces
625 2002-05-23 Tim Coleman <tim@timcoleman.com>
626 * System.Data.SqlClient/SqlCommand.cs: include
627 the BaseColumnName in the schema table. Was missed before.
628 * System.Data.Common/DbDataAdapter.cs: Use DataTable
629 mappings so that the DataSet and DataTable are more closely tied.
630 Get schema information from the DataTable using GetSchemaTable ()
631 Various other little fixes
632 * System.Data.Common/DataColumnMappingCollection.cs:
633 * System.Data.Common/DataTableMapping.cs:
634 * System.Data.Common/DataTableMappingCollection.cs: Some
635 implementation, enough to be used by DbDataAdapter.
637 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
639 * System.Data.SqlClient/SqlCommand.cs: set
640 the "ProviderType" to the PostgreSQL type oid
642 * System.Data.SqlClient/SqlDataReader.cs: fix
643 for various properties and methods that
644 return meta data: Item indexers this[name] and this[index],
645 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
648 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
650 * System.Data/DataRow.cs: change suggested
651 by tim: in Item indexer, do an EndEdit()
653 * System.Data.SqlClient/SqlCommand.cs: more
654 fixes to SqlResult. After setting each item in
655 the DataRow, do an AcceptChanges() to commit
656 the changes in the DataRow. For DataType, use a Type
657 of System.String since System.Type nor System.Object
660 * Test/TestSqlDataReader.cs
661 * Test/PostgresTest.cs: updated to to be on
662 the way schema table is suppose to work
664 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
666 * System.Data.SqlClient/SqlCommand.cs: more work on
667 building the schema table
669 2002-05-22 Tim Coleman <tim@timcoleman.com>
670 * System.Data.SqlClient/SqlCommand.cs: preliminary work
671 on getting the schema table correctly built.
673 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
675 * System.Data.SqlClient/ParmUtil.cs: added file - to
676 provide utility for conversion of input parameters
678 * System.Data.SqlClient/PostgresTypes.cs: added file -
679 moved the PostgreHelper class to here. May eventually
680 move the internal class PostgresTypes that's inside the
681 SqlConnection to here as well.
682 Handling of PostgreSQL <-> .NET types need to be though
683 out more. Also, the PostgreHelper has a method to convert
684 from .NET types to a string which can be put into used in
685 an SQL statement to execute against a PostgreSQL database.
686 This is the beginnings of parameters support. It currently
687 only supports input parameters. Still need to do output,
688 input/output, and return parameters.
690 * Test/TestSqlParameters.cs: new test to test the input
691 parameters in System.Data.SqlClient against a
694 * System.Data.SqlClient/PostgresLibrary.cs: moved
695 PostgresHelper class to file PostgresTypes.cs. Also
696 moved struct PostgresType there too.
698 * System.Data.SqlClient/SqlCommand.cs: added input
701 * System.Data.SqlClient/SqlParameter.cs: got
704 * System.Data.SqlClient/SqlParameterCollection.cs: got
705 SqlParameterCollection to work
707 * Test/System.Data_test.build: added files to exclude
710 * System.Data.SqlClient/SqlConnection.cs: release resources
713 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
715 * System.Xml: added directory for classes with namespace
716 System.Xml to go into the System.Data.dll assembly
718 * System.Xml/XmlDataDocument: added file
719 for stubbed concrete class XmlDataDocument which
720 inherits from XmlDocument. Its purpose is to provide
721 a W3C XML DOM Document for relational data and interacting
724 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
726 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
727 Text, TableDirect, and StoredProcedure
729 * Test/PostgresTest.cs: changed call to version()
730 stored procedure to use the CommandType of StoredProcedure
732 * Test/TestSqlDataReader.cs: test all the CommandTypes
734 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
736 * System.Data.build: took out all excluded
737 files except the ones in the Test directory
738 because all files compile now. It does not
739 mean they all work or have implementations
742 * System.Data/DataRelationCollection.cs
743 * System.Data/DataTableRelationCollection.cs
744 * System.Data/InternalDataCollectionBase.cs
745 * System.Data.Common/DbDataPermission.cs
746 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
747 * System.Data.SqlClient/SqlClientPermission.cs
748 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
749 to get all System.Data* files to compile.
751 * System.Data.SqlClient/SqlCommand.cs: started coding
752 to prevent SqlConnection and SqlCommand from doing
753 anyting while fetching data using SqlDataReader. Also,
754 started coding to undo this prevention once the
755 SqlDataReader is closed.
757 * System.Data.SqlClient/SqlConnection.cs: get database server
758 version. Started coding to prevent connection from
759 doing anything while fetching data and undo once the reader
760 is closed. Include events SqlInfoMessage and StateChange.
762 * System.Data.SqlClient/SqlDataReader.cs: start coding to
763 prevent connection and command from doing anything while
764 fetching data, and undo when closed.
766 * Test/PostgresTest.cs: added test to get ServerVersion
767 property from SqlConnection
769 2002-05-18 Tim Coleman <tim@timcoleman.com>
770 * System.Data/DataRow.cs: More implementation,
771 as well as boundary checks and small semantic
774 2002-05-18 Tim Coleman <tim@timcoleman.com>
775 * System.Data/DataRow.cs: Try to reduce memory
776 usage by only creating the original and proposed
777 arrays as required in BeginEdit, and then destroying
778 proposed during EndEdit, and original during AcceptChanges.
779 * System.Data.Common/DbDataAdapter.cs: Make the
780 startRecord and maxRecords parameters work correctly.
782 2002-05-18 Tim Coleman <tim@timcoleman.com>
783 * System.Data/DataRow.cs: Move the null check in
784 ItemArray set to above the Invalid Cast check, so
785 that we don't get null reference exceptions.
787 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
789 * System.Data.SqlClient/PostgresLibrary.cs: handle
790 data value from database being NULL
792 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
793 allow multiple result sets. Added new internal class
794 SqlResult to pass result set data from SqlCommand
797 * System.Data.SqlClient/SqlDataReader.cs: allow
798 multiple result sets.
800 * System.Data.SqlClient/SqlConnection.cs: moved
801 things around. Implement IDisposable.
803 * Test/TestSqlDataReader.cs: test for execution
804 of multiple result sets and display the results
805 of these multiple results sets
807 * Test/TestSqlDataAdapter.cs: tweaks
809 2002-05-17 Tim Coleman <tim@timcoleman.com>
810 * System.Data.Common/DbDataAdapter.cs:
811 - More implementation of Fill methods
812 - Get rid of isDirty flag, because we can just check
814 - Do *not* remove DataTables before Filling them
815 - Implicitly open the connection before doing a Fill
816 if it does not exist.
817 * System.Data.SqlClient/SqlDataAdapter.cs:
819 * System.Data/DataTableCollection.cs:
820 - Add DataSet to internal, undocumented constructor
821 - When a table is created, set its DataSet property
822 - Default table name for creation is "Table1" (see .NET)
823 - Inherit the ArrayList list from InternalDataCollecitonBase
824 and maintain a hashtable between table names and
826 * System.Data/DataTable.cs:
827 - Add internal dataSet field. This is used by
828 DataTableCollection when the DataTable is constructed.
829 * System.Data/DataSet.cs:
830 - Pass a reference to the DataSet when constructing the
833 2002-05-16 Tim Coleman <tim@timcoleman.com>
834 * System.Data.Common/DbDataAdapter.cs:
835 Use table.Rows.Add (itemArray) instead of
836 table.Rows.Add (thisRow) to provide better
838 * System.Data/DataRowCollection.cs:
839 Some implementation of this class.
840 * System.Data/InternalDataCollectionBase.cs:
841 Some implementation. Most notably, this now
842 has an enumerator so we can use foreach (DataRow row in table.Rows)
844 * System.Data/DataTable.cs:
845 Since DataRowCollection now accepts a DataTable in
846 its internal constructor, we must pass one in.
848 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
850 * Test/TestSqlDataAdapter.cs: added new test
851 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
852 DataRowCollection, and DataRow. It tests retrieving data
853 based on a SQL SELECT query. This test is based on Tim Coleman's
856 2002-05-16 Tim Coleman <tim@timcoleman.com>
857 * System.Data.Common/DbDataAdapter.cs:
858 Use table.Rows.Add (thisRow) instead of
859 table.ImportRow (thisRow)
860 * System.Data/DataRowCollection.cs:
861 Construct the ArrayList before using it
863 2002-05-16 Tim Coleman <tim@timcoleman.com>
864 * System.Data/DataTable.cs:
865 Construct the DataRowCollection in the DataTable
866 constructor. Otherwise, it's a null reference.
868 2002-05-16 Tim Coleman <tim@timcoleman.com>
869 * System.Data.SqlClient/SqlDataReader.cs:
870 Modify GetValues to use Array.Copy() to copy
871 the results from fields to values, rather than
872 an assignment, which results in loss of data.
874 2002-05-16 Tim Coleman <tim@timcoleman.com>
875 * System.Data/DataRow.cs:
876 More implementation and documentation. It should
877 work more like expected, although there is no way
878 to demonstrate this well yet. DataTable requires
881 2002-05-15 Tim Coleman <tim@timcoleman.com>
882 * System.Data/DataRow.cs:
883 Minor tweaks as I determine exactly how to
884 implement this class.
887 2002-05-14 Duncan Mak <duncan@ximian.com>
889 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
891 2002-05-14 Tim Coleman
892 * System.Data/DataRow.cs:
893 * System.Data/DataRowBuilder.cs:
894 * System.Data/DataTable.cs:
895 More implementation of these classes. DataRow
896 can now (possibly) do some useful things.
897 Still not sure what DataRowBuilder is all about,
898 other than passing a DataTable in.
900 2002-05-14 Tim Coleman
901 * System.Data/DataRowBuilder.cs:
902 Add stubb for this internal class.
904 2002-05-13 Tim Coleman
905 * System.Data.Common/DbDataAdapter.cs:
906 The maxRecords check was not correct.
908 2002-05-13 Tim Coleman
909 * System.Data/DataTableCollection.cs:
910 Fix an issue when adding a DataTable and size == 0.
911 Now explicitly checks if size > 0 before doing Array.Copy ()
912 * System.Data.Common/DbDataAdapter.cs:
913 Move closer to a working implementation.
914 Make the IDbCommand fields protected so that they can
916 * System.Data.SqlClient/SqlDataAdapter.cs:
917 This should inherit the IDbCommands instead of having its
918 own. An explicit cast is used to force conversion between
919 IDbCommand and SqlCommand
921 2002-05-13 Tim Coleman
922 * System.Data.Common/DataTableMappingCollection.cs:
923 Some implementation to allow progress with DbDataAdapter
925 2002-05-13 Tim Coleman
926 * System.Data.Common/DbDataAdapter.cs:
927 Modify to not break compile.
929 2002-05-13 Tim Coleman
931 include SqlDataAdapter, SqlRowUpdatedEventArgs,
932 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
933 SqlRowUpdatingEventHandler in the build.
935 2002-05-13 Tim Coleman
936 * System.Data.Common/DbDataAdapter.cs:
938 * System.Data.Common/DataAdapter.cs:
939 Correction of some of the stubbing, as well as a
940 little bit more implementation
942 2002-05-11 Tim Coleman
943 * System.Data.SqlClient/SqlDataAdapter.cs:
944 * System.Data.Common/DbDataAdapter.cs:
945 Moved methods that weren't supposed to
946 be in SqlDataAdapter out. They should be implemented
950 2002-05-11 Tim Coleman
951 * System.Data.SqlClient/SqlDataAdapter.cs:
952 some implementation of this class. Note
953 that none of the functionality has been
954 tested yet, but I felt it should be checked
955 in at this point as it compiles.
956 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
957 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
958 Modified so that they will compile properly.
959 Needed to include SqlDataAdapter in the build.
961 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
963 * System.Data/DataTable.cs (Clear): implemented.
964 (DataTable): removed repeated code in constructors, and call the
965 basic constructor from the others.
967 * System.Data/DataColumn.cs: some tweaks.
969 * System.Data/DataRow.cs (RowState): implemented.
970 (CancelEdit): set rowState property back to Unchanged.
971 (RejectChanges): call CancelEdit.
972 (Delete): set rowState to Deleted.
974 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
976 * System.Data.build: added copy of System.Data.dll to Test directory
977 for easy testing. Also, added clean for it too.
979 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
980 from PostgreSQL data type to .NET type.
982 * System.Data.SqlClient/SqlDataReader.cs: beginnings
983 handling of a NULL value from the database
985 * Test/PostgresTest.cs: added tests for NULL values retrieved
988 * Test/ReadPostgresData.cs
989 * Test/TestExecuteScalar.cs
990 * Test/TestSqlDataReader.cs
991 * Test/TestSqlException.cs
992 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
993 "postgres". These tests may eventually be removed since they
996 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
998 * System.Data.build: removed reference to non-existant
999 TestDataColumn.cs file.
1001 * System.Data/DataSet.cs: added some implementation.
1003 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
1005 * System.Data.SqlClient/PostgresLibrary.cs: got
1006 PostgreSQL data types time, date, timestamp (DateTime like)
1007 mapped to .NET System.DateTime working based
1008 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
1009 Also mapped pg type boolean to .net Boolean
1011 * SqlClient/SqlConnection.cs: run SQL command to set
1014 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
1015 added tests for aggregates min(), max(), sum(), count(). could
1016 not get avg() to work due to some formatting error; someone claimed
1017 that it was my locale settings. added tests for SELECT of columns
1018 of type boolean, float, double, date, time, and timestamp. They
1019 have not been fully tested, but its a start.
1021 2002-05-09 Tim Coleman <tim@timcoleman.com>
1022 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
1023 addition, subtraction, and multiplication for the
1024 SqlDecimal type, as well as modification of some other
1025 operations. More to come on this one.
1027 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
1029 * Test/System.Data_test.build: excluded TestDataColumn, which
1030 should be replaced with a nunit test.
1032 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
1034 2002-05-07 Tim Coleman <tim@timcoleman.com>
1048 Fix the broken build I made before. Bad
1051 2002-05-07 Tim Coleman <tim@timcoleman.com>
1053 Fix a symantic error I made in SqlString
1054 Equals where I copied and pasted wrongly
1056 2002-05-07 Tim Coleman <tim@timcoleman.com>
1061 * SqlCompareOptions.cs:
1072 Implement CompareTo, Equals, and String conversions
1075 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1077 * Test/PostgresTest.cs: modified to run completely. There
1078 are many TODOs in System.Data, so not all data types are
1079 included in the SELECT SQL query. Also, I made it to where
1081 using "host=localhost;dbname=test;user=postgres"
1082 instead of my userid and password. When more types are included,
1085 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1087 * Test/PostgresTest.cs: added - ported
1088 libgda postgres-test.c originally by
1089 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
1092 2002-05-05 Tim Coleman <tim@timcoleman.com>
1093 * System.Data.SqlTypes/SqlBinary.cs:
1094 * System.Data.SqlTypes/SqlBoolean.cs:
1095 * System.Data.SqlTypes/SqlByte.cs:
1096 * System.Data.SqlTypes/SqlDateTime.cs:
1097 * System.Data.SqlTypes/SqlDecimal.cs:
1098 * System.Data.SqlTypes/SqlDouble.cs:
1099 * System.Data.SqlTypes/SqlGuid.cs:
1100 * System.Data.SqlTypes/SqlInt16.cs:
1101 * System.Data.SqlTypes/SqlInt32.cs:
1102 * System.Data.SqlTypes/SqlInt64.cs:
1103 * System.Data.SqlTypes/SqlMoney.cs:
1104 * System.Data.SqlTypes/SqlSingle.cs:
1105 * System.Data.SqlTypes/SqlString.cs:
1106 More implementation, and code clean-up for consistency.
1107 Also, I had implemented many conversions as explicit
1108 that should have been implicit. This should remove
1109 many of the red X's and green pluses from the
1110 System.Data.SqlTypes namespace.
1112 2002-05-05 Miguel de Icaza <miguel@ximian.com>
1114 * System.Data/DataSet.cs: Remove [Serializable] attributes from
1115 methods, those only apply to structs or classes.
1117 Stub out ISerializable, ISupportInitialize, and IListSource methods
1119 * System.Data/DataRowView.cs: Stub out interface methods for
1120 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
1122 * System.Data/DataView.cs: Comment out non-implemented
1125 * System.Data/DataViewSettingsCollection.cs: Type cast variables
1126 to the correct type to make it compile.
1128 * System.Data/DataViewSettings.cs: remove reference to
1129 non-existance type ApplyDefaultSort, it is a boolean.
1132 2002-05-05 Tim Coleman <tim@timcoleman.com>
1133 * System.Data.SqlTypes/SqlBinary.cs:
1134 * System.Data.SqlTypes/SqlBoolean.cs:
1135 * System.Data.SqlTypes/SqlByte.cs:
1136 * System.Data.SqlTypes/SqlDecimal.cs:
1137 * System.Data.SqlTypes/SqlDouble.cs:
1138 * System.Data.SqlTypes/SqlGuid.cs:
1139 * System.Data.SqlTypes/SqlInt16.cs:
1140 * System.Data.SqlTypes/SqlInt32.cs:
1141 * System.Data.SqlTypes/SqlInt64.cs:
1142 * System.Data.SqlTypes/SqlMoney.cs:
1143 * System.Data.SqlTypes/SqlSingle.cs:
1144 * System.Data.SqlTypes/SqlString.cs:
1145 Various fixes, including adding the SqlNullValueException
1146 when trying to retrieve the value of a null SqlType,
1147 and when casting values, a Null of type A converts to a
1150 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1152 * System.Data.SqlClient/PostgresLibrary.cs
1153 * System.Data.SqlClient/SqlCommand.cs
1154 * System.Data.SqlClient/SqlConnection.cs
1155 * System.Data.SqlClient/SqlDataReader.cs
1156 oid should not be hard coded because they
1157 can change from one version of PostgreSQL
1158 to the next. Use the typname's instead.
1159 The PostgreSQL type data retrieves
1160 at database connection time. Any unimplemented
1161 types just default to string. These were things
1162 suggested by Gonzalo.
1164 * Test/ReadPostgresData.cs - stuff
1165 * Test/TestSqlDataReader.cs - stuff
1167 * System.Data.SqlTypes/SqlInt32.cs - added a using
1169 2002-05-03 Tim Coleman <tim@timcoleman.com>
1170 * System.Data.build: Fix the build so that test depends on build
1172 2002-05-03 Tim Coleman <tim@timcoleman.com>
1173 * System.Data.SqlTypes/SqlByte.cs:
1174 * System.Data.SqlTypes/SqlDateTime.cs:
1175 * System.Data.SqlTypes/SqlDecimal.cs:
1176 * System.Data.SqlTypes/SqlDouble.cs:
1177 * System.Data.SqlTypes/SqlGuid.cs:
1178 * System.Data.SqlTypes/SqlInt16.cs:
1179 * System.Data.SqlTypes/SqlInt64.cs:
1180 * System.Data.SqlTypes/SqlMoney.cs:
1181 * System.Data.SqlTypes/SqlSingle.cs:
1182 These files were mysteriously excluded from the last
1183 patch I made and sent to Rodrigo
1184 * System.Data.build: include the System.Data.SqlTypes in the build
1186 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1188 * System.Data.build: removed comments
1190 * System.Data.SqlClient/PostgresLibrary.cs: changed
1191 the hard-coded PostgreSQL oid type int's to using an
1192 enum. Also, added PostgreSQL bpchar (character) type.
1194 * Test/TestSqlDataReader.cs: updated test
1195 to include new bpchar PostgreSQL type
1197 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1199 * System.Data.SqlTypes/SqlBinary.cs:
1200 * System.Data.SqlTypes/SqlBoolean.cs:
1201 * System.Data.SqlTypes/SqlInt32.cs:
1202 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1203 Tim Coleman <tcoleman@opentext.com>.
1205 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1207 * Test/TestExecuteScalar.cs: added test for
1208 method ExecuteScalar in class SqlCommand.
1210 * System.Data/DataColumnCollection.cs - it should
1211 inherit properties from base InternalDataCollectionBase
1212 and use them instead of overriding them, such as, List.
1214 * System.Data/DataColumn.cs
1215 * System.Data/DataTable.cs: tweaks to retrieve
1216 meta data from the database
1218 * System.Data.SqlClient/PostgresLibrary.cs -
1219 added method OidToType to convert PostgreSQL oid type
1220 to System.Type. Renamed method OidTypeToSystem
1221 to ConvertPgTypeToSystem for converting the data value
1222 from a PostgreSQL type to a .NET System type.
1224 * System.Data.SqlClient/SqlCommand.cs: implemented
1225 method ExecuteReader which returns a SqlDataReader
1226 for a light forward only read only result set.
1227 It works on types int4 ==> Int32 and
1228 varchar ==> String. Other types
1231 * System.Data.SqlClient/SqlConnection.cs: added comment
1233 * System.Data.SqlClient/SqlDataReader.cs: implemented
1234 class. It works, but still lots to do.
1236 * Test/ReadPostgresData.cs: stuff
1238 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1239 to display meta data and the data
1241 2002-05-03 Duncan Mak <duncan@ximian.com>
1243 * TODO: Took out all the Exceptions. They should be all done now.
1245 * System.Data/ConstraintException.cs:
1246 * System.Data/DBConcurrencyException.cs:
1247 * System.Data/DataException.cs:
1248 * System.Data/DeletedRowInaccessibleException.cs:
1249 * System.Data/DuplicateNameException.cs:
1250 * System.Data/EvaluateException.cs:
1251 * System.Data/InRowChangingEventException.cs:
1252 * System.Data/InvalidConstraintException.cs:
1253 * System.Data/InvalidExpressionException.cs:
1254 * System.Data/MissingPrimaryKeyException.cs:
1255 * System.Data/NoNullAllowedException.cs:
1256 * System.Data/ReadOnlyException.cs:
1257 * System.Data/RowNotInTableException.cs:
1258 * System.Data/StrongTypingException.cs:
1259 * System.Data/SyntaxErrorException.cs:
1260 * System.Data/TypeDataSetGeneratorException.cs:
1261 * System.Data/VersionNotFoundException.cs: Added to CVS.
1263 * System.Data.SqlTypes/SqlNullValueException.cs:
1264 * System.Data.SqlTypes/SqlTruncateException.cs:
1265 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1267 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1269 * System.Data/DataViewSettingCollection.cs: implemented.
1271 * System.Data/DataRowView.cs: new stubs.
1273 * System.Data.SqlTypes/SqlByte.cs:
1274 * System.Data.SqlTypes/SqlDateTime.cs:
1275 * System.Data.SqlTypes/SqlDecimal.cs:
1276 * System.Data.SqlTypes/SqlDouble.cs:
1277 * System.Data.SqlTypes/SqlGuid.cs:
1278 * System.Data.SqlTypes/SqlInt16.cs:
1279 * System.Data.SqlTypes/SqlInt64.cs:
1280 * System.Data.SqlTypes/SqlMoney.cs:
1281 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1282 by Tim Coleman <tcoleman@opentext.com>
1284 * System.Data.build: excluded newly-added files.
1286 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1288 * System.Data.SqlClient/PostgresLibrary.cs: included new
1289 internal class that will be a helper class in using
1290 PostgreSQL. PostgresLibrary is used for the
1291 pinvoke methods to the PostgreSQL Client
1292 native C library libpq while the class PostgresHelper
1293 is used for wrapper or helper methods. It currently only
1294 has one static method OidTypeToSystem in converting
1295 PostgreSQL types to .NET System.<type>s, such as,
1296 a PostgreSQL int8 becomes a .NET System.Int64.
1297 Only a few types have been added, such as, int2,
1298 int4, int8, varchar, text, bool, and char. Other types
1301 * System.Data.SqlClient/SqlCommand.cs: implemented
1302 method ExecuteScalar which allows us to do aggregate
1303 functions, such as, count, avg, min, max, and sum. We
1304 also are able to retrieve the result, convert it to the .NET type
1305 as an object. The user of the returned object must explicitly cast.
1307 * Test/ReadPostgresData.cs: updated sample
1308 to help us learn to retrieve data in System.Data.SqlClient
1311 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1313 * System.Data.build: added /nowarn: nnnn arguments
1314 so you will not get a ton of warnings. The warnings
1315 being excluded are: 1595, 0067, 0109, 0169, and 0649
1317 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1319 * System.Data.build: modified to exclude more
1320 files from the build
1322 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1324 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1327 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1328 by John Dugaw <jdugaw@unizenconsulting.com>.
1330 * System.Data.build: excluded new files from build.
1332 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1334 * Test/ReadPostgresData.cs: added - Uses the
1335 PostgresLibrary to retrieve a recordset.
1336 This is not meant to be used in Production, but as a
1337 learning aid in coding
1338 class System.Data.SqlClient.SqlDataReader.
1339 This sample does work.
1341 * Test/TestSqlDataReader.cs: added - used
1342 to test SqlDataReader (does not work yet)
1343 Forgot to add to ChangeLog on last commit.
1345 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1347 * System.Data/DataViewSetting.cs: new class.
1349 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1351 * System.Data/DataViewManager.cs: new class.
1353 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1354 don't have implementation.
1356 * System.Data.SqlTypes/SqlInt32.cs:
1357 * System.Data.SqlTypes/SqlString.cs:
1358 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1359 these are strctures.
1361 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1364 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1366 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1367 for correctly hiding parent class' members.
1368 (AddRange): use 'override' keyword on overriden method.
1370 (Contains): likewise.
1371 (IndexOf): likewise.
1372 (OnCollectionChanged): likewise.
1373 (OnCollectionChanging): likewise.
1374 (RemoveCore): likewise.
1376 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1378 * System.Data/DataSet.cs: added missing 'using's.
1380 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1382 * System.Data/DataSet.cs:
1383 * System.Data/DataTableCollection.cs:
1384 * System.Data/DataView.cs: compilation fixes on Linux.
1386 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1388 * System.Data/DataRelation.cs
1389 * System.Data/ForeignKeyConstraint.cs
1390 * System.Data/UniqueConstraint.cs: added more stubs
1392 * System.Data/DataTableRelationCollection.cs: added back to cvs
1393 and modified for compile errors. DataRelationCollection is an
1394 abstract class and there must be a class that implements for
1395 DataTable/DataSet. DataTableRelationCollection was changed
1396 to an internal class.
1398 * System.Data.build: modified - new files added
1399 also wanted to include files/classes in the build
1400 so we can get a compilable forward read only result set.
1401 It compiles now using csc/nant with warnings, but this
1402 is a start for adding functionality for the result set.
1403 Classes associated with/and DataSet are still excluded.
1405 * TODO: modified - updated to do list for System.Data
1407 * System.Data/Constraint.cs
1408 * System.Data/ConstraintCollection.cs
1409 * System.Data/DataRelationCollection.cs
1410 * System.Data/DataRow.cs
1411 * System.Data/DataRowChangeEventArgs.cs
1412 * System.Data/DataRowCollection.cs
1413 * System.Data/DataTable.cs
1414 * System.Data/DataTableCollection.cs
1415 * System.Data/InternalDataCollectionBase.cs
1416 * System.Data/PropertyCollection.cs: modified -
1417 changes to compile SqlDataReader/DataTable and
1420 * System.Data/IDbCommand.cs
1421 * System.Data.SqlClient/SqlCommand.cs: modified -
1422 un-commented overloaded methods ExecuteReader
1423 which returns a SqlDataReader
1425 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1427 * System.Data/DataTableCollection.cs: more implementation.
1428 (Count): added 'override' keyword, as pointer out by Martin.
1430 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1431 only call Array.Copy when there is really stuff to be copied.
1432 (CopyTo): don't create the temporary array, it's not needed.
1434 * System.Data.build: excluded newly added file from build.
1436 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1438 * System.Data/DataTableRelationCollection.cs: removed, it's not
1439 on MS SDK documentation.
1441 * System.Data/DataTableCollection.cs: new class.
1443 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1445 * System.Data/DataRowChangeEventArgs.cs
1446 * System.Data/DataRowCollection.cs
1447 * System.Data/DataView.cs
1448 * System.Data/PropertyCollection.cs: added new stubs
1450 * System.Data.build: modified - added new files to exclude
1453 * TODO: modified - removed files from TODO list
1454 that were stubbed above
1456 * System.Data/DataColumn.cs
1457 * System.Data/DataRow.cs: modified - various tweaks
1458 and added internal method SetTable to set the reference
1461 * System.Data/DataSet.cs: modified - class was not
1464 * System.Data/DataTable.cs: modified - temporarily commented
1465 DataSet and DataView references - trying to compile a SqlDataReader,
1466 DataTable, and dependencies for a forward read-only result set.
1467 SqlDataAdapter, DataSet, and DataView will come later once we can get
1468 a forward read only result set working.
1470 * System.Data/IDataRecord.cs: modified - source code lines should
1473 * System.Data/InternalDataCollectionBase.cs: modified - started
1474 implementing this base class for collection of data rows,
1475 columns, tables, relations, and constraints
1477 * System.Data.SqlClient/SqlException.cs: modified -
1478 call base(message) so a unhandled exception displays
1479 the message of a SQL error instead of the
1480 default SystemException message
1482 * Test/TestSqlException.cs: modified -
1483 handle the rollback properly for a SqlException on a
1486 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1488 * System.Data.build: modified - added new
1489 files to exclude from build
1491 * System.Data/Constraint.cs
1492 * System.Data/ConstraintCollection.cs
1493 * System.Data/InternalDataCollectionBase.cs: added -
1494 stubs which are needed to build DataTable.cs
1496 * TODO: modified - added more classes TODO and
1497 added more stuff TODO, such as, create script
1498 to create test database monotestdb for testing
1499 classes in System.Data
1501 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1503 * System.Data.Common/DataAdapter.cs:
1504 * System.Data.Common/DataColumnMappingCollection.cs:
1505 * System.Data.Common/DataTableMappingCollection.cs:
1506 * System.Data.Common/DbDataPermission.cs:
1507 * System.Data.Common/DbDataPermissionAttribute.cs: some
1508 compilation errors fixed.
1510 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1512 * TODO: modified - added classes TODO, and
1513 a poor attempt at System.Data plan
1515 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1517 * ChangeLog: modified - put tabs where they belong
1519 * System.Data.SqlClient/SqlDataReader.cs
1520 * System.Data/DataColumn.cs: modified - compile errors
1521 trying to compile SqlDataAdapter and dependencies
1523 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1525 * System.Data.SqlTypes/SqlBoolean.cs
1526 * System.Data.SqlTypes/SqlCompareOptions.cs
1527 * System.Data.SqlTypes/SqlInt32.cs
1528 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1530 * System.Data/DataTable.cs
1531 * System.Data.SqlClient/SqlCommand.cs
1532 * System.Data.SqlClient/SqlConnection.cs
1533 * System.Data.SqlClient/SqlError.cs
1534 * System.Data.SqlClient/SqlTransaction.cs: modified -
1537 * System.Data.SqlClient/SqlException.cs: modified -
1538 missing Message on indexer for Message property
1540 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1542 * System.Data.SqlClient/SqlCommand.cs: modified - to
1543 compile using mcs. This problem is
1544 returning a stronger type in csc vs. msc
1546 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1547 can not do a using PGconn = IntPtr; and then declare
1548 with PGconn pgConn = IntPtr.Zero;
1549 Thiw works under csc though. Had to comment using and
1550 changed declaration to IntPtr pgConn = IntPtr.Zero;
1551 Also, got rid of compile warnings for hostaddr and port.
1553 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1554 rid of compile warnings. Commented MonoTODO attribute because mcs
1555 doesn't seem to work with C# array property indexer (Item)
1558 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1559 commented MonoTODO attribute for indexer for mcs compiling
1561 * Test/TestSqlIsolationLevel.cs:
1562 * Test/TestSqlInsert.cs:
1563 * Test/TestSqlException.cs: modified -
1564 removed extra ExecuteNonQuery which caused two inserted rows
1566 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1568 * System.Data/StateChangeEventArgs.cs - added
1569 needed to compile System.Data.dll with mcs.
1571 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1573 * System.Data.OleDb: added directory - for OleDb database
1576 * System.Data.SqlClient/SqlClientPermission.cs
1577 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1578 * System.Data.SqlClient/SqlCommandBuilder.cs
1579 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1580 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1581 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1582 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1583 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1584 * Test/TestSqlException.cs
1585 * Test/TestSqlIsolationLevel.cs: added - more tests
1587 * System.Data.build: modified - added new files - excludes these too
1589 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1591 * System.Data.SqlClient/SqlConnection.cs
1592 * System.Data.SqlClient/SqlCommand.cs
1593 * System.Data.SqlClient/SqlTransaction.cs
1594 * System.Data.SqlClient/SqlException.cs
1595 * System.Data.SqlClient/SqlErrorCollection.cs
1596 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1597 exception/error handling. SqlConnection(connectionString)
1598 constructor should not automatically connect.
1600 * System.Data.SqlClient/SqlDataReader.cs
1601 * System.Data.SqlClient/SqlDataAdapter.cs
1602 * System.Data.SqlClient/SqlParameter.cs
1603 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1604 added using System.ComponentModel;
1606 * Test/TestSqlInsert.cs: modified - to use transaction
1608 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1610 * System.Data/DataRow.cs: new skeletons.
1612 * System.Data.Common/DataAdapter.cs:
1613 * System.Data.Common/DataColumnMapping.cs:
1614 * System.Data.Common/DataColumnMappingCollection.cs:
1615 * System.Data.Common/DataTableMapping.cs:
1616 * System.Data.Common/DataTableMappingCollection.cs:
1617 * System.Data.Common/DbDataAdapter.cs:
1618 * System.Data.Common/RowUpdatedEventArgs.cs:
1619 * System.Data.SqlClient/SqlDataAdapter.cs:
1620 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1623 * System.Data.Common/DbDataRecord.cs:
1624 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1627 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1629 * Test/TestSqlInsert.cs: modified - do
1630 a SQL DELETE before SQL INSERT of row so you can use this
1633 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1634 IsolationLevel for PostgreSQL is ReadCommitted. However,
1635 PostgreSQL allows Serializable as well.
1636 (Thanks to Gonzalo for that!)
1638 * System.Data.SqlClient/SqlConnection.cs: modified
1639 * System.Data.SqlClient/SqlCommand.cs: modified
1640 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1641 working; however, we still need to implement SQL errors
1642 and exceptions to properly handle transactions. Also, added
1643 status and error message support from the PostgreSQL database.
1644 Currently, this does a Console.WriteLine() to display the
1645 status and error messages, but this is a TODO
1646 for SQL errors and exceptions.
1648 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1649 attribute for System.Data.dll assembly
1651 * System.Data/IDbCommand.cs: modified - commented
1652 overloaded method ExecuteReader
1653 so System.Data.SqlClient.SqlCommand can compile
1655 * System.Data/IDbCommand.cs: modified
1656 * System.Data/IDbConnection.cs: modified - added using System;
1657 * System.Data/IDataParameter.cs
1659 * System.Data.build: modified - build classes
1660 in System.Data.SqlClient and exclude others in System.Data
1662 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1663 parameter data type from IntPtr to enum ExecStatusType
1665 * ChangeLog: modified - corrected previous entries in log
1667 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1669 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1670 implementation. Still missing some stuff.
1672 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1674 * System.Data.SqlClient/SqlConnection.cs: modified - got
1675 to compile, run, and connect to PostgreSQL database
1677 * System.Data.SqlClient/SqlCommand.cs: modified - got
1678 to compile, run, and execute a SQL INSERT command
1679 which successfully inserted a row
1680 into the PostgreSQL database
1682 * System.Data.SqlClient/SqlTransaction.cs: modified
1683 * System.Data.SqlClient/SqlParameter.cs: modified
1684 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1685 * System.Data.SqlClient/SqlError.cs: modified
1686 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1687 * System.Data.SqlClient/SqlException.cs: modified
1688 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1690 * System.Data.SqlClient/SqlAdapter: modified
1691 * System.Data.SqlClient/SqlReader: modified - add more stubs
1693 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1695 * Test/TestSqlInsert.cs: added
1697 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1699 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1700 class SqlConnecition
1701 * System.Data.SqlClient/SqlErrorCollection.cs: added
1702 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1704 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1706 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1707 * System.Data.IDbTransaction: Added Interface to IDisposable.
1708 * System.Data.IDbCommand: Fixed Capitalization of class name.
1709 * System.Data.IDbConnection: Fixed Capitalization of class name.
1711 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1713 * System.Data.Common/DbDataPermissionAttribute.cs:
1714 * System.Data.Common/DataAdapter.cs:
1715 * System.Data.Common/DataColumnMapping.cs:
1716 * System.Data.Common/DbDataPermission.cs: added some implementation.
1718 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1720 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1721 syntax, as pointed out by Levent Camlibel.
1723 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1725 * System.Data.SqlTypes/SqlBinary.cs:
1726 * System.Data.SqlTypes/INullable.cs: new skeletons.
1728 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1730 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1731 contains all calls the the PostgreSQL client library, to be used
1732 everywhere in System.Data.SqlClient.
1734 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1736 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1739 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1741 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1743 * System.Data.Common/DbDataRecord.cs:
1744 * System.Data.Common/DbEnumerator.cs:
1745 * System.Data.Common/RowUpdatedEventArgs.cs:
1746 * System.Data.Common/RowUpdatingEventArgs.cs:
1747 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1749 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1751 * System.Data.Common/DataTableMappingCollection.cs:
1752 * System.Data.Common/DbDataAdapter.cs:
1753 * System.Data.Common/DbDataPermission.cs:
1754 * System.Data.Common/DataTableMapping.cs: new skeletons.
1756 * System.Data.SqlClient/SqlDataAdapter.cs:
1757 * System.Data.SqlClient/SqlDataReader.cs:
1758 * System.Data.SqlClient/SqlErrors.cs:
1759 * System.Data.SqlClient/SqlError.cs:
1760 * System.Data.SqlClient/SqlException.cs:
1761 * System.Data.SqlClient/SqlParameter.cs:
1762 * System.Data.SqlClient/SqlParameterCollection.cs:
1763 * System.Data.SqlClient/SqlTransaction.cs:
1764 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1766 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1768 * System.Data.Common/DataColumnMapping.cs:
1769 * System.Data.Common/DataColumnMappingCollection.cs:
1770 * System.Data.Common/DataAdapter.cs: created skeletons.
1772 * System.Data.build: exclude new directories from build.
1774 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1776 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1778 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1779 implemented (2 methods).
1781 2002-03-24 Duncan Mak <duncan@ximian.com>
1783 * System.Data.build: Excluded System.Data.SqlClient from the build.
1784 The stubs are incomplete and they are stopping the build.
1786 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1788 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1790 * System.Data.SqlClient/*: added skeletons for the SQL managed
1791 provider for ADO.Net, to be based initially in PostgreSQL.
1793 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1795 Changed the Namespace on some Enums from mono.System.Data to System.Data
1797 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1799 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1800 default name if the ColumnName is null.
1801 * DataSet.cs : Added
1802 * DataTable.cs : Added
1803 * DataRelationCollection.cs : Added
1804 * DataTableRelationCollection.cs : Added
1805 * DataColumn : Added
1807 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1809 * DataColumnChangeEventArgs.cs : Added
1810 * DataColumnCollection.cs : Added
1812 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1814 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1815 * Updated all Enums, Interfaces, and Delegates in System.Data