1 2002-09-04 Franklin Wise <gracenote@earthlink.net>
3 * Tests: See Changelog for System.Data/Test
6 System.Data/DataColumnCollectionTest.cs
7 System.Data/DataRowCollectionTest.cs
8 System.Data/DataRowTest.cs
10 * System.Data/DataColumn.cs: Flushing out validation, type conversion for
11 autoincrement. Added lots of TODO's.
12 * System.Data/DataColumnCollection.cs: Wrote out add logic as a comment.
13 Tagged implementation with FIXME tags. Lot's more validation
14 and setup needs to be done, much of which is now tagged as todo's
17 * System.Data/DataRow.cs: Lot's of fixme's added.
19 * System.Data/DataRowCollection.cs: TODO's added.
21 * System.Data/DataTable.cs: Implemented PrimaryKey.
23 * System.Data/UniqueConstraint.cs: Implemented related PrimaryKey
30 2002-08-25 Rodrigo Moya <rodrigo@ximian.com>
32 * System.Data.OleDb/OleDbTransaction.cs (OleDbTransaction): manage
33 correctly the isolation level.
34 (IsolationLevel): likewise.
35 (~OleDbTransaction): implemented.
37 * System.Data.OleDb/libgda.cs: added more needed stuff.
39 2002-08-22 Daniel Morgan <danmorg@sc.rr.com>
41 * System.Data.SqlClient/SqlParameter.cs: flush
43 * System.Data.SqlClient/SqlParameterCollection.cs: fixes
44 for the Item property, IndexOf, and Contains.
46 * Test/SqlSharpCli.cs: added input parameters support.
47 when a query is executed, if a parameter name matches
48 a SQL# internal variable name, it uses that value for the parameter; otherwise,
49 the user is prompted for the parameter value. Currently, it only supports
52 2002-08-21 Rodrigo Moya <rodrigo@ximian.com>
54 * System.Data.OleDb/libgda.cs: adapted to changes in libgda (get_vtype
55 and get_type for GdaValue).
57 * System.Data.OleDb/OleDbDataReader.cs: adapted to changes in
60 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
62 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
64 (Close): set the dataReader to null.
66 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
67 connection's DataReader property to this object.
68 (Close): set it to null here.
69 (Depth, IsDbNull): implemented.
70 (this): implemented the Item property with a string indexer.
72 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
73 ExecuteScalar): do nothing if there's already an open data reader.
75 * System.Data.OleDb/libgda.cs: more API functions.
77 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
78 reader before continuing.
80 2002-08-20 Franklin Wise <gracenote@earthlink.net>
82 * System.Data/System.Data.build: added nowarn:0679
84 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
85 setup to begin implementing. Implemented ctor().
87 * Tests: See System.Data\Test\ChangeLog
90 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
92 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
94 2002-08-19 Franklin Wise <gracenote@earthlink.net>
96 * Tests: See System.Data\Test\ChangeLog
98 * System.Data/UniqueConstraint.cs: More validation.
100 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
101 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
104 * System.Data/DataTable.cs: Added more MonoTODO tags
106 * class/System.Data/.cvsignore: added tmp & Temp
108 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
111 * System.Data/ConstraintCollection.cs: Commented out unused line.
113 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
115 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
117 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
119 (ErrorCode, Message, Source, Errors): implemented.
121 * System.Data.OleDb/OleDbError.cs: implemented the full class.
123 * System.Data.OleDb/libgda.cs: added more libgda functions.
125 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
126 the opened connection.
128 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
130 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
132 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
133 ArrayList after releasing the items.
134 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
135 GetOrdinal, GetString): implemented.
136 (GetDataTypeName): made it get the type from the data model, not from
137 the current value, which could not have been retrieved yet.
138 (GetValue): call the Get* method corresponding with the data type of
139 the requested column.
141 * System.Data.OleDb/libgda.cs: added more libgda functions.
142 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
144 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
145 titles via OleDbDataReader.GetName ().
146 (TestOleDb): create temporary table with a date field.
147 (InsertRow): set current date for the date field.
149 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
151 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
152 GetValue, which will take care of all the work needed.
153 (Close): implemented basic stuff.
154 (~OleDbDataReader): implemented.
156 * System.Data.OleDb/libgda.cs: added more needed functions.
158 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
160 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
162 (TestTransaction): added test for transactions.
164 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
166 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
168 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
169 when there are errors.
170 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
172 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
175 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
177 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
179 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
180 create an empty GdaParameterList.
182 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
183 for NULL before passing them to Marshal.PtrToStructure, which issues
184 an exception if the value is NULL.
186 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
188 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
189 unreachable code to avoid compiler warning.
191 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
193 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
194 (OpenReader): removed internal method.
196 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
197 the list of returned data models.
199 2002-08-15 Franklin Wise <gracenote@earthlink.net>
201 * System.Data/Constraint.cs: Added helper virtual functions
203 * System.Data/ConstraintCollection.cs: Improved constraint removal,
204 validation. Removed specific knowledge of subclasses of
207 * System.Data/DataColumn.cs: Added static helper function to compare
208 if two DataColumn arrays are the same.
210 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
212 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
215 2002-08-13 Franklin Wise <gracenote@earthlink.net>
217 * System.Data/DataRow.cs: Added several fixme tags.
219 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
221 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
222 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
223 to avoid compiler warnings.
225 2002-08-12 Franklin Wise <gracenote@earthlink.net>
227 * System.Data/Constraint.cs: Implemented
229 * System.Data/UniqueConstraint.cs: GetHashCode() &
230 special case Ctor. Still need to be implemented. LAMESPEC tags
233 * System.Data/ConstraintCollection.cs: Clear() &
234 AddRange() need to be finished. Several LAMESPEC tags.
236 * Allow Constraint collection to be created in DataTable.
238 * System.Data/ForeignKeyConstraint: Added a couple of
241 * System.Data/DataColumnCollection New/Added DataColumns now have
244 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
246 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
248 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
249 internal method, since we don't need it.
250 (ExecuteReader): call SetupGdaCommand before executing the command
251 via libgda functions.
252 (ExecuteScalar): implemented.
254 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
255 to OleDbCommand.OpenReader.
256 (GetBoolean): implemented.
258 2002-08-08 Franklin Wise <gracenote@earthlink.net>
260 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
262 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
264 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
267 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
269 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
270 and don't show a warning in Open.
272 * System.Data.OleDb/TestOleDb.cs: added Close.
274 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
276 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
277 ConnectionTimeout, ServerVersion, GdaConnection):
279 (OleDbConnection): call libgda.gda_init on constructor.
281 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
282 which wasn't been called.
284 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
287 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
289 * list: added missing System.Data.OleDb and
290 System.Data.Common files.
292 * System.Data.OleDb/ChangeLog: removed and merged with
293 System.Data's ChangeLog.
295 * System.Data.OleDb/OleDbDataAdapter.cs:
296 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
298 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
300 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
301 (IsClosed, Item, RecordsAffected): implemented some properties.
303 * libgda.cs: added GdaDataModel methods.
305 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
307 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
308 a second argument (ArrayList results).
309 (NextResult): implemented.
311 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
312 pass that to the OleDbDataReader.
313 (OleDbCommand constructor): don't create the ArrayList of results.
314 (GdaResults): removed property.
315 (ExecuteReader): create a temporary ArrayList and pass that to the
316 OleDbDataReader constructor.
318 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
320 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
321 (CreateParameter): implemented IDbCommand methods.
322 (CommandText): don't create many GdaCommand's, only one is needed.
323 (ExecuteNonQuery): set up the internal GDA command object.
324 (ExecuteReader): use correctly the unique GDA command object.
326 * System.Data.OleDb/libgda.cs: added new libgda calls.
328 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
330 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
331 (BeginTransaction): implemented IDbConnection methods.
333 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
335 * list: added System.Data.OleDb files to file list.
337 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
339 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
341 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
342 of the set method for this property.
344 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
345 (MissingSchemaAction): implemented.
347 2002-07-10 Tim Coleman <tim@timcoleman.com>
349 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
350 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
351 * System.Data.OleDb/OleDbError.cs: Added stubbs
352 * System.Data.OleDb/OleDbException.cs: Added stubbs
353 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
354 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
355 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
356 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
357 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
358 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
359 support transaction nesting
360 * System.Data.OleDb/libgda.cs: Added my name to this file
362 2002-07-09 Tim Coleman <tim@timcoleman.com>
364 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
365 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
366 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
367 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
368 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
369 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
370 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
371 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
372 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
373 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
374 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
375 * System.Data.OleDb/OleDbType.cs: Fixed two typos
376 * System.Data.OleDb/libgda.cs: Style changes, added new methods
378 2002-07-09 Tim Coleman <tim@timcoleman.com>
380 * System.Data.build: remove restriction on System.Data.OleDb build
382 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
384 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
385 IsSynchronized): implemented.
387 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
389 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
391 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
392 (Parameters, Transaction, Connection): made these overload
395 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
396 call m_list methods, not own ones.
398 * System.Data.OleDb/OleDbParameter.cs: more implementation.
400 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
402 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
403 Commit, Rollback): implemented.
404 (GdaConnection): added new internal property.
406 * System.Data.OleDb/OleDbParameter.cs:
407 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
410 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
412 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
414 * System.Data.OleDb/libgda.cs: added new libgda API functions.
416 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
417 (BeginTransaction): made it overload IDbConnection methods.
418 (ChangeDatabase): new stub, needs some work on libgda for being
421 (Close): implemented.
422 (CreateCommand): implemented.
423 (GetOleDbSchemaTable): new stub, until I understand what to do here.
424 (Open): implemented basic stuff, which is just supporting connection
425 strings that represent a GDA data source name. More to come.
426 (InfoMessage, StateChange): added events.
428 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
430 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
432 * System.Data.OleDb/libgda.cs: added static constructor.
433 (GdaClient): new static property to get the underlying GdaClient
436 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
437 the static 'libgda' class.
439 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
441 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
443 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
444 (ConnectionString, Connectiontimeout, Database, State):
445 implemented class properties.
446 (BeginTransaction): implemented.
448 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
450 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
452 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
454 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
456 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
458 * list: added missing PostgresTypes.cs file.
460 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
462 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
465 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
467 * System.Data.SqlClient/SqlConnection.cs: modifed -
468 start to implement the interfaces properly and
469 properly doing a Close(), Dispose(), and
472 * Test/SqlSharpCli.cs: modified -
473 add support for MySQL in Mono.Data.MySql
474 and OleDb support in System.Data.OleDb. However,
475 the OleDb support is commented right now.
476 When the program starts up, a shorter help menu should
477 display the most important commands: help and quit
479 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
481 * System.Data.build: exclude System.Data.OleDb files.
483 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
485 * System.Data.SqlClient/SqlCommand.cs: typo
486 should be CommandBehavior.KeyInfo
488 * Test/SqlSharpCli.cs: refactored and added a few more
491 2002-05-27 Tim Coleman <tim@timcoleman.com>
492 * list: update to compile properly (add missing
493 files and switch path delimiter from '\' to '/').
495 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
497 * System.Data/DataRow.cs
498 * System.Data.Common/DbDataAdapter.cs: fix to
499 get Test/TestSqlDataAdapter.cs to work again
501 * Test/TestSqlDataAdapter.cs: removed comment
502 about SqlDataReader:NextResult() not being implemented; it
505 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
507 * System.Data/DataRow.cs: modified
508 support setting of DBNull.Value
509 using the Item indexer this[DataColumn]
511 * System.Data.SqlClient/SqlCommand.cs: modified
512 tweaks to show TODO's for other CommandBehavior.
513 Set AllowDBNull column to true for IsKey row
516 * System.Data.SqlClient/SqlConnection.cs: modified
517 if transaction is in progress when a Close() is called,
518 do a transaction Rollback.
520 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
522 * Test/SqlSharpCli.cs: added file
523 My new toy. SQL# is a command-line tool to enter
524 SQL commands and queries using Mono System.Data.
525 It also serves as a test for Mono System.Data.
527 * System.Data.SqlClient/SqlCommand.cs: modified
528 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
529 should handle the results from SQL Commands and Queries.
530 - Internal class SqlResult should not create schema Table
531 for the result from a SQL Command. Also, set the RecordsRetrieved
532 property for SqlDataReader.
533 - Closing the SqlDataReader should Close() the SqlConnection for
534 a CommandBehavior.CloseConnection.
535 - Set defaults for SqlResult
537 * System.Data.SqlClient/SqlConnection.cs: modified -
538 when SqlDataReader is Close()
539 should Close() the SqlConnection for
540 a CommandBehavior.CloseConnection. Changed internal Property
541 from OpenReader get/set to IsReaderOpen get and created
542 internal methods OpenReader()/CloseReader() for SqlCommand to call.
543 SqlConnection needs to be prevented from doing while SqlDataReader
546 * System.Data.SqlClient/SqlDataReader.cs: modified -
547 call SqlCommand's OpenReader() internal method. get
548 RecordsRetrieved from SqlResult. set/reset default
549 values for SqlDataReader.
551 * Test/PostgresTest.cs
552 * Test/TestExecuteScalar.cs
553 * Test/TestSqlDataReader.cs: modified
554 for the Execute...() methods in SqlCommand
555 to test SQL Queries and Commands
557 * Test/System.Data_test.build: modified
558 exclude new file Test/SqlSharpCli.cs from
561 2002-05-24 Tim Coleman <tim@timcoleman.com>
562 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
563 for get accessors. These should be implemented in derived classes. See
564 SqlDataAdapter for clues.
565 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
566 * System.Data.Common/DataAdapter.cs:
567 * System.Data.Common/DataTableMappingCollection.cs:
568 * System.Data.Common/DataTableMapping.cs:
569 * System.Data.Common/DataColumnMappingCollection.cs:
570 * System.Data.Common/DataColumnMapping.cs:
571 Properly (I hope!) implement all of the appropriate interfaces
575 2002-05-23 Tim Coleman <tim@timcoleman.com>
576 * System.Data.SqlClient/SqlCommand.cs: include
577 the BaseColumnName in the schema table. Was missed before.
578 * System.Data.Common/DbDataAdapter.cs: Use DataTable
579 mappings so that the DataSet and DataTable are more closely tied.
580 Get schema information from the DataTable using GetSchemaTable ()
581 Various other little fixes
582 * System.Data.Common/DataColumnMappingCollection.cs:
583 * System.Data.Common/DataTableMapping.cs:
584 * System.Data.Common/DataTableMappingCollection.cs: Some
585 implementation, enough to be used by DbDataAdapter.
587 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
589 * System.Data.SqlClient/SqlCommand.cs: set
590 the "ProviderType" to the PostgreSQL type oid
592 * System.Data.SqlClient/SqlDataReader.cs: fix
593 for various properties and methods that
594 return meta data: Item indexers this[name] and this[index],
595 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
598 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
600 * System.Data/DataRow.cs: change suggested
601 by tim: in Item indexer, do an EndEdit()
603 * System.Data.SqlClient/SqlCommand.cs: more
604 fixes to SqlResult. After setting each item in
605 the DataRow, do an AcceptChanges() to commit
606 the changes in the DataRow. For DataType, use a Type
607 of System.String since System.Type nor System.Object
610 * Test/TestSqlDataReader.cs
611 * Test/PostgresTest.cs: updated to to be on
612 the way schema table is suppose to work
614 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
616 * System.Data.SqlClient/SqlCommand.cs: more work on
617 building the schema table
619 2002-05-22 Tim Coleman <tim@timcoleman.com>
620 * System.Data.SqlClient/SqlCommand.cs: preliminary work
621 on getting the schema table correctly built.
623 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
625 * System.Data.SqlClient/ParmUtil.cs: added file - to
626 provide utility for conversion of input parameters
628 * System.Data.SqlClient/PostgresTypes.cs: added file -
629 moved the PostgreHelper class to here. May eventually
630 move the internal class PostgresTypes that's inside the
631 SqlConnection to here as well.
632 Handling of PostgreSQL <-> .NET types need to be though
633 out more. Also, the PostgreHelper has a method to convert
634 from .NET types to a string which can be put into used in
635 an SQL statement to execute against a PostgreSQL database.
636 This is the beginnings of parameters support. It currently
637 only supports input parameters. Still need to do output,
638 input/output, and return parameters.
640 * Test/TestSqlParameters.cs: new test to test the input
641 parameters in System.Data.SqlClient against a
644 * System.Data.SqlClient/PostgresLibrary.cs: moved
645 PostgresHelper class to file PostgresTypes.cs. Also
646 moved struct PostgresType there too.
648 * System.Data.SqlClient/SqlCommand.cs: added input
651 * System.Data.SqlClient/SqlParameter.cs: got
654 * System.Data.SqlClient/SqlParameterCollection.cs: got
655 SqlParameterCollection to work
657 * Test/System.Data_test.build: added files to exclude
660 * System.Data.SqlClient/SqlConnection.cs: release resources
663 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
665 * System.Xml: added directory for classes with namespace
666 System.Xml to go into the System.Data.dll assembly
668 * System.Xml/XmlDataDocument: added file
669 for stubbed concrete class XmlDataDocument which
670 inherits from XmlDocument. Its purpose is to provide
671 a W3C XML DOM Document for relational data and interacting
674 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
676 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
677 Text, TableDirect, and StoredProcedure
679 * Test/PostgresTest.cs: changed call to version()
680 stored procedure to use the CommandType of StoredProcedure
682 * Test/TestSqlDataReader.cs: test all the CommandTypes
684 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
686 * System.Data.build: took out all excluded
687 files except the ones in the Test directory
688 because all files compile now. It does not
689 mean they all work or have implementations
692 * System.Data/DataRelationCollection.cs
693 * System.Data/DataTableRelationCollection.cs
694 * System.Data/InternalDataCollectionBase.cs
695 * System.Data.Common/DbDataPermission.cs
696 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
697 * System.Data.SqlClient/SqlClientPermission.cs
698 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
699 to get all System.Data* files to compile.
701 * System.Data.SqlClient/SqlCommand.cs: started coding
702 to prevent SqlConnection and SqlCommand from doing
703 anyting while fetching data using SqlDataReader. Also,
704 started coding to undo this prevention once the
705 SqlDataReader is closed.
707 * System.Data.SqlClient/SqlConnection.cs: get database server
708 version. Started coding to prevent connection from
709 doing anything while fetching data and undo once the reader
710 is closed. Include events SqlInfoMessage and StateChange.
712 * System.Data.SqlClient/SqlDataReader.cs: start coding to
713 prevent connection and command from doing anything while
714 fetching data, and undo when closed.
716 * Test/PostgresTest.cs: added test to get ServerVersion
717 property from SqlConnection
719 2002-05-18 Tim Coleman <tim@timcoleman.com>
720 * System.Data/DataRow.cs: More implementation,
721 as well as boundary checks and small semantic
724 2002-05-18 Tim Coleman <tim@timcoleman.com>
725 * System.Data/DataRow.cs: Try to reduce memory
726 usage by only creating the original and proposed
727 arrays as required in BeginEdit, and then destroying
728 proposed during EndEdit, and original during AcceptChanges.
729 * System.Data.Common/DbDataAdapter.cs: Make the
730 startRecord and maxRecords parameters work correctly.
732 2002-05-18 Tim Coleman <tim@timcoleman.com>
733 * System.Data/DataRow.cs: Move the null check in
734 ItemArray set to above the Invalid Cast check, so
735 that we don't get null reference exceptions.
737 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
739 * System.Data.SqlClient/PostgresLibrary.cs: handle
740 data value from database being NULL
742 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
743 allow multiple result sets. Added new internal class
744 SqlResult to pass result set data from SqlCommand
747 * System.Data.SqlClient/SqlDataReader.cs: allow
748 multiple result sets.
750 * System.Data.SqlClient/SqlConnection.cs: moved
751 things around. Implement IDisposable.
753 * Test/TestSqlDataReader.cs: test for execution
754 of multiple result sets and display the results
755 of these multiple results sets
757 * Test/TestSqlDataAdapter.cs: tweaks
759 2002-05-17 Tim Coleman <tim@timcoleman.com>
760 * System.Data.Common/DbDataAdapter.cs:
761 - More implementation of Fill methods
762 - Get rid of isDirty flag, because we can just check
764 - Do *not* remove DataTables before Filling them
765 - Implicitly open the connection before doing a Fill
766 if it does not exist.
767 * System.Data.SqlClient/SqlDataAdapter.cs:
769 * System.Data/DataTableCollection.cs:
770 - Add DataSet to internal, undocumented constructor
771 - When a table is created, set its DataSet property
772 - Default table name for creation is "Table1" (see .NET)
773 - Inherit the ArrayList list from InternalDataCollecitonBase
774 and maintain a hashtable between table names and
776 * System.Data/DataTable.cs:
777 - Add internal dataSet field. This is used by
778 DataTableCollection when the DataTable is constructed.
779 * System.Data/DataSet.cs:
780 - Pass a reference to the DataSet when constructing the
783 2002-05-16 Tim Coleman <tim@timcoleman.com>
784 * System.Data.Common/DbDataAdapter.cs:
785 Use table.Rows.Add (itemArray) instead of
786 table.Rows.Add (thisRow) to provide better
788 * System.Data/DataRowCollection.cs:
789 Some implementation of this class.
790 * System.Data/InternalDataCollectionBase.cs:
791 Some implementation. Most notably, this now
792 has an enumerator so we can use foreach (DataRow row in table.Rows)
794 * System.Data/DataTable.cs:
795 Since DataRowCollection now accepts a DataTable in
796 its internal constructor, we must pass one in.
798 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
800 * Test/TestSqlDataAdapter.cs: added new test
801 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
802 DataRowCollection, and DataRow. It tests retrieving data
803 based on a SQL SELECT query. This test is based on Tim Coleman's
806 2002-05-16 Tim Coleman <tim@timcoleman.com>
807 * System.Data.Common/DbDataAdapter.cs:
808 Use table.Rows.Add (thisRow) instead of
809 table.ImportRow (thisRow)
810 * System.Data/DataRowCollection.cs:
811 Construct the ArrayList before using it
813 2002-05-16 Tim Coleman <tim@timcoleman.com>
814 * System.Data/DataTable.cs:
815 Construct the DataRowCollection in the DataTable
816 constructor. Otherwise, it's a null reference.
818 2002-05-16 Tim Coleman <tim@timcoleman.com>
819 * System.Data.SqlClient/SqlDataReader.cs:
820 Modify GetValues to use Array.Copy() to copy
821 the results from fields to values, rather than
822 an assignment, which results in loss of data.
824 2002-05-16 Tim Coleman <tim@timcoleman.com>
825 * System.Data/DataRow.cs:
826 More implementation and documentation. It should
827 work more like expected, although there is no way
828 to demonstrate this well yet. DataTable requires
831 2002-05-15 Tim Coleman <tim@timcoleman.com>
832 * System.Data/DataRow.cs:
833 Minor tweaks as I determine exactly how to
834 implement this class.
837 2002-05-14 Duncan Mak <duncan@ximian.com>
839 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
841 2002-05-14 Tim Coleman
842 * System.Data/DataRow.cs:
843 * System.Data/DataRowBuilder.cs:
844 * System.Data/DataTable.cs:
845 More implementation of these classes. DataRow
846 can now (possibly) do some useful things.
847 Still not sure what DataRowBuilder is all about,
848 other than passing a DataTable in.
850 2002-05-14 Tim Coleman
851 * System.Data/DataRowBuilder.cs:
852 Add stubb for this internal class.
854 2002-05-13 Tim Coleman
855 * System.Data.Common/DbDataAdapter.cs:
856 The maxRecords check was not correct.
858 2002-05-13 Tim Coleman
859 * System.Data/DataTableCollection.cs:
860 Fix an issue when adding a DataTable and size == 0.
861 Now explicitly checks if size > 0 before doing Array.Copy ()
862 * System.Data.Common/DbDataAdapter.cs:
863 Move closer to a working implementation.
864 Make the IDbCommand fields protected so that they can
866 * System.Data.SqlClient/SqlDataAdapter.cs:
867 This should inherit the IDbCommands instead of having its
868 own. An explicit cast is used to force conversion between
869 IDbCommand and SqlCommand
871 2002-05-13 Tim Coleman
872 * System.Data.Common/DataTableMappingCollection.cs:
873 Some implementation to allow progress with DbDataAdapter
875 2002-05-13 Tim Coleman
876 * System.Data.Common/DbDataAdapter.cs:
877 Modify to not break compile.
879 2002-05-13 Tim Coleman
881 include SqlDataAdapter, SqlRowUpdatedEventArgs,
882 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
883 SqlRowUpdatingEventHandler in the build.
885 2002-05-13 Tim Coleman
886 * System.Data.Common/DbDataAdapter.cs:
888 * System.Data.Common/DataAdapter.cs:
889 Correction of some of the stubbing, as well as a
890 little bit more implementation
892 2002-05-11 Tim Coleman
893 * System.Data.SqlClient/SqlDataAdapter.cs:
894 * System.Data.Common/DbDataAdapter.cs:
895 Moved methods that weren't supposed to
896 be in SqlDataAdapter out. They should be implemented
900 2002-05-11 Tim Coleman
901 * System.Data.SqlClient/SqlDataAdapter.cs:
902 some implementation of this class. Note
903 that none of the functionality has been
904 tested yet, but I felt it should be checked
905 in at this point as it compiles.
906 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
907 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
908 Modified so that they will compile properly.
909 Needed to include SqlDataAdapter in the build.
911 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
913 * System.Data/DataTable.cs (Clear): implemented.
914 (DataTable): removed repeated code in constructors, and call the
915 basic constructor from the others.
917 * System.Data/DataColumn.cs: some tweaks.
919 * System.Data/DataRow.cs (RowState): implemented.
920 (CancelEdit): set rowState property back to Unchanged.
921 (RejectChanges): call CancelEdit.
922 (Delete): set rowState to Deleted.
924 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
926 * System.Data.build: added copy of System.Data.dll to Test directory
927 for easy testing. Also, added clean for it too.
929 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
930 from PostgreSQL data type to .NET type.
932 * System.Data.SqlClient/SqlDataReader.cs: beginnings
933 handling of a NULL value from the database
935 * Test/PostgresTest.cs: added tests for NULL values retrieved
938 * Test/ReadPostgresData.cs
939 * Test/TestExecuteScalar.cs
940 * Test/TestSqlDataReader.cs
941 * Test/TestSqlException.cs
942 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
943 "postgres". These tests may eventually be removed since they
946 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
948 * System.Data.build: removed reference to non-existant
949 TestDataColumn.cs file.
951 * System.Data/DataSet.cs: added some implementation.
953 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
955 * System.Data.SqlClient/PostgresLibrary.cs: got
956 PostgreSQL data types time, date, timestamp (DateTime like)
957 mapped to .NET System.DateTime working based
958 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
959 Also mapped pg type boolean to .net Boolean
961 * SqlClient/SqlConnection.cs: run SQL command to set
964 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
965 added tests for aggregates min(), max(), sum(), count(). could
966 not get avg() to work due to some formatting error; someone claimed
967 that it was my locale settings. added tests for SELECT of columns
968 of type boolean, float, double, date, time, and timestamp. They
969 have not been fully tested, but its a start.
971 2002-05-09 Tim Coleman <tim@timcoleman.com>
972 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
973 addition, subtraction, and multiplication for the
974 SqlDecimal type, as well as modification of some other
975 operations. More to come on this one.
977 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
979 * Test/System.Data_test.build: excluded TestDataColumn, which
980 should be replaced with a nunit test.
982 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
984 2002-05-07 Tim Coleman <tim@timcoleman.com>
998 Fix the broken build I made before. Bad
1001 2002-05-07 Tim Coleman <tim@timcoleman.com>
1003 Fix a symantic error I made in SqlString
1004 Equals where I copied and pasted wrongly
1006 2002-05-07 Tim Coleman <tim@timcoleman.com>
1011 * SqlCompareOptions.cs:
1022 Implement CompareTo, Equals, and String conversions
1025 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1027 * Test/PostgresTest.cs: modified to run completely. There
1028 are many TODOs in System.Data, so not all data types are
1029 included in the SELECT SQL query. Also, I made it to where
1031 using "host=localhost;dbname=test;user=postgres"
1032 instead of my userid and password. When more types are included,
1035 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1037 * Test/PostgresTest.cs: added - ported
1038 libgda postgres-test.c originally by
1039 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
1042 2002-05-05 Tim Coleman <tim@timcoleman.com>
1043 * System.Data.SqlTypes/SqlBinary.cs:
1044 * System.Data.SqlTypes/SqlBoolean.cs:
1045 * System.Data.SqlTypes/SqlByte.cs:
1046 * System.Data.SqlTypes/SqlDateTime.cs:
1047 * System.Data.SqlTypes/SqlDecimal.cs:
1048 * System.Data.SqlTypes/SqlDouble.cs:
1049 * System.Data.SqlTypes/SqlGuid.cs:
1050 * System.Data.SqlTypes/SqlInt16.cs:
1051 * System.Data.SqlTypes/SqlInt32.cs:
1052 * System.Data.SqlTypes/SqlInt64.cs:
1053 * System.Data.SqlTypes/SqlMoney.cs:
1054 * System.Data.SqlTypes/SqlSingle.cs:
1055 * System.Data.SqlTypes/SqlString.cs:
1056 More implementation, and code clean-up for consistency.
1057 Also, I had implemented many conversions as explicit
1058 that should have been implicit. This should remove
1059 many of the red X's and green pluses from the
1060 System.Data.SqlTypes namespace.
1062 2002-05-05 Miguel de Icaza <miguel@ximian.com>
1064 * System.Data/DataSet.cs: Remove [Serializable] attributes from
1065 methods, those only apply to structs or classes.
1067 Stub out ISerializable, ISupportInitialize, and IListSource methods
1069 * System.Data/DataRowView.cs: Stub out interface methods for
1070 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
1072 * System.Data/DataView.cs: Comment out non-implemented
1075 * System.Data/DataViewSettingsCollection.cs: Type cast variables
1076 to the correct type to make it compile.
1078 * System.Data/DataViewSettings.cs: remove reference to
1079 non-existance type ApplyDefaultSort, it is a boolean.
1082 2002-05-05 Tim Coleman <tim@timcoleman.com>
1083 * System.Data.SqlTypes/SqlBinary.cs:
1084 * System.Data.SqlTypes/SqlBoolean.cs:
1085 * System.Data.SqlTypes/SqlByte.cs:
1086 * System.Data.SqlTypes/SqlDecimal.cs:
1087 * System.Data.SqlTypes/SqlDouble.cs:
1088 * System.Data.SqlTypes/SqlGuid.cs:
1089 * System.Data.SqlTypes/SqlInt16.cs:
1090 * System.Data.SqlTypes/SqlInt32.cs:
1091 * System.Data.SqlTypes/SqlInt64.cs:
1092 * System.Data.SqlTypes/SqlMoney.cs:
1093 * System.Data.SqlTypes/SqlSingle.cs:
1094 * System.Data.SqlTypes/SqlString.cs:
1095 Various fixes, including adding the SqlNullValueException
1096 when trying to retrieve the value of a null SqlType,
1097 and when casting values, a Null of type A converts to a
1100 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1102 * System.Data.SqlClient/PostgresLibrary.cs
1103 * System.Data.SqlClient/SqlCommand.cs
1104 * System.Data.SqlClient/SqlConnection.cs
1105 * System.Data.SqlClient/SqlDataReader.cs
1106 oid should not be hard coded because they
1107 can change from one version of PostgreSQL
1108 to the next. Use the typname's instead.
1109 The PostgreSQL type data retrieves
1110 at database connection time. Any unimplemented
1111 types just default to string. These were things
1112 suggested by Gonzalo.
1114 * Test/ReadPostgresData.cs - stuff
1115 * Test/TestSqlDataReader.cs - stuff
1117 * System.Data.SqlTypes/SqlInt32.cs - added a using
1119 2002-05-03 Tim Coleman <tim@timcoleman.com>
1120 * System.Data.build: Fix the build so that test depends on build
1122 2002-05-03 Tim Coleman <tim@timcoleman.com>
1123 * System.Data.SqlTypes/SqlByte.cs:
1124 * System.Data.SqlTypes/SqlDateTime.cs:
1125 * System.Data.SqlTypes/SqlDecimal.cs:
1126 * System.Data.SqlTypes/SqlDouble.cs:
1127 * System.Data.SqlTypes/SqlGuid.cs:
1128 * System.Data.SqlTypes/SqlInt16.cs:
1129 * System.Data.SqlTypes/SqlInt64.cs:
1130 * System.Data.SqlTypes/SqlMoney.cs:
1131 * System.Data.SqlTypes/SqlSingle.cs:
1132 These files were mysteriously excluded from the last
1133 patch I made and sent to Rodrigo
1134 * System.Data.build: include the System.Data.SqlTypes in the build
1136 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1138 * System.Data.build: removed comments
1140 * System.Data.SqlClient/PostgresLibrary.cs: changed
1141 the hard-coded PostgreSQL oid type int's to using an
1142 enum. Also, added PostgreSQL bpchar (character) type.
1144 * Test/TestSqlDataReader.cs: updated test
1145 to include new bpchar PostgreSQL type
1147 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1149 * System.Data.SqlTypes/SqlBinary.cs:
1150 * System.Data.SqlTypes/SqlBoolean.cs:
1151 * System.Data.SqlTypes/SqlInt32.cs:
1152 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1153 Tim Coleman <tcoleman@opentext.com>.
1155 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1157 * Test/TestExecuteScalar.cs: added test for
1158 method ExecuteScalar in class SqlCommand.
1160 * System.Data/DataColumnCollection.cs - it should
1161 inherit properties from base InternalDataCollectionBase
1162 and use them instead of overriding them, such as, List.
1164 * System.Data/DataColumn.cs
1165 * System.Data/DataTable.cs: tweaks to retrieve
1166 meta data from the database
1168 * System.Data.SqlClient/PostgresLibrary.cs -
1169 added method OidToType to convert PostgreSQL oid type
1170 to System.Type. Renamed method OidTypeToSystem
1171 to ConvertPgTypeToSystem for converting the data value
1172 from a PostgreSQL type to a .NET System type.
1174 * System.Data.SqlClient/SqlCommand.cs: implemented
1175 method ExecuteReader which returns a SqlDataReader
1176 for a light forward only read only result set.
1177 It works on types int4 ==> Int32 and
1178 varchar ==> String. Other types
1181 * System.Data.SqlClient/SqlConnection.cs: added comment
1183 * System.Data.SqlClient/SqlDataReader.cs: implemented
1184 class. It works, but still lots to do.
1186 * Test/ReadPostgresData.cs: stuff
1188 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1189 to display meta data and the data
1191 2002-05-03 Duncan Mak <duncan@ximian.com>
1193 * TODO: Took out all the Exceptions. They should be all done now.
1195 * System.Data/ConstraintException.cs:
1196 * System.Data/DBConcurrencyException.cs:
1197 * System.Data/DataException.cs:
1198 * System.Data/DeletedRowInaccessibleException.cs:
1199 * System.Data/DuplicateNameException.cs:
1200 * System.Data/EvaluateException.cs:
1201 * System.Data/InRowChangingEventException.cs:
1202 * System.Data/InvalidConstraintException.cs:
1203 * System.Data/InvalidExpressionException.cs:
1204 * System.Data/MissingPrimaryKeyException.cs:
1205 * System.Data/NoNullAllowedException.cs:
1206 * System.Data/ReadOnlyException.cs:
1207 * System.Data/RowNotInTableException.cs:
1208 * System.Data/StrongTypingException.cs:
1209 * System.Data/SyntaxErrorException.cs:
1210 * System.Data/TypeDataSetGeneratorException.cs:
1211 * System.Data/VersionNotFoundException.cs: Added to CVS.
1213 * System.Data.SqlTypes/SqlNullValueException.cs:
1214 * System.Data.SqlTypes/SqlTruncateException.cs:
1215 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1217 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1219 * System.Data/DataViewSettingCollection.cs: implemented.
1221 * System.Data/DataRowView.cs: new stubs.
1223 * System.Data.SqlTypes/SqlByte.cs:
1224 * System.Data.SqlTypes/SqlDateTime.cs:
1225 * System.Data.SqlTypes/SqlDecimal.cs:
1226 * System.Data.SqlTypes/SqlDouble.cs:
1227 * System.Data.SqlTypes/SqlGuid.cs:
1228 * System.Data.SqlTypes/SqlInt16.cs:
1229 * System.Data.SqlTypes/SqlInt64.cs:
1230 * System.Data.SqlTypes/SqlMoney.cs:
1231 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1232 by Tim Coleman <tcoleman@opentext.com>
1234 * System.Data.build: excluded newly-added files.
1236 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1238 * System.Data.SqlClient/PostgresLibrary.cs: included new
1239 internal class that will be a helper class in using
1240 PostgreSQL. PostgresLibrary is used for the
1241 pinvoke methods to the PostgreSQL Client
1242 native C library libpq while the class PostgresHelper
1243 is used for wrapper or helper methods. It currently only
1244 has one static method OidTypeToSystem in converting
1245 PostgreSQL types to .NET System.<type>s, such as,
1246 a PostgreSQL int8 becomes a .NET System.Int64.
1247 Only a few types have been added, such as, int2,
1248 int4, int8, varchar, text, bool, and char. Other types
1251 * System.Data.SqlClient/SqlCommand.cs: implemented
1252 method ExecuteScalar which allows us to do aggregate
1253 functions, such as, count, avg, min, max, and sum. We
1254 also are able to retrieve the result, convert it to the .NET type
1255 as an object. The user of the returned object must explicitly cast.
1257 * Test/ReadPostgresData.cs: updated sample
1258 to help us learn to retrieve data in System.Data.SqlClient
1261 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1263 * System.Data.build: added /nowarn: nnnn arguments
1264 so you will not get a ton of warnings. The warnings
1265 being excluded are: 1595, 0067, 0109, 0169, and 0649
1267 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1269 * System.Data.build: modified to exclude more
1270 files from the build
1272 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1274 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1277 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1278 by John Dugaw <jdugaw@unizenconsulting.com>.
1280 * System.Data.build: excluded new files from build.
1282 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1284 * Test/ReadPostgresData.cs: added - Uses the
1285 PostgresLibrary to retrieve a recordset.
1286 This is not meant to be used in Production, but as a
1287 learning aid in coding
1288 class System.Data.SqlClient.SqlDataReader.
1289 This sample does work.
1291 * Test/TestSqlDataReader.cs: added - used
1292 to test SqlDataReader (does not work yet)
1293 Forgot to add to ChangeLog on last commit.
1295 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1297 * System.Data/DataViewSetting.cs: new class.
1299 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1301 * System.Data/DataViewManager.cs: new class.
1303 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1304 don't have implementation.
1306 * System.Data.SqlTypes/SqlInt32.cs:
1307 * System.Data.SqlTypes/SqlString.cs:
1308 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1309 these are strctures.
1311 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1314 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1316 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1317 for correctly hiding parent class' members.
1318 (AddRange): use 'override' keyword on overriden method.
1320 (Contains): likewise.
1321 (IndexOf): likewise.
1322 (OnCollectionChanged): likewise.
1323 (OnCollectionChanging): likewise.
1324 (RemoveCore): likewise.
1326 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1328 * System.Data/DataSet.cs: added missing 'using's.
1330 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1332 * System.Data/DataSet.cs:
1333 * System.Data/DataTableCollection.cs:
1334 * System.Data/DataView.cs: compilation fixes on Linux.
1336 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1338 * System.Data/DataRelation.cs
1339 * System.Data/ForeignKeyConstraint.cs
1340 * System.Data/UniqueConstraint.cs: added more stubs
1342 * System.Data/DataTableRelationCollection.cs: added back to cvs
1343 and modified for compile errors. DataRelationCollection is an
1344 abstract class and there must be a class that implements for
1345 DataTable/DataSet. DataTableRelationCollection was changed
1346 to an internal class.
1348 * System.Data.build: modified - new files added
1349 also wanted to include files/classes in the build
1350 so we can get a compilable forward read only result set.
1351 It compiles now using csc/nant with warnings, but this
1352 is a start for adding functionality for the result set.
1353 Classes associated with/and DataSet are still excluded.
1355 * TODO: modified - updated to do list for System.Data
1357 * System.Data/Constraint.cs
1358 * System.Data/ConstraintCollection.cs
1359 * System.Data/DataRelationCollection.cs
1360 * System.Data/DataRow.cs
1361 * System.Data/DataRowChangeEventArgs.cs
1362 * System.Data/DataRowCollection.cs
1363 * System.Data/DataTable.cs
1364 * System.Data/DataTableCollection.cs
1365 * System.Data/InternalDataCollectionBase.cs
1366 * System.Data/PropertyCollection.cs: modified -
1367 changes to compile SqlDataReader/DataTable and
1370 * System.Data/IDbCommand.cs
1371 * System.Data.SqlClient/SqlCommand.cs: modified -
1372 un-commented overloaded methods ExecuteReader
1373 which returns a SqlDataReader
1375 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1377 * System.Data/DataTableCollection.cs: more implementation.
1378 (Count): added 'override' keyword, as pointer out by Martin.
1380 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1381 only call Array.Copy when there is really stuff to be copied.
1382 (CopyTo): don't create the temporary array, it's not needed.
1384 * System.Data.build: excluded newly added file from build.
1386 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1388 * System.Data/DataTableRelationCollection.cs: removed, it's not
1389 on MS SDK documentation.
1391 * System.Data/DataTableCollection.cs: new class.
1393 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1395 * System.Data/DataRowChangeEventArgs.cs
1396 * System.Data/DataRowCollection.cs
1397 * System.Data/DataView.cs
1398 * System.Data/PropertyCollection.cs: added new stubs
1400 * System.Data.build: modified - added new files to exclude
1403 * TODO: modified - removed files from TODO list
1404 that were stubbed above
1406 * System.Data/DataColumn.cs
1407 * System.Data/DataRow.cs: modified - various tweaks
1408 and added internal method SetTable to set the reference
1411 * System.Data/DataSet.cs: modified - class was not
1414 * System.Data/DataTable.cs: modified - temporarily commented
1415 DataSet and DataView references - trying to compile a SqlDataReader,
1416 DataTable, and dependencies for a forward read-only result set.
1417 SqlDataAdapter, DataSet, and DataView will come later once we can get
1418 a forward read only result set working.
1420 * System.Data/IDataRecord.cs: modified - source code lines should
1423 * System.Data/InternalDataCollectionBase.cs: modified - started
1424 implementing this base class for collection of data rows,
1425 columns, tables, relations, and constraints
1427 * System.Data.SqlClient/SqlException.cs: modified -
1428 call base(message) so a unhandled exception displays
1429 the message of a SQL error instead of the
1430 default SystemException message
1432 * Test/TestSqlException.cs: modified -
1433 handle the rollback properly for a SqlException on a
1436 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1438 * System.Data.build: modified - added new
1439 files to exclude from build
1441 * System.Data/Constraint.cs
1442 * System.Data/ConstraintCollection.cs
1443 * System.Data/InternalDataCollectionBase.cs: added -
1444 stubs which are needed to build DataTable.cs
1446 * TODO: modified - added more classes TODO and
1447 added more stuff TODO, such as, create script
1448 to create test database monotestdb for testing
1449 classes in System.Data
1451 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1453 * System.Data.Common/DataAdapter.cs:
1454 * System.Data.Common/DataColumnMappingCollection.cs:
1455 * System.Data.Common/DataTableMappingCollection.cs:
1456 * System.Data.Common/DbDataPermission.cs:
1457 * System.Data.Common/DbDataPermissionAttribute.cs: some
1458 compilation errors fixed.
1460 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1462 * TODO: modified - added classes TODO, and
1463 a poor attempt at System.Data plan
1465 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1467 * ChangeLog: modified - put tabs where they belong
1469 * System.Data.SqlClient/SqlDataReader.cs
1470 * System.Data/DataColumn.cs: modified - compile errors
1471 trying to compile SqlDataAdapter and dependencies
1473 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1475 * System.Data.SqlTypes/SqlBoolean.cs
1476 * System.Data.SqlTypes/SqlCompareOptions.cs
1477 * System.Data.SqlTypes/SqlInt32.cs
1478 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1480 * System.Data/DataTable.cs
1481 * System.Data.SqlClient/SqlCommand.cs
1482 * System.Data.SqlClient/SqlConnection.cs
1483 * System.Data.SqlClient/SqlError.cs
1484 * System.Data.SqlClient/SqlTransaction.cs: modified -
1487 * System.Data.SqlClient/SqlException.cs: modified -
1488 missing Message on indexer for Message property
1490 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1492 * System.Data.SqlClient/SqlCommand.cs: modified - to
1493 compile using mcs. This problem is
1494 returning a stronger type in csc vs. msc
1496 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1497 can not do a using PGconn = IntPtr; and then declare
1498 with PGconn pgConn = IntPtr.Zero;
1499 Thiw works under csc though. Had to comment using and
1500 changed declaration to IntPtr pgConn = IntPtr.Zero;
1501 Also, got rid of compile warnings for hostaddr and port.
1503 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1504 rid of compile warnings. Commented MonoTODO attribute because mcs
1505 doesn't seem to work with C# array property indexer (Item)
1508 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1509 commented MonoTODO attribute for indexer for mcs compiling
1511 * Test/TestSqlIsolationLevel.cs:
1512 * Test/TestSqlInsert.cs:
1513 * Test/TestSqlException.cs: modified -
1514 removed extra ExecuteNonQuery which caused two inserted rows
1516 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1518 * System.Data/StateChangeEventArgs.cs - added
1519 needed to compile System.Data.dll with mcs.
1521 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1523 * System.Data.OleDb: added directory - for OleDb database
1526 * System.Data.SqlClient/SqlClientPermission.cs
1527 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1528 * System.Data.SqlClient/SqlCommandBuilder.cs
1529 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1530 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1531 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1532 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1533 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1534 * Test/TestSqlException.cs
1535 * Test/TestSqlIsolationLevel.cs: added - more tests
1537 * System.Data.build: modified - added new files - excludes these too
1539 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1541 * System.Data.SqlClient/SqlConnection.cs
1542 * System.Data.SqlClient/SqlCommand.cs
1543 * System.Data.SqlClient/SqlTransaction.cs
1544 * System.Data.SqlClient/SqlException.cs
1545 * System.Data.SqlClient/SqlErrorCollection.cs
1546 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1547 exception/error handling. SqlConnection(connectionString)
1548 constructor should not automatically connect.
1550 * System.Data.SqlClient/SqlDataReader.cs
1551 * System.Data.SqlClient/SqlDataAdapter.cs
1552 * System.Data.SqlClient/SqlParameter.cs
1553 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1554 added using System.ComponentModel;
1556 * Test/TestSqlInsert.cs: modified - to use transaction
1558 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1560 * System.Data/DataRow.cs: new skeletons.
1562 * System.Data.Common/DataAdapter.cs:
1563 * System.Data.Common/DataColumnMapping.cs:
1564 * System.Data.Common/DataColumnMappingCollection.cs:
1565 * System.Data.Common/DataTableMapping.cs:
1566 * System.Data.Common/DataTableMappingCollection.cs:
1567 * System.Data.Common/DbDataAdapter.cs:
1568 * System.Data.Common/RowUpdatedEventArgs.cs:
1569 * System.Data.SqlClient/SqlDataAdapter.cs:
1570 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1573 * System.Data.Common/DbDataRecord.cs:
1574 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1577 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1579 * Test/TestSqlInsert.cs: modified - do
1580 a SQL DELETE before SQL INSERT of row so you can use this
1583 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1584 IsolationLevel for PostgreSQL is ReadCommitted. However,
1585 PostgreSQL allows Serializable as well.
1586 (Thanks to Gonzalo for that!)
1588 * System.Data.SqlClient/SqlConnection.cs: modified
1589 * System.Data.SqlClient/SqlCommand.cs: modified
1590 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1591 working; however, we still need to implement SQL errors
1592 and exceptions to properly handle transactions. Also, added
1593 status and error message support from the PostgreSQL database.
1594 Currently, this does a Console.WriteLine() to display the
1595 status and error messages, but this is a TODO
1596 for SQL errors and exceptions.
1598 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1599 attribute for System.Data.dll assembly
1601 * System.Data/IDbCommand.cs: modified - commented
1602 overloaded method ExecuteReader
1603 so System.Data.SqlClient.SqlCommand can compile
1605 * System.Data/IDbCommand.cs: modified
1606 * System.Data/IDbConnection.cs: modified - added using System;
1607 * System.Data/IDataParameter.cs
1609 * System.Data.build: modified - build classes
1610 in System.Data.SqlClient and exclude others in System.Data
1612 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1613 parameter data type from IntPtr to enum ExecStatusType
1615 * ChangeLog: modified - corrected previous entries in log
1617 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1619 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1620 implementation. Still missing some stuff.
1622 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1624 * System.Data.SqlClient/SqlConnection.cs: modified - got
1625 to compile, run, and connect to PostgreSQL database
1627 * System.Data.SqlClient/SqlCommand.cs: modified - got
1628 to compile, run, and execute a SQL INSERT command
1629 which successfully inserted a row
1630 into the PostgreSQL database
1632 * System.Data.SqlClient/SqlTransaction.cs: modified
1633 * System.Data.SqlClient/SqlParameter.cs: modified
1634 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1635 * System.Data.SqlClient/SqlError.cs: modified
1636 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1637 * System.Data.SqlClient/SqlException.cs: modified
1638 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1640 * System.Data.SqlClient/SqlAdapter: modified
1641 * System.Data.SqlClient/SqlReader: modified - add more stubs
1643 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1645 * Test/TestSqlInsert.cs: added
1647 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1649 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1650 class SqlConnecition
1651 * System.Data.SqlClient/SqlErrorCollection.cs: added
1652 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1654 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1656 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1657 * System.Data.IDbTransaction: Added Interface to IDisposable.
1658 * System.Data.IDbCommand: Fixed Capitalization of class name.
1659 * System.Data.IDbConnection: Fixed Capitalization of class name.
1661 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1663 * System.Data.Common/DbDataPermissionAttribute.cs:
1664 * System.Data.Common/DataAdapter.cs:
1665 * System.Data.Common/DataColumnMapping.cs:
1666 * System.Data.Common/DbDataPermission.cs: added some implementation.
1668 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1670 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1671 syntax, as pointed out by Levent Camlibel.
1673 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1675 * System.Data.SqlTypes/SqlBinary.cs:
1676 * System.Data.SqlTypes/INullable.cs: new skeletons.
1678 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1680 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1681 contains all calls the the PostgreSQL client library, to be used
1682 everywhere in System.Data.SqlClient.
1684 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1686 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1689 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1691 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1693 * System.Data.Common/DbDataRecord.cs:
1694 * System.Data.Common/DbEnumerator.cs:
1695 * System.Data.Common/RowUpdatedEventArgs.cs:
1696 * System.Data.Common/RowUpdatingEventArgs.cs:
1697 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1699 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1701 * System.Data.Common/DataTableMappingCollection.cs:
1702 * System.Data.Common/DbDataAdapter.cs:
1703 * System.Data.Common/DbDataPermission.cs:
1704 * System.Data.Common/DataTableMapping.cs: new skeletons.
1706 * System.Data.SqlClient/SqlDataAdapter.cs:
1707 * System.Data.SqlClient/SqlDataReader.cs:
1708 * System.Data.SqlClient/SqlErrors.cs:
1709 * System.Data.SqlClient/SqlError.cs:
1710 * System.Data.SqlClient/SqlException.cs:
1711 * System.Data.SqlClient/SqlParameter.cs:
1712 * System.Data.SqlClient/SqlParameterCollection.cs:
1713 * System.Data.SqlClient/SqlTransaction.cs:
1714 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1716 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1718 * System.Data.Common/DataColumnMapping.cs:
1719 * System.Data.Common/DataColumnMappingCollection.cs:
1720 * System.Data.Common/DataAdapter.cs: created skeletons.
1722 * System.Data.build: exclude new directories from build.
1724 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1726 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1728 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1729 implemented (2 methods).
1731 2002-03-24 Duncan Mak <duncan@ximian.com>
1733 * System.Data.build: Excluded System.Data.SqlClient from the build.
1734 The stubs are incomplete and they are stopping the build.
1736 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1738 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1740 * System.Data.SqlClient/*: added skeletons for the SQL managed
1741 provider for ADO.Net, to be based initially in PostgreSQL.
1743 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1745 Changed the Namespace on some Enums from mono.System.Data to System.Data
1747 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1749 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1750 default name if the ColumnName is null.
1751 * DataSet.cs : Added
1752 * DataTable.cs : Added
1753 * DataRelationCollection.cs : Added
1754 * DataTableRelationCollection.cs : Added
1755 * DataColumn : Added
1757 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1759 * DataColumnChangeEventArgs.cs : Added
1760 * DataColumnCollection.cs : Added
1762 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1764 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1765 * Updated all Enums, Interfaces, and Delegates in System.Data