1 2002-08-25 Rodrigo Moya <rodrigo@ximian.com>
3 * System.Data.OleDb/OleDbTransaction.cs (OleDbTransaction): manage
4 correctly the isolation level.
5 (IsolationLevel): likewise.
6 (~OleDbTransaction): implemented.
8 * System.Data.OleDb/libgda.cs: added more needed stuff.
10 2002-08-22 Daniel Morgan <danmorg@sc.rr.com>
12 * System.Data.SqlClient/SqlParameter.cs: flush
14 * System.Data.SqlClient/SqlParameterCollection.cs: fixes
15 for the Item property, IndexOf, and Contains.
17 * Test/SqlSharpCli.cs: added input parameters support.
18 when a query is executed, if a parameter name matches
19 a SQL# internal variable name, it uses that value for the parameter; otherwise,
20 the user is prompted for the parameter value. Currently, it only supports
23 2002-08-21 Rodrigo Moya <rodrigo@ximian.com>
25 * System.Data.OleDb/libgda.cs: adapted to changes in libgda (get_vtype
26 and get_type for GdaValue).
28 * System.Data.OleDb/OleDbDataReader.cs: adapted to changes in
31 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
33 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
35 (Close): set the dataReader to null.
37 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
38 connection's DataReader property to this object.
39 (Close): set it to null here.
40 (Depth, IsDbNull): implemented.
41 (this): implemented the Item property with a string indexer.
43 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
44 ExecuteScalar): do nothing if there's already an open data reader.
46 * System.Data.OleDb/libgda.cs: more API functions.
48 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
49 reader before continuing.
51 2002-08-20 Franklin Wise <gracenote@earthlink.net>
53 * System.Data/System.Data.build: added nowarn:0679
55 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
56 setup to begin implementing. Implemented ctor().
58 * Tests: See System.Data\Test\ChangeLog
61 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
63 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
65 2002-08-19 Franklin Wise <gracenote@earthlink.net>
67 * Tests: See System.Data\Test\ChangeLog
69 * System.Data/UniqueConstraint.cs: More validation.
71 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
72 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
75 * System.Data/DataTable.cs: Added more MonoTODO tags
77 * class/System.Data/.cvsignore: added tmp & Temp
79 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
82 * System.Data/ConstraintCollection.cs: Commented out unused line.
84 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
86 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
88 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
90 (ErrorCode, Message, Source, Errors): implemented.
92 * System.Data.OleDb/OleDbError.cs: implemented the full class.
94 * System.Data.OleDb/libgda.cs: added more libgda functions.
96 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
97 the opened connection.
99 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
101 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
103 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
104 ArrayList after releasing the items.
105 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
106 GetOrdinal, GetString): implemented.
107 (GetDataTypeName): made it get the type from the data model, not from
108 the current value, which could not have been retrieved yet.
109 (GetValue): call the Get* method corresponding with the data type of
110 the requested column.
112 * System.Data.OleDb/libgda.cs: added more libgda functions.
113 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
115 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
116 titles via OleDbDataReader.GetName ().
117 (TestOleDb): create temporary table with a date field.
118 (InsertRow): set current date for the date field.
120 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
122 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
123 GetValue, which will take care of all the work needed.
124 (Close): implemented basic stuff.
125 (~OleDbDataReader): implemented.
127 * System.Data.OleDb/libgda.cs: added more needed functions.
129 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
131 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
133 (TestTransaction): added test for transactions.
135 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
137 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
139 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
140 when there are errors.
141 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
143 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
146 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
148 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
150 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
151 create an empty GdaParameterList.
153 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
154 for NULL before passing them to Marshal.PtrToStructure, which issues
155 an exception if the value is NULL.
157 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
159 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
160 unreachable code to avoid compiler warning.
162 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
164 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
165 (OpenReader): removed internal method.
167 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
168 the list of returned data models.
170 2002-08-15 Franklin Wise <gracenote@earthlink.net>
172 * System.Data/Constraint.cs: Added helper virtual functions
174 * System.Data/ConstraintCollection.cs: Improved constraint removal,
175 validation. Removed specific knowledge of subclasses of
178 * System.Data/DataColumn.cs: Added static helper function to compare
179 if two DataColumn arrays are the same.
181 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
183 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
186 2002-08-13 Franklin Wise <gracenote@earthlink.net>
188 * System.Data/DataRow.cs: Added several fixme tags.
190 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
192 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
193 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
194 to avoid compiler warnings.
196 2002-08-12 Franklin Wise <gracenote@earthlink.net>
198 * System.Data/Constraint.cs: Implemented
200 * System.Data/UniqueConstraint.cs: GetHashCode() &
201 special case Ctor. Still need to be implemented. LAMESPEC tags
204 * System.Data/ConstraintCollection.cs: Clear() &
205 AddRange() need to be finished. Several LAMESPEC tags.
207 * Allow Constraint collection to be created in DataTable.
209 * System.Data/ForeignKeyConstraint: Added a couple of
212 * System.Data/DataColumnCollection New/Added DataColumns now have
215 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
217 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
219 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
220 internal method, since we don't need it.
221 (ExecuteReader): call SetupGdaCommand before executing the command
222 via libgda functions.
223 (ExecuteScalar): implemented.
225 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
226 to OleDbCommand.OpenReader.
227 (GetBoolean): implemented.
229 2002-08-08 Franklin Wise <gracenote@earthlink.net>
231 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
233 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
235 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
238 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
240 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
241 and don't show a warning in Open.
243 * System.Data.OleDb/TestOleDb.cs: added Close.
245 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
247 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
248 ConnectionTimeout, ServerVersion, GdaConnection):
250 (OleDbConnection): call libgda.gda_init on constructor.
252 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
253 which wasn't been called.
255 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
258 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
260 * list: added missing System.Data.OleDb and
261 System.Data.Common files.
263 * System.Data.OleDb/ChangeLog: removed and merged with
264 System.Data's ChangeLog.
266 * System.Data.OleDb/OleDbDataAdapter.cs:
267 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
269 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
271 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
272 (IsClosed, Item, RecordsAffected): implemented some properties.
274 * libgda.cs: added GdaDataModel methods.
276 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
278 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
279 a second argument (ArrayList results).
280 (NextResult): implemented.
282 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
283 pass that to the OleDbDataReader.
284 (OleDbCommand constructor): don't create the ArrayList of results.
285 (GdaResults): removed property.
286 (ExecuteReader): create a temporary ArrayList and pass that to the
287 OleDbDataReader constructor.
289 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
291 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
292 (CreateParameter): implemented IDbCommand methods.
293 (CommandText): don't create many GdaCommand's, only one is needed.
294 (ExecuteNonQuery): set up the internal GDA command object.
295 (ExecuteReader): use correctly the unique GDA command object.
297 * System.Data.OleDb/libgda.cs: added new libgda calls.
299 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
301 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
302 (BeginTransaction): implemented IDbConnection methods.
304 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
306 * list: added System.Data.OleDb files to file list.
308 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
310 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
312 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
313 of the set method for this property.
315 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
316 (MissingSchemaAction): implemented.
318 2002-07-10 Tim Coleman <tim@timcoleman.com>
320 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
321 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
322 * System.Data.OleDb/OleDbError.cs: Added stubbs
323 * System.Data.OleDb/OleDbException.cs: Added stubbs
324 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
325 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
326 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
327 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
328 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
329 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
330 support transaction nesting
331 * System.Data.OleDb/libgda.cs: Added my name to this file
333 2002-07-09 Tim Coleman <tim@timcoleman.com>
335 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
336 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
337 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
338 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
339 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
340 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
341 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
342 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
343 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
344 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
345 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
346 * System.Data.OleDb/OleDbType.cs: Fixed two typos
347 * System.Data.OleDb/libgda.cs: Style changes, added new methods
349 2002-07-09 Tim Coleman <tim@timcoleman.com>
351 * System.Data.build: remove restriction on System.Data.OleDb build
353 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
355 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
356 IsSynchronized): implemented.
358 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
360 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
362 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
363 (Parameters, Transaction, Connection): made these overload
366 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
367 call m_list methods, not own ones.
369 * System.Data.OleDb/OleDbParameter.cs: more implementation.
371 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
373 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
374 Commit, Rollback): implemented.
375 (GdaConnection): added new internal property.
377 * System.Data.OleDb/OleDbParameter.cs:
378 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
381 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
383 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
385 * System.Data.OleDb/libgda.cs: added new libgda API functions.
387 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
388 (BeginTransaction): made it overload IDbConnection methods.
389 (ChangeDatabase): new stub, needs some work on libgda for being
392 (Close): implemented.
393 (CreateCommand): implemented.
394 (GetOleDbSchemaTable): new stub, until I understand what to do here.
395 (Open): implemented basic stuff, which is just supporting connection
396 strings that represent a GDA data source name. More to come.
397 (InfoMessage, StateChange): added events.
399 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
401 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
403 * System.Data.OleDb/libgda.cs: added static constructor.
404 (GdaClient): new static property to get the underlying GdaClient
407 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
408 the static 'libgda' class.
410 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
412 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
414 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
415 (ConnectionString, Connectiontimeout, Database, State):
416 implemented class properties.
417 (BeginTransaction): implemented.
419 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
421 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
423 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
425 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
427 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
429 * list: added missing PostgresTypes.cs file.
431 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
433 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
436 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
438 * System.Data.SqlClient/SqlConnection.cs: modifed -
439 start to implement the interfaces properly and
440 properly doing a Close(), Dispose(), and
443 * Test/SqlSharpCli.cs: modified -
444 add support for MySQL in Mono.Data.MySql
445 and OleDb support in System.Data.OleDb. However,
446 the OleDb support is commented right now.
447 When the program starts up, a shorter help menu should
448 display the most important commands: help and quit
450 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
452 * System.Data.build: exclude System.Data.OleDb files.
454 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
456 * System.Data.SqlClient/SqlCommand.cs: typo
457 should be CommandBehavior.KeyInfo
459 * Test/SqlSharpCli.cs: refactored and added a few more
462 2002-05-27 Tim Coleman <tim@timcoleman.com>
463 * list: update to compile properly (add missing
464 files and switch path delimiter from '\' to '/').
466 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
468 * System.Data/DataRow.cs
469 * System.Data.Common/DbDataAdapter.cs: fix to
470 get Test/TestSqlDataAdapter.cs to work again
472 * Test/TestSqlDataAdapter.cs: removed comment
473 about SqlDataReader:NextResult() not being implemented; it
476 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
478 * System.Data/DataRow.cs: modified
479 support setting of DBNull.Value
480 using the Item indexer this[DataColumn]
482 * System.Data.SqlClient/SqlCommand.cs: modified
483 tweaks to show TODO's for other CommandBehavior.
484 Set AllowDBNull column to true for IsKey row
487 * System.Data.SqlClient/SqlConnection.cs: modified
488 if transaction is in progress when a Close() is called,
489 do a transaction Rollback.
491 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
493 * Test/SqlSharpCli.cs: added file
494 My new toy. SQL# is a command-line tool to enter
495 SQL commands and queries using Mono System.Data.
496 It also serves as a test for Mono System.Data.
498 * System.Data.SqlClient/SqlCommand.cs: modified
499 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
500 should handle the results from SQL Commands and Queries.
501 - Internal class SqlResult should not create schema Table
502 for the result from a SQL Command. Also, set the RecordsRetrieved
503 property for SqlDataReader.
504 - Closing the SqlDataReader should Close() the SqlConnection for
505 a CommandBehavior.CloseConnection.
506 - Set defaults for SqlResult
508 * System.Data.SqlClient/SqlConnection.cs: modified -
509 when SqlDataReader is Close()
510 should Close() the SqlConnection for
511 a CommandBehavior.CloseConnection. Changed internal Property
512 from OpenReader get/set to IsReaderOpen get and created
513 internal methods OpenReader()/CloseReader() for SqlCommand to call.
514 SqlConnection needs to be prevented from doing while SqlDataReader
517 * System.Data.SqlClient/SqlDataReader.cs: modified -
518 call SqlCommand's OpenReader() internal method. get
519 RecordsRetrieved from SqlResult. set/reset default
520 values for SqlDataReader.
522 * Test/PostgresTest.cs
523 * Test/TestExecuteScalar.cs
524 * Test/TestSqlDataReader.cs: modified
525 for the Execute...() methods in SqlCommand
526 to test SQL Queries and Commands
528 * Test/System.Data_test.build: modified
529 exclude new file Test/SqlSharpCli.cs from
532 2002-05-24 Tim Coleman <tim@timcoleman.com>
533 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
534 for get accessors. These should be implemented in derived classes. See
535 SqlDataAdapter for clues.
536 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
537 * System.Data.Common/DataAdapter.cs:
538 * System.Data.Common/DataTableMappingCollection.cs:
539 * System.Data.Common/DataTableMapping.cs:
540 * System.Data.Common/DataColumnMappingCollection.cs:
541 * System.Data.Common/DataColumnMapping.cs:
542 Properly (I hope!) implement all of the appropriate interfaces
546 2002-05-23 Tim Coleman <tim@timcoleman.com>
547 * System.Data.SqlClient/SqlCommand.cs: include
548 the BaseColumnName in the schema table. Was missed before.
549 * System.Data.Common/DbDataAdapter.cs: Use DataTable
550 mappings so that the DataSet and DataTable are more closely tied.
551 Get schema information from the DataTable using GetSchemaTable ()
552 Various other little fixes
553 * System.Data.Common/DataColumnMappingCollection.cs:
554 * System.Data.Common/DataTableMapping.cs:
555 * System.Data.Common/DataTableMappingCollection.cs: Some
556 implementation, enough to be used by DbDataAdapter.
558 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
560 * System.Data.SqlClient/SqlCommand.cs: set
561 the "ProviderType" to the PostgreSQL type oid
563 * System.Data.SqlClient/SqlDataReader.cs: fix
564 for various properties and methods that
565 return meta data: Item indexers this[name] and this[index],
566 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
569 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
571 * System.Data/DataRow.cs: change suggested
572 by tim: in Item indexer, do an EndEdit()
574 * System.Data.SqlClient/SqlCommand.cs: more
575 fixes to SqlResult. After setting each item in
576 the DataRow, do an AcceptChanges() to commit
577 the changes in the DataRow. For DataType, use a Type
578 of System.String since System.Type nor System.Object
581 * Test/TestSqlDataReader.cs
582 * Test/PostgresTest.cs: updated to to be on
583 the way schema table is suppose to work
585 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
587 * System.Data.SqlClient/SqlCommand.cs: more work on
588 building the schema table
590 2002-05-22 Tim Coleman <tim@timcoleman.com>
591 * System.Data.SqlClient/SqlCommand.cs: preliminary work
592 on getting the schema table correctly built.
594 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
596 * System.Data.SqlClient/ParmUtil.cs: added file - to
597 provide utility for conversion of input parameters
599 * System.Data.SqlClient/PostgresTypes.cs: added file -
600 moved the PostgreHelper class to here. May eventually
601 move the internal class PostgresTypes that's inside the
602 SqlConnection to here as well.
603 Handling of PostgreSQL <-> .NET types need to be though
604 out more. Also, the PostgreHelper has a method to convert
605 from .NET types to a string which can be put into used in
606 an SQL statement to execute against a PostgreSQL database.
607 This is the beginnings of parameters support. It currently
608 only supports input parameters. Still need to do output,
609 input/output, and return parameters.
611 * Test/TestSqlParameters.cs: new test to test the input
612 parameters in System.Data.SqlClient against a
615 * System.Data.SqlClient/PostgresLibrary.cs: moved
616 PostgresHelper class to file PostgresTypes.cs. Also
617 moved struct PostgresType there too.
619 * System.Data.SqlClient/SqlCommand.cs: added input
622 * System.Data.SqlClient/SqlParameter.cs: got
625 * System.Data.SqlClient/SqlParameterCollection.cs: got
626 SqlParameterCollection to work
628 * Test/System.Data_test.build: added files to exclude
631 * System.Data.SqlClient/SqlConnection.cs: release resources
634 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
636 * System.Xml: added directory for classes with namespace
637 System.Xml to go into the System.Data.dll assembly
639 * System.Xml/XmlDataDocument: added file
640 for stubbed concrete class XmlDataDocument which
641 inherits from XmlDocument. Its purpose is to provide
642 a W3C XML DOM Document for relational data and interacting
645 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
647 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
648 Text, TableDirect, and StoredProcedure
650 * Test/PostgresTest.cs: changed call to version()
651 stored procedure to use the CommandType of StoredProcedure
653 * Test/TestSqlDataReader.cs: test all the CommandTypes
655 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
657 * System.Data.build: took out all excluded
658 files except the ones in the Test directory
659 because all files compile now. It does not
660 mean they all work or have implementations
663 * System.Data/DataRelationCollection.cs
664 * System.Data/DataTableRelationCollection.cs
665 * System.Data/InternalDataCollectionBase.cs
666 * System.Data.Common/DbDataPermission.cs
667 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
668 * System.Data.SqlClient/SqlClientPermission.cs
669 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
670 to get all System.Data* files to compile.
672 * System.Data.SqlClient/SqlCommand.cs: started coding
673 to prevent SqlConnection and SqlCommand from doing
674 anyting while fetching data using SqlDataReader. Also,
675 started coding to undo this prevention once the
676 SqlDataReader is closed.
678 * System.Data.SqlClient/SqlConnection.cs: get database server
679 version. Started coding to prevent connection from
680 doing anything while fetching data and undo once the reader
681 is closed. Include events SqlInfoMessage and StateChange.
683 * System.Data.SqlClient/SqlDataReader.cs: start coding to
684 prevent connection and command from doing anything while
685 fetching data, and undo when closed.
687 * Test/PostgresTest.cs: added test to get ServerVersion
688 property from SqlConnection
690 2002-05-18 Tim Coleman <tim@timcoleman.com>
691 * System.Data/DataRow.cs: More implementation,
692 as well as boundary checks and small semantic
695 2002-05-18 Tim Coleman <tim@timcoleman.com>
696 * System.Data/DataRow.cs: Try to reduce memory
697 usage by only creating the original and proposed
698 arrays as required in BeginEdit, and then destroying
699 proposed during EndEdit, and original during AcceptChanges.
700 * System.Data.Common/DbDataAdapter.cs: Make the
701 startRecord and maxRecords parameters work correctly.
703 2002-05-18 Tim Coleman <tim@timcoleman.com>
704 * System.Data/DataRow.cs: Move the null check in
705 ItemArray set to above the Invalid Cast check, so
706 that we don't get null reference exceptions.
708 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
710 * System.Data.SqlClient/PostgresLibrary.cs: handle
711 data value from database being NULL
713 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
714 allow multiple result sets. Added new internal class
715 SqlResult to pass result set data from SqlCommand
718 * System.Data.SqlClient/SqlDataReader.cs: allow
719 multiple result sets.
721 * System.Data.SqlClient/SqlConnection.cs: moved
722 things around. Implement IDisposable.
724 * Test/TestSqlDataReader.cs: test for execution
725 of multiple result sets and display the results
726 of these multiple results sets
728 * Test/TestSqlDataAdapter.cs: tweaks
730 2002-05-17 Tim Coleman <tim@timcoleman.com>
731 * System.Data.Common/DbDataAdapter.cs:
732 - More implementation of Fill methods
733 - Get rid of isDirty flag, because we can just check
735 - Do *not* remove DataTables before Filling them
736 - Implicitly open the connection before doing a Fill
737 if it does not exist.
738 * System.Data.SqlClient/SqlDataAdapter.cs:
740 * System.Data/DataTableCollection.cs:
741 - Add DataSet to internal, undocumented constructor
742 - When a table is created, set its DataSet property
743 - Default table name for creation is "Table1" (see .NET)
744 - Inherit the ArrayList list from InternalDataCollecitonBase
745 and maintain a hashtable between table names and
747 * System.Data/DataTable.cs:
748 - Add internal dataSet field. This is used by
749 DataTableCollection when the DataTable is constructed.
750 * System.Data/DataSet.cs:
751 - Pass a reference to the DataSet when constructing the
754 2002-05-16 Tim Coleman <tim@timcoleman.com>
755 * System.Data.Common/DbDataAdapter.cs:
756 Use table.Rows.Add (itemArray) instead of
757 table.Rows.Add (thisRow) to provide better
759 * System.Data/DataRowCollection.cs:
760 Some implementation of this class.
761 * System.Data/InternalDataCollectionBase.cs:
762 Some implementation. Most notably, this now
763 has an enumerator so we can use foreach (DataRow row in table.Rows)
765 * System.Data/DataTable.cs:
766 Since DataRowCollection now accepts a DataTable in
767 its internal constructor, we must pass one in.
769 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
771 * Test/TestSqlDataAdapter.cs: added new test
772 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
773 DataRowCollection, and DataRow. It tests retrieving data
774 based on a SQL SELECT query. This test is based on Tim Coleman's
777 2002-05-16 Tim Coleman <tim@timcoleman.com>
778 * System.Data.Common/DbDataAdapter.cs:
779 Use table.Rows.Add (thisRow) instead of
780 table.ImportRow (thisRow)
781 * System.Data/DataRowCollection.cs:
782 Construct the ArrayList before using it
784 2002-05-16 Tim Coleman <tim@timcoleman.com>
785 * System.Data/DataTable.cs:
786 Construct the DataRowCollection in the DataTable
787 constructor. Otherwise, it's a null reference.
789 2002-05-16 Tim Coleman <tim@timcoleman.com>
790 * System.Data.SqlClient/SqlDataReader.cs:
791 Modify GetValues to use Array.Copy() to copy
792 the results from fields to values, rather than
793 an assignment, which results in loss of data.
795 2002-05-16 Tim Coleman <tim@timcoleman.com>
796 * System.Data/DataRow.cs:
797 More implementation and documentation. It should
798 work more like expected, although there is no way
799 to demonstrate this well yet. DataTable requires
802 2002-05-15 Tim Coleman <tim@timcoleman.com>
803 * System.Data/DataRow.cs:
804 Minor tweaks as I determine exactly how to
805 implement this class.
808 2002-05-14 Duncan Mak <duncan@ximian.com>
810 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
812 2002-05-14 Tim Coleman
813 * System.Data/DataRow.cs:
814 * System.Data/DataRowBuilder.cs:
815 * System.Data/DataTable.cs:
816 More implementation of these classes. DataRow
817 can now (possibly) do some useful things.
818 Still not sure what DataRowBuilder is all about,
819 other than passing a DataTable in.
821 2002-05-14 Tim Coleman
822 * System.Data/DataRowBuilder.cs:
823 Add stubb for this internal class.
825 2002-05-13 Tim Coleman
826 * System.Data.Common/DbDataAdapter.cs:
827 The maxRecords check was not correct.
829 2002-05-13 Tim Coleman
830 * System.Data/DataTableCollection.cs:
831 Fix an issue when adding a DataTable and size == 0.
832 Now explicitly checks if size > 0 before doing Array.Copy ()
833 * System.Data.Common/DbDataAdapter.cs:
834 Move closer to a working implementation.
835 Make the IDbCommand fields protected so that they can
837 * System.Data.SqlClient/SqlDataAdapter.cs:
838 This should inherit the IDbCommands instead of having its
839 own. An explicit cast is used to force conversion between
840 IDbCommand and SqlCommand
842 2002-05-13 Tim Coleman
843 * System.Data.Common/DataTableMappingCollection.cs:
844 Some implementation to allow progress with DbDataAdapter
846 2002-05-13 Tim Coleman
847 * System.Data.Common/DbDataAdapter.cs:
848 Modify to not break compile.
850 2002-05-13 Tim Coleman
852 include SqlDataAdapter, SqlRowUpdatedEventArgs,
853 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
854 SqlRowUpdatingEventHandler in the build.
856 2002-05-13 Tim Coleman
857 * System.Data.Common/DbDataAdapter.cs:
859 * System.Data.Common/DataAdapter.cs:
860 Correction of some of the stubbing, as well as a
861 little bit more implementation
863 2002-05-11 Tim Coleman
864 * System.Data.SqlClient/SqlDataAdapter.cs:
865 * System.Data.Common/DbDataAdapter.cs:
866 Moved methods that weren't supposed to
867 be in SqlDataAdapter out. They should be implemented
871 2002-05-11 Tim Coleman
872 * System.Data.SqlClient/SqlDataAdapter.cs:
873 some implementation of this class. Note
874 that none of the functionality has been
875 tested yet, but I felt it should be checked
876 in at this point as it compiles.
877 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
878 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
879 Modified so that they will compile properly.
880 Needed to include SqlDataAdapter in the build.
882 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
884 * System.Data/DataTable.cs (Clear): implemented.
885 (DataTable): removed repeated code in constructors, and call the
886 basic constructor from the others.
888 * System.Data/DataColumn.cs: some tweaks.
890 * System.Data/DataRow.cs (RowState): implemented.
891 (CancelEdit): set rowState property back to Unchanged.
892 (RejectChanges): call CancelEdit.
893 (Delete): set rowState to Deleted.
895 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
897 * System.Data.build: added copy of System.Data.dll to Test directory
898 for easy testing. Also, added clean for it too.
900 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
901 from PostgreSQL data type to .NET type.
903 * System.Data.SqlClient/SqlDataReader.cs: beginnings
904 handling of a NULL value from the database
906 * Test/PostgresTest.cs: added tests for NULL values retrieved
909 * Test/ReadPostgresData.cs
910 * Test/TestExecuteScalar.cs
911 * Test/TestSqlDataReader.cs
912 * Test/TestSqlException.cs
913 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
914 "postgres". These tests may eventually be removed since they
917 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
919 * System.Data.build: removed reference to non-existant
920 TestDataColumn.cs file.
922 * System.Data/DataSet.cs: added some implementation.
924 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
926 * System.Data.SqlClient/PostgresLibrary.cs: got
927 PostgreSQL data types time, date, timestamp (DateTime like)
928 mapped to .NET System.DateTime working based
929 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
930 Also mapped pg type boolean to .net Boolean
932 * SqlClient/SqlConnection.cs: run SQL command to set
935 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
936 added tests for aggregates min(), max(), sum(), count(). could
937 not get avg() to work due to some formatting error; someone claimed
938 that it was my locale settings. added tests for SELECT of columns
939 of type boolean, float, double, date, time, and timestamp. They
940 have not been fully tested, but its a start.
942 2002-05-09 Tim Coleman <tim@timcoleman.com>
943 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
944 addition, subtraction, and multiplication for the
945 SqlDecimal type, as well as modification of some other
946 operations. More to come on this one.
948 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
950 * Test/System.Data_test.build: excluded TestDataColumn, which
951 should be replaced with a nunit test.
953 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
955 2002-05-07 Tim Coleman <tim@timcoleman.com>
969 Fix the broken build I made before. Bad
972 2002-05-07 Tim Coleman <tim@timcoleman.com>
974 Fix a symantic error I made in SqlString
975 Equals where I copied and pasted wrongly
977 2002-05-07 Tim Coleman <tim@timcoleman.com>
982 * SqlCompareOptions.cs:
993 Implement CompareTo, Equals, and String conversions
996 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
998 * Test/PostgresTest.cs: modified to run completely. There
999 are many TODOs in System.Data, so not all data types are
1000 included in the SELECT SQL query. Also, I made it to where
1002 using "host=localhost;dbname=test;user=postgres"
1003 instead of my userid and password. When more types are included,
1006 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
1008 * Test/PostgresTest.cs: added - ported
1009 libgda postgres-test.c originally by
1010 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
1013 2002-05-05 Tim Coleman <tim@timcoleman.com>
1014 * System.Data.SqlTypes/SqlBinary.cs:
1015 * System.Data.SqlTypes/SqlBoolean.cs:
1016 * System.Data.SqlTypes/SqlByte.cs:
1017 * System.Data.SqlTypes/SqlDateTime.cs:
1018 * System.Data.SqlTypes/SqlDecimal.cs:
1019 * System.Data.SqlTypes/SqlDouble.cs:
1020 * System.Data.SqlTypes/SqlGuid.cs:
1021 * System.Data.SqlTypes/SqlInt16.cs:
1022 * System.Data.SqlTypes/SqlInt32.cs:
1023 * System.Data.SqlTypes/SqlInt64.cs:
1024 * System.Data.SqlTypes/SqlMoney.cs:
1025 * System.Data.SqlTypes/SqlSingle.cs:
1026 * System.Data.SqlTypes/SqlString.cs:
1027 More implementation, and code clean-up for consistency.
1028 Also, I had implemented many conversions as explicit
1029 that should have been implicit. This should remove
1030 many of the red X's and green pluses from the
1031 System.Data.SqlTypes namespace.
1033 2002-05-05 Miguel de Icaza <miguel@ximian.com>
1035 * System.Data/DataSet.cs: Remove [Serializable] attributes from
1036 methods, those only apply to structs or classes.
1038 Stub out ISerializable, ISupportInitialize, and IListSource methods
1040 * System.Data/DataRowView.cs: Stub out interface methods for
1041 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
1043 * System.Data/DataView.cs: Comment out non-implemented
1046 * System.Data/DataViewSettingsCollection.cs: Type cast variables
1047 to the correct type to make it compile.
1049 * System.Data/DataViewSettings.cs: remove reference to
1050 non-existance type ApplyDefaultSort, it is a boolean.
1053 2002-05-05 Tim Coleman <tim@timcoleman.com>
1054 * System.Data.SqlTypes/SqlBinary.cs:
1055 * System.Data.SqlTypes/SqlBoolean.cs:
1056 * System.Data.SqlTypes/SqlByte.cs:
1057 * System.Data.SqlTypes/SqlDecimal.cs:
1058 * System.Data.SqlTypes/SqlDouble.cs:
1059 * System.Data.SqlTypes/SqlGuid.cs:
1060 * System.Data.SqlTypes/SqlInt16.cs:
1061 * System.Data.SqlTypes/SqlInt32.cs:
1062 * System.Data.SqlTypes/SqlInt64.cs:
1063 * System.Data.SqlTypes/SqlMoney.cs:
1064 * System.Data.SqlTypes/SqlSingle.cs:
1065 * System.Data.SqlTypes/SqlString.cs:
1066 Various fixes, including adding the SqlNullValueException
1067 when trying to retrieve the value of a null SqlType,
1068 and when casting values, a Null of type A converts to a
1071 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1073 * System.Data.SqlClient/PostgresLibrary.cs
1074 * System.Data.SqlClient/SqlCommand.cs
1075 * System.Data.SqlClient/SqlConnection.cs
1076 * System.Data.SqlClient/SqlDataReader.cs
1077 oid should not be hard coded because they
1078 can change from one version of PostgreSQL
1079 to the next. Use the typname's instead.
1080 The PostgreSQL type data retrieves
1081 at database connection time. Any unimplemented
1082 types just default to string. These were things
1083 suggested by Gonzalo.
1085 * Test/ReadPostgresData.cs - stuff
1086 * Test/TestSqlDataReader.cs - stuff
1088 * System.Data.SqlTypes/SqlInt32.cs - added a using
1090 2002-05-03 Tim Coleman <tim@timcoleman.com>
1091 * System.Data.build: Fix the build so that test depends on build
1093 2002-05-03 Tim Coleman <tim@timcoleman.com>
1094 * System.Data.SqlTypes/SqlByte.cs:
1095 * System.Data.SqlTypes/SqlDateTime.cs:
1096 * System.Data.SqlTypes/SqlDecimal.cs:
1097 * System.Data.SqlTypes/SqlDouble.cs:
1098 * System.Data.SqlTypes/SqlGuid.cs:
1099 * System.Data.SqlTypes/SqlInt16.cs:
1100 * System.Data.SqlTypes/SqlInt64.cs:
1101 * System.Data.SqlTypes/SqlMoney.cs:
1102 * System.Data.SqlTypes/SqlSingle.cs:
1103 These files were mysteriously excluded from the last
1104 patch I made and sent to Rodrigo
1105 * System.Data.build: include the System.Data.SqlTypes in the build
1107 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1109 * System.Data.build: removed comments
1111 * System.Data.SqlClient/PostgresLibrary.cs: changed
1112 the hard-coded PostgreSQL oid type int's to using an
1113 enum. Also, added PostgreSQL bpchar (character) type.
1115 * Test/TestSqlDataReader.cs: updated test
1116 to include new bpchar PostgreSQL type
1118 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1120 * System.Data.SqlTypes/SqlBinary.cs:
1121 * System.Data.SqlTypes/SqlBoolean.cs:
1122 * System.Data.SqlTypes/SqlInt32.cs:
1123 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1124 Tim Coleman <tcoleman@opentext.com>.
1126 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1128 * Test/TestExecuteScalar.cs: added test for
1129 method ExecuteScalar in class SqlCommand.
1131 * System.Data/DataColumnCollection.cs - it should
1132 inherit properties from base InternalDataCollectionBase
1133 and use them instead of overriding them, such as, List.
1135 * System.Data/DataColumn.cs
1136 * System.Data/DataTable.cs: tweaks to retrieve
1137 meta data from the database
1139 * System.Data.SqlClient/PostgresLibrary.cs -
1140 added method OidToType to convert PostgreSQL oid type
1141 to System.Type. Renamed method OidTypeToSystem
1142 to ConvertPgTypeToSystem for converting the data value
1143 from a PostgreSQL type to a .NET System type.
1145 * System.Data.SqlClient/SqlCommand.cs: implemented
1146 method ExecuteReader which returns a SqlDataReader
1147 for a light forward only read only result set.
1148 It works on types int4 ==> Int32 and
1149 varchar ==> String. Other types
1152 * System.Data.SqlClient/SqlConnection.cs: added comment
1154 * System.Data.SqlClient/SqlDataReader.cs: implemented
1155 class. It works, but still lots to do.
1157 * Test/ReadPostgresData.cs: stuff
1159 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1160 to display meta data and the data
1162 2002-05-03 Duncan Mak <duncan@ximian.com>
1164 * TODO: Took out all the Exceptions. They should be all done now.
1166 * System.Data/ConstraintException.cs:
1167 * System.Data/DBConcurrencyException.cs:
1168 * System.Data/DataException.cs:
1169 * System.Data/DeletedRowInaccessibleException.cs:
1170 * System.Data/DuplicateNameException.cs:
1171 * System.Data/EvaluateException.cs:
1172 * System.Data/InRowChangingEventException.cs:
1173 * System.Data/InvalidConstraintException.cs:
1174 * System.Data/InvalidExpressionException.cs:
1175 * System.Data/MissingPrimaryKeyException.cs:
1176 * System.Data/NoNullAllowedException.cs:
1177 * System.Data/ReadOnlyException.cs:
1178 * System.Data/RowNotInTableException.cs:
1179 * System.Data/StrongTypingException.cs:
1180 * System.Data/SyntaxErrorException.cs:
1181 * System.Data/TypeDataSetGeneratorException.cs:
1182 * System.Data/VersionNotFoundException.cs: Added to CVS.
1184 * System.Data.SqlTypes/SqlNullValueException.cs:
1185 * System.Data.SqlTypes/SqlTruncateException.cs:
1186 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1188 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1190 * System.Data/DataViewSettingCollection.cs: implemented.
1192 * System.Data/DataRowView.cs: new stubs.
1194 * System.Data.SqlTypes/SqlByte.cs:
1195 * System.Data.SqlTypes/SqlDateTime.cs:
1196 * System.Data.SqlTypes/SqlDecimal.cs:
1197 * System.Data.SqlTypes/SqlDouble.cs:
1198 * System.Data.SqlTypes/SqlGuid.cs:
1199 * System.Data.SqlTypes/SqlInt16.cs:
1200 * System.Data.SqlTypes/SqlInt64.cs:
1201 * System.Data.SqlTypes/SqlMoney.cs:
1202 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1203 by Tim Coleman <tcoleman@opentext.com>
1205 * System.Data.build: excluded newly-added files.
1207 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1209 * System.Data.SqlClient/PostgresLibrary.cs: included new
1210 internal class that will be a helper class in using
1211 PostgreSQL. PostgresLibrary is used for the
1212 pinvoke methods to the PostgreSQL Client
1213 native C library libpq while the class PostgresHelper
1214 is used for wrapper or helper methods. It currently only
1215 has one static method OidTypeToSystem in converting
1216 PostgreSQL types to .NET System.<type>s, such as,
1217 a PostgreSQL int8 becomes a .NET System.Int64.
1218 Only a few types have been added, such as, int2,
1219 int4, int8, varchar, text, bool, and char. Other types
1222 * System.Data.SqlClient/SqlCommand.cs: implemented
1223 method ExecuteScalar which allows us to do aggregate
1224 functions, such as, count, avg, min, max, and sum. We
1225 also are able to retrieve the result, convert it to the .NET type
1226 as an object. The user of the returned object must explicitly cast.
1228 * Test/ReadPostgresData.cs: updated sample
1229 to help us learn to retrieve data in System.Data.SqlClient
1232 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1234 * System.Data.build: added /nowarn: nnnn arguments
1235 so you will not get a ton of warnings. The warnings
1236 being excluded are: 1595, 0067, 0109, 0169, and 0649
1238 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1240 * System.Data.build: modified to exclude more
1241 files from the build
1243 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1245 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1248 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1249 by John Dugaw <jdugaw@unizenconsulting.com>.
1251 * System.Data.build: excluded new files from build.
1253 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1255 * Test/ReadPostgresData.cs: added - Uses the
1256 PostgresLibrary to retrieve a recordset.
1257 This is not meant to be used in Production, but as a
1258 learning aid in coding
1259 class System.Data.SqlClient.SqlDataReader.
1260 This sample does work.
1262 * Test/TestSqlDataReader.cs: added - used
1263 to test SqlDataReader (does not work yet)
1264 Forgot to add to ChangeLog on last commit.
1266 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1268 * System.Data/DataViewSetting.cs: new class.
1270 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1272 * System.Data/DataViewManager.cs: new class.
1274 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1275 don't have implementation.
1277 * System.Data.SqlTypes/SqlInt32.cs:
1278 * System.Data.SqlTypes/SqlString.cs:
1279 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1280 these are strctures.
1282 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1285 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1287 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1288 for correctly hiding parent class' members.
1289 (AddRange): use 'override' keyword on overriden method.
1291 (Contains): likewise.
1292 (IndexOf): likewise.
1293 (OnCollectionChanged): likewise.
1294 (OnCollectionChanging): likewise.
1295 (RemoveCore): likewise.
1297 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1299 * System.Data/DataSet.cs: added missing 'using's.
1301 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1303 * System.Data/DataSet.cs:
1304 * System.Data/DataTableCollection.cs:
1305 * System.Data/DataView.cs: compilation fixes on Linux.
1307 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1309 * System.Data/DataRelation.cs
1310 * System.Data/ForeignKeyConstraint.cs
1311 * System.Data/UniqueConstraint.cs: added more stubs
1313 * System.Data/DataTableRelationCollection.cs: added back to cvs
1314 and modified for compile errors. DataRelationCollection is an
1315 abstract class and there must be a class that implements for
1316 DataTable/DataSet. DataTableRelationCollection was changed
1317 to an internal class.
1319 * System.Data.build: modified - new files added
1320 also wanted to include files/classes in the build
1321 so we can get a compilable forward read only result set.
1322 It compiles now using csc/nant with warnings, but this
1323 is a start for adding functionality for the result set.
1324 Classes associated with/and DataSet are still excluded.
1326 * TODO: modified - updated to do list for System.Data
1328 * System.Data/Constraint.cs
1329 * System.Data/ConstraintCollection.cs
1330 * System.Data/DataRelationCollection.cs
1331 * System.Data/DataRow.cs
1332 * System.Data/DataRowChangeEventArgs.cs
1333 * System.Data/DataRowCollection.cs
1334 * System.Data/DataTable.cs
1335 * System.Data/DataTableCollection.cs
1336 * System.Data/InternalDataCollectionBase.cs
1337 * System.Data/PropertyCollection.cs: modified -
1338 changes to compile SqlDataReader/DataTable and
1341 * System.Data/IDbCommand.cs
1342 * System.Data.SqlClient/SqlCommand.cs: modified -
1343 un-commented overloaded methods ExecuteReader
1344 which returns a SqlDataReader
1346 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1348 * System.Data/DataTableCollection.cs: more implementation.
1349 (Count): added 'override' keyword, as pointer out by Martin.
1351 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1352 only call Array.Copy when there is really stuff to be copied.
1353 (CopyTo): don't create the temporary array, it's not needed.
1355 * System.Data.build: excluded newly added file from build.
1357 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1359 * System.Data/DataTableRelationCollection.cs: removed, it's not
1360 on MS SDK documentation.
1362 * System.Data/DataTableCollection.cs: new class.
1364 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1366 * System.Data/DataRowChangeEventArgs.cs
1367 * System.Data/DataRowCollection.cs
1368 * System.Data/DataView.cs
1369 * System.Data/PropertyCollection.cs: added new stubs
1371 * System.Data.build: modified - added new files to exclude
1374 * TODO: modified - removed files from TODO list
1375 that were stubbed above
1377 * System.Data/DataColumn.cs
1378 * System.Data/DataRow.cs: modified - various tweaks
1379 and added internal method SetTable to set the reference
1382 * System.Data/DataSet.cs: modified - class was not
1385 * System.Data/DataTable.cs: modified - temporarily commented
1386 DataSet and DataView references - trying to compile a SqlDataReader,
1387 DataTable, and dependencies for a forward read-only result set.
1388 SqlDataAdapter, DataSet, and DataView will come later once we can get
1389 a forward read only result set working.
1391 * System.Data/IDataRecord.cs: modified - source code lines should
1394 * System.Data/InternalDataCollectionBase.cs: modified - started
1395 implementing this base class for collection of data rows,
1396 columns, tables, relations, and constraints
1398 * System.Data.SqlClient/SqlException.cs: modified -
1399 call base(message) so a unhandled exception displays
1400 the message of a SQL error instead of the
1401 default SystemException message
1403 * Test/TestSqlException.cs: modified -
1404 handle the rollback properly for a SqlException on a
1407 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1409 * System.Data.build: modified - added new
1410 files to exclude from build
1412 * System.Data/Constraint.cs
1413 * System.Data/ConstraintCollection.cs
1414 * System.Data/InternalDataCollectionBase.cs: added -
1415 stubs which are needed to build DataTable.cs
1417 * TODO: modified - added more classes TODO and
1418 added more stuff TODO, such as, create script
1419 to create test database monotestdb for testing
1420 classes in System.Data
1422 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1424 * System.Data.Common/DataAdapter.cs:
1425 * System.Data.Common/DataColumnMappingCollection.cs:
1426 * System.Data.Common/DataTableMappingCollection.cs:
1427 * System.Data.Common/DbDataPermission.cs:
1428 * System.Data.Common/DbDataPermissionAttribute.cs: some
1429 compilation errors fixed.
1431 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1433 * TODO: modified - added classes TODO, and
1434 a poor attempt at System.Data plan
1436 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1438 * ChangeLog: modified - put tabs where they belong
1440 * System.Data.SqlClient/SqlDataReader.cs
1441 * System.Data/DataColumn.cs: modified - compile errors
1442 trying to compile SqlDataAdapter and dependencies
1444 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1446 * System.Data.SqlTypes/SqlBoolean.cs
1447 * System.Data.SqlTypes/SqlCompareOptions.cs
1448 * System.Data.SqlTypes/SqlInt32.cs
1449 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1451 * System.Data/DataTable.cs
1452 * System.Data.SqlClient/SqlCommand.cs
1453 * System.Data.SqlClient/SqlConnection.cs
1454 * System.Data.SqlClient/SqlError.cs
1455 * System.Data.SqlClient/SqlTransaction.cs: modified -
1458 * System.Data.SqlClient/SqlException.cs: modified -
1459 missing Message on indexer for Message property
1461 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1463 * System.Data.SqlClient/SqlCommand.cs: modified - to
1464 compile using mcs. This problem is
1465 returning a stronger type in csc vs. msc
1467 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1468 can not do a using PGconn = IntPtr; and then declare
1469 with PGconn pgConn = IntPtr.Zero;
1470 Thiw works under csc though. Had to comment using and
1471 changed declaration to IntPtr pgConn = IntPtr.Zero;
1472 Also, got rid of compile warnings for hostaddr and port.
1474 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1475 rid of compile warnings. Commented MonoTODO attribute because mcs
1476 doesn't seem to work with C# array property indexer (Item)
1479 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1480 commented MonoTODO attribute for indexer for mcs compiling
1482 * Test/TestSqlIsolationLevel.cs:
1483 * Test/TestSqlInsert.cs:
1484 * Test/TestSqlException.cs: modified -
1485 removed extra ExecuteNonQuery which caused two inserted rows
1487 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1489 * System.Data/StateChangeEventArgs.cs - added
1490 needed to compile System.Data.dll with mcs.
1492 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1494 * System.Data.OleDb: added directory - for OleDb database
1497 * System.Data.SqlClient/SqlClientPermission.cs
1498 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1499 * System.Data.SqlClient/SqlCommandBuilder.cs
1500 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1501 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1502 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1503 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1504 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1505 * Test/TestSqlException.cs
1506 * Test/TestSqlIsolationLevel.cs: added - more tests
1508 * System.Data.build: modified - added new files - excludes these too
1510 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1512 * System.Data.SqlClient/SqlConnection.cs
1513 * System.Data.SqlClient/SqlCommand.cs
1514 * System.Data.SqlClient/SqlTransaction.cs
1515 * System.Data.SqlClient/SqlException.cs
1516 * System.Data.SqlClient/SqlErrorCollection.cs
1517 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1518 exception/error handling. SqlConnection(connectionString)
1519 constructor should not automatically connect.
1521 * System.Data.SqlClient/SqlDataReader.cs
1522 * System.Data.SqlClient/SqlDataAdapter.cs
1523 * System.Data.SqlClient/SqlParameter.cs
1524 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1525 added using System.ComponentModel;
1527 * Test/TestSqlInsert.cs: modified - to use transaction
1529 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1531 * System.Data/DataRow.cs: new skeletons.
1533 * System.Data.Common/DataAdapter.cs:
1534 * System.Data.Common/DataColumnMapping.cs:
1535 * System.Data.Common/DataColumnMappingCollection.cs:
1536 * System.Data.Common/DataTableMapping.cs:
1537 * System.Data.Common/DataTableMappingCollection.cs:
1538 * System.Data.Common/DbDataAdapter.cs:
1539 * System.Data.Common/RowUpdatedEventArgs.cs:
1540 * System.Data.SqlClient/SqlDataAdapter.cs:
1541 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1544 * System.Data.Common/DbDataRecord.cs:
1545 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1548 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1550 * Test/TestSqlInsert.cs: modified - do
1551 a SQL DELETE before SQL INSERT of row so you can use this
1554 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1555 IsolationLevel for PostgreSQL is ReadCommitted. However,
1556 PostgreSQL allows Serializable as well.
1557 (Thanks to Gonzalo for that!)
1559 * System.Data.SqlClient/SqlConnection.cs: modified
1560 * System.Data.SqlClient/SqlCommand.cs: modified
1561 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1562 working; however, we still need to implement SQL errors
1563 and exceptions to properly handle transactions. Also, added
1564 status and error message support from the PostgreSQL database.
1565 Currently, this does a Console.WriteLine() to display the
1566 status and error messages, but this is a TODO
1567 for SQL errors and exceptions.
1569 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1570 attribute for System.Data.dll assembly
1572 * System.Data/IDbCommand.cs: modified - commented
1573 overloaded method ExecuteReader
1574 so System.Data.SqlClient.SqlCommand can compile
1576 * System.Data/IDbCommand.cs: modified
1577 * System.Data/IDbConnection.cs: modified - added using System;
1578 * System.Data/IDataParameter.cs
1580 * System.Data.build: modified - build classes
1581 in System.Data.SqlClient and exclude others in System.Data
1583 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1584 parameter data type from IntPtr to enum ExecStatusType
1586 * ChangeLog: modified - corrected previous entries in log
1588 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1590 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1591 implementation. Still missing some stuff.
1593 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1595 * System.Data.SqlClient/SqlConnection.cs: modified - got
1596 to compile, run, and connect to PostgreSQL database
1598 * System.Data.SqlClient/SqlCommand.cs: modified - got
1599 to compile, run, and execute a SQL INSERT command
1600 which successfully inserted a row
1601 into the PostgreSQL database
1603 * System.Data.SqlClient/SqlTransaction.cs: modified
1604 * System.Data.SqlClient/SqlParameter.cs: modified
1605 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1606 * System.Data.SqlClient/SqlError.cs: modified
1607 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1608 * System.Data.SqlClient/SqlException.cs: modified
1609 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1611 * System.Data.SqlClient/SqlAdapter: modified
1612 * System.Data.SqlClient/SqlReader: modified - add more stubs
1614 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1616 * Test/TestSqlInsert.cs: added
1618 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1620 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1621 class SqlConnecition
1622 * System.Data.SqlClient/SqlErrorCollection.cs: added
1623 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1625 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1627 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1628 * System.Data.IDbTransaction: Added Interface to IDisposable.
1629 * System.Data.IDbCommand: Fixed Capitalization of class name.
1630 * System.Data.IDbConnection: Fixed Capitalization of class name.
1632 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1634 * System.Data.Common/DbDataPermissionAttribute.cs:
1635 * System.Data.Common/DataAdapter.cs:
1636 * System.Data.Common/DataColumnMapping.cs:
1637 * System.Data.Common/DbDataPermission.cs: added some implementation.
1639 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1641 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1642 syntax, as pointed out by Levent Camlibel.
1644 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1646 * System.Data.SqlTypes/SqlBinary.cs:
1647 * System.Data.SqlTypes/INullable.cs: new skeletons.
1649 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1651 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1652 contains all calls the the PostgreSQL client library, to be used
1653 everywhere in System.Data.SqlClient.
1655 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1657 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1660 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1662 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1664 * System.Data.Common/DbDataRecord.cs:
1665 * System.Data.Common/DbEnumerator.cs:
1666 * System.Data.Common/RowUpdatedEventArgs.cs:
1667 * System.Data.Common/RowUpdatingEventArgs.cs:
1668 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1670 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1672 * System.Data.Common/DataTableMappingCollection.cs:
1673 * System.Data.Common/DbDataAdapter.cs:
1674 * System.Data.Common/DbDataPermission.cs:
1675 * System.Data.Common/DataTableMapping.cs: new skeletons.
1677 * System.Data.SqlClient/SqlDataAdapter.cs:
1678 * System.Data.SqlClient/SqlDataReader.cs:
1679 * System.Data.SqlClient/SqlErrors.cs:
1680 * System.Data.SqlClient/SqlError.cs:
1681 * System.Data.SqlClient/SqlException.cs:
1682 * System.Data.SqlClient/SqlParameter.cs:
1683 * System.Data.SqlClient/SqlParameterCollection.cs:
1684 * System.Data.SqlClient/SqlTransaction.cs:
1685 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1687 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1689 * System.Data.Common/DataColumnMapping.cs:
1690 * System.Data.Common/DataColumnMappingCollection.cs:
1691 * System.Data.Common/DataAdapter.cs: created skeletons.
1693 * System.Data.build: exclude new directories from build.
1695 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1697 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1699 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1700 implemented (2 methods).
1702 2002-03-24 Duncan Mak <duncan@ximian.com>
1704 * System.Data.build: Excluded System.Data.SqlClient from the build.
1705 The stubs are incomplete and they are stopping the build.
1707 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1709 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1711 * System.Data.SqlClient/*: added skeletons for the SQL managed
1712 provider for ADO.Net, to be based initially in PostgreSQL.
1714 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1716 Changed the Namespace on some Enums from mono.System.Data to System.Data
1718 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1720 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1721 default name if the ColumnName is null.
1722 * DataSet.cs : Added
1723 * DataTable.cs : Added
1724 * DataRelationCollection.cs : Added
1725 * DataTableRelationCollection.cs : Added
1726 * DataColumn : Added
1728 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1730 * DataColumnChangeEventArgs.cs : Added
1731 * DataColumnCollection.cs : Added
1733 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1735 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1736 * Updated all Enums, Interfaces, and Delegates in System.Data