1 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
3 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
4 unreachable code to avoid compiler warning.
6 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
8 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
9 (OpenReader): removed internal method.
11 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
12 the list of returned data models.
14 2002-08-15 Franklin Wise <gracenote@earthlink.net>
16 * System.Data/Constraint.cs: Added helper virtual functions
18 * System.Data/ConstraintCollection.cs: Improved constraint removal,
19 validation. Removed specific knowledge of subclasses of
22 * System.Data/DataColumn.cs: Added static helper function to compare
23 if two DataColumn arrays are the same.
25 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
27 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
30 2002-08-13 Franklin Wise <gracenote@earthlink.net>
32 * System.Data/DataRow.cs: Added several fixme tags.
34 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
36 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
37 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
38 to avoid compiler warnings.
40 2002-08-12 Franklin Wise <gracenote@earthlink.net>
42 * System.Data/Constraint.cs: Implemented
44 * System.Data/UniqueConstraint.cs: GetHashCode() &
45 special case Ctor. Still need to be implemented. LAMESPEC tags
48 * System.Data/ConstraintCollection.cs: Clear() &
49 AddRange() need to be finished. Several LAMESPEC tags.
51 * Allow Constraint collection to be created in DataTable.
53 * System.Data/ForeignKeyConstraint: Added a couple of
56 * System.Data/DataColumnCollection New/Added DataColumns now have
59 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
61 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
63 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
64 internal method, since we don't need it.
65 (ExecuteReader): call SetupGdaCommand before executing the command
67 (ExecuteScalar): implemented.
69 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
70 to OleDbCommand.OpenReader.
71 (GetBoolean): implemented.
73 2002-08-08 Franklin Wise <gracenote@earthlink.net>
75 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
77 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
79 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
82 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
84 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
85 and don't show a warning in Open.
87 * System.Data.OleDb/TestOleDb.cs: added Close.
89 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
91 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
92 ConnectionTimeout, ServerVersion, GdaConnection):
94 (OleDbConnection): call libgda.gda_init on constructor.
96 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
97 which wasn't been called.
99 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
102 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
104 * list: added missing System.Data.OleDb and
105 System.Data.Common files.
107 * System.Data.OleDb/ChangeLog: removed and merged with
108 System.Data's ChangeLog.
110 * System.Data.OleDb/OleDbDataAdapter.cs:
111 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
113 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
115 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
116 (IsClosed, Item, RecordsAffected): implemented some properties.
118 * libgda.cs: added GdaDataModel methods.
120 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
122 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
123 a second argument (ArrayList results).
124 (NextResult): implemented.
126 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
127 pass that to the OleDbDataReader.
128 (OleDbCommand constructor): don't create the ArrayList of results.
129 (GdaResults): removed property.
130 (ExecuteReader): create a temporary ArrayList and pass that to the
131 OleDbDataReader constructor.
133 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
135 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
136 (CreateParameter): implemented IDbCommand methods.
137 (CommandText): don't create many GdaCommand's, only one is needed.
138 (ExecuteNonQuery): set up the internal GDA command object.
139 (ExecuteReader): use correctly the unique GDA command object.
141 * System.Data.OleDb/libgda.cs: added new libgda calls.
143 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
145 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
146 (BeginTransaction): implemented IDbConnection methods.
148 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
150 * list: added System.Data.OleDb files to file list.
152 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
154 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
156 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
157 of the set method for this property.
159 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
160 (MissingSchemaAction): implemented.
162 2002-07-10 Tim Coleman <tim@timcoleman.com>
164 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
165 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
166 * System.Data.OleDb/OleDbError.cs: Added stubbs
167 * System.Data.OleDb/OleDbException.cs: Added stubbs
168 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
169 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
170 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
171 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
172 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
173 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
174 support transaction nesting
175 * System.Data.OleDb/libgda.cs: Added my name to this file
177 2002-07-09 Tim Coleman <tim@timcoleman.com>
179 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
180 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
181 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
182 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
183 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
184 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
185 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
186 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
187 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
188 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
189 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
190 * System.Data.OleDb/OleDbType.cs: Fixed two typos
191 * System.Data.OleDb/libgda.cs: Style changes, added new methods
193 2002-07-09 Tim Coleman <tim@timcoleman.com>
195 * System.Data.build: remove restriction on System.Data.OleDb build
197 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
199 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
200 IsSynchronized): implemented.
202 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
204 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
206 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
207 (Parameters, Transaction, Connection): made these overload
210 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
211 call m_list methods, not own ones.
213 * System.Data.OleDb/OleDbParameter.cs: more implementation.
215 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
217 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
218 Commit, Rollback): implemented.
219 (GdaConnection): added new internal property.
221 * System.Data.OleDb/OleDbParameter.cs:
222 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
225 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
227 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
229 * System.Data.OleDb/libgda.cs: added new libgda API functions.
231 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
232 (BeginTransaction): made it overload IDbConnection methods.
233 (ChangeDatabase): new stub, needs some work on libgda for being
236 (Close): implemented.
237 (CreateCommand): implemented.
238 (GetOleDbSchemaTable): new stub, until I understand what to do here.
239 (Open): implemented basic stuff, which is just supporting connection
240 strings that represent a GDA data source name. More to come.
241 (InfoMessage, StateChange): added events.
243 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
245 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
247 * System.Data.OleDb/libgda.cs: added static constructor.
248 (GdaClient): new static property to get the underlying GdaClient
251 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
252 the static 'libgda' class.
254 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
256 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
258 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
259 (ConnectionString, Connectiontimeout, Database, State):
260 implemented class properties.
261 (BeginTransaction): implemented.
263 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
265 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
267 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
269 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
271 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
273 * list: added missing PostgresTypes.cs file.
275 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
277 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
280 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
282 * System.Data.SqlClient/SqlConnection.cs: modifed -
283 start to implement the interfaces properly and
284 properly doing a Close(), Dispose(), and
287 * Test/SqlSharpCli.cs: modified -
288 add support for MySQL in Mono.Data.MySql
289 and OleDb support in System.Data.OleDb. However,
290 the OleDb support is commented right now.
291 When the program starts up, a shorter help menu should
292 display the most important commands: help and quit
294 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
296 * System.Data.build: exclude System.Data.OleDb files.
298 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
300 * System.Data.SqlClient/SqlCommand.cs: typo
301 should be CommandBehavior.KeyInfo
303 * Test/SqlSharpCli.cs: refactored and added a few more
306 2002-05-27 Tim Coleman <tim@timcoleman.com>
307 * list: update to compile properly (add missing
308 files and switch path delimiter from '\' to '/').
310 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
312 * System.Data/DataRow.cs
313 * System.Data.Common/DbDataAdapter.cs: fix to
314 get Test/TestSqlDataAdapter.cs to work again
316 * Test/TestSqlDataAdapter.cs: removed comment
317 about SqlDataReader:NextResult() not being implemented; it
320 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
322 * System.Data/DataRow.cs: modified
323 support setting of DBNull.Value
324 using the Item indexer this[DataColumn]
326 * System.Data.SqlClient/SqlCommand.cs: modified
327 tweaks to show TODO's for other CommandBehavior.
328 Set AllowDBNull column to true for IsKey row
331 * System.Data.SqlClient/SqlConnection.cs: modified
332 if transaction is in progress when a Close() is called,
333 do a transaction Rollback.
335 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
337 * Test/SqlSharpCli.cs: added file
338 My new toy. SQL# is a command-line tool to enter
339 SQL commands and queries using Mono System.Data.
340 It also serves as a test for Mono System.Data.
342 * System.Data.SqlClient/SqlCommand.cs: modified
343 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
344 should handle the results from SQL Commands and Queries.
345 - Internal class SqlResult should not create schema Table
346 for the result from a SQL Command. Also, set the RecordsRetrieved
347 property for SqlDataReader.
348 - Closing the SqlDataReader should Close() the SqlConnection for
349 a CommandBehavior.CloseConnection.
350 - Set defaults for SqlResult
352 * System.Data.SqlClient/SqlConnection.cs: modified -
353 when SqlDataReader is Close()
354 should Close() the SqlConnection for
355 a CommandBehavior.CloseConnection. Changed internal Property
356 from OpenReader get/set to IsReaderOpen get and created
357 internal methods OpenReader()/CloseReader() for SqlCommand to call.
358 SqlConnection needs to be prevented from doing while SqlDataReader
361 * System.Data.SqlClient/SqlDataReader.cs: modified -
362 call SqlCommand's OpenReader() internal method. get
363 RecordsRetrieved from SqlResult. set/reset default
364 values for SqlDataReader.
366 * Test/PostgresTest.cs
367 * Test/TestExecuteScalar.cs
368 * Test/TestSqlDataReader.cs: modified
369 for the Execute...() methods in SqlCommand
370 to test SQL Queries and Commands
372 * Test/System.Data_test.build: modified
373 exclude new file Test/SqlSharpCli.cs from
376 2002-05-24 Tim Coleman <tim@timcoleman.com>
377 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
378 for get accessors. These should be implemented in derived classes. See
379 SqlDataAdapter for clues.
380 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
381 * System.Data.Common/DataAdapter.cs:
382 * System.Data.Common/DataTableMappingCollection.cs:
383 * System.Data.Common/DataTableMapping.cs:
384 * System.Data.Common/DataColumnMappingCollection.cs:
385 * System.Data.Common/DataColumnMapping.cs:
386 Properly (I hope!) implement all of the appropriate interfaces
390 2002-05-23 Tim Coleman <tim@timcoleman.com>
391 * System.Data.SqlClient/SqlCommand.cs: include
392 the BaseColumnName in the schema table. Was missed before.
393 * System.Data.Common/DbDataAdapter.cs: Use DataTable
394 mappings so that the DataSet and DataTable are more closely tied.
395 Get schema information from the DataTable using GetSchemaTable ()
396 Various other little fixes
397 * System.Data.Common/DataColumnMappingCollection.cs:
398 * System.Data.Common/DataTableMapping.cs:
399 * System.Data.Common/DataTableMappingCollection.cs: Some
400 implementation, enough to be used by DbDataAdapter.
402 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
404 * System.Data.SqlClient/SqlCommand.cs: set
405 the "ProviderType" to the PostgreSQL type oid
407 * System.Data.SqlClient/SqlDataReader.cs: fix
408 for various properties and methods that
409 return meta data: Item indexers this[name] and this[index],
410 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
413 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
415 * System.Data/DataRow.cs: change suggested
416 by tim: in Item indexer, do an EndEdit()
418 * System.Data.SqlClient/SqlCommand.cs: more
419 fixes to SqlResult. After setting each item in
420 the DataRow, do an AcceptChanges() to commit
421 the changes in the DataRow. For DataType, use a Type
422 of System.String since System.Type nor System.Object
425 * Test/TestSqlDataReader.cs
426 * Test/PostgresTest.cs: updated to to be on
427 the way schema table is suppose to work
429 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
431 * System.Data.SqlClient/SqlCommand.cs: more work on
432 building the schema table
434 2002-05-22 Tim Coleman <tim@timcoleman.com>
435 * System.Data.SqlClient/SqlCommand.cs: preliminary work
436 on getting the schema table correctly built.
438 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
440 * System.Data.SqlClient/ParmUtil.cs: added file - to
441 provide utility for conversion of input parameters
443 * System.Data.SqlClient/PostgresTypes.cs: added file -
444 moved the PostgreHelper class to here. May eventually
445 move the internal class PostgresTypes that's inside the
446 SqlConnection to here as well.
447 Handling of PostgreSQL <-> .NET types need to be though
448 out more. Also, the PostgreHelper has a method to convert
449 from .NET types to a string which can be put into used in
450 an SQL statement to execute against a PostgreSQL database.
451 This is the beginnings of parameters support. It currently
452 only supports input parameters. Still need to do output,
453 input/output, and return parameters.
455 * Test/TestSqlParameters.cs: new test to test the input
456 parameters in System.Data.SqlClient against a
459 * System.Data.SqlClient/PostgresLibrary.cs: moved
460 PostgresHelper class to file PostgresTypes.cs. Also
461 moved struct PostgresType there too.
463 * System.Data.SqlClient/SqlCommand.cs: added input
466 * System.Data.SqlClient/SqlParameter.cs: got
469 * System.Data.SqlClient/SqlParameterCollection.cs: got
470 SqlParameterCollection to work
472 * Test/System.Data_test.build: added files to exclude
475 * System.Data.SqlClient/SqlConnection.cs: release resources
478 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
480 * System.Xml: added directory for classes with namespace
481 System.Xml to go into the System.Data.dll assembly
483 * System.Xml/XmlDataDocument: added file
484 for stubbed concrete class XmlDataDocument which
485 inherits from XmlDocument. Its purpose is to provide
486 a W3C XML DOM Document for relational data and interacting
489 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
491 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
492 Text, TableDirect, and StoredProcedure
494 * Test/PostgresTest.cs: changed call to version()
495 stored procedure to use the CommandType of StoredProcedure
497 * Test/TestSqlDataReader.cs: test all the CommandTypes
499 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
501 * System.Data.build: took out all excluded
502 files except the ones in the Test directory
503 because all files compile now. It does not
504 mean they all work or have implementations
507 * System.Data/DataRelationCollection.cs
508 * System.Data/DataTableRelationCollection.cs
509 * System.Data/InternalDataCollectionBase.cs
510 * System.Data.Common/DbDataPermission.cs
511 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
512 * System.Data.SqlClient/SqlClientPermission.cs
513 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
514 to get all System.Data* files to compile.
516 * System.Data.SqlClient/SqlCommand.cs: started coding
517 to prevent SqlConnection and SqlCommand from doing
518 anyting while fetching data using SqlDataReader. Also,
519 started coding to undo this prevention once the
520 SqlDataReader is closed.
522 * System.Data.SqlClient/SqlConnection.cs: get database server
523 version. Started coding to prevent connection from
524 doing anything while fetching data and undo once the reader
525 is closed. Include events SqlInfoMessage and StateChange.
527 * System.Data.SqlClient/SqlDataReader.cs: start coding to
528 prevent connection and command from doing anything while
529 fetching data, and undo when closed.
531 * Test/PostgresTest.cs: added test to get ServerVersion
532 property from SqlConnection
534 2002-05-18 Tim Coleman <tim@timcoleman.com>
535 * System.Data/DataRow.cs: More implementation,
536 as well as boundary checks and small semantic
539 2002-05-18 Tim Coleman <tim@timcoleman.com>
540 * System.Data/DataRow.cs: Try to reduce memory
541 usage by only creating the original and proposed
542 arrays as required in BeginEdit, and then destroying
543 proposed during EndEdit, and original during AcceptChanges.
544 * System.Data.Common/DbDataAdapter.cs: Make the
545 startRecord and maxRecords parameters work correctly.
547 2002-05-18 Tim Coleman <tim@timcoleman.com>
548 * System.Data/DataRow.cs: Move the null check in
549 ItemArray set to above the Invalid Cast check, so
550 that we don't get null reference exceptions.
552 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
554 * System.Data.SqlClient/PostgresLibrary.cs: handle
555 data value from database being NULL
557 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
558 allow multiple result sets. Added new internal class
559 SqlResult to pass result set data from SqlCommand
562 * System.Data.SqlClient/SqlDataReader.cs: allow
563 multiple result sets.
565 * System.Data.SqlClient/SqlConnection.cs: moved
566 things around. Implement IDisposable.
568 * Test/TestSqlDataReader.cs: test for execution
569 of multiple result sets and display the results
570 of these multiple results sets
572 * Test/TestSqlDataAdapter.cs: tweaks
574 2002-05-17 Tim Coleman <tim@timcoleman.com>
575 * System.Data.Common/DbDataAdapter.cs:
576 - More implementation of Fill methods
577 - Get rid of isDirty flag, because we can just check
579 - Do *not* remove DataTables before Filling them
580 - Implicitly open the connection before doing a Fill
581 if it does not exist.
582 * System.Data.SqlClient/SqlDataAdapter.cs:
584 * System.Data/DataTableCollection.cs:
585 - Add DataSet to internal, undocumented constructor
586 - When a table is created, set its DataSet property
587 - Default table name for creation is "Table1" (see .NET)
588 - Inherit the ArrayList list from InternalDataCollecitonBase
589 and maintain a hashtable between table names and
591 * System.Data/DataTable.cs:
592 - Add internal dataSet field. This is used by
593 DataTableCollection when the DataTable is constructed.
594 * System.Data/DataSet.cs:
595 - Pass a reference to the DataSet when constructing the
598 2002-05-16 Tim Coleman <tim@timcoleman.com>
599 * System.Data.Common/DbDataAdapter.cs:
600 Use table.Rows.Add (itemArray) instead of
601 table.Rows.Add (thisRow) to provide better
603 * System.Data/DataRowCollection.cs:
604 Some implementation of this class.
605 * System.Data/InternalDataCollectionBase.cs:
606 Some implementation. Most notably, this now
607 has an enumerator so we can use foreach (DataRow row in table.Rows)
609 * System.Data/DataTable.cs:
610 Since DataRowCollection now accepts a DataTable in
611 its internal constructor, we must pass one in.
613 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
615 * Test/TestSqlDataAdapter.cs: added new test
616 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
617 DataRowCollection, and DataRow. It tests retrieving data
618 based on a SQL SELECT query. This test is based on Tim Coleman's
621 2002-05-16 Tim Coleman <tim@timcoleman.com>
622 * System.Data.Common/DbDataAdapter.cs:
623 Use table.Rows.Add (thisRow) instead of
624 table.ImportRow (thisRow)
625 * System.Data/DataRowCollection.cs:
626 Construct the ArrayList before using it
628 2002-05-16 Tim Coleman <tim@timcoleman.com>
629 * System.Data/DataTable.cs:
630 Construct the DataRowCollection in the DataTable
631 constructor. Otherwise, it's a null reference.
633 2002-05-16 Tim Coleman <tim@timcoleman.com>
634 * System.Data.SqlClient/SqlDataReader.cs:
635 Modify GetValues to use Array.Copy() to copy
636 the results from fields to values, rather than
637 an assignment, which results in loss of data.
639 2002-05-16 Tim Coleman <tim@timcoleman.com>
640 * System.Data/DataRow.cs:
641 More implementation and documentation. It should
642 work more like expected, although there is no way
643 to demonstrate this well yet. DataTable requires
646 2002-05-15 Tim Coleman <tim@timcoleman.com>
647 * System.Data/DataRow.cs:
648 Minor tweaks as I determine exactly how to
649 implement this class.
652 2002-05-14 Duncan Mak <duncan@ximian.com>
654 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
656 2002-05-14 Tim Coleman
657 * System.Data/DataRow.cs:
658 * System.Data/DataRowBuilder.cs:
659 * System.Data/DataTable.cs:
660 More implementation of these classes. DataRow
661 can now (possibly) do some useful things.
662 Still not sure what DataRowBuilder is all about,
663 other than passing a DataTable in.
665 2002-05-14 Tim Coleman
666 * System.Data/DataRowBuilder.cs:
667 Add stubb for this internal class.
669 2002-05-13 Tim Coleman
670 * System.Data.Common/DbDataAdapter.cs:
671 The maxRecords check was not correct.
673 2002-05-13 Tim Coleman
674 * System.Data/DataTableCollection.cs:
675 Fix an issue when adding a DataTable and size == 0.
676 Now explicitly checks if size > 0 before doing Array.Copy ()
677 * System.Data.Common/DbDataAdapter.cs:
678 Move closer to a working implementation.
679 Make the IDbCommand fields protected so that they can
681 * System.Data.SqlClient/SqlDataAdapter.cs:
682 This should inherit the IDbCommands instead of having its
683 own. An explicit cast is used to force conversion between
684 IDbCommand and SqlCommand
686 2002-05-13 Tim Coleman
687 * System.Data.Common/DataTableMappingCollection.cs:
688 Some implementation to allow progress with DbDataAdapter
690 2002-05-13 Tim Coleman
691 * System.Data.Common/DbDataAdapter.cs:
692 Modify to not break compile.
694 2002-05-13 Tim Coleman
696 include SqlDataAdapter, SqlRowUpdatedEventArgs,
697 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
698 SqlRowUpdatingEventHandler in the build.
700 2002-05-13 Tim Coleman
701 * System.Data.Common/DbDataAdapter.cs:
703 * System.Data.Common/DataAdapter.cs:
704 Correction of some of the stubbing, as well as a
705 little bit more implementation
707 2002-05-11 Tim Coleman
708 * System.Data.SqlClient/SqlDataAdapter.cs:
709 * System.Data.Common/DbDataAdapter.cs:
710 Moved methods that weren't supposed to
711 be in SqlDataAdapter out. They should be implemented
715 2002-05-11 Tim Coleman
716 * System.Data.SqlClient/SqlDataAdapter.cs:
717 some implementation of this class. Note
718 that none of the functionality has been
719 tested yet, but I felt it should be checked
720 in at this point as it compiles.
721 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
722 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
723 Modified so that they will compile properly.
724 Needed to include SqlDataAdapter in the build.
726 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
728 * System.Data/DataTable.cs (Clear): implemented.
729 (DataTable): removed repeated code in constructors, and call the
730 basic constructor from the others.
732 * System.Data/DataColumn.cs: some tweaks.
734 * System.Data/DataRow.cs (RowState): implemented.
735 (CancelEdit): set rowState property back to Unchanged.
736 (RejectChanges): call CancelEdit.
737 (Delete): set rowState to Deleted.
739 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
741 * System.Data.build: added copy of System.Data.dll to Test directory
742 for easy testing. Also, added clean for it too.
744 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
745 from PostgreSQL data type to .NET type.
747 * System.Data.SqlClient/SqlDataReader.cs: beginnings
748 handling of a NULL value from the database
750 * Test/PostgresTest.cs: added tests for NULL values retrieved
753 * Test/ReadPostgresData.cs
754 * Test/TestExecuteScalar.cs
755 * Test/TestSqlDataReader.cs
756 * Test/TestSqlException.cs
757 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
758 "postgres". These tests may eventually be removed since they
761 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
763 * System.Data.build: removed reference to non-existant
764 TestDataColumn.cs file.
766 * System.Data/DataSet.cs: added some implementation.
768 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
770 * System.Data.SqlClient/PostgresLibrary.cs: got
771 PostgreSQL data types time, date, timestamp (DateTime like)
772 mapped to .NET System.DateTime working based
773 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
774 Also mapped pg type boolean to .net Boolean
776 * SqlClient/SqlConnection.cs: run SQL command to set
779 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
780 added tests for aggregates min(), max(), sum(), count(). could
781 not get avg() to work due to some formatting error; someone claimed
782 that it was my locale settings. added tests for SELECT of columns
783 of type boolean, float, double, date, time, and timestamp. They
784 have not been fully tested, but its a start.
786 2002-05-09 Tim Coleman <tim@timcoleman.com>
787 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
788 addition, subtraction, and multiplication for the
789 SqlDecimal type, as well as modification of some other
790 operations. More to come on this one.
792 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
794 * Test/System.Data_test.build: excluded TestDataColumn, which
795 should be replaced with a nunit test.
797 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
799 2002-05-07 Tim Coleman <tim@timcoleman.com>
813 Fix the broken build I made before. Bad
816 2002-05-07 Tim Coleman <tim@timcoleman.com>
818 Fix a symantic error I made in SqlString
819 Equals where I copied and pasted wrongly
821 2002-05-07 Tim Coleman <tim@timcoleman.com>
826 * SqlCompareOptions.cs:
837 Implement CompareTo, Equals, and String conversions
840 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
842 * Test/PostgresTest.cs: modified to run completely. There
843 are many TODOs in System.Data, so not all data types are
844 included in the SELECT SQL query. Also, I made it to where
846 using "host=localhost;dbname=test;user=postgres"
847 instead of my userid and password. When more types are included,
850 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
852 * Test/PostgresTest.cs: added - ported
853 libgda postgres-test.c originally by
854 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
857 2002-05-05 Tim Coleman <tim@timcoleman.com>
858 * System.Data.SqlTypes/SqlBinary.cs:
859 * System.Data.SqlTypes/SqlBoolean.cs:
860 * System.Data.SqlTypes/SqlByte.cs:
861 * System.Data.SqlTypes/SqlDateTime.cs:
862 * System.Data.SqlTypes/SqlDecimal.cs:
863 * System.Data.SqlTypes/SqlDouble.cs:
864 * System.Data.SqlTypes/SqlGuid.cs:
865 * System.Data.SqlTypes/SqlInt16.cs:
866 * System.Data.SqlTypes/SqlInt32.cs:
867 * System.Data.SqlTypes/SqlInt64.cs:
868 * System.Data.SqlTypes/SqlMoney.cs:
869 * System.Data.SqlTypes/SqlSingle.cs:
870 * System.Data.SqlTypes/SqlString.cs:
871 More implementation, and code clean-up for consistency.
872 Also, I had implemented many conversions as explicit
873 that should have been implicit. This should remove
874 many of the red X's and green pluses from the
875 System.Data.SqlTypes namespace.
877 2002-05-05 Miguel de Icaza <miguel@ximian.com>
879 * System.Data/DataSet.cs: Remove [Serializable] attributes from
880 methods, those only apply to structs or classes.
882 Stub out ISerializable, ISupportInitialize, and IListSource methods
884 * System.Data/DataRowView.cs: Stub out interface methods for
885 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
887 * System.Data/DataView.cs: Comment out non-implemented
890 * System.Data/DataViewSettingsCollection.cs: Type cast variables
891 to the correct type to make it compile.
893 * System.Data/DataViewSettings.cs: remove reference to
894 non-existance type ApplyDefaultSort, it is a boolean.
897 2002-05-05 Tim Coleman <tim@timcoleman.com>
898 * System.Data.SqlTypes/SqlBinary.cs:
899 * System.Data.SqlTypes/SqlBoolean.cs:
900 * System.Data.SqlTypes/SqlByte.cs:
901 * System.Data.SqlTypes/SqlDecimal.cs:
902 * System.Data.SqlTypes/SqlDouble.cs:
903 * System.Data.SqlTypes/SqlGuid.cs:
904 * System.Data.SqlTypes/SqlInt16.cs:
905 * System.Data.SqlTypes/SqlInt32.cs:
906 * System.Data.SqlTypes/SqlInt64.cs:
907 * System.Data.SqlTypes/SqlMoney.cs:
908 * System.Data.SqlTypes/SqlSingle.cs:
909 * System.Data.SqlTypes/SqlString.cs:
910 Various fixes, including adding the SqlNullValueException
911 when trying to retrieve the value of a null SqlType,
912 and when casting values, a Null of type A converts to a
915 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
917 * System.Data.SqlClient/PostgresLibrary.cs
918 * System.Data.SqlClient/SqlCommand.cs
919 * System.Data.SqlClient/SqlConnection.cs
920 * System.Data.SqlClient/SqlDataReader.cs
921 oid should not be hard coded because they
922 can change from one version of PostgreSQL
923 to the next. Use the typname's instead.
924 The PostgreSQL type data retrieves
925 at database connection time. Any unimplemented
926 types just default to string. These were things
927 suggested by Gonzalo.
929 * Test/ReadPostgresData.cs - stuff
930 * Test/TestSqlDataReader.cs - stuff
932 * System.Data.SqlTypes/SqlInt32.cs - added a using
934 2002-05-03 Tim Coleman <tim@timcoleman.com>
935 * System.Data.build: Fix the build so that test depends on build
937 2002-05-03 Tim Coleman <tim@timcoleman.com>
938 * System.Data.SqlTypes/SqlByte.cs:
939 * System.Data.SqlTypes/SqlDateTime.cs:
940 * System.Data.SqlTypes/SqlDecimal.cs:
941 * System.Data.SqlTypes/SqlDouble.cs:
942 * System.Data.SqlTypes/SqlGuid.cs:
943 * System.Data.SqlTypes/SqlInt16.cs:
944 * System.Data.SqlTypes/SqlInt64.cs:
945 * System.Data.SqlTypes/SqlMoney.cs:
946 * System.Data.SqlTypes/SqlSingle.cs:
947 These files were mysteriously excluded from the last
948 patch I made and sent to Rodrigo
949 * System.Data.build: include the System.Data.SqlTypes in the build
951 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
953 * System.Data.build: removed comments
955 * System.Data.SqlClient/PostgresLibrary.cs: changed
956 the hard-coded PostgreSQL oid type int's to using an
957 enum. Also, added PostgreSQL bpchar (character) type.
959 * Test/TestSqlDataReader.cs: updated test
960 to include new bpchar PostgreSQL type
962 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
964 * System.Data.SqlTypes/SqlBinary.cs:
965 * System.Data.SqlTypes/SqlBoolean.cs:
966 * System.Data.SqlTypes/SqlInt32.cs:
967 * System.Data.SqlTypes/SqlString.cs: more implementation, by
968 Tim Coleman <tcoleman@opentext.com>.
970 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
972 * Test/TestExecuteScalar.cs: added test for
973 method ExecuteScalar in class SqlCommand.
975 * System.Data/DataColumnCollection.cs - it should
976 inherit properties from base InternalDataCollectionBase
977 and use them instead of overriding them, such as, List.
979 * System.Data/DataColumn.cs
980 * System.Data/DataTable.cs: tweaks to retrieve
981 meta data from the database
983 * System.Data.SqlClient/PostgresLibrary.cs -
984 added method OidToType to convert PostgreSQL oid type
985 to System.Type. Renamed method OidTypeToSystem
986 to ConvertPgTypeToSystem for converting the data value
987 from a PostgreSQL type to a .NET System type.
989 * System.Data.SqlClient/SqlCommand.cs: implemented
990 method ExecuteReader which returns a SqlDataReader
991 for a light forward only read only result set.
992 It works on types int4 ==> Int32 and
993 varchar ==> String. Other types
996 * System.Data.SqlClient/SqlConnection.cs: added comment
998 * System.Data.SqlClient/SqlDataReader.cs: implemented
999 class. It works, but still lots to do.
1001 * Test/ReadPostgresData.cs: stuff
1003 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1004 to display meta data and the data
1006 2002-05-03 Duncan Mak <duncan@ximian.com>
1008 * TODO: Took out all the Exceptions. They should be all done now.
1010 * System.Data/ConstraintException.cs:
1011 * System.Data/DBConcurrencyException.cs:
1012 * System.Data/DataException.cs:
1013 * System.Data/DeletedRowInaccessibleException.cs:
1014 * System.Data/DuplicateNameException.cs:
1015 * System.Data/EvaluateException.cs:
1016 * System.Data/InRowChangingEventException.cs:
1017 * System.Data/InvalidConstraintException.cs:
1018 * System.Data/InvalidExpressionException.cs:
1019 * System.Data/MissingPrimaryKeyException.cs:
1020 * System.Data/NoNullAllowedException.cs:
1021 * System.Data/ReadOnlyException.cs:
1022 * System.Data/RowNotInTableException.cs:
1023 * System.Data/StrongTypingException.cs:
1024 * System.Data/SyntaxErrorException.cs:
1025 * System.Data/TypeDataSetGeneratorException.cs:
1026 * System.Data/VersionNotFoundException.cs: Added to CVS.
1028 * System.Data.SqlTypes/SqlNullValueException.cs:
1029 * System.Data.SqlTypes/SqlTruncateException.cs:
1030 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1032 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1034 * System.Data/DataViewSettingCollection.cs: implemented.
1036 * System.Data/DataRowView.cs: new stubs.
1038 * System.Data.SqlTypes/SqlByte.cs:
1039 * System.Data.SqlTypes/SqlDateTime.cs:
1040 * System.Data.SqlTypes/SqlDecimal.cs:
1041 * System.Data.SqlTypes/SqlDouble.cs:
1042 * System.Data.SqlTypes/SqlGuid.cs:
1043 * System.Data.SqlTypes/SqlInt16.cs:
1044 * System.Data.SqlTypes/SqlInt64.cs:
1045 * System.Data.SqlTypes/SqlMoney.cs:
1046 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1047 by Tim Coleman <tcoleman@opentext.com>
1049 * System.Data.build: excluded newly-added files.
1051 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1053 * System.Data.SqlClient/PostgresLibrary.cs: included new
1054 internal class that will be a helper class in using
1055 PostgreSQL. PostgresLibrary is used for the
1056 pinvoke methods to the PostgreSQL Client
1057 native C library libpq while the class PostgresHelper
1058 is used for wrapper or helper methods. It currently only
1059 has one static method OidTypeToSystem in converting
1060 PostgreSQL types to .NET System.<type>s, such as,
1061 a PostgreSQL int8 becomes a .NET System.Int64.
1062 Only a few types have been added, such as, int2,
1063 int4, int8, varchar, text, bool, and char. Other types
1066 * System.Data.SqlClient/SqlCommand.cs: implemented
1067 method ExecuteScalar which allows us to do aggregate
1068 functions, such as, count, avg, min, max, and sum. We
1069 also are able to retrieve the result, convert it to the .NET type
1070 as an object. The user of the returned object must explicitly cast.
1072 * Test/ReadPostgresData.cs: updated sample
1073 to help us learn to retrieve data in System.Data.SqlClient
1076 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1078 * System.Data.build: added /nowarn: nnnn arguments
1079 so you will not get a ton of warnings. The warnings
1080 being excluded are: 1595, 0067, 0109, 0169, and 0649
1082 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1084 * System.Data.build: modified to exclude more
1085 files from the build
1087 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1089 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1092 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1093 by John Dugaw <jdugaw@unizenconsulting.com>.
1095 * System.Data.build: excluded new files from build.
1097 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1099 * Test/ReadPostgresData.cs: added - Uses the
1100 PostgresLibrary to retrieve a recordset.
1101 This is not meant to be used in Production, but as a
1102 learning aid in coding
1103 class System.Data.SqlClient.SqlDataReader.
1104 This sample does work.
1106 * Test/TestSqlDataReader.cs: added - used
1107 to test SqlDataReader (does not work yet)
1108 Forgot to add to ChangeLog on last commit.
1110 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1112 * System.Data/DataViewSetting.cs: new class.
1114 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1116 * System.Data/DataViewManager.cs: new class.
1118 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1119 don't have implementation.
1121 * System.Data.SqlTypes/SqlInt32.cs:
1122 * System.Data.SqlTypes/SqlString.cs:
1123 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1124 these are strctures.
1126 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1129 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1131 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1132 for correctly hiding parent class' members.
1133 (AddRange): use 'override' keyword on overriden method.
1135 (Contains): likewise.
1136 (IndexOf): likewise.
1137 (OnCollectionChanged): likewise.
1138 (OnCollectionChanging): likewise.
1139 (RemoveCore): likewise.
1141 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1143 * System.Data/DataSet.cs: added missing 'using's.
1145 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1147 * System.Data/DataSet.cs:
1148 * System.Data/DataTableCollection.cs:
1149 * System.Data/DataView.cs: compilation fixes on Linux.
1151 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1153 * System.Data/DataRelation.cs
1154 * System.Data/ForeignKeyConstraint.cs
1155 * System.Data/UniqueConstraint.cs: added more stubs
1157 * System.Data/DataTableRelationCollection.cs: added back to cvs
1158 and modified for compile errors. DataRelationCollection is an
1159 abstract class and there must be a class that implements for
1160 DataTable/DataSet. DataTableRelationCollection was changed
1161 to an internal class.
1163 * System.Data.build: modified - new files added
1164 also wanted to include files/classes in the build
1165 so we can get a compilable forward read only result set.
1166 It compiles now using csc/nant with warnings, but this
1167 is a start for adding functionality for the result set.
1168 Classes associated with/and DataSet are still excluded.
1170 * TODO: modified - updated to do list for System.Data
1172 * System.Data/Constraint.cs
1173 * System.Data/ConstraintCollection.cs
1174 * System.Data/DataRelationCollection.cs
1175 * System.Data/DataRow.cs
1176 * System.Data/DataRowChangeEventArgs.cs
1177 * System.Data/DataRowCollection.cs
1178 * System.Data/DataTable.cs
1179 * System.Data/DataTableCollection.cs
1180 * System.Data/InternalDataCollectionBase.cs
1181 * System.Data/PropertyCollection.cs: modified -
1182 changes to compile SqlDataReader/DataTable and
1185 * System.Data/IDbCommand.cs
1186 * System.Data.SqlClient/SqlCommand.cs: modified -
1187 un-commented overloaded methods ExecuteReader
1188 which returns a SqlDataReader
1190 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1192 * System.Data/DataTableCollection.cs: more implementation.
1193 (Count): added 'override' keyword, as pointer out by Martin.
1195 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1196 only call Array.Copy when there is really stuff to be copied.
1197 (CopyTo): don't create the temporary array, it's not needed.
1199 * System.Data.build: excluded newly added file from build.
1201 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1203 * System.Data/DataTableRelationCollection.cs: removed, it's not
1204 on MS SDK documentation.
1206 * System.Data/DataTableCollection.cs: new class.
1208 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1210 * System.Data/DataRowChangeEventArgs.cs
1211 * System.Data/DataRowCollection.cs
1212 * System.Data/DataView.cs
1213 * System.Data/PropertyCollection.cs: added new stubs
1215 * System.Data.build: modified - added new files to exclude
1218 * TODO: modified - removed files from TODO list
1219 that were stubbed above
1221 * System.Data/DataColumn.cs
1222 * System.Data/DataRow.cs: modified - various tweaks
1223 and added internal method SetTable to set the reference
1226 * System.Data/DataSet.cs: modified - class was not
1229 * System.Data/DataTable.cs: modified - temporarily commented
1230 DataSet and DataView references - trying to compile a SqlDataReader,
1231 DataTable, and dependencies for a forward read-only result set.
1232 SqlDataAdapter, DataSet, and DataView will come later once we can get
1233 a forward read only result set working.
1235 * System.Data/IDataRecord.cs: modified - source code lines should
1238 * System.Data/InternalDataCollectionBase.cs: modified - started
1239 implementing this base class for collection of data rows,
1240 columns, tables, relations, and constraints
1242 * System.Data.SqlClient/SqlException.cs: modified -
1243 call base(message) so a unhandled exception displays
1244 the message of a SQL error instead of the
1245 default SystemException message
1247 * Test/TestSqlException.cs: modified -
1248 handle the rollback properly for a SqlException on a
1251 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1253 * System.Data.build: modified - added new
1254 files to exclude from build
1256 * System.Data/Constraint.cs
1257 * System.Data/ConstraintCollection.cs
1258 * System.Data/InternalDataCollectionBase.cs: added -
1259 stubs which are needed to build DataTable.cs
1261 * TODO: modified - added more classes TODO and
1262 added more stuff TODO, such as, create script
1263 to create test database monotestdb for testing
1264 classes in System.Data
1266 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1268 * System.Data.Common/DataAdapter.cs:
1269 * System.Data.Common/DataColumnMappingCollection.cs:
1270 * System.Data.Common/DataTableMappingCollection.cs:
1271 * System.Data.Common/DbDataPermission.cs:
1272 * System.Data.Common/DbDataPermissionAttribute.cs: some
1273 compilation errors fixed.
1275 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1277 * TODO: modified - added classes TODO, and
1278 a poor attempt at System.Data plan
1280 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1282 * ChangeLog: modified - put tabs where they belong
1284 * System.Data.SqlClient/SqlDataReader.cs
1285 * System.Data/DataColumn.cs: modified - compile errors
1286 trying to compile SqlDataAdapter and dependencies
1288 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1290 * System.Data.SqlTypes/SqlBoolean.cs
1291 * System.Data.SqlTypes/SqlCompareOptions.cs
1292 * System.Data.SqlTypes/SqlInt32.cs
1293 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1295 * System.Data/DataTable.cs
1296 * System.Data.SqlClient/SqlCommand.cs
1297 * System.Data.SqlClient/SqlConnection.cs
1298 * System.Data.SqlClient/SqlError.cs
1299 * System.Data.SqlClient/SqlTransaction.cs: modified -
1302 * System.Data.SqlClient/SqlException.cs: modified -
1303 missing Message on indexer for Message property
1305 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1307 * System.Data.SqlClient/SqlCommand.cs: modified - to
1308 compile using mcs. This problem is
1309 returning a stronger type in csc vs. msc
1311 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1312 can not do a using PGconn = IntPtr; and then declare
1313 with PGconn pgConn = IntPtr.Zero;
1314 Thiw works under csc though. Had to comment using and
1315 changed declaration to IntPtr pgConn = IntPtr.Zero;
1316 Also, got rid of compile warnings for hostaddr and port.
1318 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1319 rid of compile warnings. Commented MonoTODO attribute because mcs
1320 doesn't seem to work with C# array property indexer (Item)
1323 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1324 commented MonoTODO attribute for indexer for mcs compiling
1326 * Test/TestSqlIsolationLevel.cs:
1327 * Test/TestSqlInsert.cs:
1328 * Test/TestSqlException.cs: modified -
1329 removed extra ExecuteNonQuery which caused two inserted rows
1331 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1333 * System.Data/StateChangeEventArgs.cs - added
1334 needed to compile System.Data.dll with mcs.
1336 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1338 * System.Data.OleDb: added directory - for OleDb database
1341 * System.Data.SqlClient/SqlClientPermission.cs
1342 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1343 * System.Data.SqlClient/SqlCommandBuilder.cs
1344 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1345 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1346 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1347 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1348 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1349 * Test/TestSqlException.cs
1350 * Test/TestSqlIsolationLevel.cs: added - more tests
1352 * System.Data.build: modified - added new files - excludes these too
1354 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1356 * System.Data.SqlClient/SqlConnection.cs
1357 * System.Data.SqlClient/SqlCommand.cs
1358 * System.Data.SqlClient/SqlTransaction.cs
1359 * System.Data.SqlClient/SqlException.cs
1360 * System.Data.SqlClient/SqlErrorCollection.cs
1361 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1362 exception/error handling. SqlConnection(connectionString)
1363 constructor should not automatically connect.
1365 * System.Data.SqlClient/SqlDataReader.cs
1366 * System.Data.SqlClient/SqlDataAdapter.cs
1367 * System.Data.SqlClient/SqlParameter.cs
1368 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1369 added using System.ComponentModel;
1371 * Test/TestSqlInsert.cs: modified - to use transaction
1373 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1375 * System.Data/DataRow.cs: new skeletons.
1377 * System.Data.Common/DataAdapter.cs:
1378 * System.Data.Common/DataColumnMapping.cs:
1379 * System.Data.Common/DataColumnMappingCollection.cs:
1380 * System.Data.Common/DataTableMapping.cs:
1381 * System.Data.Common/DataTableMappingCollection.cs:
1382 * System.Data.Common/DbDataAdapter.cs:
1383 * System.Data.Common/RowUpdatedEventArgs.cs:
1384 * System.Data.SqlClient/SqlDataAdapter.cs:
1385 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1388 * System.Data.Common/DbDataRecord.cs:
1389 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1392 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1394 * Test/TestSqlInsert.cs: modified - do
1395 a SQL DELETE before SQL INSERT of row so you can use this
1398 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1399 IsolationLevel for PostgreSQL is ReadCommitted. However,
1400 PostgreSQL allows Serializable as well.
1401 (Thanks to Gonzalo for that!)
1403 * System.Data.SqlClient/SqlConnection.cs: modified
1404 * System.Data.SqlClient/SqlCommand.cs: modified
1405 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1406 working; however, we still need to implement SQL errors
1407 and exceptions to properly handle transactions. Also, added
1408 status and error message support from the PostgreSQL database.
1409 Currently, this does a Console.WriteLine() to display the
1410 status and error messages, but this is a TODO
1411 for SQL errors and exceptions.
1413 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1414 attribute for System.Data.dll assembly
1416 * System.Data/IDbCommand.cs: modified - commented
1417 overloaded method ExecuteReader
1418 so System.Data.SqlClient.SqlCommand can compile
1420 * System.Data/IDbCommand.cs: modified
1421 * System.Data/IDbConnection.cs: modified - added using System;
1422 * System.Data/IDataParameter.cs
1424 * System.Data.build: modified - build classes
1425 in System.Data.SqlClient and exclude others in System.Data
1427 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1428 parameter data type from IntPtr to enum ExecStatusType
1430 * ChangeLog: modified - corrected previous entries in log
1432 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1434 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1435 implementation. Still missing some stuff.
1437 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1439 * System.Data.SqlClient/SqlConnection.cs: modified - got
1440 to compile, run, and connect to PostgreSQL database
1442 * System.Data.SqlClient/SqlCommand.cs: modified - got
1443 to compile, run, and execute a SQL INSERT command
1444 which successfully inserted a row
1445 into the PostgreSQL database
1447 * System.Data.SqlClient/SqlTransaction.cs: modified
1448 * System.Data.SqlClient/SqlParameter.cs: modified
1449 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1450 * System.Data.SqlClient/SqlError.cs: modified
1451 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1452 * System.Data.SqlClient/SqlException.cs: modified
1453 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1455 * System.Data.SqlClient/SqlAdapter: modified
1456 * System.Data.SqlClient/SqlReader: modified - add more stubs
1458 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1460 * Test/TestSqlInsert.cs: added
1462 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1464 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1465 class SqlConnecition
1466 * System.Data.SqlClient/SqlErrorCollection.cs: added
1467 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1469 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1471 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1472 * System.Data.IDbTransaction: Added Interface to IDisposable.
1473 * System.Data.IDbCommand: Fixed Capitalization of class name.
1474 * System.Data.IDbConnection: Fixed Capitalization of class name.
1476 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1478 * System.Data.Common/DbDataPermissionAttribute.cs:
1479 * System.Data.Common/DataAdapter.cs:
1480 * System.Data.Common/DataColumnMapping.cs:
1481 * System.Data.Common/DbDataPermission.cs: added some implementation.
1483 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1485 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1486 syntax, as pointed out by Levent Camlibel.
1488 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1490 * System.Data.SqlTypes/SqlBinary.cs:
1491 * System.Data.SqlTypes/INullable.cs: new skeletons.
1493 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1495 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1496 contains all calls the the PostgreSQL client library, to be used
1497 everywhere in System.Data.SqlClient.
1499 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1501 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1504 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1506 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1508 * System.Data.Common/DbDataRecord.cs:
1509 * System.Data.Common/DbEnumerator.cs:
1510 * System.Data.Common/RowUpdatedEventArgs.cs:
1511 * System.Data.Common/RowUpdatingEventArgs.cs:
1512 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1514 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1516 * System.Data.Common/DataTableMappingCollection.cs:
1517 * System.Data.Common/DbDataAdapter.cs:
1518 * System.Data.Common/DbDataPermission.cs:
1519 * System.Data.Common/DataTableMapping.cs: new skeletons.
1521 * System.Data.SqlClient/SqlDataAdapter.cs:
1522 * System.Data.SqlClient/SqlDataReader.cs:
1523 * System.Data.SqlClient/SqlErrors.cs:
1524 * System.Data.SqlClient/SqlError.cs:
1525 * System.Data.SqlClient/SqlException.cs:
1526 * System.Data.SqlClient/SqlParameter.cs:
1527 * System.Data.SqlClient/SqlParameterCollection.cs:
1528 * System.Data.SqlClient/SqlTransaction.cs:
1529 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1531 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1533 * System.Data.Common/DataColumnMapping.cs:
1534 * System.Data.Common/DataColumnMappingCollection.cs:
1535 * System.Data.Common/DataAdapter.cs: created skeletons.
1537 * System.Data.build: exclude new directories from build.
1539 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1541 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1543 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1544 implemented (2 methods).
1546 2002-03-24 Duncan Mak <duncan@ximian.com>
1548 * System.Data.build: Excluded System.Data.SqlClient from the build.
1549 The stubs are incomplete and they are stopping the build.
1551 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1553 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1555 * System.Data.SqlClient/*: added skeletons for the SQL managed
1556 provider for ADO.Net, to be based initially in PostgreSQL.
1558 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1560 Changed the Namespace on some Enums from mono.System.Data to System.Data
1562 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1564 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1565 default name if the ColumnName is null.
1566 * DataSet.cs : Added
1567 * DataTable.cs : Added
1568 * DataRelationCollection.cs : Added
1569 * DataTableRelationCollection.cs : Added
1570 * DataColumn : Added
1572 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1574 * DataColumnChangeEventArgs.cs : Added
1575 * DataColumnCollection.cs : Added
1577 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1579 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1580 * Updated all Enums, Interfaces, and Delegates in System.Data