1 2002-08-22 Daniel Morgan <danmorg@sc.rr.com>
3 * System.Data.SqlClient/SqlParameter.cs: flush
5 * System.Data.SqlClient/SqlParameterCollection.cs: fixes
6 for the Item property, IndexOf, and Contains.
8 * Test/SqlSharpCli.cs: added input parameters support.
9 when a query is executed, if a parameter name matches
10 a SQL# internal variable name, it uses that value for the parameter; otherwise,
11 the user is prompted for the parameter value. Currently, it only supports
14 2002-08-21 Rodrigo Moya <rodrigo@ximian.com>
16 * System.Data.OleDb/libgda.cs: adapted to changes in libgda (get_vtype
17 and get_type for GdaValue).
19 * System.Data.OleDb/OleDbDataReader.cs: adapted to changes in
22 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
24 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
26 (Close): set the dataReader to null.
28 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
29 connection's DataReader property to this object.
30 (Close): set it to null here.
31 (Depth, IsDbNull): implemented.
32 (this): implemented the Item property with a string indexer.
34 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
35 ExecuteScalar): do nothing if there's already an open data reader.
37 * System.Data.OleDb/libgda.cs: more API functions.
39 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
40 reader before continuing.
42 2002-08-20 Franklin Wise <gracenote@earthlink.net>
44 * System.Data/System.Data.build: added nowarn:0679
46 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
47 setup to begin implementing. Implemented ctor().
49 * Tests: See System.Data\Test\ChangeLog
52 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
54 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
56 2002-08-19 Franklin Wise <gracenote@earthlink.net>
58 * Tests: See System.Data\Test\ChangeLog
60 * System.Data/UniqueConstraint.cs: More validation.
62 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
63 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
66 * System.Data/DataTable.cs: Added more MonoTODO tags
68 * class/System.Data/.cvsignore: added tmp & Temp
70 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
73 * System.Data/ConstraintCollection.cs: Commented out unused line.
75 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
77 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
79 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
81 (ErrorCode, Message, Source, Errors): implemented.
83 * System.Data.OleDb/OleDbError.cs: implemented the full class.
85 * System.Data.OleDb/libgda.cs: added more libgda functions.
87 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
88 the opened connection.
90 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
92 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
94 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
95 ArrayList after releasing the items.
96 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
97 GetOrdinal, GetString): implemented.
98 (GetDataTypeName): made it get the type from the data model, not from
99 the current value, which could not have been retrieved yet.
100 (GetValue): call the Get* method corresponding with the data type of
101 the requested column.
103 * System.Data.OleDb/libgda.cs: added more libgda functions.
104 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
106 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
107 titles via OleDbDataReader.GetName ().
108 (TestOleDb): create temporary table with a date field.
109 (InsertRow): set current date for the date field.
111 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
113 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
114 GetValue, which will take care of all the work needed.
115 (Close): implemented basic stuff.
116 (~OleDbDataReader): implemented.
118 * System.Data.OleDb/libgda.cs: added more needed functions.
120 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
122 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
124 (TestTransaction): added test for transactions.
126 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
128 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
130 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
131 when there are errors.
132 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
134 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
137 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
139 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
141 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
142 create an empty GdaParameterList.
144 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
145 for NULL before passing them to Marshal.PtrToStructure, which issues
146 an exception if the value is NULL.
148 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
150 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
151 unreachable code to avoid compiler warning.
153 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
155 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
156 (OpenReader): removed internal method.
158 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
159 the list of returned data models.
161 2002-08-15 Franklin Wise <gracenote@earthlink.net>
163 * System.Data/Constraint.cs: Added helper virtual functions
165 * System.Data/ConstraintCollection.cs: Improved constraint removal,
166 validation. Removed specific knowledge of subclasses of
169 * System.Data/DataColumn.cs: Added static helper function to compare
170 if two DataColumn arrays are the same.
172 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
174 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
177 2002-08-13 Franklin Wise <gracenote@earthlink.net>
179 * System.Data/DataRow.cs: Added several fixme tags.
181 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
183 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
184 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
185 to avoid compiler warnings.
187 2002-08-12 Franklin Wise <gracenote@earthlink.net>
189 * System.Data/Constraint.cs: Implemented
191 * System.Data/UniqueConstraint.cs: GetHashCode() &
192 special case Ctor. Still need to be implemented. LAMESPEC tags
195 * System.Data/ConstraintCollection.cs: Clear() &
196 AddRange() need to be finished. Several LAMESPEC tags.
198 * Allow Constraint collection to be created in DataTable.
200 * System.Data/ForeignKeyConstraint: Added a couple of
203 * System.Data/DataColumnCollection New/Added DataColumns now have
206 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
208 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
210 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
211 internal method, since we don't need it.
212 (ExecuteReader): call SetupGdaCommand before executing the command
213 via libgda functions.
214 (ExecuteScalar): implemented.
216 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
217 to OleDbCommand.OpenReader.
218 (GetBoolean): implemented.
220 2002-08-08 Franklin Wise <gracenote@earthlink.net>
222 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
224 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
226 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
229 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
231 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
232 and don't show a warning in Open.
234 * System.Data.OleDb/TestOleDb.cs: added Close.
236 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
238 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
239 ConnectionTimeout, ServerVersion, GdaConnection):
241 (OleDbConnection): call libgda.gda_init on constructor.
243 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
244 which wasn't been called.
246 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
249 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
251 * list: added missing System.Data.OleDb and
252 System.Data.Common files.
254 * System.Data.OleDb/ChangeLog: removed and merged with
255 System.Data's ChangeLog.
257 * System.Data.OleDb/OleDbDataAdapter.cs:
258 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
260 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
262 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
263 (IsClosed, Item, RecordsAffected): implemented some properties.
265 * libgda.cs: added GdaDataModel methods.
267 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
269 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
270 a second argument (ArrayList results).
271 (NextResult): implemented.
273 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
274 pass that to the OleDbDataReader.
275 (OleDbCommand constructor): don't create the ArrayList of results.
276 (GdaResults): removed property.
277 (ExecuteReader): create a temporary ArrayList and pass that to the
278 OleDbDataReader constructor.
280 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
282 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
283 (CreateParameter): implemented IDbCommand methods.
284 (CommandText): don't create many GdaCommand's, only one is needed.
285 (ExecuteNonQuery): set up the internal GDA command object.
286 (ExecuteReader): use correctly the unique GDA command object.
288 * System.Data.OleDb/libgda.cs: added new libgda calls.
290 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
292 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
293 (BeginTransaction): implemented IDbConnection methods.
295 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
297 * list: added System.Data.OleDb files to file list.
299 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
301 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
303 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
304 of the set method for this property.
306 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
307 (MissingSchemaAction): implemented.
309 2002-07-10 Tim Coleman <tim@timcoleman.com>
311 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
312 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
313 * System.Data.OleDb/OleDbError.cs: Added stubbs
314 * System.Data.OleDb/OleDbException.cs: Added stubbs
315 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
316 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
317 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
318 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
319 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
320 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
321 support transaction nesting
322 * System.Data.OleDb/libgda.cs: Added my name to this file
324 2002-07-09 Tim Coleman <tim@timcoleman.com>
326 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
327 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
328 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
329 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
330 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
331 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
332 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
333 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
334 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
335 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
336 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
337 * System.Data.OleDb/OleDbType.cs: Fixed two typos
338 * System.Data.OleDb/libgda.cs: Style changes, added new methods
340 2002-07-09 Tim Coleman <tim@timcoleman.com>
342 * System.Data.build: remove restriction on System.Data.OleDb build
344 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
346 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
347 IsSynchronized): implemented.
349 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
351 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
353 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
354 (Parameters, Transaction, Connection): made these overload
357 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
358 call m_list methods, not own ones.
360 * System.Data.OleDb/OleDbParameter.cs: more implementation.
362 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
364 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
365 Commit, Rollback): implemented.
366 (GdaConnection): added new internal property.
368 * System.Data.OleDb/OleDbParameter.cs:
369 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
372 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
374 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
376 * System.Data.OleDb/libgda.cs: added new libgda API functions.
378 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
379 (BeginTransaction): made it overload IDbConnection methods.
380 (ChangeDatabase): new stub, needs some work on libgda for being
383 (Close): implemented.
384 (CreateCommand): implemented.
385 (GetOleDbSchemaTable): new stub, until I understand what to do here.
386 (Open): implemented basic stuff, which is just supporting connection
387 strings that represent a GDA data source name. More to come.
388 (InfoMessage, StateChange): added events.
390 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
392 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
394 * System.Data.OleDb/libgda.cs: added static constructor.
395 (GdaClient): new static property to get the underlying GdaClient
398 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
399 the static 'libgda' class.
401 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
403 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
405 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
406 (ConnectionString, Connectiontimeout, Database, State):
407 implemented class properties.
408 (BeginTransaction): implemented.
410 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
412 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
414 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
416 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
418 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
420 * list: added missing PostgresTypes.cs file.
422 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
424 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
427 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
429 * System.Data.SqlClient/SqlConnection.cs: modifed -
430 start to implement the interfaces properly and
431 properly doing a Close(), Dispose(), and
434 * Test/SqlSharpCli.cs: modified -
435 add support for MySQL in Mono.Data.MySql
436 and OleDb support in System.Data.OleDb. However,
437 the OleDb support is commented right now.
438 When the program starts up, a shorter help menu should
439 display the most important commands: help and quit
441 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
443 * System.Data.build: exclude System.Data.OleDb files.
445 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
447 * System.Data.SqlClient/SqlCommand.cs: typo
448 should be CommandBehavior.KeyInfo
450 * Test/SqlSharpCli.cs: refactored and added a few more
453 2002-05-27 Tim Coleman <tim@timcoleman.com>
454 * list: update to compile properly (add missing
455 files and switch path delimiter from '\' to '/').
457 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
459 * System.Data/DataRow.cs
460 * System.Data.Common/DbDataAdapter.cs: fix to
461 get Test/TestSqlDataAdapter.cs to work again
463 * Test/TestSqlDataAdapter.cs: removed comment
464 about SqlDataReader:NextResult() not being implemented; it
467 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
469 * System.Data/DataRow.cs: modified
470 support setting of DBNull.Value
471 using the Item indexer this[DataColumn]
473 * System.Data.SqlClient/SqlCommand.cs: modified
474 tweaks to show TODO's for other CommandBehavior.
475 Set AllowDBNull column to true for IsKey row
478 * System.Data.SqlClient/SqlConnection.cs: modified
479 if transaction is in progress when a Close() is called,
480 do a transaction Rollback.
482 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
484 * Test/SqlSharpCli.cs: added file
485 My new toy. SQL# is a command-line tool to enter
486 SQL commands and queries using Mono System.Data.
487 It also serves as a test for Mono System.Data.
489 * System.Data.SqlClient/SqlCommand.cs: modified
490 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
491 should handle the results from SQL Commands and Queries.
492 - Internal class SqlResult should not create schema Table
493 for the result from a SQL Command. Also, set the RecordsRetrieved
494 property for SqlDataReader.
495 - Closing the SqlDataReader should Close() the SqlConnection for
496 a CommandBehavior.CloseConnection.
497 - Set defaults for SqlResult
499 * System.Data.SqlClient/SqlConnection.cs: modified -
500 when SqlDataReader is Close()
501 should Close() the SqlConnection for
502 a CommandBehavior.CloseConnection. Changed internal Property
503 from OpenReader get/set to IsReaderOpen get and created
504 internal methods OpenReader()/CloseReader() for SqlCommand to call.
505 SqlConnection needs to be prevented from doing while SqlDataReader
508 * System.Data.SqlClient/SqlDataReader.cs: modified -
509 call SqlCommand's OpenReader() internal method. get
510 RecordsRetrieved from SqlResult. set/reset default
511 values for SqlDataReader.
513 * Test/PostgresTest.cs
514 * Test/TestExecuteScalar.cs
515 * Test/TestSqlDataReader.cs: modified
516 for the Execute...() methods in SqlCommand
517 to test SQL Queries and Commands
519 * Test/System.Data_test.build: modified
520 exclude new file Test/SqlSharpCli.cs from
523 2002-05-24 Tim Coleman <tim@timcoleman.com>
524 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
525 for get accessors. These should be implemented in derived classes. See
526 SqlDataAdapter for clues.
527 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
528 * System.Data.Common/DataAdapter.cs:
529 * System.Data.Common/DataTableMappingCollection.cs:
530 * System.Data.Common/DataTableMapping.cs:
531 * System.Data.Common/DataColumnMappingCollection.cs:
532 * System.Data.Common/DataColumnMapping.cs:
533 Properly (I hope!) implement all of the appropriate interfaces
537 2002-05-23 Tim Coleman <tim@timcoleman.com>
538 * System.Data.SqlClient/SqlCommand.cs: include
539 the BaseColumnName in the schema table. Was missed before.
540 * System.Data.Common/DbDataAdapter.cs: Use DataTable
541 mappings so that the DataSet and DataTable are more closely tied.
542 Get schema information from the DataTable using GetSchemaTable ()
543 Various other little fixes
544 * System.Data.Common/DataColumnMappingCollection.cs:
545 * System.Data.Common/DataTableMapping.cs:
546 * System.Data.Common/DataTableMappingCollection.cs: Some
547 implementation, enough to be used by DbDataAdapter.
549 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
551 * System.Data.SqlClient/SqlCommand.cs: set
552 the "ProviderType" to the PostgreSQL type oid
554 * System.Data.SqlClient/SqlDataReader.cs: fix
555 for various properties and methods that
556 return meta data: Item indexers this[name] and this[index],
557 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
560 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
562 * System.Data/DataRow.cs: change suggested
563 by tim: in Item indexer, do an EndEdit()
565 * System.Data.SqlClient/SqlCommand.cs: more
566 fixes to SqlResult. After setting each item in
567 the DataRow, do an AcceptChanges() to commit
568 the changes in the DataRow. For DataType, use a Type
569 of System.String since System.Type nor System.Object
572 * Test/TestSqlDataReader.cs
573 * Test/PostgresTest.cs: updated to to be on
574 the way schema table is suppose to work
576 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
578 * System.Data.SqlClient/SqlCommand.cs: more work on
579 building the schema table
581 2002-05-22 Tim Coleman <tim@timcoleman.com>
582 * System.Data.SqlClient/SqlCommand.cs: preliminary work
583 on getting the schema table correctly built.
585 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
587 * System.Data.SqlClient/ParmUtil.cs: added file - to
588 provide utility for conversion of input parameters
590 * System.Data.SqlClient/PostgresTypes.cs: added file -
591 moved the PostgreHelper class to here. May eventually
592 move the internal class PostgresTypes that's inside the
593 SqlConnection to here as well.
594 Handling of PostgreSQL <-> .NET types need to be though
595 out more. Also, the PostgreHelper has a method to convert
596 from .NET types to a string which can be put into used in
597 an SQL statement to execute against a PostgreSQL database.
598 This is the beginnings of parameters support. It currently
599 only supports input parameters. Still need to do output,
600 input/output, and return parameters.
602 * Test/TestSqlParameters.cs: new test to test the input
603 parameters in System.Data.SqlClient against a
606 * System.Data.SqlClient/PostgresLibrary.cs: moved
607 PostgresHelper class to file PostgresTypes.cs. Also
608 moved struct PostgresType there too.
610 * System.Data.SqlClient/SqlCommand.cs: added input
613 * System.Data.SqlClient/SqlParameter.cs: got
616 * System.Data.SqlClient/SqlParameterCollection.cs: got
617 SqlParameterCollection to work
619 * Test/System.Data_test.build: added files to exclude
622 * System.Data.SqlClient/SqlConnection.cs: release resources
625 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
627 * System.Xml: added directory for classes with namespace
628 System.Xml to go into the System.Data.dll assembly
630 * System.Xml/XmlDataDocument: added file
631 for stubbed concrete class XmlDataDocument which
632 inherits from XmlDocument. Its purpose is to provide
633 a W3C XML DOM Document for relational data and interacting
636 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
638 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
639 Text, TableDirect, and StoredProcedure
641 * Test/PostgresTest.cs: changed call to version()
642 stored procedure to use the CommandType of StoredProcedure
644 * Test/TestSqlDataReader.cs: test all the CommandTypes
646 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
648 * System.Data.build: took out all excluded
649 files except the ones in the Test directory
650 because all files compile now. It does not
651 mean they all work or have implementations
654 * System.Data/DataRelationCollection.cs
655 * System.Data/DataTableRelationCollection.cs
656 * System.Data/InternalDataCollectionBase.cs
657 * System.Data.Common/DbDataPermission.cs
658 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
659 * System.Data.SqlClient/SqlClientPermission.cs
660 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
661 to get all System.Data* files to compile.
663 * System.Data.SqlClient/SqlCommand.cs: started coding
664 to prevent SqlConnection and SqlCommand from doing
665 anyting while fetching data using SqlDataReader. Also,
666 started coding to undo this prevention once the
667 SqlDataReader is closed.
669 * System.Data.SqlClient/SqlConnection.cs: get database server
670 version. Started coding to prevent connection from
671 doing anything while fetching data and undo once the reader
672 is closed. Include events SqlInfoMessage and StateChange.
674 * System.Data.SqlClient/SqlDataReader.cs: start coding to
675 prevent connection and command from doing anything while
676 fetching data, and undo when closed.
678 * Test/PostgresTest.cs: added test to get ServerVersion
679 property from SqlConnection
681 2002-05-18 Tim Coleman <tim@timcoleman.com>
682 * System.Data/DataRow.cs: More implementation,
683 as well as boundary checks and small semantic
686 2002-05-18 Tim Coleman <tim@timcoleman.com>
687 * System.Data/DataRow.cs: Try to reduce memory
688 usage by only creating the original and proposed
689 arrays as required in BeginEdit, and then destroying
690 proposed during EndEdit, and original during AcceptChanges.
691 * System.Data.Common/DbDataAdapter.cs: Make the
692 startRecord and maxRecords parameters work correctly.
694 2002-05-18 Tim Coleman <tim@timcoleman.com>
695 * System.Data/DataRow.cs: Move the null check in
696 ItemArray set to above the Invalid Cast check, so
697 that we don't get null reference exceptions.
699 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
701 * System.Data.SqlClient/PostgresLibrary.cs: handle
702 data value from database being NULL
704 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
705 allow multiple result sets. Added new internal class
706 SqlResult to pass result set data from SqlCommand
709 * System.Data.SqlClient/SqlDataReader.cs: allow
710 multiple result sets.
712 * System.Data.SqlClient/SqlConnection.cs: moved
713 things around. Implement IDisposable.
715 * Test/TestSqlDataReader.cs: test for execution
716 of multiple result sets and display the results
717 of these multiple results sets
719 * Test/TestSqlDataAdapter.cs: tweaks
721 2002-05-17 Tim Coleman <tim@timcoleman.com>
722 * System.Data.Common/DbDataAdapter.cs:
723 - More implementation of Fill methods
724 - Get rid of isDirty flag, because we can just check
726 - Do *not* remove DataTables before Filling them
727 - Implicitly open the connection before doing a Fill
728 if it does not exist.
729 * System.Data.SqlClient/SqlDataAdapter.cs:
731 * System.Data/DataTableCollection.cs:
732 - Add DataSet to internal, undocumented constructor
733 - When a table is created, set its DataSet property
734 - Default table name for creation is "Table1" (see .NET)
735 - Inherit the ArrayList list from InternalDataCollecitonBase
736 and maintain a hashtable between table names and
738 * System.Data/DataTable.cs:
739 - Add internal dataSet field. This is used by
740 DataTableCollection when the DataTable is constructed.
741 * System.Data/DataSet.cs:
742 - Pass a reference to the DataSet when constructing the
745 2002-05-16 Tim Coleman <tim@timcoleman.com>
746 * System.Data.Common/DbDataAdapter.cs:
747 Use table.Rows.Add (itemArray) instead of
748 table.Rows.Add (thisRow) to provide better
750 * System.Data/DataRowCollection.cs:
751 Some implementation of this class.
752 * System.Data/InternalDataCollectionBase.cs:
753 Some implementation. Most notably, this now
754 has an enumerator so we can use foreach (DataRow row in table.Rows)
756 * System.Data/DataTable.cs:
757 Since DataRowCollection now accepts a DataTable in
758 its internal constructor, we must pass one in.
760 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
762 * Test/TestSqlDataAdapter.cs: added new test
763 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
764 DataRowCollection, and DataRow. It tests retrieving data
765 based on a SQL SELECT query. This test is based on Tim Coleman's
768 2002-05-16 Tim Coleman <tim@timcoleman.com>
769 * System.Data.Common/DbDataAdapter.cs:
770 Use table.Rows.Add (thisRow) instead of
771 table.ImportRow (thisRow)
772 * System.Data/DataRowCollection.cs:
773 Construct the ArrayList before using it
775 2002-05-16 Tim Coleman <tim@timcoleman.com>
776 * System.Data/DataTable.cs:
777 Construct the DataRowCollection in the DataTable
778 constructor. Otherwise, it's a null reference.
780 2002-05-16 Tim Coleman <tim@timcoleman.com>
781 * System.Data.SqlClient/SqlDataReader.cs:
782 Modify GetValues to use Array.Copy() to copy
783 the results from fields to values, rather than
784 an assignment, which results in loss of data.
786 2002-05-16 Tim Coleman <tim@timcoleman.com>
787 * System.Data/DataRow.cs:
788 More implementation and documentation. It should
789 work more like expected, although there is no way
790 to demonstrate this well yet. DataTable requires
793 2002-05-15 Tim Coleman <tim@timcoleman.com>
794 * System.Data/DataRow.cs:
795 Minor tweaks as I determine exactly how to
796 implement this class.
799 2002-05-14 Duncan Mak <duncan@ximian.com>
801 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
803 2002-05-14 Tim Coleman
804 * System.Data/DataRow.cs:
805 * System.Data/DataRowBuilder.cs:
806 * System.Data/DataTable.cs:
807 More implementation of these classes. DataRow
808 can now (possibly) do some useful things.
809 Still not sure what DataRowBuilder is all about,
810 other than passing a DataTable in.
812 2002-05-14 Tim Coleman
813 * System.Data/DataRowBuilder.cs:
814 Add stubb for this internal class.
816 2002-05-13 Tim Coleman
817 * System.Data.Common/DbDataAdapter.cs:
818 The maxRecords check was not correct.
820 2002-05-13 Tim Coleman
821 * System.Data/DataTableCollection.cs:
822 Fix an issue when adding a DataTable and size == 0.
823 Now explicitly checks if size > 0 before doing Array.Copy ()
824 * System.Data.Common/DbDataAdapter.cs:
825 Move closer to a working implementation.
826 Make the IDbCommand fields protected so that they can
828 * System.Data.SqlClient/SqlDataAdapter.cs:
829 This should inherit the IDbCommands instead of having its
830 own. An explicit cast is used to force conversion between
831 IDbCommand and SqlCommand
833 2002-05-13 Tim Coleman
834 * System.Data.Common/DataTableMappingCollection.cs:
835 Some implementation to allow progress with DbDataAdapter
837 2002-05-13 Tim Coleman
838 * System.Data.Common/DbDataAdapter.cs:
839 Modify to not break compile.
841 2002-05-13 Tim Coleman
843 include SqlDataAdapter, SqlRowUpdatedEventArgs,
844 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
845 SqlRowUpdatingEventHandler in the build.
847 2002-05-13 Tim Coleman
848 * System.Data.Common/DbDataAdapter.cs:
850 * System.Data.Common/DataAdapter.cs:
851 Correction of some of the stubbing, as well as a
852 little bit more implementation
854 2002-05-11 Tim Coleman
855 * System.Data.SqlClient/SqlDataAdapter.cs:
856 * System.Data.Common/DbDataAdapter.cs:
857 Moved methods that weren't supposed to
858 be in SqlDataAdapter out. They should be implemented
862 2002-05-11 Tim Coleman
863 * System.Data.SqlClient/SqlDataAdapter.cs:
864 some implementation of this class. Note
865 that none of the functionality has been
866 tested yet, but I felt it should be checked
867 in at this point as it compiles.
868 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
869 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
870 Modified so that they will compile properly.
871 Needed to include SqlDataAdapter in the build.
873 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
875 * System.Data/DataTable.cs (Clear): implemented.
876 (DataTable): removed repeated code in constructors, and call the
877 basic constructor from the others.
879 * System.Data/DataColumn.cs: some tweaks.
881 * System.Data/DataRow.cs (RowState): implemented.
882 (CancelEdit): set rowState property back to Unchanged.
883 (RejectChanges): call CancelEdit.
884 (Delete): set rowState to Deleted.
886 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
888 * System.Data.build: added copy of System.Data.dll to Test directory
889 for easy testing. Also, added clean for it too.
891 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
892 from PostgreSQL data type to .NET type.
894 * System.Data.SqlClient/SqlDataReader.cs: beginnings
895 handling of a NULL value from the database
897 * Test/PostgresTest.cs: added tests for NULL values retrieved
900 * Test/ReadPostgresData.cs
901 * Test/TestExecuteScalar.cs
902 * Test/TestSqlDataReader.cs
903 * Test/TestSqlException.cs
904 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
905 "postgres". These tests may eventually be removed since they
908 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
910 * System.Data.build: removed reference to non-existant
911 TestDataColumn.cs file.
913 * System.Data/DataSet.cs: added some implementation.
915 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
917 * System.Data.SqlClient/PostgresLibrary.cs: got
918 PostgreSQL data types time, date, timestamp (DateTime like)
919 mapped to .NET System.DateTime working based
920 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
921 Also mapped pg type boolean to .net Boolean
923 * SqlClient/SqlConnection.cs: run SQL command to set
926 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
927 added tests for aggregates min(), max(), sum(), count(). could
928 not get avg() to work due to some formatting error; someone claimed
929 that it was my locale settings. added tests for SELECT of columns
930 of type boolean, float, double, date, time, and timestamp. They
931 have not been fully tested, but its a start.
933 2002-05-09 Tim Coleman <tim@timcoleman.com>
934 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
935 addition, subtraction, and multiplication for the
936 SqlDecimal type, as well as modification of some other
937 operations. More to come on this one.
939 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
941 * Test/System.Data_test.build: excluded TestDataColumn, which
942 should be replaced with a nunit test.
944 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
946 2002-05-07 Tim Coleman <tim@timcoleman.com>
960 Fix the broken build I made before. Bad
963 2002-05-07 Tim Coleman <tim@timcoleman.com>
965 Fix a symantic error I made in SqlString
966 Equals where I copied and pasted wrongly
968 2002-05-07 Tim Coleman <tim@timcoleman.com>
973 * SqlCompareOptions.cs:
984 Implement CompareTo, Equals, and String conversions
987 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
989 * Test/PostgresTest.cs: modified to run completely. There
990 are many TODOs in System.Data, so not all data types are
991 included in the SELECT SQL query. Also, I made it to where
993 using "host=localhost;dbname=test;user=postgres"
994 instead of my userid and password. When more types are included,
997 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
999 * Test/PostgresTest.cs: added - ported
1000 libgda postgres-test.c originally by
1001 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
1004 2002-05-05 Tim Coleman <tim@timcoleman.com>
1005 * System.Data.SqlTypes/SqlBinary.cs:
1006 * System.Data.SqlTypes/SqlBoolean.cs:
1007 * System.Data.SqlTypes/SqlByte.cs:
1008 * System.Data.SqlTypes/SqlDateTime.cs:
1009 * System.Data.SqlTypes/SqlDecimal.cs:
1010 * System.Data.SqlTypes/SqlDouble.cs:
1011 * System.Data.SqlTypes/SqlGuid.cs:
1012 * System.Data.SqlTypes/SqlInt16.cs:
1013 * System.Data.SqlTypes/SqlInt32.cs:
1014 * System.Data.SqlTypes/SqlInt64.cs:
1015 * System.Data.SqlTypes/SqlMoney.cs:
1016 * System.Data.SqlTypes/SqlSingle.cs:
1017 * System.Data.SqlTypes/SqlString.cs:
1018 More implementation, and code clean-up for consistency.
1019 Also, I had implemented many conversions as explicit
1020 that should have been implicit. This should remove
1021 many of the red X's and green pluses from the
1022 System.Data.SqlTypes namespace.
1024 2002-05-05 Miguel de Icaza <miguel@ximian.com>
1026 * System.Data/DataSet.cs: Remove [Serializable] attributes from
1027 methods, those only apply to structs or classes.
1029 Stub out ISerializable, ISupportInitialize, and IListSource methods
1031 * System.Data/DataRowView.cs: Stub out interface methods for
1032 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
1034 * System.Data/DataView.cs: Comment out non-implemented
1037 * System.Data/DataViewSettingsCollection.cs: Type cast variables
1038 to the correct type to make it compile.
1040 * System.Data/DataViewSettings.cs: remove reference to
1041 non-existance type ApplyDefaultSort, it is a boolean.
1044 2002-05-05 Tim Coleman <tim@timcoleman.com>
1045 * System.Data.SqlTypes/SqlBinary.cs:
1046 * System.Data.SqlTypes/SqlBoolean.cs:
1047 * System.Data.SqlTypes/SqlByte.cs:
1048 * System.Data.SqlTypes/SqlDecimal.cs:
1049 * System.Data.SqlTypes/SqlDouble.cs:
1050 * System.Data.SqlTypes/SqlGuid.cs:
1051 * System.Data.SqlTypes/SqlInt16.cs:
1052 * System.Data.SqlTypes/SqlInt32.cs:
1053 * System.Data.SqlTypes/SqlInt64.cs:
1054 * System.Data.SqlTypes/SqlMoney.cs:
1055 * System.Data.SqlTypes/SqlSingle.cs:
1056 * System.Data.SqlTypes/SqlString.cs:
1057 Various fixes, including adding the SqlNullValueException
1058 when trying to retrieve the value of a null SqlType,
1059 and when casting values, a Null of type A converts to a
1062 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
1064 * System.Data.SqlClient/PostgresLibrary.cs
1065 * System.Data.SqlClient/SqlCommand.cs
1066 * System.Data.SqlClient/SqlConnection.cs
1067 * System.Data.SqlClient/SqlDataReader.cs
1068 oid should not be hard coded because they
1069 can change from one version of PostgreSQL
1070 to the next. Use the typname's instead.
1071 The PostgreSQL type data retrieves
1072 at database connection time. Any unimplemented
1073 types just default to string. These were things
1074 suggested by Gonzalo.
1076 * Test/ReadPostgresData.cs - stuff
1077 * Test/TestSqlDataReader.cs - stuff
1079 * System.Data.SqlTypes/SqlInt32.cs - added a using
1081 2002-05-03 Tim Coleman <tim@timcoleman.com>
1082 * System.Data.build: Fix the build so that test depends on build
1084 2002-05-03 Tim Coleman <tim@timcoleman.com>
1085 * System.Data.SqlTypes/SqlByte.cs:
1086 * System.Data.SqlTypes/SqlDateTime.cs:
1087 * System.Data.SqlTypes/SqlDecimal.cs:
1088 * System.Data.SqlTypes/SqlDouble.cs:
1089 * System.Data.SqlTypes/SqlGuid.cs:
1090 * System.Data.SqlTypes/SqlInt16.cs:
1091 * System.Data.SqlTypes/SqlInt64.cs:
1092 * System.Data.SqlTypes/SqlMoney.cs:
1093 * System.Data.SqlTypes/SqlSingle.cs:
1094 These files were mysteriously excluded from the last
1095 patch I made and sent to Rodrigo
1096 * System.Data.build: include the System.Data.SqlTypes in the build
1098 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1100 * System.Data.build: removed comments
1102 * System.Data.SqlClient/PostgresLibrary.cs: changed
1103 the hard-coded PostgreSQL oid type int's to using an
1104 enum. Also, added PostgreSQL bpchar (character) type.
1106 * Test/TestSqlDataReader.cs: updated test
1107 to include new bpchar PostgreSQL type
1109 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
1111 * System.Data.SqlTypes/SqlBinary.cs:
1112 * System.Data.SqlTypes/SqlBoolean.cs:
1113 * System.Data.SqlTypes/SqlInt32.cs:
1114 * System.Data.SqlTypes/SqlString.cs: more implementation, by
1115 Tim Coleman <tcoleman@opentext.com>.
1117 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
1119 * Test/TestExecuteScalar.cs: added test for
1120 method ExecuteScalar in class SqlCommand.
1122 * System.Data/DataColumnCollection.cs - it should
1123 inherit properties from base InternalDataCollectionBase
1124 and use them instead of overriding them, such as, List.
1126 * System.Data/DataColumn.cs
1127 * System.Data/DataTable.cs: tweaks to retrieve
1128 meta data from the database
1130 * System.Data.SqlClient/PostgresLibrary.cs -
1131 added method OidToType to convert PostgreSQL oid type
1132 to System.Type. Renamed method OidTypeToSystem
1133 to ConvertPgTypeToSystem for converting the data value
1134 from a PostgreSQL type to a .NET System type.
1136 * System.Data.SqlClient/SqlCommand.cs: implemented
1137 method ExecuteReader which returns a SqlDataReader
1138 for a light forward only read only result set.
1139 It works on types int4 ==> Int32 and
1140 varchar ==> String. Other types
1143 * System.Data.SqlClient/SqlConnection.cs: added comment
1145 * System.Data.SqlClient/SqlDataReader.cs: implemented
1146 class. It works, but still lots to do.
1148 * Test/ReadPostgresData.cs: stuff
1150 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
1151 to display meta data and the data
1153 2002-05-03 Duncan Mak <duncan@ximian.com>
1155 * TODO: Took out all the Exceptions. They should be all done now.
1157 * System.Data/ConstraintException.cs:
1158 * System.Data/DBConcurrencyException.cs:
1159 * System.Data/DataException.cs:
1160 * System.Data/DeletedRowInaccessibleException.cs:
1161 * System.Data/DuplicateNameException.cs:
1162 * System.Data/EvaluateException.cs:
1163 * System.Data/InRowChangingEventException.cs:
1164 * System.Data/InvalidConstraintException.cs:
1165 * System.Data/InvalidExpressionException.cs:
1166 * System.Data/MissingPrimaryKeyException.cs:
1167 * System.Data/NoNullAllowedException.cs:
1168 * System.Data/ReadOnlyException.cs:
1169 * System.Data/RowNotInTableException.cs:
1170 * System.Data/StrongTypingException.cs:
1171 * System.Data/SyntaxErrorException.cs:
1172 * System.Data/TypeDataSetGeneratorException.cs:
1173 * System.Data/VersionNotFoundException.cs: Added to CVS.
1175 * System.Data.SqlTypes/SqlNullValueException.cs:
1176 * System.Data.SqlTypes/SqlTruncateException.cs:
1177 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
1179 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
1181 * System.Data/DataViewSettingCollection.cs: implemented.
1183 * System.Data/DataRowView.cs: new stubs.
1185 * System.Data.SqlTypes/SqlByte.cs:
1186 * System.Data.SqlTypes/SqlDateTime.cs:
1187 * System.Data.SqlTypes/SqlDecimal.cs:
1188 * System.Data.SqlTypes/SqlDouble.cs:
1189 * System.Data.SqlTypes/SqlGuid.cs:
1190 * System.Data.SqlTypes/SqlInt16.cs:
1191 * System.Data.SqlTypes/SqlInt64.cs:
1192 * System.Data.SqlTypes/SqlMoney.cs:
1193 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
1194 by Tim Coleman <tcoleman@opentext.com>
1196 * System.Data.build: excluded newly-added files.
1198 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
1200 * System.Data.SqlClient/PostgresLibrary.cs: included new
1201 internal class that will be a helper class in using
1202 PostgreSQL. PostgresLibrary is used for the
1203 pinvoke methods to the PostgreSQL Client
1204 native C library libpq while the class PostgresHelper
1205 is used for wrapper or helper methods. It currently only
1206 has one static method OidTypeToSystem in converting
1207 PostgreSQL types to .NET System.<type>s, such as,
1208 a PostgreSQL int8 becomes a .NET System.Int64.
1209 Only a few types have been added, such as, int2,
1210 int4, int8, varchar, text, bool, and char. Other types
1213 * System.Data.SqlClient/SqlCommand.cs: implemented
1214 method ExecuteScalar which allows us to do aggregate
1215 functions, such as, count, avg, min, max, and sum. We
1216 also are able to retrieve the result, convert it to the .NET type
1217 as an object. The user of the returned object must explicitly cast.
1219 * Test/ReadPostgresData.cs: updated sample
1220 to help us learn to retrieve data in System.Data.SqlClient
1223 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1225 * System.Data.build: added /nowarn: nnnn arguments
1226 so you will not get a ton of warnings. The warnings
1227 being excluded are: 1595, 0067, 0109, 0169, and 0649
1229 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
1231 * System.Data.build: modified to exclude more
1232 files from the build
1234 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
1236 * System.Data.SqlClient/SqlClientPermission.cs: added missing
1239 * System.Data/MergeFailedEventArgs.cs: new class, contributed
1240 by John Dugaw <jdugaw@unizenconsulting.com>.
1242 * System.Data.build: excluded new files from build.
1244 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
1246 * Test/ReadPostgresData.cs: added - Uses the
1247 PostgresLibrary to retrieve a recordset.
1248 This is not meant to be used in Production, but as a
1249 learning aid in coding
1250 class System.Data.SqlClient.SqlDataReader.
1251 This sample does work.
1253 * Test/TestSqlDataReader.cs: added - used
1254 to test SqlDataReader (does not work yet)
1255 Forgot to add to ChangeLog on last commit.
1257 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1259 * System.Data/DataViewSetting.cs: new class.
1261 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1263 * System.Data/DataViewManager.cs: new class.
1265 * System.Data.SqlTypes/INullable.cs: properties for interfaces
1266 don't have implementation.
1268 * System.Data.SqlTypes/SqlInt32.cs:
1269 * System.Data.SqlTypes/SqlString.cs:
1270 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
1271 these are strctures.
1273 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
1276 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1278 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
1279 for correctly hiding parent class' members.
1280 (AddRange): use 'override' keyword on overriden method.
1282 (Contains): likewise.
1283 (IndexOf): likewise.
1284 (OnCollectionChanged): likewise.
1285 (OnCollectionChanging): likewise.
1286 (RemoveCore): likewise.
1288 * System.Data/DataColumnCollection.cs: use 'new' keyword.
1290 * System.Data/DataSet.cs: added missing 'using's.
1292 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1294 * System.Data/DataSet.cs:
1295 * System.Data/DataTableCollection.cs:
1296 * System.Data/DataView.cs: compilation fixes on Linux.
1298 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
1300 * System.Data/DataRelation.cs
1301 * System.Data/ForeignKeyConstraint.cs
1302 * System.Data/UniqueConstraint.cs: added more stubs
1304 * System.Data/DataTableRelationCollection.cs: added back to cvs
1305 and modified for compile errors. DataRelationCollection is an
1306 abstract class and there must be a class that implements for
1307 DataTable/DataSet. DataTableRelationCollection was changed
1308 to an internal class.
1310 * System.Data.build: modified - new files added
1311 also wanted to include files/classes in the build
1312 so we can get a compilable forward read only result set.
1313 It compiles now using csc/nant with warnings, but this
1314 is a start for adding functionality for the result set.
1315 Classes associated with/and DataSet are still excluded.
1317 * TODO: modified - updated to do list for System.Data
1319 * System.Data/Constraint.cs
1320 * System.Data/ConstraintCollection.cs
1321 * System.Data/DataRelationCollection.cs
1322 * System.Data/DataRow.cs
1323 * System.Data/DataRowChangeEventArgs.cs
1324 * System.Data/DataRowCollection.cs
1325 * System.Data/DataTable.cs
1326 * System.Data/DataTableCollection.cs
1327 * System.Data/InternalDataCollectionBase.cs
1328 * System.Data/PropertyCollection.cs: modified -
1329 changes to compile SqlDataReader/DataTable and
1332 * System.Data/IDbCommand.cs
1333 * System.Data.SqlClient/SqlCommand.cs: modified -
1334 un-commented overloaded methods ExecuteReader
1335 which returns a SqlDataReader
1337 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
1339 * System.Data/DataTableCollection.cs: more implementation.
1340 (Count): added 'override' keyword, as pointer out by Martin.
1342 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
1343 only call Array.Copy when there is really stuff to be copied.
1344 (CopyTo): don't create the temporary array, it's not needed.
1346 * System.Data.build: excluded newly added file from build.
1348 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
1350 * System.Data/DataTableRelationCollection.cs: removed, it's not
1351 on MS SDK documentation.
1353 * System.Data/DataTableCollection.cs: new class.
1355 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
1357 * System.Data/DataRowChangeEventArgs.cs
1358 * System.Data/DataRowCollection.cs
1359 * System.Data/DataView.cs
1360 * System.Data/PropertyCollection.cs: added new stubs
1362 * System.Data.build: modified - added new files to exclude
1365 * TODO: modified - removed files from TODO list
1366 that were stubbed above
1368 * System.Data/DataColumn.cs
1369 * System.Data/DataRow.cs: modified - various tweaks
1370 and added internal method SetTable to set the reference
1373 * System.Data/DataSet.cs: modified - class was not
1376 * System.Data/DataTable.cs: modified - temporarily commented
1377 DataSet and DataView references - trying to compile a SqlDataReader,
1378 DataTable, and dependencies for a forward read-only result set.
1379 SqlDataAdapter, DataSet, and DataView will come later once we can get
1380 a forward read only result set working.
1382 * System.Data/IDataRecord.cs: modified - source code lines should
1385 * System.Data/InternalDataCollectionBase.cs: modified - started
1386 implementing this base class for collection of data rows,
1387 columns, tables, relations, and constraints
1389 * System.Data.SqlClient/SqlException.cs: modified -
1390 call base(message) so a unhandled exception displays
1391 the message of a SQL error instead of the
1392 default SystemException message
1394 * Test/TestSqlException.cs: modified -
1395 handle the rollback properly for a SqlException on a
1398 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1400 * System.Data.build: modified - added new
1401 files to exclude from build
1403 * System.Data/Constraint.cs
1404 * System.Data/ConstraintCollection.cs
1405 * System.Data/InternalDataCollectionBase.cs: added -
1406 stubs which are needed to build DataTable.cs
1408 * TODO: modified - added more classes TODO and
1409 added more stuff TODO, such as, create script
1410 to create test database monotestdb for testing
1411 classes in System.Data
1413 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
1415 * System.Data.Common/DataAdapter.cs:
1416 * System.Data.Common/DataColumnMappingCollection.cs:
1417 * System.Data.Common/DataTableMappingCollection.cs:
1418 * System.Data.Common/DbDataPermission.cs:
1419 * System.Data.Common/DbDataPermissionAttribute.cs: some
1420 compilation errors fixed.
1422 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1424 * TODO: modified - added classes TODO, and
1425 a poor attempt at System.Data plan
1427 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1429 * ChangeLog: modified - put tabs where they belong
1431 * System.Data.SqlClient/SqlDataReader.cs
1432 * System.Data/DataColumn.cs: modified - compile errors
1433 trying to compile SqlDataAdapter and dependencies
1435 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
1437 * System.Data.SqlTypes/SqlBoolean.cs
1438 * System.Data.SqlTypes/SqlCompareOptions.cs
1439 * System.Data.SqlTypes/SqlInt32.cs
1440 * System.Data.SqlTypes/SqlString.cs: added - new stubs
1442 * System.Data/DataTable.cs
1443 * System.Data.SqlClient/SqlCommand.cs
1444 * System.Data.SqlClient/SqlConnection.cs
1445 * System.Data.SqlClient/SqlError.cs
1446 * System.Data.SqlClient/SqlTransaction.cs: modified -
1449 * System.Data.SqlClient/SqlException.cs: modified -
1450 missing Message on indexer for Message property
1452 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
1454 * System.Data.SqlClient/SqlCommand.cs: modified - to
1455 compile using mcs. This problem is
1456 returning a stronger type in csc vs. msc
1458 * System.Data.SqlClient/SqlConnection.cs: modified - msc
1459 can not do a using PGconn = IntPtr; and then declare
1460 with PGconn pgConn = IntPtr.Zero;
1461 Thiw works under csc though. Had to comment using and
1462 changed declaration to IntPtr pgConn = IntPtr.Zero;
1463 Also, got rid of compile warnings for hostaddr and port.
1465 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
1466 rid of compile warnings. Commented MonoTODO attribute because mcs
1467 doesn't seem to work with C# array property indexer (Item)
1470 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1471 commented MonoTODO attribute for indexer for mcs compiling
1473 * Test/TestSqlIsolationLevel.cs:
1474 * Test/TestSqlInsert.cs:
1475 * Test/TestSqlException.cs: modified -
1476 removed extra ExecuteNonQuery which caused two inserted rows
1478 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1480 * System.Data/StateChangeEventArgs.cs - added
1481 needed to compile System.Data.dll with mcs.
1483 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
1485 * System.Data.OleDb: added directory - for OleDb database
1488 * System.Data.SqlClient/SqlClientPermission.cs
1489 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
1490 * System.Data.SqlClient/SqlCommandBuilder.cs
1491 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
1492 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
1493 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
1494 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
1495 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
1496 * Test/TestSqlException.cs
1497 * Test/TestSqlIsolationLevel.cs: added - more tests
1499 * System.Data.build: modified - added new files - excludes these too
1501 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
1503 * System.Data.SqlClient/SqlConnection.cs
1504 * System.Data.SqlClient/SqlCommand.cs
1505 * System.Data.SqlClient/SqlTransaction.cs
1506 * System.Data.SqlClient/SqlException.cs
1507 * System.Data.SqlClient/SqlErrorCollection.cs
1508 * System.Data.SqlClient/SqlError.cs: modified - transaction and
1509 exception/error handling. SqlConnection(connectionString)
1510 constructor should not automatically connect.
1512 * System.Data.SqlClient/SqlDataReader.cs
1513 * System.Data.SqlClient/SqlDataAdapter.cs
1514 * System.Data.SqlClient/SqlParameter.cs
1515 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
1516 added using System.ComponentModel;
1518 * Test/TestSqlInsert.cs: modified - to use transaction
1520 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
1522 * System.Data/DataRow.cs: new skeletons.
1524 * System.Data.Common/DataAdapter.cs:
1525 * System.Data.Common/DataColumnMapping.cs:
1526 * System.Data.Common/DataColumnMappingCollection.cs:
1527 * System.Data.Common/DataTableMapping.cs:
1528 * System.Data.Common/DataTableMappingCollection.cs:
1529 * System.Data.Common/DbDataAdapter.cs:
1530 * System.Data.Common/RowUpdatedEventArgs.cs:
1531 * System.Data.SqlClient/SqlDataAdapter.cs:
1532 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
1535 * System.Data.Common/DbDataRecord.cs:
1536 * System.Data.Common/DbEnumerator.cs: removed MS implementation
1539 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
1541 * Test/TestSqlInsert.cs: modified - do
1542 a SQL DELETE before SQL INSERT of row so you can use this
1545 * System.Data.SqlClient/SqlTransaction.cs: modified - default
1546 IsolationLevel for PostgreSQL is ReadCommitted. However,
1547 PostgreSQL allows Serializable as well.
1548 (Thanks to Gonzalo for that!)
1550 * System.Data.SqlClient/SqlConnection.cs: modified
1551 * System.Data.SqlClient/SqlCommand.cs: modified
1552 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
1553 working; however, we still need to implement SQL errors
1554 and exceptions to properly handle transactions. Also, added
1555 status and error message support from the PostgreSQL database.
1556 Currently, this does a Console.WriteLine() to display the
1557 status and error messages, but this is a TODO
1558 for SQL errors and exceptions.
1560 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1561 attribute for System.Data.dll assembly
1563 * System.Data/IDbCommand.cs: modified - commented
1564 overloaded method ExecuteReader
1565 so System.Data.SqlClient.SqlCommand can compile
1567 * System.Data/IDbCommand.cs: modified
1568 * System.Data/IDbConnection.cs: modified - added using System;
1569 * System.Data/IDataParameter.cs
1571 * System.Data.build: modified - build classes
1572 in System.Data.SqlClient and exclude others in System.Data
1574 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1575 parameter data type from IntPtr to enum ExecStatusType
1577 * ChangeLog: modified - corrected previous entries in log
1579 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1581 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1582 implementation. Still missing some stuff.
1584 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1586 * System.Data.SqlClient/SqlConnection.cs: modified - got
1587 to compile, run, and connect to PostgreSQL database
1589 * System.Data.SqlClient/SqlCommand.cs: modified - got
1590 to compile, run, and execute a SQL INSERT command
1591 which successfully inserted a row
1592 into the PostgreSQL database
1594 * System.Data.SqlClient/SqlTransaction.cs: modified
1595 * System.Data.SqlClient/SqlParameter.cs: modified
1596 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1597 * System.Data.SqlClient/SqlError.cs: modified
1598 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1599 * System.Data.SqlClient/SqlException.cs: modified
1600 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1602 * System.Data.SqlClient/SqlAdapter: modified
1603 * System.Data.SqlClient/SqlReader: modified - add more stubs
1605 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1607 * Test/TestSqlInsert.cs: added
1609 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1611 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1612 class SqlConnecition
1613 * System.Data.SqlClient/SqlErrorCollection.cs: added
1614 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1616 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1618 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1619 * System.Data.IDbTransaction: Added Interface to IDisposable.
1620 * System.Data.IDbCommand: Fixed Capitalization of class name.
1621 * System.Data.IDbConnection: Fixed Capitalization of class name.
1623 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1625 * System.Data.Common/DbDataPermissionAttribute.cs:
1626 * System.Data.Common/DataAdapter.cs:
1627 * System.Data.Common/DataColumnMapping.cs:
1628 * System.Data.Common/DbDataPermission.cs: added some implementation.
1630 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1632 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1633 syntax, as pointed out by Levent Camlibel.
1635 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1637 * System.Data.SqlTypes/SqlBinary.cs:
1638 * System.Data.SqlTypes/INullable.cs: new skeletons.
1640 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1642 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1643 contains all calls the the PostgreSQL client library, to be used
1644 everywhere in System.Data.SqlClient.
1646 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1648 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1651 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1653 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1655 * System.Data.Common/DbDataRecord.cs:
1656 * System.Data.Common/DbEnumerator.cs:
1657 * System.Data.Common/RowUpdatedEventArgs.cs:
1658 * System.Data.Common/RowUpdatingEventArgs.cs:
1659 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1661 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1663 * System.Data.Common/DataTableMappingCollection.cs:
1664 * System.Data.Common/DbDataAdapter.cs:
1665 * System.Data.Common/DbDataPermission.cs:
1666 * System.Data.Common/DataTableMapping.cs: new skeletons.
1668 * System.Data.SqlClient/SqlDataAdapter.cs:
1669 * System.Data.SqlClient/SqlDataReader.cs:
1670 * System.Data.SqlClient/SqlErrors.cs:
1671 * System.Data.SqlClient/SqlError.cs:
1672 * System.Data.SqlClient/SqlException.cs:
1673 * System.Data.SqlClient/SqlParameter.cs:
1674 * System.Data.SqlClient/SqlParameterCollection.cs:
1675 * System.Data.SqlClient/SqlTransaction.cs:
1676 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1678 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1680 * System.Data.Common/DataColumnMapping.cs:
1681 * System.Data.Common/DataColumnMappingCollection.cs:
1682 * System.Data.Common/DataAdapter.cs: created skeletons.
1684 * System.Data.build: exclude new directories from build.
1686 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1688 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1690 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1691 implemented (2 methods).
1693 2002-03-24 Duncan Mak <duncan@ximian.com>
1695 * System.Data.build: Excluded System.Data.SqlClient from the build.
1696 The stubs are incomplete and they are stopping the build.
1698 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1700 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1702 * System.Data.SqlClient/*: added skeletons for the SQL managed
1703 provider for ADO.Net, to be based initially in PostgreSQL.
1705 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1707 Changed the Namespace on some Enums from mono.System.Data to System.Data
1709 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1711 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1712 default name if the ColumnName is null.
1713 * DataSet.cs : Added
1714 * DataTable.cs : Added
1715 * DataRelationCollection.cs : Added
1716 * DataTableRelationCollection.cs : Added
1717 * DataColumn : Added
1719 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1721 * DataColumnChangeEventArgs.cs : Added
1722 * DataColumnCollection.cs : Added
1724 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1726 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1727 * Updated all Enums, Interfaces, and Delegates in System.Data