1 2002-09-06 Franklin Wise <gracenote@earthlink.net>
3 * System.Data/DataColumn.cs: More flushing out.
5 * System.Data/ForeignKeyConstraint.cs: Implemented GetHashCode()
7 * System.Data/UniqueKeyConstraint.cs: Implemented GetHashCode()
9 * Tests: See Changelog for System.Data/Test
11 2002-09-04 Franklin Wise <gracenote@earthlink.net>
13 * Tests: See Changelog for System.Data/Test
16 System.Data/DataColumnCollectionTest.cs
17 System.Data/DataRowCollectionTest.cs
18 System.Data/DataRowTest.cs
20 * System.Data/DataColumn.cs: Flushing out validation, type conversion for
21 autoincrement. Added lots of TODO's.
22 * System.Data/DataColumnCollection.cs: Wrote out add logic as a comment.
23 Tagged implementation with FIXME tags. Lot's more validation
24 and setup needs to be done, much of which is now tagged as todo's
27 * System.Data/DataRow.cs: Lot's of fixme's added.
29 * System.Data/DataRowCollection.cs: TODO's added.
31 * System.Data/DataTable.cs: Implemented PrimaryKey.
33 * System.Data/UniqueConstraint.cs: Implemented related PrimaryKey
40 2002-08-25 Rodrigo Moya <rodrigo@ximian.com>
42 * System.Data.OleDb/OleDbTransaction.cs (OleDbTransaction): manage
43 correctly the isolation level.
44 (IsolationLevel): likewise.
45 (~OleDbTransaction): implemented.
47 * System.Data.OleDb/libgda.cs: added more needed stuff.
49 2002-08-22 Daniel Morgan <danmorg@sc.rr.com>
51 * System.Data.SqlClient/SqlParameter.cs: flush
53 * System.Data.SqlClient/SqlParameterCollection.cs: fixes
54 for the Item property, IndexOf, and Contains.
56 * Test/SqlSharpCli.cs: added input parameters support.
57 when a query is executed, if a parameter name matches
58 a SQL# internal variable name, it uses that value for the parameter; otherwise,
59 the user is prompted for the parameter value. Currently, it only supports
62 2002-08-21 Rodrigo Moya <rodrigo@ximian.com>
64 * System.Data.OleDb/libgda.cs: adapted to changes in libgda (get_vtype
65 and get_type for GdaValue).
67 * System.Data.OleDb/OleDbDataReader.cs: adapted to changes in
70 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
72 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
74 (Close): set the dataReader to null.
76 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
77 connection's DataReader property to this object.
78 (Close): set it to null here.
79 (Depth, IsDbNull): implemented.
80 (this): implemented the Item property with a string indexer.
82 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
83 ExecuteScalar): do nothing if there's already an open data reader.
85 * System.Data.OleDb/libgda.cs: more API functions.
87 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
88 reader before continuing.
90 2002-08-20 Franklin Wise <gracenote@earthlink.net>
92 * System.Data/System.Data.build: added nowarn:0679
94 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
95 setup to begin implementing. Implemented ctor().
97 * Tests: See System.Data\Test\ChangeLog
100 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
102 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
104 2002-08-19 Franklin Wise <gracenote@earthlink.net>
106 * Tests: See System.Data\Test\ChangeLog
108 * System.Data/UniqueConstraint.cs: More validation.
110 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
111 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
114 * System.Data/DataTable.cs: Added more MonoTODO tags
116 * class/System.Data/.cvsignore: added tmp & Temp
118 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
121 * System.Data/ConstraintCollection.cs: Commented out unused line.
123 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
125 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
127 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
129 (ErrorCode, Message, Source, Errors): implemented.
131 * System.Data.OleDb/OleDbError.cs: implemented the full class.
133 * System.Data.OleDb/libgda.cs: added more libgda functions.
135 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
136 the opened connection.
138 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
140 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
142 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
143 ArrayList after releasing the items.
144 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
145 GetOrdinal, GetString): implemented.
146 (GetDataTypeName): made it get the type from the data model, not from
147 the current value, which could not have been retrieved yet.
148 (GetValue): call the Get* method corresponding with the data type of
149 the requested column.
151 * System.Data.OleDb/libgda.cs: added more libgda functions.
152 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
154 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
155 titles via OleDbDataReader.GetName ().
156 (TestOleDb): create temporary table with a date field.
157 (InsertRow): set current date for the date field.
159 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
161 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
162 GetValue, which will take care of all the work needed.
163 (Close): implemented basic stuff.
164 (~OleDbDataReader): implemented.
166 * System.Data.OleDb/libgda.cs: added more needed functions.
168 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
170 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
172 (TestTransaction): added test for transactions.
174 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
176 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
178 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
179 when there are errors.
180 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
182 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
185 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
187 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
189 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
190 create an empty GdaParameterList.
192 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
193 for NULL before passing them to Marshal.PtrToStructure, which issues
194 an exception if the value is NULL.
196 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
198 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
199 unreachable code to avoid compiler warning.
201 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
203 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
204 (OpenReader): removed internal method.
206 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
207 the list of returned data models.
209 2002-08-15 Franklin Wise <gracenote@earthlink.net>
211 * System.Data/Constraint.cs: Added helper virtual functions
213 * System.Data/ConstraintCollection.cs: Improved constraint removal,
214 validation. Removed specific knowledge of subclasses of
217 * System.Data/DataColumn.cs: Added static helper function to compare
218 if two DataColumn arrays are the same.
220 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
222 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
225 2002-08-13 Franklin Wise <gracenote@earthlink.net>
227 * System.Data/DataRow.cs: Added several fixme tags.
229 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
231 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
232 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
233 to avoid compiler warnings.
235 2002-08-12 Franklin Wise <gracenote@earthlink.net>
237 * System.Data/Constraint.cs: Implemented
239 * System.Data/UniqueConstraint.cs: GetHashCode() &
240 special case Ctor. Still need to be implemented. LAMESPEC tags
243 * System.Data/ConstraintCollection.cs: Clear() &
244 AddRange() need to be finished. Several LAMESPEC tags.
246 * Allow Constraint collection to be created in DataTable.
248 * System.Data/ForeignKeyConstraint: Added a couple of
251 * System.Data/DataColumnCollection New/Added DataColumns now have
254 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
256 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
258 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
259 internal method, since we don't need it.
260 (ExecuteReader): call SetupGdaCommand before executing the command
261 via libgda functions.
262 (ExecuteScalar): implemented.
264 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
265 to OleDbCommand.OpenReader.
266 (GetBoolean): implemented.
268 2002-08-08 Franklin Wise <gracenote@earthlink.net>
270 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
272 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
274 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
277 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
279 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
280 and don't show a warning in Open.
282 * System.Data.OleDb/TestOleDb.cs: added Close.
284 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
286 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
287 ConnectionTimeout, ServerVersion, GdaConnection):
289 (OleDbConnection): call libgda.gda_init on constructor.
291 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
292 which wasn't been called.
294 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
297 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
299 * list: added missing System.Data.OleDb and
300 System.Data.Common files.
302 * System.Data.OleDb/ChangeLog: removed and merged with
303 System.Data's ChangeLog.
305 * System.Data.OleDb/OleDbDataAdapter.cs:
306 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
308 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
310 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
311 (IsClosed, Item, RecordsAffected): implemented some properties.
313 * libgda.cs: added GdaDataModel methods.
315 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
317 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
318 a second argument (ArrayList results).
319 (NextResult): implemented.
321 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
322 pass that to the OleDbDataReader.
323 (OleDbCommand constructor): don't create the ArrayList of results.
324 (GdaResults): removed property.
325 (ExecuteReader): create a temporary ArrayList and pass that to the
326 OleDbDataReader constructor.
328 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
330 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
331 (CreateParameter): implemented IDbCommand methods.
332 (CommandText): don't create many GdaCommand's, only one is needed.
333 (ExecuteNonQuery): set up the internal GDA command object.
334 (ExecuteReader): use correctly the unique GDA command object.
336 * System.Data.OleDb/libgda.cs: added new libgda calls.
338 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
340 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
341 (BeginTransaction): implemented IDbConnection methods.
343 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
345 * list: added System.Data.OleDb files to file list.
347 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
349 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
351 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
352 of the set method for this property.
354 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
355 (MissingSchemaAction): implemented.
357 2002-07-10 Tim Coleman <tim@timcoleman.com>
359 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
360 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
361 * System.Data.OleDb/OleDbError.cs: Added stubbs
362 * System.Data.OleDb/OleDbException.cs: Added stubbs
363 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
364 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
365 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
366 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
367 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
368 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
369 support transaction nesting
370 * System.Data.OleDb/libgda.cs: Added my name to this file
372 2002-07-09 Tim Coleman <tim@timcoleman.com>
374 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
375 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
376 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
377 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
378 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
379 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
380 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
381 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
382 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
383 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
384 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
385 * System.Data.OleDb/OleDbType.cs: Fixed two typos
386 * System.Data.OleDb/libgda.cs: Style changes, added new methods
388 2002-07-09 Tim Coleman <tim@timcoleman.com>
390 * System.Data.build: remove restriction on System.Data.OleDb build
392 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
394 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
395 IsSynchronized): implemented.
397 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
399 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
401 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
402 (Parameters, Transaction, Connection): made these overload
405 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
406 call m_list methods, not own ones.
408 * System.Data.OleDb/OleDbParameter.cs: more implementation.
410 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
412 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
413 Commit, Rollback): implemented.
414 (GdaConnection): added new internal property.
416 * System.Data.OleDb/OleDbParameter.cs:
417 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
420 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
422 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
424 * System.Data.OleDb/libgda.cs: added new libgda API functions.
426 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
427 (BeginTransaction): made it overload IDbConnection methods.
428 (ChangeDatabase): new stub, needs some work on libgda for being
431 (Close): implemented.
432 (CreateCommand): implemented.
433 (GetOleDbSchemaTable): new stub, until I understand what to do here.
434 (Open): implemented basic stuff, which is just supporting connection
435 strings that represent a GDA data source name. More to come.
436 (InfoMessage, StateChange): added events.
438 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
440 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
442 * System.Data.OleDb/libgda.cs: added static constructor.
443 (GdaClient): new static property to get the underlying GdaClient
446 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
447 the static 'libgda' class.
449 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
451 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
453 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
454 (ConnectionString, Connectiontimeout, Database, State):
455 implemented class properties.
456 (BeginTransaction): implemented.
458 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
460 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
462 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
464 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
466 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
468 * list: added missing PostgresTypes.cs file.
470 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
472 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
475 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
477 * System.Data.SqlClient/SqlConnection.cs: modifed -
478 start to implement the interfaces properly and
479 properly doing a Close(), Dispose(), and
482 * Test/SqlSharpCli.cs: modified -
483 add support for MySQL in Mono.Data.MySql
484 and OleDb support in System.Data.OleDb. However,
485 the OleDb support is commented right now.
486 When the program starts up, a shorter help menu should
487 display the most important commands: help and quit
489 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
491 * System.Data.build: exclude System.Data.OleDb files.
493 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
495 * System.Data.SqlClient/SqlCommand.cs: typo
496 should be CommandBehavior.KeyInfo
498 * Test/SqlSharpCli.cs: refactored and added a few more
501 2002-05-27 Tim Coleman <tim@timcoleman.com>
502 * list: update to compile properly (add missing
503 files and switch path delimiter from '\' to '/').
505 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
507 * System.Data/DataRow.cs
508 * System.Data.Common/DbDataAdapter.cs: fix to
509 get Test/TestSqlDataAdapter.cs to work again
511 * Test/TestSqlDataAdapter.cs: removed comment
512 about SqlDataReader:NextResult() not being implemented; it
515 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
517 * System.Data/DataRow.cs: modified
518 support setting of DBNull.Value
519 using the Item indexer this[DataColumn]
521 * System.Data.SqlClient/SqlCommand.cs: modified
522 tweaks to show TODO's for other CommandBehavior.
523 Set AllowDBNull column to true for IsKey row
526 * System.Data.SqlClient/SqlConnection.cs: modified
527 if transaction is in progress when a Close() is called,
528 do a transaction Rollback.
530 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
532 * Test/SqlSharpCli.cs: added file
533 My new toy. SQL# is a command-line tool to enter
534 SQL commands and queries using Mono System.Data.
535 It also serves as a test for Mono System.Data.
537 * System.Data.SqlClient/SqlCommand.cs: modified
538 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
539 should handle the results from SQL Commands and Queries.
540 - Internal class SqlResult should not create schema Table
541 for the result from a SQL Command. Also, set the RecordsRetrieved
542 property for SqlDataReader.
543 - Closing the SqlDataReader should Close() the SqlConnection for
544 a CommandBehavior.CloseConnection.
545 - Set defaults for SqlResult
547 * System.Data.SqlClient/SqlConnection.cs: modified -
548 when SqlDataReader is Close()
549 should Close() the SqlConnection for
550 a CommandBehavior.CloseConnection. Changed internal Property
551 from OpenReader get/set to IsReaderOpen get and created
552 internal methods OpenReader()/CloseReader() for SqlCommand to call.
553 SqlConnection needs to be prevented from doing while SqlDataReader
556 * System.Data.SqlClient/SqlDataReader.cs: modified -
557 call SqlCommand's OpenReader() internal method. get
558 RecordsRetrieved from SqlResult. set/reset default
559 values for SqlDataReader.
561 * Test/PostgresTest.cs
562 * Test/TestExecuteScalar.cs
563 * Test/TestSqlDataReader.cs: modified
564 for the Execute...() methods in SqlCommand
565 to test SQL Queries and Commands
567 * Test/System.Data_test.build: modified
568 exclude new file Test/SqlSharpCli.cs from
571 2002-05-24 Tim Coleman <tim@timcoleman.com>
572 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
573 for get accessors. These should be implemented in derived classes. See
574 SqlDataAdapter for clues.
575 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
576 * System.Data.Common/DataAdapter.cs:
577 * System.Data.Common/DataTableMappingCollection.cs:
578 * System.Data.Common/DataTableMapping.cs:
579 * System.Data.Common/DataColumnMappingCollection.cs:
580 * System.Data.Common/DataColumnMapping.cs:
581 Properly (I hope!) implement all of the appropriate interfaces
585 2002-05-23 Tim Coleman <tim@timcoleman.com>
586 * System.Data.SqlClient/SqlCommand.cs: include
587 the BaseColumnName in the schema table. Was missed before.
588 * System.Data.Common/DbDataAdapter.cs: Use DataTable
589 mappings so that the DataSet and DataTable are more closely tied.
590 Get schema information from the DataTable using GetSchemaTable ()
591 Various other little fixes
592 * System.Data.Common/DataColumnMappingCollection.cs:
593 * System.Data.Common/DataTableMapping.cs:
594 * System.Data.Common/DataTableMappingCollection.cs: Some
595 implementation, enough to be used by DbDataAdapter.
597 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
599 * System.Data.SqlClient/SqlCommand.cs: set
600 the "ProviderType" to the PostgreSQL type oid
602 * System.Data.SqlClient/SqlDataReader.cs: fix
603 for various properties and methods that
604 return meta data: Item indexers this[name] and this[index],
605 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
608 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
610 * System.Data/DataRow.cs: change suggested
611 by tim: in Item indexer, do an EndEdit()
613 * System.Data.SqlClient/SqlCommand.cs: more
614 fixes to SqlResult. After setting each item in
615 the DataRow, do an AcceptChanges() to commit
616 the changes in the DataRow. For DataType, use a Type
617 of System.String since System.Type nor System.Object
620 * Test/TestSqlDataReader.cs
621 * Test/PostgresTest.cs: updated to to be on
622 the way schema table is suppose to work
624 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
626 * System.Data.SqlClient/SqlCommand.cs: more work on
627 building the schema table
629 2002-05-22 Tim Coleman <tim@timcoleman.com>
630 * System.Data.SqlClient/SqlCommand.cs: preliminary work
631 on getting the schema table correctly built.
633 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
635 * System.Data.SqlClient/ParmUtil.cs: added file - to
636 provide utility for conversion of input parameters
638 * System.Data.SqlClient/PostgresTypes.cs: added file -
639 moved the PostgreHelper class to here. May eventually
640 move the internal class PostgresTypes that's inside the
641 SqlConnection to here as well.
642 Handling of PostgreSQL <-> .NET types need to be though
643 out more. Also, the PostgreHelper has a method to convert
644 from .NET types to a string which can be put into used in
645 an SQL statement to execute against a PostgreSQL database.
646 This is the beginnings of parameters support. It currently
647 only supports input parameters. Still need to do output,
648 input/output, and return parameters.
650 * Test/TestSqlParameters.cs: new test to test the input
651 parameters in System.Data.SqlClient against a
654 * System.Data.SqlClient/PostgresLibrary.cs: moved
655 PostgresHelper class to file PostgresTypes.cs. Also
656 moved struct PostgresType there too.
658 * System.Data.SqlClient/SqlCommand.cs: added input
661 * System.Data.SqlClient/SqlParameter.cs: got
664 * System.Data.SqlClient/SqlParameterCollection.cs: got
665 SqlParameterCollection to work
667 * Test/System.Data_test.build: added files to exclude
670 * System.Data.SqlClient/SqlConnection.cs: release resources
673 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
675 * System.Xml: added directory for classes with namespace
676 System.Xml to go into the System.Data.dll assembly
678 * System.Xml/XmlDataDocument: added file
679 for stubbed concrete class XmlDataDocument which
680 inherits from XmlDocument. Its purpose is to provide
681 a W3C XML DOM Document for relational data and interacting
684 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
686 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
687 Text, TableDirect, and StoredProcedure
689 * Test/PostgresTest.cs: changed call to version()
690 stored procedure to use the CommandType of StoredProcedure
692 * Test/TestSqlDataReader.cs: test all the CommandTypes
694 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
696 * System.Data.build: took out all excluded
697 files except the ones in the Test directory
698 because all files compile now. It does not
699 mean they all work or have implementations
702 * System.Data/DataRelationCollection.cs
703 * System.Data/DataTableRelationCollection.cs
704 * System.Data/InternalDataCollectionBase.cs
705 * System.Data.Common/DbDataPermission.cs
706 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
707 * System.Data.SqlClient/SqlClientPermission.cs
708 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
709 to get all System.Data* files to compile.
711 * System.Data.SqlClient/SqlCommand.cs: started coding
712 to prevent SqlConnection and SqlCommand from doing
713 anyting while fetching data using SqlDataReader. Also,
714 started coding to undo this prevention once the
715 SqlDataReader is closed.
717 * System.Data.SqlClient/SqlConnection.cs: get database server
718 version. Started coding to prevent connection from
719 doing anything while fetching data and undo once the reader
720 is closed. Include events SqlInfoMessage and StateChange.
722 * System.Data.SqlClient/SqlDataReader.cs: start coding to
723 prevent connection and command from doing anything while
724 fetching data, and undo when closed.
726 * Test/PostgresTest.cs: added test to get ServerVersion
727 property from SqlConnection
729 2002-05-18 Tim Coleman <tim@timcoleman.com>
730 * System.Data/DataRow.cs: More implementation,
731 as well as boundary checks and small semantic
734 2002-05-18 Tim Coleman <tim@timcoleman.com>
735 * System.Data/DataRow.cs: Try to reduce memory
736 usage by only creating the original and proposed
737 arrays as required in BeginEdit, and then destroying
738 proposed during EndEdit, and original during AcceptChanges.
739 * System.Data.Common/DbDataAdapter.cs: Make the
740 startRecord and maxRecords parameters work correctly.
742 2002-05-18 Tim Coleman <tim@timcoleman.com>
743 * System.Data/DataRow.cs: Move the null check in
744 ItemArray set to above the Invalid Cast check, so
745 that we don't get null reference exceptions.
747 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
749 * System.Data.SqlClient/PostgresLibrary.cs: handle
750 data value from database being NULL
752 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
753 allow multiple result sets. Added new internal class
754 SqlResult to pass result set data from SqlCommand
757 * System.Data.SqlClient/SqlDataReader.cs: allow
758 multiple result sets.
760 * System.Data.SqlClient/SqlConnection.cs: moved
761 things around. Implement IDisposable.
763 * Test/TestSqlDataReader.cs: test for execution
764 of multiple result sets and display the results
765 of these multiple results sets
767 * Test/TestSqlDataAdapter.cs: tweaks
769 2002-05-17 Tim Coleman <tim@timcoleman.com>
770 * System.Data.Common/DbDataAdapter.cs:
771 - More implementation of Fill methods
772 - Get rid of isDirty flag, because we can just check
774 - Do *not* remove DataTables before Filling them
775 - Implicitly open the connection before doing a Fill
776 if it does not exist.
777 * System.Data.SqlClient/SqlDataAdapter.cs:
779 * System.Data/DataTableCollection.cs:
780 - Add DataSet to internal, undocumented constructor
781 - When a table is created, set its DataSet property
782 - Default table name for creation is "Table1" (see .NET)
783 - Inherit the ArrayList list from InternalDataCollecitonBase
784 and maintain a hashtable between table names and
786 * System.Data/DataTable.cs:
787 - Add internal dataSet field. This is used by
788 DataTableCollection when the DataTable is constructed.
789 * System.Data/DataSet.cs:
790 - Pass a reference to the DataSet when constructing the
793 2002-05-16 Tim Coleman <tim@timcoleman.com>
794 * System.Data.Common/DbDataAdapter.cs:
795 Use table.Rows.Add (itemArray) instead of
796 table.Rows.Add (thisRow) to provide better
798 * System.Data/DataRowCollection.cs:
799 Some implementation of this class.
800 * System.Data/InternalDataCollectionBase.cs:
801 Some implementation. Most notably, this now
802 has an enumerator so we can use foreach (DataRow row in table.Rows)
804 * System.Data/DataTable.cs:
805 Since DataRowCollection now accepts a DataTable in
806 its internal constructor, we must pass one in.
808 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
810 * Test/TestSqlDataAdapter.cs: added new test
811 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
812 DataRowCollection, and DataRow. It tests retrieving data
813 based on a SQL SELECT query. This test is based on Tim Coleman's
816 2002-05-16 Tim Coleman <tim@timcoleman.com>
817 * System.Data.Common/DbDataAdapter.cs:
818 Use table.Rows.Add (thisRow) instead of
819 table.ImportRow (thisRow)
820 * System.Data/DataRowCollection.cs:
821 Construct the ArrayList before using it
823 2002-05-16 Tim Coleman <tim@timcoleman.com>
824 * System.Data/DataTable.cs:
825 Construct the DataRowCollection in the DataTable
826 constructor. Otherwise, it's a null reference.
828 2002-05-16 Tim Coleman <tim@timcoleman.com>
829 * System.Data.SqlClient/SqlDataReader.cs:
830 Modify GetValues to use Array.Copy() to copy
831 the results from fields to values, rather than
832 an assignment, which results in loss of data.
834 2002-05-16 Tim Coleman <tim@timcoleman.com>
835 * System.Data/DataRow.cs:
836 More implementation and documentation. It should
837 work more like expected, although there is no way
838 to demonstrate this well yet. DataTable requires
841 2002-05-15 Tim Coleman <tim@timcoleman.com>
842 * System.Data/DataRow.cs:
843 Minor tweaks as I determine exactly how to
844 implement this class.
847 2002-05-14 Duncan Mak <duncan@ximian.com>
849 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
851 2002-05-14 Tim Coleman
852 * System.Data/DataRow.cs:
853 * System.Data/DataRowBuilder.cs:
854 * System.Data/DataTable.cs:
855 More implementation of these classes. DataRow
856 can now (possibly) do some useful things.
857 Still not sure what DataRowBuilder is all about,
858 other than passing a DataTable in.
860 2002-05-14 Tim Coleman
861 * System.Data/DataRowBuilder.cs:
862 Add stubb for this internal class.
864 2002-05-13 Tim Coleman
865 * System.Data.Common/DbDataAdapter.cs:
866 The maxRecords check was not correct.
868 2002-05-13 Tim Coleman
869 * System.Data/DataTableCollection.cs:
870 Fix an issue when adding a DataTable and size == 0.
871 Now explicitly checks if size > 0 before doing Array.Copy ()
872 * System.Data.Common/DbDataAdapter.cs:
873 Move closer to a working implementation.
874 Make the IDbCommand fields protected so that they can
876 * System.Data.SqlClient/SqlDataAdapter.cs:
877 This should inherit the IDbCommands instead of having its
878 own. An explicit cast is used to force conversion between
879 IDbCommand and SqlCommand
881 2002-05-13 Tim Coleman
882 * System.Data.Common/DataTableMappingCollection.cs:
883 Some implementation to allow progress with DbDataAdapter
885 2002-05-13 Tim Coleman
886 * System.Data.Common/DbDataAdapter.cs:
887 Modify to not break compile.
889 2002-05-13 Tim Coleman
891 include SqlDataAdapter, SqlRowUpdatedEventArgs,
892 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
893 SqlRowUpdatingEventHandler in the build.
895 2002-05-13 Tim Coleman
896 * System.Data.Common/DbDataAdapter.cs:
898 * System.Data.Common/DataAdapter.cs:
899 Correction of some of the stubbing, as well as a
900 little bit more implementation
902 2002-05-11 Tim Coleman
903 * System.Data.SqlClient/SqlDataAdapter.cs:
904 * System.Data.Common/DbDataAdapter.cs:
905 Moved methods that weren't supposed to
906 be in SqlDataAdapter out. They should be implemented
910 2002-05-11 Tim Coleman
911 * System.Data.SqlClient/SqlDataAdapter.cs:
912 some implementation of this class. Note
913 that none of the functionality has been
914 tested yet, but I felt it should be checked
915 in at this point as it compiles.
916 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
917 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
918 Modified so that they will compile properly.
919 Needed to include SqlDataAdapter in the build.
921 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
923 * System.Data/DataTable.cs (Clear): implemented.
924 (DataTable): removed repeated code in constructors, and call the
925 basic constructor from the others.
927 * System.Data/DataColumn.cs: some tweaks.
929 * System.Data/DataRow.cs (RowState): implemented.
930 (CancelEdit): set rowState property back to Unchanged.
931 (RejectChanges): call CancelEdit.
932 (Delete): set rowState to Deleted.
934 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
936 * System.Data.build: added copy of System.Data.dll to Test directory
937 for easy testing. Also, added clean for it too.
939 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
940 from PostgreSQL data type to .NET type.
942 * System.Data.SqlClient/SqlDataReader.cs: beginnings
943 handling of a NULL value from the database
945 * Test/PostgresTest.cs: added tests for NULL values retrieved
948 * Test/ReadPostgresData.cs
949 * Test/TestExecuteScalar.cs
950 * Test/TestSqlDataReader.cs
951 * Test/TestSqlException.cs
952 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
953 "postgres". These tests may eventually be removed since they
956 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
958 * System.Data.build: removed reference to non-existant
959 TestDataColumn.cs file.
961 * System.Data/DataSet.cs: added some implementation.
963 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
965 * System.Data.SqlClient/PostgresLibrary.cs: got
966 PostgreSQL data types time, date, timestamp (DateTime like)
967 mapped to .NET System.DateTime working based
968 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
969 Also mapped pg type boolean to .net Boolean
971 * SqlClient/SqlConnection.cs: run SQL command to set
974 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
975 added tests for aggregates min(), max(), sum(), count(). could
976 not get avg() to work due to some formatting error; someone claimed
977 that it was my locale settings. added tests for SELECT of columns
978 of type boolean, float, double, date, time, and timestamp. They
979 have not been fully tested, but its a start.
981 2002-05-09 Tim Coleman <tim@timcoleman.com>
982 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
983 addition, subtraction, and multiplication for the
984 SqlDecimal type, as well as modification of some other
985 operations. More to come on this one.
987 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
989 * Test/System.Data_test.build: excluded TestDataColumn, which
990 should be replaced with a nunit test.
992 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
994 2002-05-07 Tim Coleman <tim@timcoleman.com>
1008 Fix the broken build I made before. Bad
1011 2002-05-07 Tim Coleman <tim@timcoleman.com>
1013 Fix a symantic error I made in SqlString
1014 Equals where I copied and pasted wrongly
1016 2002-05-07 Tim Coleman <tim@timcoleman.com>
1021 * SqlCompareOptions.cs:
1032 Implement CompareTo, Equals, and String conversions
1035 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1037 * Test/PostgresTest.cs: modified to run completely. There
1038 are many TODOs in System.Data, so not all data types are
1039 included in the SELECT SQL query. Also, I made it to where
1041 using "host=localhost;dbname=test;user=postgres"
1042 instead of my userid and password. When more types are included,
1045 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1047 * Test/PostgresTest.cs: added - ported
1048 libgda postgres-test.c originally by
1049 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
1052 2002-05-05 Tim Coleman <tim@timcoleman.com>
1053 * System.Data.SqlTypes/SqlBinary.cs:
1054 * System.Data.SqlTypes/SqlBoolean.cs:
1055 * System.Data.SqlTypes/SqlByte.cs:
1056 * System.Data.SqlTypes/SqlDateTime.cs:
1057 * System.Data.SqlTypes/SqlDecimal.cs:
1058 * System.Data.SqlTypes/SqlDouble.cs:
1059 * System.Data.SqlTypes/SqlGuid.cs:
1060 * System.Data.SqlTypes/SqlInt16.cs:
1061 * System.Data.SqlTypes/SqlInt32.cs:
1062 * System.Data.SqlTypes/SqlInt64.cs:
1063 * System.Data.SqlTypes/SqlMoney.cs:
1064 * System.Data.SqlTypes/SqlSingle.cs:
1065 * System.Data.SqlTypes/SqlString.cs:
1066 More implementation, and code clean-up for consistency.
1067 Also, I had implemented many conversions as explicit
1068 that should have been implicit. This should remove
1069 many of the red X's and green pluses from the
1070 System.Data.SqlTypes namespace.
1072 2002-05-05 Miguel de Icaza <miguel@ximian.com>
1074 * System.Data/DataSet.cs: Remove [Serializable] attributes from
1075 methods, those only apply to structs or classes.
1077 Stub out ISerializable, ISupportInitialize, and IListSource methods
1079 * System.Data/DataRowView.cs: Stub out interface methods for
1080 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
1082 * System.Data/DataView.cs: Comment out non-implemented
1085 * System.Data/DataViewSettingsCollection.cs: Type cast variables
1086 to the correct type to make it compile.
1088 * System.Data/DataViewSettings.cs: remove reference to
1089 non-existance type ApplyDefaultSort, it is a boolean.
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/SqlDecimal.cs:
1097 * System.Data.SqlTypes/SqlDouble.cs:
1098 * System.Data.SqlTypes/SqlGuid.cs:
1099 * System.Data.SqlTypes/SqlInt16.cs:
1100 * System.Data.SqlTypes/SqlInt32.cs:
1101 * System.Data.SqlTypes/SqlInt64.cs:
1102 * System.Data.SqlTypes/SqlMoney.cs:
1103 * System.Data.SqlTypes/SqlSingle.cs:
1104 * System.Data.SqlTypes/SqlString.cs:
1105 Various fixes, including adding the SqlNullValueException
1106 when trying to retrieve the value of a null SqlType,
1107 and when casting values, a Null of type A converts to a
1110 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1112 * System.Data.SqlClient/PostgresLibrary.cs
1113 * System.Data.SqlClient/SqlCommand.cs
1114 * System.Data.SqlClient/SqlConnection.cs
1115 * System.Data.SqlClient/SqlDataReader.cs
1116 oid should not be hard coded because they
1117 can change from one version of PostgreSQL
1118 to the next. Use the typname's instead.
1119 The PostgreSQL type data retrieves
1120 at database connection time. Any unimplemented
1121 types just default to string. These were things
1122 suggested by Gonzalo.
1124 * Test/ReadPostgresData.cs - stuff
1125 * Test/TestSqlDataReader.cs - stuff
1127 * System.Data.SqlTypes/SqlInt32.cs - added a using
1129 2002-05-03 Tim Coleman <tim@timcoleman.com>
1130 * System.Data.build: Fix the build so that test depends on build
1132 2002-05-03 Tim Coleman <tim@timcoleman.com>
1133 * System.Data.SqlTypes/SqlByte.cs:
1134 * System.Data.SqlTypes/SqlDateTime.cs:
1135 * System.Data.SqlTypes/SqlDecimal.cs:
1136 * System.Data.SqlTypes/SqlDouble.cs:
1137 * System.Data.SqlTypes/SqlGuid.cs:
1138 * System.Data.SqlTypes/SqlInt16.cs:
1139 * System.Data.SqlTypes/SqlInt64.cs:
1140 * System.Data.SqlTypes/SqlMoney.cs:
1141 * System.Data.SqlTypes/SqlSingle.cs:
1142 These files were mysteriously excluded from the last
1143 patch I made and sent to Rodrigo
1144 * System.Data.build: include the System.Data.SqlTypes in the build
1146 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1148 * System.Data.build: removed comments
1150 * System.Data.SqlClient/PostgresLibrary.cs: changed
1151 the hard-coded PostgreSQL oid type int's to using an
1152 enum. Also, added PostgreSQL bpchar (character) type.
1154 * Test/TestSqlDataReader.cs: updated test
1155 to include new bpchar PostgreSQL type
1157 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1159 * System.Data.SqlTypes/SqlBinary.cs:
1160 * System.Data.SqlTypes/SqlBoolean.cs:
1161 * System.Data.SqlTypes/SqlInt32.cs:
1162 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1163 Tim Coleman <tcoleman@opentext.com>.
1165 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1167 * Test/TestExecuteScalar.cs: added test for
1168 method ExecuteScalar in class SqlCommand.
1170 * System.Data/DataColumnCollection.cs - it should
1171 inherit properties from base InternalDataCollectionBase
1172 and use them instead of overriding them, such as, List.
1174 * System.Data/DataColumn.cs
1175 * System.Data/DataTable.cs: tweaks to retrieve
1176 meta data from the database
1178 * System.Data.SqlClient/PostgresLibrary.cs -
1179 added method OidToType to convert PostgreSQL oid type
1180 to System.Type. Renamed method OidTypeToSystem
1181 to ConvertPgTypeToSystem for converting the data value
1182 from a PostgreSQL type to a .NET System type.
1184 * System.Data.SqlClient/SqlCommand.cs: implemented
1185 method ExecuteReader which returns a SqlDataReader
1186 for a light forward only read only result set.
1187 It works on types int4 ==> Int32 and
1188 varchar ==> String. Other types
1191 * System.Data.SqlClient/SqlConnection.cs: added comment
1193 * System.Data.SqlClient/SqlDataReader.cs: implemented
1194 class. It works, but still lots to do.
1196 * Test/ReadPostgresData.cs: stuff
1198 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1199 to display meta data and the data
1201 2002-05-03 Duncan Mak <duncan@ximian.com>
1203 * TODO: Took out all the Exceptions. They should be all done now.
1205 * System.Data/ConstraintException.cs:
1206 * System.Data/DBConcurrencyException.cs:
1207 * System.Data/DataException.cs:
1208 * System.Data/DeletedRowInaccessibleException.cs:
1209 * System.Data/DuplicateNameException.cs:
1210 * System.Data/EvaluateException.cs:
1211 * System.Data/InRowChangingEventException.cs:
1212 * System.Data/InvalidConstraintException.cs:
1213 * System.Data/InvalidExpressionException.cs:
1214 * System.Data/MissingPrimaryKeyException.cs:
1215 * System.Data/NoNullAllowedException.cs:
1216 * System.Data/ReadOnlyException.cs:
1217 * System.Data/RowNotInTableException.cs:
1218 * System.Data/StrongTypingException.cs:
1219 * System.Data/SyntaxErrorException.cs:
1220 * System.Data/TypeDataSetGeneratorException.cs:
1221 * System.Data/VersionNotFoundException.cs: Added to CVS.
1223 * System.Data.SqlTypes/SqlNullValueException.cs:
1224 * System.Data.SqlTypes/SqlTruncateException.cs:
1225 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1227 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1229 * System.Data/DataViewSettingCollection.cs: implemented.
1231 * System.Data/DataRowView.cs: new stubs.
1233 * System.Data.SqlTypes/SqlByte.cs:
1234 * System.Data.SqlTypes/SqlDateTime.cs:
1235 * System.Data.SqlTypes/SqlDecimal.cs:
1236 * System.Data.SqlTypes/SqlDouble.cs:
1237 * System.Data.SqlTypes/SqlGuid.cs:
1238 * System.Data.SqlTypes/SqlInt16.cs:
1239 * System.Data.SqlTypes/SqlInt64.cs:
1240 * System.Data.SqlTypes/SqlMoney.cs:
1241 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1242 by Tim Coleman <tcoleman@opentext.com>
1244 * System.Data.build: excluded newly-added files.
1246 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1248 * System.Data.SqlClient/PostgresLibrary.cs: included new
1249 internal class that will be a helper class in using
1250 PostgreSQL. PostgresLibrary is used for the
1251 pinvoke methods to the PostgreSQL Client
1252 native C library libpq while the class PostgresHelper
1253 is used for wrapper or helper methods. It currently only
1254 has one static method OidTypeToSystem in converting
1255 PostgreSQL types to .NET System.<type>s, such as,
1256 a PostgreSQL int8 becomes a .NET System.Int64.
1257 Only a few types have been added, such as, int2,
1258 int4, int8, varchar, text, bool, and char. Other types
1261 * System.Data.SqlClient/SqlCommand.cs: implemented
1262 method ExecuteScalar which allows us to do aggregate
1263 functions, such as, count, avg, min, max, and sum. We
1264 also are able to retrieve the result, convert it to the .NET type
1265 as an object. The user of the returned object must explicitly cast.
1267 * Test/ReadPostgresData.cs: updated sample
1268 to help us learn to retrieve data in System.Data.SqlClient
1271 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1273 * System.Data.build: added /nowarn: nnnn arguments
1274 so you will not get a ton of warnings. The warnings
1275 being excluded are: 1595, 0067, 0109, 0169, and 0649
1277 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1279 * System.Data.build: modified to exclude more
1280 files from the build
1282 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1284 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1287 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1288 by John Dugaw <jdugaw@unizenconsulting.com>.
1290 * System.Data.build: excluded new files from build.
1292 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1294 * Test/ReadPostgresData.cs: added - Uses the
1295 PostgresLibrary to retrieve a recordset.
1296 This is not meant to be used in Production, but as a
1297 learning aid in coding
1298 class System.Data.SqlClient.SqlDataReader.
1299 This sample does work.
1301 * Test/TestSqlDataReader.cs: added - used
1302 to test SqlDataReader (does not work yet)
1303 Forgot to add to ChangeLog on last commit.
1305 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1307 * System.Data/DataViewSetting.cs: new class.
1309 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1311 * System.Data/DataViewManager.cs: new class.
1313 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1314 don't have implementation.
1316 * System.Data.SqlTypes/SqlInt32.cs:
1317 * System.Data.SqlTypes/SqlString.cs:
1318 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1319 these are strctures.
1321 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1324 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1326 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1327 for correctly hiding parent class' members.
1328 (AddRange): use 'override' keyword on overriden method.
1330 (Contains): likewise.
1331 (IndexOf): likewise.
1332 (OnCollectionChanged): likewise.
1333 (OnCollectionChanging): likewise.
1334 (RemoveCore): likewise.
1336 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1338 * System.Data/DataSet.cs: added missing 'using's.
1340 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1342 * System.Data/DataSet.cs:
1343 * System.Data/DataTableCollection.cs:
1344 * System.Data/DataView.cs: compilation fixes on Linux.
1346 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1348 * System.Data/DataRelation.cs
1349 * System.Data/ForeignKeyConstraint.cs
1350 * System.Data/UniqueConstraint.cs: added more stubs
1352 * System.Data/DataTableRelationCollection.cs: added back to cvs
1353 and modified for compile errors. DataRelationCollection is an
1354 abstract class and there must be a class that implements for
1355 DataTable/DataSet. DataTableRelationCollection was changed
1356 to an internal class.
1358 * System.Data.build: modified - new files added
1359 also wanted to include files/classes in the build
1360 so we can get a compilable forward read only result set.
1361 It compiles now using csc/nant with warnings, but this
1362 is a start for adding functionality for the result set.
1363 Classes associated with/and DataSet are still excluded.
1365 * TODO: modified - updated to do list for System.Data
1367 * System.Data/Constraint.cs
1368 * System.Data/ConstraintCollection.cs
1369 * System.Data/DataRelationCollection.cs
1370 * System.Data/DataRow.cs
1371 * System.Data/DataRowChangeEventArgs.cs
1372 * System.Data/DataRowCollection.cs
1373 * System.Data/DataTable.cs
1374 * System.Data/DataTableCollection.cs
1375 * System.Data/InternalDataCollectionBase.cs
1376 * System.Data/PropertyCollection.cs: modified -
1377 changes to compile SqlDataReader/DataTable and
1380 * System.Data/IDbCommand.cs
1381 * System.Data.SqlClient/SqlCommand.cs: modified -
1382 un-commented overloaded methods ExecuteReader
1383 which returns a SqlDataReader
1385 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1387 * System.Data/DataTableCollection.cs: more implementation.
1388 (Count): added 'override' keyword, as pointer out by Martin.
1390 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1391 only call Array.Copy when there is really stuff to be copied.
1392 (CopyTo): don't create the temporary array, it's not needed.
1394 * System.Data.build: excluded newly added file from build.
1396 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1398 * System.Data/DataTableRelationCollection.cs: removed, it's not
1399 on MS SDK documentation.
1401 * System.Data/DataTableCollection.cs: new class.
1403 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1405 * System.Data/DataRowChangeEventArgs.cs
1406 * System.Data/DataRowCollection.cs
1407 * System.Data/DataView.cs
1408 * System.Data/PropertyCollection.cs: added new stubs
1410 * System.Data.build: modified - added new files to exclude
1413 * TODO: modified - removed files from TODO list
1414 that were stubbed above
1416 * System.Data/DataColumn.cs
1417 * System.Data/DataRow.cs: modified - various tweaks
1418 and added internal method SetTable to set the reference
1421 * System.Data/DataSet.cs: modified - class was not
1424 * System.Data/DataTable.cs: modified - temporarily commented
1425 DataSet and DataView references - trying to compile a SqlDataReader,
1426 DataTable, and dependencies for a forward read-only result set.
1427 SqlDataAdapter, DataSet, and DataView will come later once we can get
1428 a forward read only result set working.
1430 * System.Data/IDataRecord.cs: modified - source code lines should
1433 * System.Data/InternalDataCollectionBase.cs: modified - started
1434 implementing this base class for collection of data rows,
1435 columns, tables, relations, and constraints
1437 * System.Data.SqlClient/SqlException.cs: modified -
1438 call base(message) so a unhandled exception displays
1439 the message of a SQL error instead of the
1440 default SystemException message
1442 * Test/TestSqlException.cs: modified -
1443 handle the rollback properly for a SqlException on a
1446 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1448 * System.Data.build: modified - added new
1449 files to exclude from build
1451 * System.Data/Constraint.cs
1452 * System.Data/ConstraintCollection.cs
1453 * System.Data/InternalDataCollectionBase.cs: added -
1454 stubs which are needed to build DataTable.cs
1456 * TODO: modified - added more classes TODO and
1457 added more stuff TODO, such as, create script
1458 to create test database monotestdb for testing
1459 classes in System.Data
1461 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1463 * System.Data.Common/DataAdapter.cs:
1464 * System.Data.Common/DataColumnMappingCollection.cs:
1465 * System.Data.Common/DataTableMappingCollection.cs:
1466 * System.Data.Common/DbDataPermission.cs:
1467 * System.Data.Common/DbDataPermissionAttribute.cs: some
1468 compilation errors fixed.
1470 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1472 * TODO: modified - added classes TODO, and
1473 a poor attempt at System.Data plan
1475 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1477 * ChangeLog: modified - put tabs where they belong
1479 * System.Data.SqlClient/SqlDataReader.cs
1480 * System.Data/DataColumn.cs: modified - compile errors
1481 trying to compile SqlDataAdapter and dependencies
1483 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1485 * System.Data.SqlTypes/SqlBoolean.cs
1486 * System.Data.SqlTypes/SqlCompareOptions.cs
1487 * System.Data.SqlTypes/SqlInt32.cs
1488 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1490 * System.Data/DataTable.cs
1491 * System.Data.SqlClient/SqlCommand.cs
1492 * System.Data.SqlClient/SqlConnection.cs
1493 * System.Data.SqlClient/SqlError.cs
1494 * System.Data.SqlClient/SqlTransaction.cs: modified -
1497 * System.Data.SqlClient/SqlException.cs: modified -
1498 missing Message on indexer for Message property
1500 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1502 * System.Data.SqlClient/SqlCommand.cs: modified - to
1503 compile using mcs. This problem is
1504 returning a stronger type in csc vs. msc
1506 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1507 can not do a using PGconn = IntPtr; and then declare
1508 with PGconn pgConn = IntPtr.Zero;
1509 Thiw works under csc though. Had to comment using and
1510 changed declaration to IntPtr pgConn = IntPtr.Zero;
1511 Also, got rid of compile warnings for hostaddr and port.
1513 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1514 rid of compile warnings. Commented MonoTODO attribute because mcs
1515 doesn't seem to work with C# array property indexer (Item)
1518 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1519 commented MonoTODO attribute for indexer for mcs compiling
1521 * Test/TestSqlIsolationLevel.cs:
1522 * Test/TestSqlInsert.cs:
1523 * Test/TestSqlException.cs: modified -
1524 removed extra ExecuteNonQuery which caused two inserted rows
1526 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1528 * System.Data/StateChangeEventArgs.cs - added
1529 needed to compile System.Data.dll with mcs.
1531 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1533 * System.Data.OleDb: added directory - for OleDb database
1536 * System.Data.SqlClient/SqlClientPermission.cs
1537 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1538 * System.Data.SqlClient/SqlCommandBuilder.cs
1539 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1540 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1541 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1542 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1543 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1544 * Test/TestSqlException.cs
1545 * Test/TestSqlIsolationLevel.cs: added - more tests
1547 * System.Data.build: modified - added new files - excludes these too
1549 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1551 * System.Data.SqlClient/SqlConnection.cs
1552 * System.Data.SqlClient/SqlCommand.cs
1553 * System.Data.SqlClient/SqlTransaction.cs
1554 * System.Data.SqlClient/SqlException.cs
1555 * System.Data.SqlClient/SqlErrorCollection.cs
1556 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1557 exception/error handling. SqlConnection(connectionString)
1558 constructor should not automatically connect.
1560 * System.Data.SqlClient/SqlDataReader.cs
1561 * System.Data.SqlClient/SqlDataAdapter.cs
1562 * System.Data.SqlClient/SqlParameter.cs
1563 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1564 added using System.ComponentModel;
1566 * Test/TestSqlInsert.cs: modified - to use transaction
1568 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1570 * System.Data/DataRow.cs: new skeletons.
1572 * System.Data.Common/DataAdapter.cs:
1573 * System.Data.Common/DataColumnMapping.cs:
1574 * System.Data.Common/DataColumnMappingCollection.cs:
1575 * System.Data.Common/DataTableMapping.cs:
1576 * System.Data.Common/DataTableMappingCollection.cs:
1577 * System.Data.Common/DbDataAdapter.cs:
1578 * System.Data.Common/RowUpdatedEventArgs.cs:
1579 * System.Data.SqlClient/SqlDataAdapter.cs:
1580 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1583 * System.Data.Common/DbDataRecord.cs:
1584 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1587 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1589 * Test/TestSqlInsert.cs: modified - do
1590 a SQL DELETE before SQL INSERT of row so you can use this
1593 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1594 IsolationLevel for PostgreSQL is ReadCommitted. However,
1595 PostgreSQL allows Serializable as well.
1596 (Thanks to Gonzalo for that!)
1598 * System.Data.SqlClient/SqlConnection.cs: modified
1599 * System.Data.SqlClient/SqlCommand.cs: modified
1600 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1601 working; however, we still need to implement SQL errors
1602 and exceptions to properly handle transactions. Also, added
1603 status and error message support from the PostgreSQL database.
1604 Currently, this does a Console.WriteLine() to display the
1605 status and error messages, but this is a TODO
1606 for SQL errors and exceptions.
1608 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1609 attribute for System.Data.dll assembly
1611 * System.Data/IDbCommand.cs: modified - commented
1612 overloaded method ExecuteReader
1613 so System.Data.SqlClient.SqlCommand can compile
1615 * System.Data/IDbCommand.cs: modified
1616 * System.Data/IDbConnection.cs: modified - added using System;
1617 * System.Data/IDataParameter.cs
1619 * System.Data.build: modified - build classes
1620 in System.Data.SqlClient and exclude others in System.Data
1622 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1623 parameter data type from IntPtr to enum ExecStatusType
1625 * ChangeLog: modified - corrected previous entries in log
1627 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1629 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1630 implementation. Still missing some stuff.
1632 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1634 * System.Data.SqlClient/SqlConnection.cs: modified - got
1635 to compile, run, and connect to PostgreSQL database
1637 * System.Data.SqlClient/SqlCommand.cs: modified - got
1638 to compile, run, and execute a SQL INSERT command
1639 which successfully inserted a row
1640 into the PostgreSQL database
1642 * System.Data.SqlClient/SqlTransaction.cs: modified
1643 * System.Data.SqlClient/SqlParameter.cs: modified
1644 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1645 * System.Data.SqlClient/SqlError.cs: modified
1646 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1647 * System.Data.SqlClient/SqlException.cs: modified
1648 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1650 * System.Data.SqlClient/SqlAdapter: modified
1651 * System.Data.SqlClient/SqlReader: modified - add more stubs
1653 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1655 * Test/TestSqlInsert.cs: added
1657 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1659 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1660 class SqlConnecition
1661 * System.Data.SqlClient/SqlErrorCollection.cs: added
1662 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1664 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1666 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1667 * System.Data.IDbTransaction: Added Interface to IDisposable.
1668 * System.Data.IDbCommand: Fixed Capitalization of class name.
1669 * System.Data.IDbConnection: Fixed Capitalization of class name.
1671 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1673 * System.Data.Common/DbDataPermissionAttribute.cs:
1674 * System.Data.Common/DataAdapter.cs:
1675 * System.Data.Common/DataColumnMapping.cs:
1676 * System.Data.Common/DbDataPermission.cs: added some implementation.
1678 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1680 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1681 syntax, as pointed out by Levent Camlibel.
1683 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1685 * System.Data.SqlTypes/SqlBinary.cs:
1686 * System.Data.SqlTypes/INullable.cs: new skeletons.
1688 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1690 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1691 contains all calls the the PostgreSQL client library, to be used
1692 everywhere in System.Data.SqlClient.
1694 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1696 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1699 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1701 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1703 * System.Data.Common/DbDataRecord.cs:
1704 * System.Data.Common/DbEnumerator.cs:
1705 * System.Data.Common/RowUpdatedEventArgs.cs:
1706 * System.Data.Common/RowUpdatingEventArgs.cs:
1707 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1709 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1711 * System.Data.Common/DataTableMappingCollection.cs:
1712 * System.Data.Common/DbDataAdapter.cs:
1713 * System.Data.Common/DbDataPermission.cs:
1714 * System.Data.Common/DataTableMapping.cs: new skeletons.
1716 * System.Data.SqlClient/SqlDataAdapter.cs:
1717 * System.Data.SqlClient/SqlDataReader.cs:
1718 * System.Data.SqlClient/SqlErrors.cs:
1719 * System.Data.SqlClient/SqlError.cs:
1720 * System.Data.SqlClient/SqlException.cs:
1721 * System.Data.SqlClient/SqlParameter.cs:
1722 * System.Data.SqlClient/SqlParameterCollection.cs:
1723 * System.Data.SqlClient/SqlTransaction.cs:
1724 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1726 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1728 * System.Data.Common/DataColumnMapping.cs:
1729 * System.Data.Common/DataColumnMappingCollection.cs:
1730 * System.Data.Common/DataAdapter.cs: created skeletons.
1732 * System.Data.build: exclude new directories from build.
1734 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1736 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1738 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1739 implemented (2 methods).
1741 2002-03-24 Duncan Mak <duncan@ximian.com>
1743 * System.Data.build: Excluded System.Data.SqlClient from the build.
1744 The stubs are incomplete and they are stopping the build.
1746 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1748 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1750 * System.Data.SqlClient/*: added skeletons for the SQL managed
1751 provider for ADO.Net, to be based initially in PostgreSQL.
1753 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1755 Changed the Namespace on some Enums from mono.System.Data to System.Data
1757 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1759 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1760 default name if the ColumnName is null.
1761 * DataSet.cs : Added
1762 * DataTable.cs : Added
1763 * DataRelationCollection.cs : Added
1764 * DataTableRelationCollection.cs : Added
1765 * DataColumn : Added
1767 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1769 * DataColumnChangeEventArgs.cs : Added
1770 * DataColumnCollection.cs : Added
1772 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1774 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1775 * Updated all Enums, Interfaces, and Delegates in System.Data