1 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
3 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
5 (Close): set the dataReader to null.
7 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
8 connection's DataReader property to this object.
9 (Close): set it to null here.
10 (Depth, IsDbNull): implemented.
11 (this): implemented the Item property with a string indexer.
13 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
14 ExecuteScalar): do nothing if there's already an open data reader.
16 * System.Data.OleDb/libgda.cs: more API functions.
18 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
19 reader before continuing.
21 2002-08-20 Franklin Wise <gracenote@earthlink.net>
23 * System.Data/System.Data.build: added nowarn:0679
25 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
26 setup to begin implementing. Implemented ctor().
28 * Tests: See System.Data\Test\ChangeLog
31 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
33 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
35 2002-08-19 Franklin Wise <gracenote@earthlink.net>
37 * Tests: See System.Data\Test\ChangeLog
39 * System.Data/UniqueConstraint.cs: More validation.
41 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
42 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
45 * System.Data/DataTable.cs: Added more MonoTODO tags
47 * class/System.Data/.cvsignore: added tmp & Temp
49 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
52 * System.Data/ConstraintCollection.cs: Commented out unused line.
54 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
56 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
58 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
60 (ErrorCode, Message, Source, Errors): implemented.
62 * System.Data.OleDb/OleDbError.cs: implemented the full class.
64 * System.Data.OleDb/libgda.cs: added more libgda functions.
66 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
67 the opened connection.
69 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
71 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
73 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
74 ArrayList after releasing the items.
75 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
76 GetOrdinal, GetString): implemented.
77 (GetDataTypeName): made it get the type from the data model, not from
78 the current value, which could not have been retrieved yet.
79 (GetValue): call the Get* method corresponding with the data type of
82 * System.Data.OleDb/libgda.cs: added more libgda functions.
83 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
85 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
86 titles via OleDbDataReader.GetName ().
87 (TestOleDb): create temporary table with a date field.
88 (InsertRow): set current date for the date field.
90 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
92 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
93 GetValue, which will take care of all the work needed.
94 (Close): implemented basic stuff.
95 (~OleDbDataReader): implemented.
97 * System.Data.OleDb/libgda.cs: added more needed functions.
99 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
101 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
103 (TestTransaction): added test for transactions.
105 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
107 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
109 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
110 when there are errors.
111 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
113 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
116 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
118 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
120 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
121 create an empty GdaParameterList.
123 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
124 for NULL before passing them to Marshal.PtrToStructure, which issues
125 an exception if the value is NULL.
127 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
129 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
130 unreachable code to avoid compiler warning.
132 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
134 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
135 (OpenReader): removed internal method.
137 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
138 the list of returned data models.
140 2002-08-15 Franklin Wise <gracenote@earthlink.net>
142 * System.Data/Constraint.cs: Added helper virtual functions
144 * System.Data/ConstraintCollection.cs: Improved constraint removal,
145 validation. Removed specific knowledge of subclasses of
148 * System.Data/DataColumn.cs: Added static helper function to compare
149 if two DataColumn arrays are the same.
151 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
153 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
156 2002-08-13 Franklin Wise <gracenote@earthlink.net>
158 * System.Data/DataRow.cs: Added several fixme tags.
160 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
162 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
163 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
164 to avoid compiler warnings.
166 2002-08-12 Franklin Wise <gracenote@earthlink.net>
168 * System.Data/Constraint.cs: Implemented
170 * System.Data/UniqueConstraint.cs: GetHashCode() &
171 special case Ctor. Still need to be implemented. LAMESPEC tags
174 * System.Data/ConstraintCollection.cs: Clear() &
175 AddRange() need to be finished. Several LAMESPEC tags.
177 * Allow Constraint collection to be created in DataTable.
179 * System.Data/ForeignKeyConstraint: Added a couple of
182 * System.Data/DataColumnCollection New/Added DataColumns now have
185 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
187 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
189 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
190 internal method, since we don't need it.
191 (ExecuteReader): call SetupGdaCommand before executing the command
192 via libgda functions.
193 (ExecuteScalar): implemented.
195 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
196 to OleDbCommand.OpenReader.
197 (GetBoolean): implemented.
199 2002-08-08 Franklin Wise <gracenote@earthlink.net>
201 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
203 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
205 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
208 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
210 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
211 and don't show a warning in Open.
213 * System.Data.OleDb/TestOleDb.cs: added Close.
215 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
217 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
218 ConnectionTimeout, ServerVersion, GdaConnection):
220 (OleDbConnection): call libgda.gda_init on constructor.
222 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
223 which wasn't been called.
225 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
228 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
230 * list: added missing System.Data.OleDb and
231 System.Data.Common files.
233 * System.Data.OleDb/ChangeLog: removed and merged with
234 System.Data's ChangeLog.
236 * System.Data.OleDb/OleDbDataAdapter.cs:
237 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
239 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
241 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
242 (IsClosed, Item, RecordsAffected): implemented some properties.
244 * libgda.cs: added GdaDataModel methods.
246 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
248 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
249 a second argument (ArrayList results).
250 (NextResult): implemented.
252 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
253 pass that to the OleDbDataReader.
254 (OleDbCommand constructor): don't create the ArrayList of results.
255 (GdaResults): removed property.
256 (ExecuteReader): create a temporary ArrayList and pass that to the
257 OleDbDataReader constructor.
259 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
261 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
262 (CreateParameter): implemented IDbCommand methods.
263 (CommandText): don't create many GdaCommand's, only one is needed.
264 (ExecuteNonQuery): set up the internal GDA command object.
265 (ExecuteReader): use correctly the unique GDA command object.
267 * System.Data.OleDb/libgda.cs: added new libgda calls.
269 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
271 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
272 (BeginTransaction): implemented IDbConnection methods.
274 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
276 * list: added System.Data.OleDb files to file list.
278 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
280 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
282 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
283 of the set method for this property.
285 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
286 (MissingSchemaAction): implemented.
288 2002-07-10 Tim Coleman <tim@timcoleman.com>
290 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
291 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
292 * System.Data.OleDb/OleDbError.cs: Added stubbs
293 * System.Data.OleDb/OleDbException.cs: Added stubbs
294 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
295 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
296 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
297 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
298 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
299 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
300 support transaction nesting
301 * System.Data.OleDb/libgda.cs: Added my name to this file
303 2002-07-09 Tim Coleman <tim@timcoleman.com>
305 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
306 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
307 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
308 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
309 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
310 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
311 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
312 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
313 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
314 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
315 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
316 * System.Data.OleDb/OleDbType.cs: Fixed two typos
317 * System.Data.OleDb/libgda.cs: Style changes, added new methods
319 2002-07-09 Tim Coleman <tim@timcoleman.com>
321 * System.Data.build: remove restriction on System.Data.OleDb build
323 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
325 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
326 IsSynchronized): implemented.
328 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
330 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
332 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
333 (Parameters, Transaction, Connection): made these overload
336 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
337 call m_list methods, not own ones.
339 * System.Data.OleDb/OleDbParameter.cs: more implementation.
341 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
343 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
344 Commit, Rollback): implemented.
345 (GdaConnection): added new internal property.
347 * System.Data.OleDb/OleDbParameter.cs:
348 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
351 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
353 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
355 * System.Data.OleDb/libgda.cs: added new libgda API functions.
357 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
358 (BeginTransaction): made it overload IDbConnection methods.
359 (ChangeDatabase): new stub, needs some work on libgda for being
362 (Close): implemented.
363 (CreateCommand): implemented.
364 (GetOleDbSchemaTable): new stub, until I understand what to do here.
365 (Open): implemented basic stuff, which is just supporting connection
366 strings that represent a GDA data source name. More to come.
367 (InfoMessage, StateChange): added events.
369 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
371 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
373 * System.Data.OleDb/libgda.cs: added static constructor.
374 (GdaClient): new static property to get the underlying GdaClient
377 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
378 the static 'libgda' class.
380 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
382 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
384 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
385 (ConnectionString, Connectiontimeout, Database, State):
386 implemented class properties.
387 (BeginTransaction): implemented.
389 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
391 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
393 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
395 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
397 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
399 * list: added missing PostgresTypes.cs file.
401 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
403 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
406 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
408 * System.Data.SqlClient/SqlConnection.cs: modifed -
409 start to implement the interfaces properly and
410 properly doing a Close(), Dispose(), and
413 * Test/SqlSharpCli.cs: modified -
414 add support for MySQL in Mono.Data.MySql
415 and OleDb support in System.Data.OleDb. However,
416 the OleDb support is commented right now.
417 When the program starts up, a shorter help menu should
418 display the most important commands: help and quit
420 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
422 * System.Data.build: exclude System.Data.OleDb files.
424 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
426 * System.Data.SqlClient/SqlCommand.cs: typo
427 should be CommandBehavior.KeyInfo
429 * Test/SqlSharpCli.cs: refactored and added a few more
432 2002-05-27 Tim Coleman <tim@timcoleman.com>
433 * list: update to compile properly (add missing
434 files and switch path delimiter from '\' to '/').
436 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
438 * System.Data/DataRow.cs
439 * System.Data.Common/DbDataAdapter.cs: fix to
440 get Test/TestSqlDataAdapter.cs to work again
442 * Test/TestSqlDataAdapter.cs: removed comment
443 about SqlDataReader:NextResult() not being implemented; it
446 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
448 * System.Data/DataRow.cs: modified
449 support setting of DBNull.Value
450 using the Item indexer this[DataColumn]
452 * System.Data.SqlClient/SqlCommand.cs: modified
453 tweaks to show TODO's for other CommandBehavior.
454 Set AllowDBNull column to true for IsKey row
457 * System.Data.SqlClient/SqlConnection.cs: modified
458 if transaction is in progress when a Close() is called,
459 do a transaction Rollback.
461 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
463 * Test/SqlSharpCli.cs: added file
464 My new toy. SQL# is a command-line tool to enter
465 SQL commands and queries using Mono System.Data.
466 It also serves as a test for Mono System.Data.
468 * System.Data.SqlClient/SqlCommand.cs: modified
469 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
470 should handle the results from SQL Commands and Queries.
471 - Internal class SqlResult should not create schema Table
472 for the result from a SQL Command. Also, set the RecordsRetrieved
473 property for SqlDataReader.
474 - Closing the SqlDataReader should Close() the SqlConnection for
475 a CommandBehavior.CloseConnection.
476 - Set defaults for SqlResult
478 * System.Data.SqlClient/SqlConnection.cs: modified -
479 when SqlDataReader is Close()
480 should Close() the SqlConnection for
481 a CommandBehavior.CloseConnection. Changed internal Property
482 from OpenReader get/set to IsReaderOpen get and created
483 internal methods OpenReader()/CloseReader() for SqlCommand to call.
484 SqlConnection needs to be prevented from doing while SqlDataReader
487 * System.Data.SqlClient/SqlDataReader.cs: modified -
488 call SqlCommand's OpenReader() internal method. get
489 RecordsRetrieved from SqlResult. set/reset default
490 values for SqlDataReader.
492 * Test/PostgresTest.cs
493 * Test/TestExecuteScalar.cs
494 * Test/TestSqlDataReader.cs: modified
495 for the Execute...() methods in SqlCommand
496 to test SQL Queries and Commands
498 * Test/System.Data_test.build: modified
499 exclude new file Test/SqlSharpCli.cs from
502 2002-05-24 Tim Coleman <tim@timcoleman.com>
503 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
504 for get accessors. These should be implemented in derived classes. See
505 SqlDataAdapter for clues.
506 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
507 * System.Data.Common/DataAdapter.cs:
508 * System.Data.Common/DataTableMappingCollection.cs:
509 * System.Data.Common/DataTableMapping.cs:
510 * System.Data.Common/DataColumnMappingCollection.cs:
511 * System.Data.Common/DataColumnMapping.cs:
512 Properly (I hope!) implement all of the appropriate interfaces
516 2002-05-23 Tim Coleman <tim@timcoleman.com>
517 * System.Data.SqlClient/SqlCommand.cs: include
518 the BaseColumnName in the schema table. Was missed before.
519 * System.Data.Common/DbDataAdapter.cs: Use DataTable
520 mappings so that the DataSet and DataTable are more closely tied.
521 Get schema information from the DataTable using GetSchemaTable ()
522 Various other little fixes
523 * System.Data.Common/DataColumnMappingCollection.cs:
524 * System.Data.Common/DataTableMapping.cs:
525 * System.Data.Common/DataTableMappingCollection.cs: Some
526 implementation, enough to be used by DbDataAdapter.
528 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
530 * System.Data.SqlClient/SqlCommand.cs: set
531 the "ProviderType" to the PostgreSQL type oid
533 * System.Data.SqlClient/SqlDataReader.cs: fix
534 for various properties and methods that
535 return meta data: Item indexers this[name] and this[index],
536 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
539 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
541 * System.Data/DataRow.cs: change suggested
542 by tim: in Item indexer, do an EndEdit()
544 * System.Data.SqlClient/SqlCommand.cs: more
545 fixes to SqlResult. After setting each item in
546 the DataRow, do an AcceptChanges() to commit
547 the changes in the DataRow. For DataType, use a Type
548 of System.String since System.Type nor System.Object
551 * Test/TestSqlDataReader.cs
552 * Test/PostgresTest.cs: updated to to be on
553 the way schema table is suppose to work
555 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
557 * System.Data.SqlClient/SqlCommand.cs: more work on
558 building the schema table
560 2002-05-22 Tim Coleman <tim@timcoleman.com>
561 * System.Data.SqlClient/SqlCommand.cs: preliminary work
562 on getting the schema table correctly built.
564 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
566 * System.Data.SqlClient/ParmUtil.cs: added file - to
567 provide utility for conversion of input parameters
569 * System.Data.SqlClient/PostgresTypes.cs: added file -
570 moved the PostgreHelper class to here. May eventually
571 move the internal class PostgresTypes that's inside the
572 SqlConnection to here as well.
573 Handling of PostgreSQL <-> .NET types need to be though
574 out more. Also, the PostgreHelper has a method to convert
575 from .NET types to a string which can be put into used in
576 an SQL statement to execute against a PostgreSQL database.
577 This is the beginnings of parameters support. It currently
578 only supports input parameters. Still need to do output,
579 input/output, and return parameters.
581 * Test/TestSqlParameters.cs: new test to test the input
582 parameters in System.Data.SqlClient against a
585 * System.Data.SqlClient/PostgresLibrary.cs: moved
586 PostgresHelper class to file PostgresTypes.cs. Also
587 moved struct PostgresType there too.
589 * System.Data.SqlClient/SqlCommand.cs: added input
592 * System.Data.SqlClient/SqlParameter.cs: got
595 * System.Data.SqlClient/SqlParameterCollection.cs: got
596 SqlParameterCollection to work
598 * Test/System.Data_test.build: added files to exclude
601 * System.Data.SqlClient/SqlConnection.cs: release resources
604 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
606 * System.Xml: added directory for classes with namespace
607 System.Xml to go into the System.Data.dll assembly
609 * System.Xml/XmlDataDocument: added file
610 for stubbed concrete class XmlDataDocument which
611 inherits from XmlDocument. Its purpose is to provide
612 a W3C XML DOM Document for relational data and interacting
615 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
617 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
618 Text, TableDirect, and StoredProcedure
620 * Test/PostgresTest.cs: changed call to version()
621 stored procedure to use the CommandType of StoredProcedure
623 * Test/TestSqlDataReader.cs: test all the CommandTypes
625 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
627 * System.Data.build: took out all excluded
628 files except the ones in the Test directory
629 because all files compile now. It does not
630 mean they all work or have implementations
633 * System.Data/DataRelationCollection.cs
634 * System.Data/DataTableRelationCollection.cs
635 * System.Data/InternalDataCollectionBase.cs
636 * System.Data.Common/DbDataPermission.cs
637 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
638 * System.Data.SqlClient/SqlClientPermission.cs
639 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
640 to get all System.Data* files to compile.
642 * System.Data.SqlClient/SqlCommand.cs: started coding
643 to prevent SqlConnection and SqlCommand from doing
644 anyting while fetching data using SqlDataReader. Also,
645 started coding to undo this prevention once the
646 SqlDataReader is closed.
648 * System.Data.SqlClient/SqlConnection.cs: get database server
649 version. Started coding to prevent connection from
650 doing anything while fetching data and undo once the reader
651 is closed. Include events SqlInfoMessage and StateChange.
653 * System.Data.SqlClient/SqlDataReader.cs: start coding to
654 prevent connection and command from doing anything while
655 fetching data, and undo when closed.
657 * Test/PostgresTest.cs: added test to get ServerVersion
658 property from SqlConnection
660 2002-05-18 Tim Coleman <tim@timcoleman.com>
661 * System.Data/DataRow.cs: More implementation,
662 as well as boundary checks and small semantic
665 2002-05-18 Tim Coleman <tim@timcoleman.com>
666 * System.Data/DataRow.cs: Try to reduce memory
667 usage by only creating the original and proposed
668 arrays as required in BeginEdit, and then destroying
669 proposed during EndEdit, and original during AcceptChanges.
670 * System.Data.Common/DbDataAdapter.cs: Make the
671 startRecord and maxRecords parameters work correctly.
673 2002-05-18 Tim Coleman <tim@timcoleman.com>
674 * System.Data/DataRow.cs: Move the null check in
675 ItemArray set to above the Invalid Cast check, so
676 that we don't get null reference exceptions.
678 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
680 * System.Data.SqlClient/PostgresLibrary.cs: handle
681 data value from database being NULL
683 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
684 allow multiple result sets. Added new internal class
685 SqlResult to pass result set data from SqlCommand
688 * System.Data.SqlClient/SqlDataReader.cs: allow
689 multiple result sets.
691 * System.Data.SqlClient/SqlConnection.cs: moved
692 things around. Implement IDisposable.
694 * Test/TestSqlDataReader.cs: test for execution
695 of multiple result sets and display the results
696 of these multiple results sets
698 * Test/TestSqlDataAdapter.cs: tweaks
700 2002-05-17 Tim Coleman <tim@timcoleman.com>
701 * System.Data.Common/DbDataAdapter.cs:
702 - More implementation of Fill methods
703 - Get rid of isDirty flag, because we can just check
705 - Do *not* remove DataTables before Filling them
706 - Implicitly open the connection before doing a Fill
707 if it does not exist.
708 * System.Data.SqlClient/SqlDataAdapter.cs:
710 * System.Data/DataTableCollection.cs:
711 - Add DataSet to internal, undocumented constructor
712 - When a table is created, set its DataSet property
713 - Default table name for creation is "Table1" (see .NET)
714 - Inherit the ArrayList list from InternalDataCollecitonBase
715 and maintain a hashtable between table names and
717 * System.Data/DataTable.cs:
718 - Add internal dataSet field. This is used by
719 DataTableCollection when the DataTable is constructed.
720 * System.Data/DataSet.cs:
721 - Pass a reference to the DataSet when constructing the
724 2002-05-16 Tim Coleman <tim@timcoleman.com>
725 * System.Data.Common/DbDataAdapter.cs:
726 Use table.Rows.Add (itemArray) instead of
727 table.Rows.Add (thisRow) to provide better
729 * System.Data/DataRowCollection.cs:
730 Some implementation of this class.
731 * System.Data/InternalDataCollectionBase.cs:
732 Some implementation. Most notably, this now
733 has an enumerator so we can use foreach (DataRow row in table.Rows)
735 * System.Data/DataTable.cs:
736 Since DataRowCollection now accepts a DataTable in
737 its internal constructor, we must pass one in.
739 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
741 * Test/TestSqlDataAdapter.cs: added new test
742 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
743 DataRowCollection, and DataRow. It tests retrieving data
744 based on a SQL SELECT query. This test is based on Tim Coleman's
747 2002-05-16 Tim Coleman <tim@timcoleman.com>
748 * System.Data.Common/DbDataAdapter.cs:
749 Use table.Rows.Add (thisRow) instead of
750 table.ImportRow (thisRow)
751 * System.Data/DataRowCollection.cs:
752 Construct the ArrayList before using it
754 2002-05-16 Tim Coleman <tim@timcoleman.com>
755 * System.Data/DataTable.cs:
756 Construct the DataRowCollection in the DataTable
757 constructor. Otherwise, it's a null reference.
759 2002-05-16 Tim Coleman <tim@timcoleman.com>
760 * System.Data.SqlClient/SqlDataReader.cs:
761 Modify GetValues to use Array.Copy() to copy
762 the results from fields to values, rather than
763 an assignment, which results in loss of data.
765 2002-05-16 Tim Coleman <tim@timcoleman.com>
766 * System.Data/DataRow.cs:
767 More implementation and documentation. It should
768 work more like expected, although there is no way
769 to demonstrate this well yet. DataTable requires
772 2002-05-15 Tim Coleman <tim@timcoleman.com>
773 * System.Data/DataRow.cs:
774 Minor tweaks as I determine exactly how to
775 implement this class.
778 2002-05-14 Duncan Mak <duncan@ximian.com>
780 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
782 2002-05-14 Tim Coleman
783 * System.Data/DataRow.cs:
784 * System.Data/DataRowBuilder.cs:
785 * System.Data/DataTable.cs:
786 More implementation of these classes. DataRow
787 can now (possibly) do some useful things.
788 Still not sure what DataRowBuilder is all about,
789 other than passing a DataTable in.
791 2002-05-14 Tim Coleman
792 * System.Data/DataRowBuilder.cs:
793 Add stubb for this internal class.
795 2002-05-13 Tim Coleman
796 * System.Data.Common/DbDataAdapter.cs:
797 The maxRecords check was not correct.
799 2002-05-13 Tim Coleman
800 * System.Data/DataTableCollection.cs:
801 Fix an issue when adding a DataTable and size == 0.
802 Now explicitly checks if size > 0 before doing Array.Copy ()
803 * System.Data.Common/DbDataAdapter.cs:
804 Move closer to a working implementation.
805 Make the IDbCommand fields protected so that they can
807 * System.Data.SqlClient/SqlDataAdapter.cs:
808 This should inherit the IDbCommands instead of having its
809 own. An explicit cast is used to force conversion between
810 IDbCommand and SqlCommand
812 2002-05-13 Tim Coleman
813 * System.Data.Common/DataTableMappingCollection.cs:
814 Some implementation to allow progress with DbDataAdapter
816 2002-05-13 Tim Coleman
817 * System.Data.Common/DbDataAdapter.cs:
818 Modify to not break compile.
820 2002-05-13 Tim Coleman
822 include SqlDataAdapter, SqlRowUpdatedEventArgs,
823 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
824 SqlRowUpdatingEventHandler in the build.
826 2002-05-13 Tim Coleman
827 * System.Data.Common/DbDataAdapter.cs:
829 * System.Data.Common/DataAdapter.cs:
830 Correction of some of the stubbing, as well as a
831 little bit more implementation
833 2002-05-11 Tim Coleman
834 * System.Data.SqlClient/SqlDataAdapter.cs:
835 * System.Data.Common/DbDataAdapter.cs:
836 Moved methods that weren't supposed to
837 be in SqlDataAdapter out. They should be implemented
841 2002-05-11 Tim Coleman
842 * System.Data.SqlClient/SqlDataAdapter.cs:
843 some implementation of this class. Note
844 that none of the functionality has been
845 tested yet, but I felt it should be checked
846 in at this point as it compiles.
847 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
848 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
849 Modified so that they will compile properly.
850 Needed to include SqlDataAdapter in the build.
852 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
854 * System.Data/DataTable.cs (Clear): implemented.
855 (DataTable): removed repeated code in constructors, and call the
856 basic constructor from the others.
858 * System.Data/DataColumn.cs: some tweaks.
860 * System.Data/DataRow.cs (RowState): implemented.
861 (CancelEdit): set rowState property back to Unchanged.
862 (RejectChanges): call CancelEdit.
863 (Delete): set rowState to Deleted.
865 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
867 * System.Data.build: added copy of System.Data.dll to Test directory
868 for easy testing. Also, added clean for it too.
870 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
871 from PostgreSQL data type to .NET type.
873 * System.Data.SqlClient/SqlDataReader.cs: beginnings
874 handling of a NULL value from the database
876 * Test/PostgresTest.cs: added tests for NULL values retrieved
879 * Test/ReadPostgresData.cs
880 * Test/TestExecuteScalar.cs
881 * Test/TestSqlDataReader.cs
882 * Test/TestSqlException.cs
883 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
884 "postgres". These tests may eventually be removed since they
887 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
889 * System.Data.build: removed reference to non-existant
890 TestDataColumn.cs file.
892 * System.Data/DataSet.cs: added some implementation.
894 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
896 * System.Data.SqlClient/PostgresLibrary.cs: got
897 PostgreSQL data types time, date, timestamp (DateTime like)
898 mapped to .NET System.DateTime working based
899 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
900 Also mapped pg type boolean to .net Boolean
902 * SqlClient/SqlConnection.cs: run SQL command to set
905 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
906 added tests for aggregates min(), max(), sum(), count(). could
907 not get avg() to work due to some formatting error; someone claimed
908 that it was my locale settings. added tests for SELECT of columns
909 of type boolean, float, double, date, time, and timestamp. They
910 have not been fully tested, but its a start.
912 2002-05-09 Tim Coleman <tim@timcoleman.com>
913 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
914 addition, subtraction, and multiplication for the
915 SqlDecimal type, as well as modification of some other
916 operations. More to come on this one.
918 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
920 * Test/System.Data_test.build: excluded TestDataColumn, which
921 should be replaced with a nunit test.
923 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
925 2002-05-07 Tim Coleman <tim@timcoleman.com>
939 Fix the broken build I made before. Bad
942 2002-05-07 Tim Coleman <tim@timcoleman.com>
944 Fix a symantic error I made in SqlString
945 Equals where I copied and pasted wrongly
947 2002-05-07 Tim Coleman <tim@timcoleman.com>
952 * SqlCompareOptions.cs:
963 Implement CompareTo, Equals, and String conversions
966 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
968 * Test/PostgresTest.cs: modified to run completely. There
969 are many TODOs in System.Data, so not all data types are
970 included in the SELECT SQL query. Also, I made it to where
972 using "host=localhost;dbname=test;user=postgres"
973 instead of my userid and password. When more types are included,
976 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
978 * Test/PostgresTest.cs: added - ported
979 libgda postgres-test.c originally by
980 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
983 2002-05-05 Tim Coleman <tim@timcoleman.com>
984 * System.Data.SqlTypes/SqlBinary.cs:
985 * System.Data.SqlTypes/SqlBoolean.cs:
986 * System.Data.SqlTypes/SqlByte.cs:
987 * System.Data.SqlTypes/SqlDateTime.cs:
988 * System.Data.SqlTypes/SqlDecimal.cs:
989 * System.Data.SqlTypes/SqlDouble.cs:
990 * System.Data.SqlTypes/SqlGuid.cs:
991 * System.Data.SqlTypes/SqlInt16.cs:
992 * System.Data.SqlTypes/SqlInt32.cs:
993 * System.Data.SqlTypes/SqlInt64.cs:
994 * System.Data.SqlTypes/SqlMoney.cs:
995 * System.Data.SqlTypes/SqlSingle.cs:
996 * System.Data.SqlTypes/SqlString.cs:
997 More implementation, and code clean-up for consistency.
998 Also, I had implemented many conversions as explicit
999 that should have been implicit. This should remove
1000 many of the red X's and green pluses from the
1001 System.Data.SqlTypes namespace.
1003 2002-05-05 Miguel de Icaza <miguel@ximian.com>
1005 * System.Data/DataSet.cs: Remove [Serializable] attributes from
1006 methods, those only apply to structs or classes.
1008 Stub out ISerializable, ISupportInitialize, and IListSource methods
1010 * System.Data/DataRowView.cs: Stub out interface methods for
1011 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
1013 * System.Data/DataView.cs: Comment out non-implemented
1016 * System.Data/DataViewSettingsCollection.cs: Type cast variables
1017 to the correct type to make it compile.
1019 * System.Data/DataViewSettings.cs: remove reference to
1020 non-existance type ApplyDefaultSort, it is a boolean.
1023 2002-05-05 Tim Coleman <tim@timcoleman.com>
1024 * System.Data.SqlTypes/SqlBinary.cs:
1025 * System.Data.SqlTypes/SqlBoolean.cs:
1026 * System.Data.SqlTypes/SqlByte.cs:
1027 * System.Data.SqlTypes/SqlDecimal.cs:
1028 * System.Data.SqlTypes/SqlDouble.cs:
1029 * System.Data.SqlTypes/SqlGuid.cs:
1030 * System.Data.SqlTypes/SqlInt16.cs:
1031 * System.Data.SqlTypes/SqlInt32.cs:
1032 * System.Data.SqlTypes/SqlInt64.cs:
1033 * System.Data.SqlTypes/SqlMoney.cs:
1034 * System.Data.SqlTypes/SqlSingle.cs:
1035 * System.Data.SqlTypes/SqlString.cs:
1036 Various fixes, including adding the SqlNullValueException
1037 when trying to retrieve the value of a null SqlType,
1038 and when casting values, a Null of type A converts to a
1041 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1043 * System.Data.SqlClient/PostgresLibrary.cs
1044 * System.Data.SqlClient/SqlCommand.cs
1045 * System.Data.SqlClient/SqlConnection.cs
1046 * System.Data.SqlClient/SqlDataReader.cs
1047 oid should not be hard coded because they
1048 can change from one version of PostgreSQL
1049 to the next. Use the typname's instead.
1050 The PostgreSQL type data retrieves
1051 at database connection time. Any unimplemented
1052 types just default to string. These were things
1053 suggested by Gonzalo.
1055 * Test/ReadPostgresData.cs - stuff
1056 * Test/TestSqlDataReader.cs - stuff
1058 * System.Data.SqlTypes/SqlInt32.cs - added a using
1060 2002-05-03 Tim Coleman <tim@timcoleman.com>
1061 * System.Data.build: Fix the build so that test depends on build
1063 2002-05-03 Tim Coleman <tim@timcoleman.com>
1064 * System.Data.SqlTypes/SqlByte.cs:
1065 * System.Data.SqlTypes/SqlDateTime.cs:
1066 * System.Data.SqlTypes/SqlDecimal.cs:
1067 * System.Data.SqlTypes/SqlDouble.cs:
1068 * System.Data.SqlTypes/SqlGuid.cs:
1069 * System.Data.SqlTypes/SqlInt16.cs:
1070 * System.Data.SqlTypes/SqlInt64.cs:
1071 * System.Data.SqlTypes/SqlMoney.cs:
1072 * System.Data.SqlTypes/SqlSingle.cs:
1073 These files were mysteriously excluded from the last
1074 patch I made and sent to Rodrigo
1075 * System.Data.build: include the System.Data.SqlTypes in the build
1077 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1079 * System.Data.build: removed comments
1081 * System.Data.SqlClient/PostgresLibrary.cs: changed
1082 the hard-coded PostgreSQL oid type int's to using an
1083 enum. Also, added PostgreSQL bpchar (character) type.
1085 * Test/TestSqlDataReader.cs: updated test
1086 to include new bpchar PostgreSQL type
1088 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1090 * System.Data.SqlTypes/SqlBinary.cs:
1091 * System.Data.SqlTypes/SqlBoolean.cs:
1092 * System.Data.SqlTypes/SqlInt32.cs:
1093 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1094 Tim Coleman <tcoleman@opentext.com>.
1096 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1098 * Test/TestExecuteScalar.cs: added test for
1099 method ExecuteScalar in class SqlCommand.
1101 * System.Data/DataColumnCollection.cs - it should
1102 inherit properties from base InternalDataCollectionBase
1103 and use them instead of overriding them, such as, List.
1105 * System.Data/DataColumn.cs
1106 * System.Data/DataTable.cs: tweaks to retrieve
1107 meta data from the database
1109 * System.Data.SqlClient/PostgresLibrary.cs -
1110 added method OidToType to convert PostgreSQL oid type
1111 to System.Type. Renamed method OidTypeToSystem
1112 to ConvertPgTypeToSystem for converting the data value
1113 from a PostgreSQL type to a .NET System type.
1115 * System.Data.SqlClient/SqlCommand.cs: implemented
1116 method ExecuteReader which returns a SqlDataReader
1117 for a light forward only read only result set.
1118 It works on types int4 ==> Int32 and
1119 varchar ==> String. Other types
1122 * System.Data.SqlClient/SqlConnection.cs: added comment
1124 * System.Data.SqlClient/SqlDataReader.cs: implemented
1125 class. It works, but still lots to do.
1127 * Test/ReadPostgresData.cs: stuff
1129 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1130 to display meta data and the data
1132 2002-05-03 Duncan Mak <duncan@ximian.com>
1134 * TODO: Took out all the Exceptions. They should be all done now.
1136 * System.Data/ConstraintException.cs:
1137 * System.Data/DBConcurrencyException.cs:
1138 * System.Data/DataException.cs:
1139 * System.Data/DeletedRowInaccessibleException.cs:
1140 * System.Data/DuplicateNameException.cs:
1141 * System.Data/EvaluateException.cs:
1142 * System.Data/InRowChangingEventException.cs:
1143 * System.Data/InvalidConstraintException.cs:
1144 * System.Data/InvalidExpressionException.cs:
1145 * System.Data/MissingPrimaryKeyException.cs:
1146 * System.Data/NoNullAllowedException.cs:
1147 * System.Data/ReadOnlyException.cs:
1148 * System.Data/RowNotInTableException.cs:
1149 * System.Data/StrongTypingException.cs:
1150 * System.Data/SyntaxErrorException.cs:
1151 * System.Data/TypeDataSetGeneratorException.cs:
1152 * System.Data/VersionNotFoundException.cs: Added to CVS.
1154 * System.Data.SqlTypes/SqlNullValueException.cs:
1155 * System.Data.SqlTypes/SqlTruncateException.cs:
1156 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1158 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1160 * System.Data/DataViewSettingCollection.cs: implemented.
1162 * System.Data/DataRowView.cs: new stubs.
1164 * System.Data.SqlTypes/SqlByte.cs:
1165 * System.Data.SqlTypes/SqlDateTime.cs:
1166 * System.Data.SqlTypes/SqlDecimal.cs:
1167 * System.Data.SqlTypes/SqlDouble.cs:
1168 * System.Data.SqlTypes/SqlGuid.cs:
1169 * System.Data.SqlTypes/SqlInt16.cs:
1170 * System.Data.SqlTypes/SqlInt64.cs:
1171 * System.Data.SqlTypes/SqlMoney.cs:
1172 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1173 by Tim Coleman <tcoleman@opentext.com>
1175 * System.Data.build: excluded newly-added files.
1177 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1179 * System.Data.SqlClient/PostgresLibrary.cs: included new
1180 internal class that will be a helper class in using
1181 PostgreSQL. PostgresLibrary is used for the
1182 pinvoke methods to the PostgreSQL Client
1183 native C library libpq while the class PostgresHelper
1184 is used for wrapper or helper methods. It currently only
1185 has one static method OidTypeToSystem in converting
1186 PostgreSQL types to .NET System.<type>s, such as,
1187 a PostgreSQL int8 becomes a .NET System.Int64.
1188 Only a few types have been added, such as, int2,
1189 int4, int8, varchar, text, bool, and char. Other types
1192 * System.Data.SqlClient/SqlCommand.cs: implemented
1193 method ExecuteScalar which allows us to do aggregate
1194 functions, such as, count, avg, min, max, and sum. We
1195 also are able to retrieve the result, convert it to the .NET type
1196 as an object. The user of the returned object must explicitly cast.
1198 * Test/ReadPostgresData.cs: updated sample
1199 to help us learn to retrieve data in System.Data.SqlClient
1202 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1204 * System.Data.build: added /nowarn: nnnn arguments
1205 so you will not get a ton of warnings. The warnings
1206 being excluded are: 1595, 0067, 0109, 0169, and 0649
1208 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1210 * System.Data.build: modified to exclude more
1211 files from the build
1213 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1215 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1218 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1219 by John Dugaw <jdugaw@unizenconsulting.com>.
1221 * System.Data.build: excluded new files from build.
1223 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1225 * Test/ReadPostgresData.cs: added - Uses the
1226 PostgresLibrary to retrieve a recordset.
1227 This is not meant to be used in Production, but as a
1228 learning aid in coding
1229 class System.Data.SqlClient.SqlDataReader.
1230 This sample does work.
1232 * Test/TestSqlDataReader.cs: added - used
1233 to test SqlDataReader (does not work yet)
1234 Forgot to add to ChangeLog on last commit.
1236 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1238 * System.Data/DataViewSetting.cs: new class.
1240 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1242 * System.Data/DataViewManager.cs: new class.
1244 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1245 don't have implementation.
1247 * System.Data.SqlTypes/SqlInt32.cs:
1248 * System.Data.SqlTypes/SqlString.cs:
1249 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1250 these are strctures.
1252 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1255 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1257 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1258 for correctly hiding parent class' members.
1259 (AddRange): use 'override' keyword on overriden method.
1261 (Contains): likewise.
1262 (IndexOf): likewise.
1263 (OnCollectionChanged): likewise.
1264 (OnCollectionChanging): likewise.
1265 (RemoveCore): likewise.
1267 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1269 * System.Data/DataSet.cs: added missing 'using's.
1271 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1273 * System.Data/DataSet.cs:
1274 * System.Data/DataTableCollection.cs:
1275 * System.Data/DataView.cs: compilation fixes on Linux.
1277 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1279 * System.Data/DataRelation.cs
1280 * System.Data/ForeignKeyConstraint.cs
1281 * System.Data/UniqueConstraint.cs: added more stubs
1283 * System.Data/DataTableRelationCollection.cs: added back to cvs
1284 and modified for compile errors. DataRelationCollection is an
1285 abstract class and there must be a class that implements for
1286 DataTable/DataSet. DataTableRelationCollection was changed
1287 to an internal class.
1289 * System.Data.build: modified - new files added
1290 also wanted to include files/classes in the build
1291 so we can get a compilable forward read only result set.
1292 It compiles now using csc/nant with warnings, but this
1293 is a start for adding functionality for the result set.
1294 Classes associated with/and DataSet are still excluded.
1296 * TODO: modified - updated to do list for System.Data
1298 * System.Data/Constraint.cs
1299 * System.Data/ConstraintCollection.cs
1300 * System.Data/DataRelationCollection.cs
1301 * System.Data/DataRow.cs
1302 * System.Data/DataRowChangeEventArgs.cs
1303 * System.Data/DataRowCollection.cs
1304 * System.Data/DataTable.cs
1305 * System.Data/DataTableCollection.cs
1306 * System.Data/InternalDataCollectionBase.cs
1307 * System.Data/PropertyCollection.cs: modified -
1308 changes to compile SqlDataReader/DataTable and
1311 * System.Data/IDbCommand.cs
1312 * System.Data.SqlClient/SqlCommand.cs: modified -
1313 un-commented overloaded methods ExecuteReader
1314 which returns a SqlDataReader
1316 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1318 * System.Data/DataTableCollection.cs: more implementation.
1319 (Count): added 'override' keyword, as pointer out by Martin.
1321 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1322 only call Array.Copy when there is really stuff to be copied.
1323 (CopyTo): don't create the temporary array, it's not needed.
1325 * System.Data.build: excluded newly added file from build.
1327 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1329 * System.Data/DataTableRelationCollection.cs: removed, it's not
1330 on MS SDK documentation.
1332 * System.Data/DataTableCollection.cs: new class.
1334 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1336 * System.Data/DataRowChangeEventArgs.cs
1337 * System.Data/DataRowCollection.cs
1338 * System.Data/DataView.cs
1339 * System.Data/PropertyCollection.cs: added new stubs
1341 * System.Data.build: modified - added new files to exclude
1344 * TODO: modified - removed files from TODO list
1345 that were stubbed above
1347 * System.Data/DataColumn.cs
1348 * System.Data/DataRow.cs: modified - various tweaks
1349 and added internal method SetTable to set the reference
1352 * System.Data/DataSet.cs: modified - class was not
1355 * System.Data/DataTable.cs: modified - temporarily commented
1356 DataSet and DataView references - trying to compile a SqlDataReader,
1357 DataTable, and dependencies for a forward read-only result set.
1358 SqlDataAdapter, DataSet, and DataView will come later once we can get
1359 a forward read only result set working.
1361 * System.Data/IDataRecord.cs: modified - source code lines should
1364 * System.Data/InternalDataCollectionBase.cs: modified - started
1365 implementing this base class for collection of data rows,
1366 columns, tables, relations, and constraints
1368 * System.Data.SqlClient/SqlException.cs: modified -
1369 call base(message) so a unhandled exception displays
1370 the message of a SQL error instead of the
1371 default SystemException message
1373 * Test/TestSqlException.cs: modified -
1374 handle the rollback properly for a SqlException on a
1377 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1379 * System.Data.build: modified - added new
1380 files to exclude from build
1382 * System.Data/Constraint.cs
1383 * System.Data/ConstraintCollection.cs
1384 * System.Data/InternalDataCollectionBase.cs: added -
1385 stubs which are needed to build DataTable.cs
1387 * TODO: modified - added more classes TODO and
1388 added more stuff TODO, such as, create script
1389 to create test database monotestdb for testing
1390 classes in System.Data
1392 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1394 * System.Data.Common/DataAdapter.cs:
1395 * System.Data.Common/DataColumnMappingCollection.cs:
1396 * System.Data.Common/DataTableMappingCollection.cs:
1397 * System.Data.Common/DbDataPermission.cs:
1398 * System.Data.Common/DbDataPermissionAttribute.cs: some
1399 compilation errors fixed.
1401 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1403 * TODO: modified - added classes TODO, and
1404 a poor attempt at System.Data plan
1406 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1408 * ChangeLog: modified - put tabs where they belong
1410 * System.Data.SqlClient/SqlDataReader.cs
1411 * System.Data/DataColumn.cs: modified - compile errors
1412 trying to compile SqlDataAdapter and dependencies
1414 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1416 * System.Data.SqlTypes/SqlBoolean.cs
1417 * System.Data.SqlTypes/SqlCompareOptions.cs
1418 * System.Data.SqlTypes/SqlInt32.cs
1419 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1421 * System.Data/DataTable.cs
1422 * System.Data.SqlClient/SqlCommand.cs
1423 * System.Data.SqlClient/SqlConnection.cs
1424 * System.Data.SqlClient/SqlError.cs
1425 * System.Data.SqlClient/SqlTransaction.cs: modified -
1428 * System.Data.SqlClient/SqlException.cs: modified -
1429 missing Message on indexer for Message property
1431 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1433 * System.Data.SqlClient/SqlCommand.cs: modified - to
1434 compile using mcs. This problem is
1435 returning a stronger type in csc vs. msc
1437 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1438 can not do a using PGconn = IntPtr; and then declare
1439 with PGconn pgConn = IntPtr.Zero;
1440 Thiw works under csc though. Had to comment using and
1441 changed declaration to IntPtr pgConn = IntPtr.Zero;
1442 Also, got rid of compile warnings for hostaddr and port.
1444 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1445 rid of compile warnings. Commented MonoTODO attribute because mcs
1446 doesn't seem to work with C# array property indexer (Item)
1449 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1450 commented MonoTODO attribute for indexer for mcs compiling
1452 * Test/TestSqlIsolationLevel.cs:
1453 * Test/TestSqlInsert.cs:
1454 * Test/TestSqlException.cs: modified -
1455 removed extra ExecuteNonQuery which caused two inserted rows
1457 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1459 * System.Data/StateChangeEventArgs.cs - added
1460 needed to compile System.Data.dll with mcs.
1462 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1464 * System.Data.OleDb: added directory - for OleDb database
1467 * System.Data.SqlClient/SqlClientPermission.cs
1468 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1469 * System.Data.SqlClient/SqlCommandBuilder.cs
1470 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1471 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1472 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1473 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1474 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1475 * Test/TestSqlException.cs
1476 * Test/TestSqlIsolationLevel.cs: added - more tests
1478 * System.Data.build: modified - added new files - excludes these too
1480 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1482 * System.Data.SqlClient/SqlConnection.cs
1483 * System.Data.SqlClient/SqlCommand.cs
1484 * System.Data.SqlClient/SqlTransaction.cs
1485 * System.Data.SqlClient/SqlException.cs
1486 * System.Data.SqlClient/SqlErrorCollection.cs
1487 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1488 exception/error handling. SqlConnection(connectionString)
1489 constructor should not automatically connect.
1491 * System.Data.SqlClient/SqlDataReader.cs
1492 * System.Data.SqlClient/SqlDataAdapter.cs
1493 * System.Data.SqlClient/SqlParameter.cs
1494 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1495 added using System.ComponentModel;
1497 * Test/TestSqlInsert.cs: modified - to use transaction
1499 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1501 * System.Data/DataRow.cs: new skeletons.
1503 * System.Data.Common/DataAdapter.cs:
1504 * System.Data.Common/DataColumnMapping.cs:
1505 * System.Data.Common/DataColumnMappingCollection.cs:
1506 * System.Data.Common/DataTableMapping.cs:
1507 * System.Data.Common/DataTableMappingCollection.cs:
1508 * System.Data.Common/DbDataAdapter.cs:
1509 * System.Data.Common/RowUpdatedEventArgs.cs:
1510 * System.Data.SqlClient/SqlDataAdapter.cs:
1511 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1514 * System.Data.Common/DbDataRecord.cs:
1515 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1518 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1520 * Test/TestSqlInsert.cs: modified - do
1521 a SQL DELETE before SQL INSERT of row so you can use this
1524 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1525 IsolationLevel for PostgreSQL is ReadCommitted. However,
1526 PostgreSQL allows Serializable as well.
1527 (Thanks to Gonzalo for that!)
1529 * System.Data.SqlClient/SqlConnection.cs: modified
1530 * System.Data.SqlClient/SqlCommand.cs: modified
1531 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1532 working; however, we still need to implement SQL errors
1533 and exceptions to properly handle transactions. Also, added
1534 status and error message support from the PostgreSQL database.
1535 Currently, this does a Console.WriteLine() to display the
1536 status and error messages, but this is a TODO
1537 for SQL errors and exceptions.
1539 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1540 attribute for System.Data.dll assembly
1542 * System.Data/IDbCommand.cs: modified - commented
1543 overloaded method ExecuteReader
1544 so System.Data.SqlClient.SqlCommand can compile
1546 * System.Data/IDbCommand.cs: modified
1547 * System.Data/IDbConnection.cs: modified - added using System;
1548 * System.Data/IDataParameter.cs
1550 * System.Data.build: modified - build classes
1551 in System.Data.SqlClient and exclude others in System.Data
1553 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1554 parameter data type from IntPtr to enum ExecStatusType
1556 * ChangeLog: modified - corrected previous entries in log
1558 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1560 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1561 implementation. Still missing some stuff.
1563 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1565 * System.Data.SqlClient/SqlConnection.cs: modified - got
1566 to compile, run, and connect to PostgreSQL database
1568 * System.Data.SqlClient/SqlCommand.cs: modified - got
1569 to compile, run, and execute a SQL INSERT command
1570 which successfully inserted a row
1571 into the PostgreSQL database
1573 * System.Data.SqlClient/SqlTransaction.cs: modified
1574 * System.Data.SqlClient/SqlParameter.cs: modified
1575 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1576 * System.Data.SqlClient/SqlError.cs: modified
1577 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1578 * System.Data.SqlClient/SqlException.cs: modified
1579 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1581 * System.Data.SqlClient/SqlAdapter: modified
1582 * System.Data.SqlClient/SqlReader: modified - add more stubs
1584 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1586 * Test/TestSqlInsert.cs: added
1588 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1590 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1591 class SqlConnecition
1592 * System.Data.SqlClient/SqlErrorCollection.cs: added
1593 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1595 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1597 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1598 * System.Data.IDbTransaction: Added Interface to IDisposable.
1599 * System.Data.IDbCommand: Fixed Capitalization of class name.
1600 * System.Data.IDbConnection: Fixed Capitalization of class name.
1602 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1604 * System.Data.Common/DbDataPermissionAttribute.cs:
1605 * System.Data.Common/DataAdapter.cs:
1606 * System.Data.Common/DataColumnMapping.cs:
1607 * System.Data.Common/DbDataPermission.cs: added some implementation.
1609 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1611 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1612 syntax, as pointed out by Levent Camlibel.
1614 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1616 * System.Data.SqlTypes/SqlBinary.cs:
1617 * System.Data.SqlTypes/INullable.cs: new skeletons.
1619 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1621 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1622 contains all calls the the PostgreSQL client library, to be used
1623 everywhere in System.Data.SqlClient.
1625 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1627 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1630 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1632 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1634 * System.Data.Common/DbDataRecord.cs:
1635 * System.Data.Common/DbEnumerator.cs:
1636 * System.Data.Common/RowUpdatedEventArgs.cs:
1637 * System.Data.Common/RowUpdatingEventArgs.cs:
1638 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1640 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1642 * System.Data.Common/DataTableMappingCollection.cs:
1643 * System.Data.Common/DbDataAdapter.cs:
1644 * System.Data.Common/DbDataPermission.cs:
1645 * System.Data.Common/DataTableMapping.cs: new skeletons.
1647 * System.Data.SqlClient/SqlDataAdapter.cs:
1648 * System.Data.SqlClient/SqlDataReader.cs:
1649 * System.Data.SqlClient/SqlErrors.cs:
1650 * System.Data.SqlClient/SqlError.cs:
1651 * System.Data.SqlClient/SqlException.cs:
1652 * System.Data.SqlClient/SqlParameter.cs:
1653 * System.Data.SqlClient/SqlParameterCollection.cs:
1654 * System.Data.SqlClient/SqlTransaction.cs:
1655 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1657 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1659 * System.Data.Common/DataColumnMapping.cs:
1660 * System.Data.Common/DataColumnMappingCollection.cs:
1661 * System.Data.Common/DataAdapter.cs: created skeletons.
1663 * System.Data.build: exclude new directories from build.
1665 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1667 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1669 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1670 implemented (2 methods).
1672 2002-03-24 Duncan Mak <duncan@ximian.com>
1674 * System.Data.build: Excluded System.Data.SqlClient from the build.
1675 The stubs are incomplete and they are stopping the build.
1677 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1679 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1681 * System.Data.SqlClient/*: added skeletons for the SQL managed
1682 provider for ADO.Net, to be based initially in PostgreSQL.
1684 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1686 Changed the Namespace on some Enums from mono.System.Data to System.Data
1688 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1690 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1691 default name if the ColumnName is null.
1692 * DataSet.cs : Added
1693 * DataTable.cs : Added
1694 * DataRelationCollection.cs : Added
1695 * DataTableRelationCollection.cs : Added
1696 * DataColumn : Added
1698 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1700 * DataColumnChangeEventArgs.cs : Added
1701 * DataColumnCollection.cs : Added
1703 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1705 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1706 * Updated all Enums, Interfaces, and Delegates in System.Data