1 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
3 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
5 2002-08-19 Franklin Wise <gracenote@earthlink.net>
7 * Tests: See System.Data\Test\ChangeLog
9 * System.Data/UniqueConstraint.cs: More validation.
11 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
12 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
15 * System.Data/DataTable.cs: Added more MonoTODO tags
17 * class/System.Data/.cvsignore: added tmp & Temp
19 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
22 * System.Data/ConstraintCollection.cs: Commented out unused line.
24 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
26 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
28 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
30 (ErrorCode, Message, Source, Errors): implemented.
32 * System.Data.OleDb/OleDbError.cs: implemented the full class.
34 * System.Data.OleDb/libgda.cs: added more libgda functions.
36 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
37 the opened connection.
39 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
41 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
43 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
44 ArrayList after releasing the items.
45 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
46 GetOrdinal, GetString): implemented.
47 (GetDataTypeName): made it get the type from the data model, not from
48 the current value, which could not have been retrieved yet.
49 (GetValue): call the Get* method corresponding with the data type of
52 * System.Data.OleDb/libgda.cs: added more libgda functions.
53 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
55 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
56 titles via OleDbDataReader.GetName ().
57 (TestOleDb): create temporary table with a date field.
58 (InsertRow): set current date for the date field.
60 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
62 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
63 GetValue, which will take care of all the work needed.
64 (Close): implemented basic stuff.
65 (~OleDbDataReader): implemented.
67 * System.Data.OleDb/libgda.cs: added more needed functions.
69 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
71 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
73 (TestTransaction): added test for transactions.
75 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
77 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
79 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
80 when there are errors.
81 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
83 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
86 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
88 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
90 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
91 create an empty GdaParameterList.
93 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
94 for NULL before passing them to Marshal.PtrToStructure, which issues
95 an exception if the value is NULL.
97 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
99 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
100 unreachable code to avoid compiler warning.
102 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
104 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
105 (OpenReader): removed internal method.
107 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
108 the list of returned data models.
110 2002-08-15 Franklin Wise <gracenote@earthlink.net>
112 * System.Data/Constraint.cs: Added helper virtual functions
114 * System.Data/ConstraintCollection.cs: Improved constraint removal,
115 validation. Removed specific knowledge of subclasses of
118 * System.Data/DataColumn.cs: Added static helper function to compare
119 if two DataColumn arrays are the same.
121 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
123 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
126 2002-08-13 Franklin Wise <gracenote@earthlink.net>
128 * System.Data/DataRow.cs: Added several fixme tags.
130 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
132 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
133 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
134 to avoid compiler warnings.
136 2002-08-12 Franklin Wise <gracenote@earthlink.net>
138 * System.Data/Constraint.cs: Implemented
140 * System.Data/UniqueConstraint.cs: GetHashCode() &
141 special case Ctor. Still need to be implemented. LAMESPEC tags
144 * System.Data/ConstraintCollection.cs: Clear() &
145 AddRange() need to be finished. Several LAMESPEC tags.
147 * Allow Constraint collection to be created in DataTable.
149 * System.Data/ForeignKeyConstraint: Added a couple of
152 * System.Data/DataColumnCollection New/Added DataColumns now have
155 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
157 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
159 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
160 internal method, since we don't need it.
161 (ExecuteReader): call SetupGdaCommand before executing the command
162 via libgda functions.
163 (ExecuteScalar): implemented.
165 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
166 to OleDbCommand.OpenReader.
167 (GetBoolean): implemented.
169 2002-08-08 Franklin Wise <gracenote@earthlink.net>
171 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
173 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
175 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
178 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
180 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
181 and don't show a warning in Open.
183 * System.Data.OleDb/TestOleDb.cs: added Close.
185 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
187 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
188 ConnectionTimeout, ServerVersion, GdaConnection):
190 (OleDbConnection): call libgda.gda_init on constructor.
192 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
193 which wasn't been called.
195 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
198 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
200 * list: added missing System.Data.OleDb and
201 System.Data.Common files.
203 * System.Data.OleDb/ChangeLog: removed and merged with
204 System.Data's ChangeLog.
206 * System.Data.OleDb/OleDbDataAdapter.cs:
207 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
209 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
211 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
212 (IsClosed, Item, RecordsAffected): implemented some properties.
214 * libgda.cs: added GdaDataModel methods.
216 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
218 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
219 a second argument (ArrayList results).
220 (NextResult): implemented.
222 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
223 pass that to the OleDbDataReader.
224 (OleDbCommand constructor): don't create the ArrayList of results.
225 (GdaResults): removed property.
226 (ExecuteReader): create a temporary ArrayList and pass that to the
227 OleDbDataReader constructor.
229 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
231 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
232 (CreateParameter): implemented IDbCommand methods.
233 (CommandText): don't create many GdaCommand's, only one is needed.
234 (ExecuteNonQuery): set up the internal GDA command object.
235 (ExecuteReader): use correctly the unique GDA command object.
237 * System.Data.OleDb/libgda.cs: added new libgda calls.
239 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
241 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
242 (BeginTransaction): implemented IDbConnection methods.
244 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
246 * list: added System.Data.OleDb files to file list.
248 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
250 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
252 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
253 of the set method for this property.
255 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
256 (MissingSchemaAction): implemented.
258 2002-07-10 Tim Coleman <tim@timcoleman.com>
260 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
261 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
262 * System.Data.OleDb/OleDbError.cs: Added stubbs
263 * System.Data.OleDb/OleDbException.cs: Added stubbs
264 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
265 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
266 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
267 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
268 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
269 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
270 support transaction nesting
271 * System.Data.OleDb/libgda.cs: Added my name to this file
273 2002-07-09 Tim Coleman <tim@timcoleman.com>
275 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
276 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
277 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
278 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
279 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
280 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
281 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
282 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
283 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
284 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
285 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
286 * System.Data.OleDb/OleDbType.cs: Fixed two typos
287 * System.Data.OleDb/libgda.cs: Style changes, added new methods
289 2002-07-09 Tim Coleman <tim@timcoleman.com>
291 * System.Data.build: remove restriction on System.Data.OleDb build
293 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
295 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
296 IsSynchronized): implemented.
298 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
300 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
302 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
303 (Parameters, Transaction, Connection): made these overload
306 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
307 call m_list methods, not own ones.
309 * System.Data.OleDb/OleDbParameter.cs: more implementation.
311 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
313 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
314 Commit, Rollback): implemented.
315 (GdaConnection): added new internal property.
317 * System.Data.OleDb/OleDbParameter.cs:
318 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
321 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
323 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
325 * System.Data.OleDb/libgda.cs: added new libgda API functions.
327 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
328 (BeginTransaction): made it overload IDbConnection methods.
329 (ChangeDatabase): new stub, needs some work on libgda for being
332 (Close): implemented.
333 (CreateCommand): implemented.
334 (GetOleDbSchemaTable): new stub, until I understand what to do here.
335 (Open): implemented basic stuff, which is just supporting connection
336 strings that represent a GDA data source name. More to come.
337 (InfoMessage, StateChange): added events.
339 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
341 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
343 * System.Data.OleDb/libgda.cs: added static constructor.
344 (GdaClient): new static property to get the underlying GdaClient
347 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
348 the static 'libgda' class.
350 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
352 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
354 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
355 (ConnectionString, Connectiontimeout, Database, State):
356 implemented class properties.
357 (BeginTransaction): implemented.
359 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
361 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
363 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
365 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
367 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
369 * list: added missing PostgresTypes.cs file.
371 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
373 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
376 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
378 * System.Data.SqlClient/SqlConnection.cs: modifed -
379 start to implement the interfaces properly and
380 properly doing a Close(), Dispose(), and
383 * Test/SqlSharpCli.cs: modified -
384 add support for MySQL in Mono.Data.MySql
385 and OleDb support in System.Data.OleDb. However,
386 the OleDb support is commented right now.
387 When the program starts up, a shorter help menu should
388 display the most important commands: help and quit
390 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
392 * System.Data.build: exclude System.Data.OleDb files.
394 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
396 * System.Data.SqlClient/SqlCommand.cs: typo
397 should be CommandBehavior.KeyInfo
399 * Test/SqlSharpCli.cs: refactored and added a few more
402 2002-05-27 Tim Coleman <tim@timcoleman.com>
403 * list: update to compile properly (add missing
404 files and switch path delimiter from '\' to '/').
406 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
408 * System.Data/DataRow.cs
409 * System.Data.Common/DbDataAdapter.cs: fix to
410 get Test/TestSqlDataAdapter.cs to work again
412 * Test/TestSqlDataAdapter.cs: removed comment
413 about SqlDataReader:NextResult() not being implemented; it
416 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
418 * System.Data/DataRow.cs: modified
419 support setting of DBNull.Value
420 using the Item indexer this[DataColumn]
422 * System.Data.SqlClient/SqlCommand.cs: modified
423 tweaks to show TODO's for other CommandBehavior.
424 Set AllowDBNull column to true for IsKey row
427 * System.Data.SqlClient/SqlConnection.cs: modified
428 if transaction is in progress when a Close() is called,
429 do a transaction Rollback.
431 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
433 * Test/SqlSharpCli.cs: added file
434 My new toy. SQL# is a command-line tool to enter
435 SQL commands and queries using Mono System.Data.
436 It also serves as a test for Mono System.Data.
438 * System.Data.SqlClient/SqlCommand.cs: modified
439 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
440 should handle the results from SQL Commands and Queries.
441 - Internal class SqlResult should not create schema Table
442 for the result from a SQL Command. Also, set the RecordsRetrieved
443 property for SqlDataReader.
444 - Closing the SqlDataReader should Close() the SqlConnection for
445 a CommandBehavior.CloseConnection.
446 - Set defaults for SqlResult
448 * System.Data.SqlClient/SqlConnection.cs: modified -
449 when SqlDataReader is Close()
450 should Close() the SqlConnection for
451 a CommandBehavior.CloseConnection. Changed internal Property
452 from OpenReader get/set to IsReaderOpen get and created
453 internal methods OpenReader()/CloseReader() for SqlCommand to call.
454 SqlConnection needs to be prevented from doing while SqlDataReader
457 * System.Data.SqlClient/SqlDataReader.cs: modified -
458 call SqlCommand's OpenReader() internal method. get
459 RecordsRetrieved from SqlResult. set/reset default
460 values for SqlDataReader.
462 * Test/PostgresTest.cs
463 * Test/TestExecuteScalar.cs
464 * Test/TestSqlDataReader.cs: modified
465 for the Execute...() methods in SqlCommand
466 to test SQL Queries and Commands
468 * Test/System.Data_test.build: modified
469 exclude new file Test/SqlSharpCli.cs from
472 2002-05-24 Tim Coleman <tim@timcoleman.com>
473 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
474 for get accessors. These should be implemented in derived classes. See
475 SqlDataAdapter for clues.
476 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
477 * System.Data.Common/DataAdapter.cs:
478 * System.Data.Common/DataTableMappingCollection.cs:
479 * System.Data.Common/DataTableMapping.cs:
480 * System.Data.Common/DataColumnMappingCollection.cs:
481 * System.Data.Common/DataColumnMapping.cs:
482 Properly (I hope!) implement all of the appropriate interfaces
486 2002-05-23 Tim Coleman <tim@timcoleman.com>
487 * System.Data.SqlClient/SqlCommand.cs: include
488 the BaseColumnName in the schema table. Was missed before.
489 * System.Data.Common/DbDataAdapter.cs: Use DataTable
490 mappings so that the DataSet and DataTable are more closely tied.
491 Get schema information from the DataTable using GetSchemaTable ()
492 Various other little fixes
493 * System.Data.Common/DataColumnMappingCollection.cs:
494 * System.Data.Common/DataTableMapping.cs:
495 * System.Data.Common/DataTableMappingCollection.cs: Some
496 implementation, enough to be used by DbDataAdapter.
498 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
500 * System.Data.SqlClient/SqlCommand.cs: set
501 the "ProviderType" to the PostgreSQL type oid
503 * System.Data.SqlClient/SqlDataReader.cs: fix
504 for various properties and methods that
505 return meta data: Item indexers this[name] and this[index],
506 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
509 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
511 * System.Data/DataRow.cs: change suggested
512 by tim: in Item indexer, do an EndEdit()
514 * System.Data.SqlClient/SqlCommand.cs: more
515 fixes to SqlResult. After setting each item in
516 the DataRow, do an AcceptChanges() to commit
517 the changes in the DataRow. For DataType, use a Type
518 of System.String since System.Type nor System.Object
521 * Test/TestSqlDataReader.cs
522 * Test/PostgresTest.cs: updated to to be on
523 the way schema table is suppose to work
525 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
527 * System.Data.SqlClient/SqlCommand.cs: more work on
528 building the schema table
530 2002-05-22 Tim Coleman <tim@timcoleman.com>
531 * System.Data.SqlClient/SqlCommand.cs: preliminary work
532 on getting the schema table correctly built.
534 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
536 * System.Data.SqlClient/ParmUtil.cs: added file - to
537 provide utility for conversion of input parameters
539 * System.Data.SqlClient/PostgresTypes.cs: added file -
540 moved the PostgreHelper class to here. May eventually
541 move the internal class PostgresTypes that's inside the
542 SqlConnection to here as well.
543 Handling of PostgreSQL <-> .NET types need to be though
544 out more. Also, the PostgreHelper has a method to convert
545 from .NET types to a string which can be put into used in
546 an SQL statement to execute against a PostgreSQL database.
547 This is the beginnings of parameters support. It currently
548 only supports input parameters. Still need to do output,
549 input/output, and return parameters.
551 * Test/TestSqlParameters.cs: new test to test the input
552 parameters in System.Data.SqlClient against a
555 * System.Data.SqlClient/PostgresLibrary.cs: moved
556 PostgresHelper class to file PostgresTypes.cs. Also
557 moved struct PostgresType there too.
559 * System.Data.SqlClient/SqlCommand.cs: added input
562 * System.Data.SqlClient/SqlParameter.cs: got
565 * System.Data.SqlClient/SqlParameterCollection.cs: got
566 SqlParameterCollection to work
568 * Test/System.Data_test.build: added files to exclude
571 * System.Data.SqlClient/SqlConnection.cs: release resources
574 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
576 * System.Xml: added directory for classes with namespace
577 System.Xml to go into the System.Data.dll assembly
579 * System.Xml/XmlDataDocument: added file
580 for stubbed concrete class XmlDataDocument which
581 inherits from XmlDocument. Its purpose is to provide
582 a W3C XML DOM Document for relational data and interacting
585 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
587 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
588 Text, TableDirect, and StoredProcedure
590 * Test/PostgresTest.cs: changed call to version()
591 stored procedure to use the CommandType of StoredProcedure
593 * Test/TestSqlDataReader.cs: test all the CommandTypes
595 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
597 * System.Data.build: took out all excluded
598 files except the ones in the Test directory
599 because all files compile now. It does not
600 mean they all work or have implementations
603 * System.Data/DataRelationCollection.cs
604 * System.Data/DataTableRelationCollection.cs
605 * System.Data/InternalDataCollectionBase.cs
606 * System.Data.Common/DbDataPermission.cs
607 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
608 * System.Data.SqlClient/SqlClientPermission.cs
609 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
610 to get all System.Data* files to compile.
612 * System.Data.SqlClient/SqlCommand.cs: started coding
613 to prevent SqlConnection and SqlCommand from doing
614 anyting while fetching data using SqlDataReader. Also,
615 started coding to undo this prevention once the
616 SqlDataReader is closed.
618 * System.Data.SqlClient/SqlConnection.cs: get database server
619 version. Started coding to prevent connection from
620 doing anything while fetching data and undo once the reader
621 is closed. Include events SqlInfoMessage and StateChange.
623 * System.Data.SqlClient/SqlDataReader.cs: start coding to
624 prevent connection and command from doing anything while
625 fetching data, and undo when closed.
627 * Test/PostgresTest.cs: added test to get ServerVersion
628 property from SqlConnection
630 2002-05-18 Tim Coleman <tim@timcoleman.com>
631 * System.Data/DataRow.cs: More implementation,
632 as well as boundary checks and small semantic
635 2002-05-18 Tim Coleman <tim@timcoleman.com>
636 * System.Data/DataRow.cs: Try to reduce memory
637 usage by only creating the original and proposed
638 arrays as required in BeginEdit, and then destroying
639 proposed during EndEdit, and original during AcceptChanges.
640 * System.Data.Common/DbDataAdapter.cs: Make the
641 startRecord and maxRecords parameters work correctly.
643 2002-05-18 Tim Coleman <tim@timcoleman.com>
644 * System.Data/DataRow.cs: Move the null check in
645 ItemArray set to above the Invalid Cast check, so
646 that we don't get null reference exceptions.
648 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
650 * System.Data.SqlClient/PostgresLibrary.cs: handle
651 data value from database being NULL
653 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
654 allow multiple result sets. Added new internal class
655 SqlResult to pass result set data from SqlCommand
658 * System.Data.SqlClient/SqlDataReader.cs: allow
659 multiple result sets.
661 * System.Data.SqlClient/SqlConnection.cs: moved
662 things around. Implement IDisposable.
664 * Test/TestSqlDataReader.cs: test for execution
665 of multiple result sets and display the results
666 of these multiple results sets
668 * Test/TestSqlDataAdapter.cs: tweaks
670 2002-05-17 Tim Coleman <tim@timcoleman.com>
671 * System.Data.Common/DbDataAdapter.cs:
672 - More implementation of Fill methods
673 - Get rid of isDirty flag, because we can just check
675 - Do *not* remove DataTables before Filling them
676 - Implicitly open the connection before doing a Fill
677 if it does not exist.
678 * System.Data.SqlClient/SqlDataAdapter.cs:
680 * System.Data/DataTableCollection.cs:
681 - Add DataSet to internal, undocumented constructor
682 - When a table is created, set its DataSet property
683 - Default table name for creation is "Table1" (see .NET)
684 - Inherit the ArrayList list from InternalDataCollecitonBase
685 and maintain a hashtable between table names and
687 * System.Data/DataTable.cs:
688 - Add internal dataSet field. This is used by
689 DataTableCollection when the DataTable is constructed.
690 * System.Data/DataSet.cs:
691 - Pass a reference to the DataSet when constructing the
694 2002-05-16 Tim Coleman <tim@timcoleman.com>
695 * System.Data.Common/DbDataAdapter.cs:
696 Use table.Rows.Add (itemArray) instead of
697 table.Rows.Add (thisRow) to provide better
699 * System.Data/DataRowCollection.cs:
700 Some implementation of this class.
701 * System.Data/InternalDataCollectionBase.cs:
702 Some implementation. Most notably, this now
703 has an enumerator so we can use foreach (DataRow row in table.Rows)
705 * System.Data/DataTable.cs:
706 Since DataRowCollection now accepts a DataTable in
707 its internal constructor, we must pass one in.
709 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
711 * Test/TestSqlDataAdapter.cs: added new test
712 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
713 DataRowCollection, and DataRow. It tests retrieving data
714 based on a SQL SELECT query. This test is based on Tim Coleman's
717 2002-05-16 Tim Coleman <tim@timcoleman.com>
718 * System.Data.Common/DbDataAdapter.cs:
719 Use table.Rows.Add (thisRow) instead of
720 table.ImportRow (thisRow)
721 * System.Data/DataRowCollection.cs:
722 Construct the ArrayList before using it
724 2002-05-16 Tim Coleman <tim@timcoleman.com>
725 * System.Data/DataTable.cs:
726 Construct the DataRowCollection in the DataTable
727 constructor. Otherwise, it's a null reference.
729 2002-05-16 Tim Coleman <tim@timcoleman.com>
730 * System.Data.SqlClient/SqlDataReader.cs:
731 Modify GetValues to use Array.Copy() to copy
732 the results from fields to values, rather than
733 an assignment, which results in loss of data.
735 2002-05-16 Tim Coleman <tim@timcoleman.com>
736 * System.Data/DataRow.cs:
737 More implementation and documentation. It should
738 work more like expected, although there is no way
739 to demonstrate this well yet. DataTable requires
742 2002-05-15 Tim Coleman <tim@timcoleman.com>
743 * System.Data/DataRow.cs:
744 Minor tweaks as I determine exactly how to
745 implement this class.
748 2002-05-14 Duncan Mak <duncan@ximian.com>
750 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
752 2002-05-14 Tim Coleman
753 * System.Data/DataRow.cs:
754 * System.Data/DataRowBuilder.cs:
755 * System.Data/DataTable.cs:
756 More implementation of these classes. DataRow
757 can now (possibly) do some useful things.
758 Still not sure what DataRowBuilder is all about,
759 other than passing a DataTable in.
761 2002-05-14 Tim Coleman
762 * System.Data/DataRowBuilder.cs:
763 Add stubb for this internal class.
765 2002-05-13 Tim Coleman
766 * System.Data.Common/DbDataAdapter.cs:
767 The maxRecords check was not correct.
769 2002-05-13 Tim Coleman
770 * System.Data/DataTableCollection.cs:
771 Fix an issue when adding a DataTable and size == 0.
772 Now explicitly checks if size > 0 before doing Array.Copy ()
773 * System.Data.Common/DbDataAdapter.cs:
774 Move closer to a working implementation.
775 Make the IDbCommand fields protected so that they can
777 * System.Data.SqlClient/SqlDataAdapter.cs:
778 This should inherit the IDbCommands instead of having its
779 own. An explicit cast is used to force conversion between
780 IDbCommand and SqlCommand
782 2002-05-13 Tim Coleman
783 * System.Data.Common/DataTableMappingCollection.cs:
784 Some implementation to allow progress with DbDataAdapter
786 2002-05-13 Tim Coleman
787 * System.Data.Common/DbDataAdapter.cs:
788 Modify to not break compile.
790 2002-05-13 Tim Coleman
792 include SqlDataAdapter, SqlRowUpdatedEventArgs,
793 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
794 SqlRowUpdatingEventHandler in the build.
796 2002-05-13 Tim Coleman
797 * System.Data.Common/DbDataAdapter.cs:
799 * System.Data.Common/DataAdapter.cs:
800 Correction of some of the stubbing, as well as a
801 little bit more implementation
803 2002-05-11 Tim Coleman
804 * System.Data.SqlClient/SqlDataAdapter.cs:
805 * System.Data.Common/DbDataAdapter.cs:
806 Moved methods that weren't supposed to
807 be in SqlDataAdapter out. They should be implemented
811 2002-05-11 Tim Coleman
812 * System.Data.SqlClient/SqlDataAdapter.cs:
813 some implementation of this class. Note
814 that none of the functionality has been
815 tested yet, but I felt it should be checked
816 in at this point as it compiles.
817 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
818 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
819 Modified so that they will compile properly.
820 Needed to include SqlDataAdapter in the build.
822 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
824 * System.Data/DataTable.cs (Clear): implemented.
825 (DataTable): removed repeated code in constructors, and call the
826 basic constructor from the others.
828 * System.Data/DataColumn.cs: some tweaks.
830 * System.Data/DataRow.cs (RowState): implemented.
831 (CancelEdit): set rowState property back to Unchanged.
832 (RejectChanges): call CancelEdit.
833 (Delete): set rowState to Deleted.
835 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
837 * System.Data.build: added copy of System.Data.dll to Test directory
838 for easy testing. Also, added clean for it too.
840 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
841 from PostgreSQL data type to .NET type.
843 * System.Data.SqlClient/SqlDataReader.cs: beginnings
844 handling of a NULL value from the database
846 * Test/PostgresTest.cs: added tests for NULL values retrieved
849 * Test/ReadPostgresData.cs
850 * Test/TestExecuteScalar.cs
851 * Test/TestSqlDataReader.cs
852 * Test/TestSqlException.cs
853 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
854 "postgres". These tests may eventually be removed since they
857 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
859 * System.Data.build: removed reference to non-existant
860 TestDataColumn.cs file.
862 * System.Data/DataSet.cs: added some implementation.
864 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
866 * System.Data.SqlClient/PostgresLibrary.cs: got
867 PostgreSQL data types time, date, timestamp (DateTime like)
868 mapped to .NET System.DateTime working based
869 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
870 Also mapped pg type boolean to .net Boolean
872 * SqlClient/SqlConnection.cs: run SQL command to set
875 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
876 added tests for aggregates min(), max(), sum(), count(). could
877 not get avg() to work due to some formatting error; someone claimed
878 that it was my locale settings. added tests for SELECT of columns
879 of type boolean, float, double, date, time, and timestamp. They
880 have not been fully tested, but its a start.
882 2002-05-09 Tim Coleman <tim@timcoleman.com>
883 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
884 addition, subtraction, and multiplication for the
885 SqlDecimal type, as well as modification of some other
886 operations. More to come on this one.
888 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
890 * Test/System.Data_test.build: excluded TestDataColumn, which
891 should be replaced with a nunit test.
893 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
895 2002-05-07 Tim Coleman <tim@timcoleman.com>
909 Fix the broken build I made before. Bad
912 2002-05-07 Tim Coleman <tim@timcoleman.com>
914 Fix a symantic error I made in SqlString
915 Equals where I copied and pasted wrongly
917 2002-05-07 Tim Coleman <tim@timcoleman.com>
922 * SqlCompareOptions.cs:
933 Implement CompareTo, Equals, and String conversions
936 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
938 * Test/PostgresTest.cs: modified to run completely. There
939 are many TODOs in System.Data, so not all data types are
940 included in the SELECT SQL query. Also, I made it to where
942 using "host=localhost;dbname=test;user=postgres"
943 instead of my userid and password. When more types are included,
946 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
948 * Test/PostgresTest.cs: added - ported
949 libgda postgres-test.c originally by
950 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
953 2002-05-05 Tim Coleman <tim@timcoleman.com>
954 * System.Data.SqlTypes/SqlBinary.cs:
955 * System.Data.SqlTypes/SqlBoolean.cs:
956 * System.Data.SqlTypes/SqlByte.cs:
957 * System.Data.SqlTypes/SqlDateTime.cs:
958 * System.Data.SqlTypes/SqlDecimal.cs:
959 * System.Data.SqlTypes/SqlDouble.cs:
960 * System.Data.SqlTypes/SqlGuid.cs:
961 * System.Data.SqlTypes/SqlInt16.cs:
962 * System.Data.SqlTypes/SqlInt32.cs:
963 * System.Data.SqlTypes/SqlInt64.cs:
964 * System.Data.SqlTypes/SqlMoney.cs:
965 * System.Data.SqlTypes/SqlSingle.cs:
966 * System.Data.SqlTypes/SqlString.cs:
967 More implementation, and code clean-up for consistency.
968 Also, I had implemented many conversions as explicit
969 that should have been implicit. This should remove
970 many of the red X's and green pluses from the
971 System.Data.SqlTypes namespace.
973 2002-05-05 Miguel de Icaza <miguel@ximian.com>
975 * System.Data/DataSet.cs: Remove [Serializable] attributes from
976 methods, those only apply to structs or classes.
978 Stub out ISerializable, ISupportInitialize, and IListSource methods
980 * System.Data/DataRowView.cs: Stub out interface methods for
981 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
983 * System.Data/DataView.cs: Comment out non-implemented
986 * System.Data/DataViewSettingsCollection.cs: Type cast variables
987 to the correct type to make it compile.
989 * System.Data/DataViewSettings.cs: remove reference to
990 non-existance type ApplyDefaultSort, it is a boolean.
993 2002-05-05 Tim Coleman <tim@timcoleman.com>
994 * System.Data.SqlTypes/SqlBinary.cs:
995 * System.Data.SqlTypes/SqlBoolean.cs:
996 * System.Data.SqlTypes/SqlByte.cs:
997 * System.Data.SqlTypes/SqlDecimal.cs:
998 * System.Data.SqlTypes/SqlDouble.cs:
999 * System.Data.SqlTypes/SqlGuid.cs:
1000 * System.Data.SqlTypes/SqlInt16.cs:
1001 * System.Data.SqlTypes/SqlInt32.cs:
1002 * System.Data.SqlTypes/SqlInt64.cs:
1003 * System.Data.SqlTypes/SqlMoney.cs:
1004 * System.Data.SqlTypes/SqlSingle.cs:
1005 * System.Data.SqlTypes/SqlString.cs:
1006 Various fixes, including adding the SqlNullValueException
1007 when trying to retrieve the value of a null SqlType,
1008 and when casting values, a Null of type A converts to a
1011 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1013 * System.Data.SqlClient/PostgresLibrary.cs
1014 * System.Data.SqlClient/SqlCommand.cs
1015 * System.Data.SqlClient/SqlConnection.cs
1016 * System.Data.SqlClient/SqlDataReader.cs
1017 oid should not be hard coded because they
1018 can change from one version of PostgreSQL
1019 to the next. Use the typname's instead.
1020 The PostgreSQL type data retrieves
1021 at database connection time. Any unimplemented
1022 types just default to string. These were things
1023 suggested by Gonzalo.
1025 * Test/ReadPostgresData.cs - stuff
1026 * Test/TestSqlDataReader.cs - stuff
1028 * System.Data.SqlTypes/SqlInt32.cs - added a using
1030 2002-05-03 Tim Coleman <tim@timcoleman.com>
1031 * System.Data.build: Fix the build so that test depends on build
1033 2002-05-03 Tim Coleman <tim@timcoleman.com>
1034 * System.Data.SqlTypes/SqlByte.cs:
1035 * System.Data.SqlTypes/SqlDateTime.cs:
1036 * System.Data.SqlTypes/SqlDecimal.cs:
1037 * System.Data.SqlTypes/SqlDouble.cs:
1038 * System.Data.SqlTypes/SqlGuid.cs:
1039 * System.Data.SqlTypes/SqlInt16.cs:
1040 * System.Data.SqlTypes/SqlInt64.cs:
1041 * System.Data.SqlTypes/SqlMoney.cs:
1042 * System.Data.SqlTypes/SqlSingle.cs:
1043 These files were mysteriously excluded from the last
1044 patch I made and sent to Rodrigo
1045 * System.Data.build: include the System.Data.SqlTypes in the build
1047 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1049 * System.Data.build: removed comments
1051 * System.Data.SqlClient/PostgresLibrary.cs: changed
1052 the hard-coded PostgreSQL oid type int's to using an
1053 enum. Also, added PostgreSQL bpchar (character) type.
1055 * Test/TestSqlDataReader.cs: updated test
1056 to include new bpchar PostgreSQL type
1058 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1060 * System.Data.SqlTypes/SqlBinary.cs:
1061 * System.Data.SqlTypes/SqlBoolean.cs:
1062 * System.Data.SqlTypes/SqlInt32.cs:
1063 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1064 Tim Coleman <tcoleman@opentext.com>.
1066 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1068 * Test/TestExecuteScalar.cs: added test for
1069 method ExecuteScalar in class SqlCommand.
1071 * System.Data/DataColumnCollection.cs - it should
1072 inherit properties from base InternalDataCollectionBase
1073 and use them instead of overriding them, such as, List.
1075 * System.Data/DataColumn.cs
1076 * System.Data/DataTable.cs: tweaks to retrieve
1077 meta data from the database
1079 * System.Data.SqlClient/PostgresLibrary.cs -
1080 added method OidToType to convert PostgreSQL oid type
1081 to System.Type. Renamed method OidTypeToSystem
1082 to ConvertPgTypeToSystem for converting the data value
1083 from a PostgreSQL type to a .NET System type.
1085 * System.Data.SqlClient/SqlCommand.cs: implemented
1086 method ExecuteReader which returns a SqlDataReader
1087 for a light forward only read only result set.
1088 It works on types int4 ==> Int32 and
1089 varchar ==> String. Other types
1092 * System.Data.SqlClient/SqlConnection.cs: added comment
1094 * System.Data.SqlClient/SqlDataReader.cs: implemented
1095 class. It works, but still lots to do.
1097 * Test/ReadPostgresData.cs: stuff
1099 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1100 to display meta data and the data
1102 2002-05-03 Duncan Mak <duncan@ximian.com>
1104 * TODO: Took out all the Exceptions. They should be all done now.
1106 * System.Data/ConstraintException.cs:
1107 * System.Data/DBConcurrencyException.cs:
1108 * System.Data/DataException.cs:
1109 * System.Data/DeletedRowInaccessibleException.cs:
1110 * System.Data/DuplicateNameException.cs:
1111 * System.Data/EvaluateException.cs:
1112 * System.Data/InRowChangingEventException.cs:
1113 * System.Data/InvalidConstraintException.cs:
1114 * System.Data/InvalidExpressionException.cs:
1115 * System.Data/MissingPrimaryKeyException.cs:
1116 * System.Data/NoNullAllowedException.cs:
1117 * System.Data/ReadOnlyException.cs:
1118 * System.Data/RowNotInTableException.cs:
1119 * System.Data/StrongTypingException.cs:
1120 * System.Data/SyntaxErrorException.cs:
1121 * System.Data/TypeDataSetGeneratorException.cs:
1122 * System.Data/VersionNotFoundException.cs: Added to CVS.
1124 * System.Data.SqlTypes/SqlNullValueException.cs:
1125 * System.Data.SqlTypes/SqlTruncateException.cs:
1126 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1128 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1130 * System.Data/DataViewSettingCollection.cs: implemented.
1132 * System.Data/DataRowView.cs: new stubs.
1134 * System.Data.SqlTypes/SqlByte.cs:
1135 * System.Data.SqlTypes/SqlDateTime.cs:
1136 * System.Data.SqlTypes/SqlDecimal.cs:
1137 * System.Data.SqlTypes/SqlDouble.cs:
1138 * System.Data.SqlTypes/SqlGuid.cs:
1139 * System.Data.SqlTypes/SqlInt16.cs:
1140 * System.Data.SqlTypes/SqlInt64.cs:
1141 * System.Data.SqlTypes/SqlMoney.cs:
1142 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1143 by Tim Coleman <tcoleman@opentext.com>
1145 * System.Data.build: excluded newly-added files.
1147 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1149 * System.Data.SqlClient/PostgresLibrary.cs: included new
1150 internal class that will be a helper class in using
1151 PostgreSQL. PostgresLibrary is used for the
1152 pinvoke methods to the PostgreSQL Client
1153 native C library libpq while the class PostgresHelper
1154 is used for wrapper or helper methods. It currently only
1155 has one static method OidTypeToSystem in converting
1156 PostgreSQL types to .NET System.<type>s, such as,
1157 a PostgreSQL int8 becomes a .NET System.Int64.
1158 Only a few types have been added, such as, int2,
1159 int4, int8, varchar, text, bool, and char. Other types
1162 * System.Data.SqlClient/SqlCommand.cs: implemented
1163 method ExecuteScalar which allows us to do aggregate
1164 functions, such as, count, avg, min, max, and sum. We
1165 also are able to retrieve the result, convert it to the .NET type
1166 as an object. The user of the returned object must explicitly cast.
1168 * Test/ReadPostgresData.cs: updated sample
1169 to help us learn to retrieve data in System.Data.SqlClient
1172 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1174 * System.Data.build: added /nowarn: nnnn arguments
1175 so you will not get a ton of warnings. The warnings
1176 being excluded are: 1595, 0067, 0109, 0169, and 0649
1178 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1180 * System.Data.build: modified to exclude more
1181 files from the build
1183 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1185 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1188 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1189 by John Dugaw <jdugaw@unizenconsulting.com>.
1191 * System.Data.build: excluded new files from build.
1193 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1195 * Test/ReadPostgresData.cs: added - Uses the
1196 PostgresLibrary to retrieve a recordset.
1197 This is not meant to be used in Production, but as a
1198 learning aid in coding
1199 class System.Data.SqlClient.SqlDataReader.
1200 This sample does work.
1202 * Test/TestSqlDataReader.cs: added - used
1203 to test SqlDataReader (does not work yet)
1204 Forgot to add to ChangeLog on last commit.
1206 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1208 * System.Data/DataViewSetting.cs: new class.
1210 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1212 * System.Data/DataViewManager.cs: new class.
1214 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1215 don't have implementation.
1217 * System.Data.SqlTypes/SqlInt32.cs:
1218 * System.Data.SqlTypes/SqlString.cs:
1219 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1220 these are strctures.
1222 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1225 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1227 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1228 for correctly hiding parent class' members.
1229 (AddRange): use 'override' keyword on overriden method.
1231 (Contains): likewise.
1232 (IndexOf): likewise.
1233 (OnCollectionChanged): likewise.
1234 (OnCollectionChanging): likewise.
1235 (RemoveCore): likewise.
1237 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1239 * System.Data/DataSet.cs: added missing 'using's.
1241 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1243 * System.Data/DataSet.cs:
1244 * System.Data/DataTableCollection.cs:
1245 * System.Data/DataView.cs: compilation fixes on Linux.
1247 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1249 * System.Data/DataRelation.cs
1250 * System.Data/ForeignKeyConstraint.cs
1251 * System.Data/UniqueConstraint.cs: added more stubs
1253 * System.Data/DataTableRelationCollection.cs: added back to cvs
1254 and modified for compile errors. DataRelationCollection is an
1255 abstract class and there must be a class that implements for
1256 DataTable/DataSet. DataTableRelationCollection was changed
1257 to an internal class.
1259 * System.Data.build: modified - new files added
1260 also wanted to include files/classes in the build
1261 so we can get a compilable forward read only result set.
1262 It compiles now using csc/nant with warnings, but this
1263 is a start for adding functionality for the result set.
1264 Classes associated with/and DataSet are still excluded.
1266 * TODO: modified - updated to do list for System.Data
1268 * System.Data/Constraint.cs
1269 * System.Data/ConstraintCollection.cs
1270 * System.Data/DataRelationCollection.cs
1271 * System.Data/DataRow.cs
1272 * System.Data/DataRowChangeEventArgs.cs
1273 * System.Data/DataRowCollection.cs
1274 * System.Data/DataTable.cs
1275 * System.Data/DataTableCollection.cs
1276 * System.Data/InternalDataCollectionBase.cs
1277 * System.Data/PropertyCollection.cs: modified -
1278 changes to compile SqlDataReader/DataTable and
1281 * System.Data/IDbCommand.cs
1282 * System.Data.SqlClient/SqlCommand.cs: modified -
1283 un-commented overloaded methods ExecuteReader
1284 which returns a SqlDataReader
1286 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1288 * System.Data/DataTableCollection.cs: more implementation.
1289 (Count): added 'override' keyword, as pointer out by Martin.
1291 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1292 only call Array.Copy when there is really stuff to be copied.
1293 (CopyTo): don't create the temporary array, it's not needed.
1295 * System.Data.build: excluded newly added file from build.
1297 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1299 * System.Data/DataTableRelationCollection.cs: removed, it's not
1300 on MS SDK documentation.
1302 * System.Data/DataTableCollection.cs: new class.
1304 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1306 * System.Data/DataRowChangeEventArgs.cs
1307 * System.Data/DataRowCollection.cs
1308 * System.Data/DataView.cs
1309 * System.Data/PropertyCollection.cs: added new stubs
1311 * System.Data.build: modified - added new files to exclude
1314 * TODO: modified - removed files from TODO list
1315 that were stubbed above
1317 * System.Data/DataColumn.cs
1318 * System.Data/DataRow.cs: modified - various tweaks
1319 and added internal method SetTable to set the reference
1322 * System.Data/DataSet.cs: modified - class was not
1325 * System.Data/DataTable.cs: modified - temporarily commented
1326 DataSet and DataView references - trying to compile a SqlDataReader,
1327 DataTable, and dependencies for a forward read-only result set.
1328 SqlDataAdapter, DataSet, and DataView will come later once we can get
1329 a forward read only result set working.
1331 * System.Data/IDataRecord.cs: modified - source code lines should
1334 * System.Data/InternalDataCollectionBase.cs: modified - started
1335 implementing this base class for collection of data rows,
1336 columns, tables, relations, and constraints
1338 * System.Data.SqlClient/SqlException.cs: modified -
1339 call base(message) so a unhandled exception displays
1340 the message of a SQL error instead of the
1341 default SystemException message
1343 * Test/TestSqlException.cs: modified -
1344 handle the rollback properly for a SqlException on a
1347 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1349 * System.Data.build: modified - added new
1350 files to exclude from build
1352 * System.Data/Constraint.cs
1353 * System.Data/ConstraintCollection.cs
1354 * System.Data/InternalDataCollectionBase.cs: added -
1355 stubs which are needed to build DataTable.cs
1357 * TODO: modified - added more classes TODO and
1358 added more stuff TODO, such as, create script
1359 to create test database monotestdb for testing
1360 classes in System.Data
1362 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1364 * System.Data.Common/DataAdapter.cs:
1365 * System.Data.Common/DataColumnMappingCollection.cs:
1366 * System.Data.Common/DataTableMappingCollection.cs:
1367 * System.Data.Common/DbDataPermission.cs:
1368 * System.Data.Common/DbDataPermissionAttribute.cs: some
1369 compilation errors fixed.
1371 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1373 * TODO: modified - added classes TODO, and
1374 a poor attempt at System.Data plan
1376 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1378 * ChangeLog: modified - put tabs where they belong
1380 * System.Data.SqlClient/SqlDataReader.cs
1381 * System.Data/DataColumn.cs: modified - compile errors
1382 trying to compile SqlDataAdapter and dependencies
1384 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1386 * System.Data.SqlTypes/SqlBoolean.cs
1387 * System.Data.SqlTypes/SqlCompareOptions.cs
1388 * System.Data.SqlTypes/SqlInt32.cs
1389 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1391 * System.Data/DataTable.cs
1392 * System.Data.SqlClient/SqlCommand.cs
1393 * System.Data.SqlClient/SqlConnection.cs
1394 * System.Data.SqlClient/SqlError.cs
1395 * System.Data.SqlClient/SqlTransaction.cs: modified -
1398 * System.Data.SqlClient/SqlException.cs: modified -
1399 missing Message on indexer for Message property
1401 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1403 * System.Data.SqlClient/SqlCommand.cs: modified - to
1404 compile using mcs. This problem is
1405 returning a stronger type in csc vs. msc
1407 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1408 can not do a using PGconn = IntPtr; and then declare
1409 with PGconn pgConn = IntPtr.Zero;
1410 Thiw works under csc though. Had to comment using and
1411 changed declaration to IntPtr pgConn = IntPtr.Zero;
1412 Also, got rid of compile warnings for hostaddr and port.
1414 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1415 rid of compile warnings. Commented MonoTODO attribute because mcs
1416 doesn't seem to work with C# array property indexer (Item)
1419 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1420 commented MonoTODO attribute for indexer for mcs compiling
1422 * Test/TestSqlIsolationLevel.cs:
1423 * Test/TestSqlInsert.cs:
1424 * Test/TestSqlException.cs: modified -
1425 removed extra ExecuteNonQuery which caused two inserted rows
1427 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1429 * System.Data/StateChangeEventArgs.cs - added
1430 needed to compile System.Data.dll with mcs.
1432 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1434 * System.Data.OleDb: added directory - for OleDb database
1437 * System.Data.SqlClient/SqlClientPermission.cs
1438 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1439 * System.Data.SqlClient/SqlCommandBuilder.cs
1440 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1441 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1442 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1443 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1444 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1445 * Test/TestSqlException.cs
1446 * Test/TestSqlIsolationLevel.cs: added - more tests
1448 * System.Data.build: modified - added new files - excludes these too
1450 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1452 * System.Data.SqlClient/SqlConnection.cs
1453 * System.Data.SqlClient/SqlCommand.cs
1454 * System.Data.SqlClient/SqlTransaction.cs
1455 * System.Data.SqlClient/SqlException.cs
1456 * System.Data.SqlClient/SqlErrorCollection.cs
1457 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1458 exception/error handling. SqlConnection(connectionString)
1459 constructor should not automatically connect.
1461 * System.Data.SqlClient/SqlDataReader.cs
1462 * System.Data.SqlClient/SqlDataAdapter.cs
1463 * System.Data.SqlClient/SqlParameter.cs
1464 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1465 added using System.ComponentModel;
1467 * Test/TestSqlInsert.cs: modified - to use transaction
1469 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1471 * System.Data/DataRow.cs: new skeletons.
1473 * System.Data.Common/DataAdapter.cs:
1474 * System.Data.Common/DataColumnMapping.cs:
1475 * System.Data.Common/DataColumnMappingCollection.cs:
1476 * System.Data.Common/DataTableMapping.cs:
1477 * System.Data.Common/DataTableMappingCollection.cs:
1478 * System.Data.Common/DbDataAdapter.cs:
1479 * System.Data.Common/RowUpdatedEventArgs.cs:
1480 * System.Data.SqlClient/SqlDataAdapter.cs:
1481 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1484 * System.Data.Common/DbDataRecord.cs:
1485 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1488 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1490 * Test/TestSqlInsert.cs: modified - do
1491 a SQL DELETE before SQL INSERT of row so you can use this
1494 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1495 IsolationLevel for PostgreSQL is ReadCommitted. However,
1496 PostgreSQL allows Serializable as well.
1497 (Thanks to Gonzalo for that!)
1499 * System.Data.SqlClient/SqlConnection.cs: modified
1500 * System.Data.SqlClient/SqlCommand.cs: modified
1501 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1502 working; however, we still need to implement SQL errors
1503 and exceptions to properly handle transactions. Also, added
1504 status and error message support from the PostgreSQL database.
1505 Currently, this does a Console.WriteLine() to display the
1506 status and error messages, but this is a TODO
1507 for SQL errors and exceptions.
1509 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1510 attribute for System.Data.dll assembly
1512 * System.Data/IDbCommand.cs: modified - commented
1513 overloaded method ExecuteReader
1514 so System.Data.SqlClient.SqlCommand can compile
1516 * System.Data/IDbCommand.cs: modified
1517 * System.Data/IDbConnection.cs: modified - added using System;
1518 * System.Data/IDataParameter.cs
1520 * System.Data.build: modified - build classes
1521 in System.Data.SqlClient and exclude others in System.Data
1523 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1524 parameter data type from IntPtr to enum ExecStatusType
1526 * ChangeLog: modified - corrected previous entries in log
1528 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1530 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1531 implementation. Still missing some stuff.
1533 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1535 * System.Data.SqlClient/SqlConnection.cs: modified - got
1536 to compile, run, and connect to PostgreSQL database
1538 * System.Data.SqlClient/SqlCommand.cs: modified - got
1539 to compile, run, and execute a SQL INSERT command
1540 which successfully inserted a row
1541 into the PostgreSQL database
1543 * System.Data.SqlClient/SqlTransaction.cs: modified
1544 * System.Data.SqlClient/SqlParameter.cs: modified
1545 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1546 * System.Data.SqlClient/SqlError.cs: modified
1547 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1548 * System.Data.SqlClient/SqlException.cs: modified
1549 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1551 * System.Data.SqlClient/SqlAdapter: modified
1552 * System.Data.SqlClient/SqlReader: modified - add more stubs
1554 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1556 * Test/TestSqlInsert.cs: added
1558 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1560 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1561 class SqlConnecition
1562 * System.Data.SqlClient/SqlErrorCollection.cs: added
1563 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1565 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1567 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1568 * System.Data.IDbTransaction: Added Interface to IDisposable.
1569 * System.Data.IDbCommand: Fixed Capitalization of class name.
1570 * System.Data.IDbConnection: Fixed Capitalization of class name.
1572 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1574 * System.Data.Common/DbDataPermissionAttribute.cs:
1575 * System.Data.Common/DataAdapter.cs:
1576 * System.Data.Common/DataColumnMapping.cs:
1577 * System.Data.Common/DbDataPermission.cs: added some implementation.
1579 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1581 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1582 syntax, as pointed out by Levent Camlibel.
1584 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1586 * System.Data.SqlTypes/SqlBinary.cs:
1587 * System.Data.SqlTypes/INullable.cs: new skeletons.
1589 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1591 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1592 contains all calls the the PostgreSQL client library, to be used
1593 everywhere in System.Data.SqlClient.
1595 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1597 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1600 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1602 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1604 * System.Data.Common/DbDataRecord.cs:
1605 * System.Data.Common/DbEnumerator.cs:
1606 * System.Data.Common/RowUpdatedEventArgs.cs:
1607 * System.Data.Common/RowUpdatingEventArgs.cs:
1608 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1610 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1612 * System.Data.Common/DataTableMappingCollection.cs:
1613 * System.Data.Common/DbDataAdapter.cs:
1614 * System.Data.Common/DbDataPermission.cs:
1615 * System.Data.Common/DataTableMapping.cs: new skeletons.
1617 * System.Data.SqlClient/SqlDataAdapter.cs:
1618 * System.Data.SqlClient/SqlDataReader.cs:
1619 * System.Data.SqlClient/SqlErrors.cs:
1620 * System.Data.SqlClient/SqlError.cs:
1621 * System.Data.SqlClient/SqlException.cs:
1622 * System.Data.SqlClient/SqlParameter.cs:
1623 * System.Data.SqlClient/SqlParameterCollection.cs:
1624 * System.Data.SqlClient/SqlTransaction.cs:
1625 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1627 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1629 * System.Data.Common/DataColumnMapping.cs:
1630 * System.Data.Common/DataColumnMappingCollection.cs:
1631 * System.Data.Common/DataAdapter.cs: created skeletons.
1633 * System.Data.build: exclude new directories from build.
1635 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1637 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1639 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1640 implemented (2 methods).
1642 2002-03-24 Duncan Mak <duncan@ximian.com>
1644 * System.Data.build: Excluded System.Data.SqlClient from the build.
1645 The stubs are incomplete and they are stopping the build.
1647 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1649 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1651 * System.Data.SqlClient/*: added skeletons for the SQL managed
1652 provider for ADO.Net, to be based initially in PostgreSQL.
1654 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1656 Changed the Namespace on some Enums from mono.System.Data to System.Data
1658 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1660 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1661 default name if the ColumnName is null.
1662 * DataSet.cs : Added
1663 * DataTable.cs : Added
1664 * DataRelationCollection.cs : Added
1665 * DataTableRelationCollection.cs : Added
1666 * DataColumn : Added
1668 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1670 * DataColumnChangeEventArgs.cs : Added
1671 * DataColumnCollection.cs : Added
1673 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1675 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1676 * Updated all Enums, Interfaces, and Delegates in System.Data