1 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
3 * System.Data/DataRow.cs: change suggested
4 by tim: in Item indexer, do an EndEdit()
6 * System.Data.SqlClient/SqlCommand.cs: more
7 fixes to SqlResult. After setting each item in
8 the DataRow, do an AcceptChanges() to commit
9 the changes in the DataRow. For DataType, use a Type
10 of System.String since System.Type nor System.Object
13 * Test/TestSqlDataReader.cs
14 * Test/PostgresTest.cs: updated to to be on
15 the way schema table is suppose to work
17 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
19 * System.Data.SqlClient/SqlCommand.cs: more work on
20 building the schema table
22 2002-05-22 Tim Coleman <tim@timcoleman.com>
23 * System.Data.SqlClient/SqlCommand.cs: preliminary work
24 on getting the schema table correctly built.
26 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
28 * System.Data.SqlClient/ParmUtil.cs: added file - to
29 provide utility for conversion of input parameters
31 * System.Data.SqlClient/PostgresTypes.cs: added file -
32 moved the PostgreHelper class to here. May eventually
33 move the internal class PostgresTypes that's inside the
34 SqlConnection to here as well.
35 Handling of PostgreSQL <-> .NET types need to be though
36 out more. Also, the PostgreHelper has a method to convert
37 from .NET types to a string which can be put into used in
38 an SQL statement to execute against a PostgreSQL database.
39 This is the beginnings of parameters support. It currently
40 only supports input parameters. Still need to do output,
41 input/output, and return parameters.
43 * Test/TestSqlParameters.cs: new test to test the input
44 parameters in System.Data.SqlClient against a
47 * System.Data.SqlClient/PostgresLibrary.cs: moved
48 PostgresHelper class to file PostgresTypes.cs. Also
49 moved struct PostgresType there too.
51 * System.Data.SqlClient/SqlCommand.cs: added input
54 * System.Data.SqlClient/SqlParameter.cs: got
57 * System.Data.SqlClient/SqlParameterCollection.cs: got
58 SqlParameterCollection to work
60 * Test/System.Data_test.build: added files to exclude
63 * System.Data.SqlClient/SqlConnection.cs: release resources
66 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
68 * System.Xml: added directory for classes with namespace
69 System.Xml to go into the System.Data.dll assembly
71 * System.Xml/XmlDataDocument: added file
72 for stubbed concrete class XmlDataDocument which
73 inherits from XmlDocument. Its purpose is to provide
74 a W3C XML DOM Document for relational data and interacting
77 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
79 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
80 Text, TableDirect, and StoredProcedure
82 * Test/PostgresTest.cs: changed call to version()
83 stored procedure to use the CommandType of StoredProcedure
85 * Test/TestSqlDataReader.cs: test all the CommandTypes
87 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
89 * System.Data.build: took out all excluded
90 files except the ones in the Test directory
91 because all files compile now. It does not
92 mean they all work or have implementations
95 * System.Data/DataRelationCollection.cs
96 * System.Data/DataTableRelationCollection.cs
97 * System.Data/InternalDataCollectionBase.cs
98 * System.Data.Common/DbDataPermission.cs
99 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
100 * System.Data.SqlClient/SqlClientPermission.cs
101 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
102 to get all System.Data* files to compile.
104 * System.Data.SqlClient/SqlCommand.cs: started coding
105 to prevent SqlConnection and SqlCommand from doing
106 anyting while fetching data using SqlDataReader. Also,
107 started coding to undo this prevention once the
108 SqlDataReader is closed.
110 * System.Data.SqlClient/SqlConnection.cs: get database server
111 version. Started coding to prevent connection from
112 doing anything while fetching data and undo once the reader
113 is closed. Include events SqlInfoMessage and StateChange.
115 * System.Data.SqlClient/SqlDataReader.cs: start coding to
116 prevent connection and command from doing anything while
117 fetching data, and undo when closed.
119 * Test/PostgresTest.cs: added test to get ServerVersion
120 property from SqlConnection
122 2002-05-18 Tim Coleman <tim@timcoleman.com>
123 * System.Data/DataRow.cs: More implementation,
124 as well as boundary checks and small semantic
127 2002-05-18 Tim Coleman <tim@timcoleman.com>
128 * System.Data/DataRow.cs: Try to reduce memory
129 usage by only creating the original and proposed
130 arrays as required in BeginEdit, and then destroying
131 proposed during EndEdit, and original during AcceptChanges.
132 * System.Data.Common/DbDataAdapter.cs: Make the
133 startRecord and maxRecords parameters work correctly.
135 2002-05-18 Tim Coleman <tim@timcoleman.com>
136 * System.Data/DataRow.cs: Move the null check in
137 ItemArray set to above the Invalid Cast check, so
138 that we don't get null reference exceptions.
140 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
142 * System.Data.SqlClient/PostgresLibrary.cs: handle
143 data value from database being NULL
145 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
146 allow multiple result sets. Added new internal class
147 SqlResult to pass result set data from SqlCommand
150 * System.Data.SqlClient/SqlDataReader.cs: allow
151 multiple result sets.
153 * System.Data.SqlClient/SqlConnection.cs: moved
154 things around. Implement IDisposable.
156 * Test/TestSqlDataReader.cs: test for execution
157 of multiple result sets and display the results
158 of these multiple results sets
160 * Test/TestSqlDataAdapter.cs: tweaks
162 2002-05-17 Tim Coleman <tim@timcoleman.com>
163 * System.Data.Common/DbDataAdapter.cs:
164 - More implementation of Fill methods
165 - Get rid of isDirty flag, because we can just check
167 - Do *not* remove DataTables before Filling them
168 - Implicitly open the connection before doing a Fill
169 if it does not exist.
170 * System.Data.SqlClient/SqlDataAdapter.cs:
172 * System.Data/DataTableCollection.cs:
173 - Add DataSet to internal, undocumented constructor
174 - When a table is created, set its DataSet property
175 - Default table name for creation is "Table1" (see .NET)
176 - Inherit the ArrayList list from InternalDataCollecitonBase
177 and maintain a hashtable between table names and
179 * System.Data/DataTable.cs:
180 - Add internal dataSet field. This is used by
181 DataTableCollection when the DataTable is constructed.
182 * System.Data/DataSet.cs:
183 - Pass a reference to the DataSet when constructing the
186 2002-05-16 Tim Coleman <tim@timcoleman.com>
187 * System.Data.Common/DbDataAdapter.cs:
188 Use table.Rows.Add (itemArray) instead of
189 table.Rows.Add (thisRow) to provide better
191 * System.Data/DataRowCollection.cs:
192 Some implementation of this class.
193 * System.Data/InternalDataCollectionBase.cs:
194 Some implementation. Most notably, this now
195 has an enumerator so we can use foreach (DataRow row in table.Rows)
197 * System.Data/DataTable.cs:
198 Since DataRowCollection now accepts a DataTable in
199 its internal constructor, we must pass one in.
201 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
203 * Test/TestSqlDataAdapter.cs: added new test
204 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
205 DataRowCollection, and DataRow. It tests retrieving data
206 based on a SQL SELECT query. This test is based on Tim Coleman's
209 2002-05-16 Tim Coleman <tim@timcoleman.com>
210 * System.Data.Common/DbDataAdapter.cs:
211 Use table.Rows.Add (thisRow) instead of
212 table.ImportRow (thisRow)
213 * System.Data/DataRowCollection.cs:
214 Construct the ArrayList before using it
216 2002-05-16 Tim Coleman <tim@timcoleman.com>
217 * System.Data/DataTable.cs:
218 Construct the DataRowCollection in the DataTable
219 constructor. Otherwise, it's a null reference.
221 2002-05-16 Tim Coleman <tim@timcoleman.com>
222 * System.Data.SqlClient/SqlDataReader.cs:
223 Modify GetValues to use Array.Copy() to copy
224 the results from fields to values, rather than
225 an assignment, which results in loss of data.
227 2002-05-16 Tim Coleman <tim@timcoleman.com>
228 * System.Data/DataRow.cs:
229 More implementation and documentation. It should
230 work more like expected, although there is no way
231 to demonstrate this well yet. DataTable requires
234 2002-05-15 Tim Coleman <tim@timcoleman.com>
235 * System.Data/DataRow.cs:
236 Minor tweaks as I determine exactly how to
237 implement this class.
240 2002-05-14 Duncan Mak <duncan@ximian.com>
242 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
244 2002-05-14 Tim Coleman
245 * System.Data/DataRow.cs:
246 * System.Data/DataRowBuilder.cs:
247 * System.Data/DataTable.cs:
248 More implementation of these classes. DataRow
249 can now (possibly) do some useful things.
250 Still not sure what DataRowBuilder is all about,
251 other than passing a DataTable in.
253 2002-05-14 Tim Coleman
254 * System.Data/DataRowBuilder.cs:
255 Add stubb for this internal class.
257 2002-05-13 Tim Coleman
258 * System.Data.Common/DbDataAdapter.cs:
259 The maxRecords check was not correct.
261 2002-05-13 Tim Coleman
262 * System.Data/DataTableCollection.cs:
263 Fix an issue when adding a DataTable and size == 0.
264 Now explicitly checks if size > 0 before doing Array.Copy ()
265 * System.Data.Common/DbDataAdapter.cs:
266 Move closer to a working implementation.
267 Make the IDbCommand fields protected so that they can
269 * System.Data.SqlClient/SqlDataAdapter.cs:
270 This should inherit the IDbCommands instead of having its
271 own. An explicit cast is used to force conversion between
272 IDbCommand and SqlCommand
274 2002-05-13 Tim Coleman
275 * System.Data.Common/DataTableMappingCollection.cs:
276 Some implementation to allow progress with DbDataAdapter
278 2002-05-13 Tim Coleman
279 * System.Data.Common/DbDataAdapter.cs:
280 Modify to not break compile.
282 2002-05-13 Tim Coleman
284 include SqlDataAdapter, SqlRowUpdatedEventArgs,
285 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
286 SqlRowUpdatingEventHandler in the build.
288 2002-05-13 Tim Coleman
289 * System.Data.Common/DbDataAdapter.cs:
291 * System.Data.Common/DataAdapter.cs:
292 Correction of some of the stubbing, as well as a
293 little bit more implementation
295 2002-05-11 Tim Coleman
296 * System.Data.SqlClient/SqlDataAdapter.cs:
297 * System.Data.Common/DbDataAdapter.cs:
298 Moved methods that weren't supposed to
299 be in SqlDataAdapter out. They should be implemented
303 2002-05-11 Tim Coleman
304 * System.Data.SqlClient/SqlDataAdapter.cs:
305 some implementation of this class. Note
306 that none of the functionality has been
307 tested yet, but I felt it should be checked
308 in at this point as it compiles.
309 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
310 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
311 Modified so that they will compile properly.
312 Needed to include SqlDataAdapter in the build.
314 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
316 * System.Data/DataTable.cs (Clear): implemented.
317 (DataTable): removed repeated code in constructors, and call the
318 basic constructor from the others.
320 * System.Data/DataColumn.cs: some tweaks.
322 * System.Data/DataRow.cs (RowState): implemented.
323 (CancelEdit): set rowState property back to Unchanged.
324 (RejectChanges): call CancelEdit.
325 (Delete): set rowState to Deleted.
327 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
329 * System.Data.build: added copy of System.Data.dll to Test directory
330 for easy testing. Also, added clean for it too.
332 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
333 from PostgreSQL data type to .NET type.
335 * System.Data.SqlClient/SqlDataReader.cs: beginnings
336 handling of a NULL value from the database
338 * Test/PostgresTest.cs: added tests for NULL values retrieved
341 * Test/ReadPostgresData.cs
342 * Test/TestExecuteScalar.cs
343 * Test/TestSqlDataReader.cs
344 * Test/TestSqlException.cs
345 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
346 "postgres". These tests may eventually be removed since they
349 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
351 * System.Data.build: removed reference to non-existant
352 TestDataColumn.cs file.
354 * System.Data/DataSet.cs: added some implementation.
356 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
358 * System.Data.SqlClient/PostgresLibrary.cs: got
359 PostgreSQL data types time, date, timestamp (DateTime like)
360 mapped to .NET System.DateTime working based
361 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
362 Also mapped pg type boolean to .net Boolean
364 * SqlClient/SqlConnection.cs: run SQL command to set
367 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
368 added tests for aggregates min(), max(), sum(), count(). could
369 not get avg() to work due to some formatting error; someone claimed
370 that it was my locale settings. added tests for SELECT of columns
371 of type boolean, float, double, date, time, and timestamp. They
372 have not been fully tested, but its a start.
374 2002-05-09 Tim Coleman <tim@timcoleman.com>
375 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
376 addition, subtraction, and multiplication for the
377 SqlDecimal type, as well as modification of some other
378 operations. More to come on this one.
380 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
382 * Test/System.Data_test.build: excluded TestDataColumn, which
383 should be replaced with a nunit test.
385 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
387 2002-05-07 Tim Coleman <tim@timcoleman.com>
401 Fix the broken build I made before. Bad
404 2002-05-07 Tim Coleman <tim@timcoleman.com>
406 Fix a symantic error I made in SqlString
407 Equals where I copied and pasted wrongly
409 2002-05-07 Tim Coleman <tim@timcoleman.com>
414 * SqlCompareOptions.cs:
425 Implement CompareTo, Equals, and String conversions
428 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
430 * Test/PostgresTest.cs: modified to run completely. There
431 are many TODOs in System.Data, so not all data types are
432 included in the SELECT SQL query. Also, I made it to where
434 using "host=localhost;dbname=test;user=postgres"
435 instead of my userid and password. When more types are included,
438 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
440 * Test/PostgresTest.cs: added - ported
441 libgda postgres-test.c originally by
442 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
445 2002-05-05 Tim Coleman <tim@timcoleman.com>
446 * System.Data.SqlTypes/SqlBinary.cs:
447 * System.Data.SqlTypes/SqlBoolean.cs:
448 * System.Data.SqlTypes/SqlByte.cs:
449 * System.Data.SqlTypes/SqlDateTime.cs:
450 * System.Data.SqlTypes/SqlDecimal.cs:
451 * System.Data.SqlTypes/SqlDouble.cs:
452 * System.Data.SqlTypes/SqlGuid.cs:
453 * System.Data.SqlTypes/SqlInt16.cs:
454 * System.Data.SqlTypes/SqlInt32.cs:
455 * System.Data.SqlTypes/SqlInt64.cs:
456 * System.Data.SqlTypes/SqlMoney.cs:
457 * System.Data.SqlTypes/SqlSingle.cs:
458 * System.Data.SqlTypes/SqlString.cs:
459 More implementation, and code clean-up for consistency.
460 Also, I had implemented many conversions as explicit
461 that should have been implicit. This should remove
462 many of the red X's and green pluses from the
463 System.Data.SqlTypes namespace.
465 2002-05-05 Miguel de Icaza <miguel@ximian.com>
467 * System.Data/DataSet.cs: Remove [Serializable] attributes from
468 methods, those only apply to structs or classes.
470 Stub out ISerializable, ISupportInitialize, and IListSource methods
472 * System.Data/DataRowView.cs: Stub out interface methods for
473 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
475 * System.Data/DataView.cs: Comment out non-implemented
478 * System.Data/DataViewSettingsCollection.cs: Type cast variables
479 to the correct type to make it compile.
481 * System.Data/DataViewSettings.cs: remove reference to
482 non-existance type ApplyDefaultSort, it is a boolean.
485 2002-05-05 Tim Coleman <tim@timcoleman.com>
486 * System.Data.SqlTypes/SqlBinary.cs:
487 * System.Data.SqlTypes/SqlBoolean.cs:
488 * System.Data.SqlTypes/SqlByte.cs:
489 * System.Data.SqlTypes/SqlDecimal.cs:
490 * System.Data.SqlTypes/SqlDouble.cs:
491 * System.Data.SqlTypes/SqlGuid.cs:
492 * System.Data.SqlTypes/SqlInt16.cs:
493 * System.Data.SqlTypes/SqlInt32.cs:
494 * System.Data.SqlTypes/SqlInt64.cs:
495 * System.Data.SqlTypes/SqlMoney.cs:
496 * System.Data.SqlTypes/SqlSingle.cs:
497 * System.Data.SqlTypes/SqlString.cs:
498 Various fixes, including adding the SqlNullValueException
499 when trying to retrieve the value of a null SqlType,
500 and when casting values, a Null of type A converts to a
503 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
505 * System.Data.SqlClient/PostgresLibrary.cs
506 * System.Data.SqlClient/SqlCommand.cs
507 * System.Data.SqlClient/SqlConnection.cs
508 * System.Data.SqlClient/SqlDataReader.cs
509 oid should not be hard coded because they
510 can change from one version of PostgreSQL
511 to the next. Use the typname's instead.
512 The PostgreSQL type data retrieves
513 at database connection time. Any unimplemented
514 types just default to string. These were things
515 suggested by Gonzalo.
517 * Test/ReadPostgresData.cs - stuff
518 * Test/TestSqlDataReader.cs - stuff
520 * System.Data.SqlTypes/SqlInt32.cs - added a using
522 2002-05-03 Tim Coleman <tim@timcoleman.com>
523 * System.Data.build: Fix the build so that test depends on build
525 2002-05-03 Tim Coleman <tim@timcoleman.com>
526 * System.Data.SqlTypes/SqlByte.cs:
527 * System.Data.SqlTypes/SqlDateTime.cs:
528 * System.Data.SqlTypes/SqlDecimal.cs:
529 * System.Data.SqlTypes/SqlDouble.cs:
530 * System.Data.SqlTypes/SqlGuid.cs:
531 * System.Data.SqlTypes/SqlInt16.cs:
532 * System.Data.SqlTypes/SqlInt64.cs:
533 * System.Data.SqlTypes/SqlMoney.cs:
534 * System.Data.SqlTypes/SqlSingle.cs:
535 These files were mysteriously excluded from the last
536 patch I made and sent to Rodrigo
537 * System.Data.build: include the System.Data.SqlTypes in the build
539 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
541 * System.Data.build: removed comments
543 * System.Data.SqlClient/PostgresLibrary.cs: changed
544 the hard-coded PostgreSQL oid type int's to using an
545 enum. Also, added PostgreSQL bpchar (character) type.
547 * Test/TestSqlDataReader.cs: updated test
548 to include new bpchar PostgreSQL type
550 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
552 * System.Data.SqlTypes/SqlBinary.cs:
553 * System.Data.SqlTypes/SqlBoolean.cs:
554 * System.Data.SqlTypes/SqlInt32.cs:
555 * System.Data.SqlTypes/SqlString.cs: more implementation, by
556 Tim Coleman <tcoleman@opentext.com>.
558 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
560 * Test/TestExecuteScalar.cs: added test for
561 method ExecuteScalar in class SqlCommand.
563 * System.Data/DataColumnCollection.cs - it should
564 inherit properties from base InternalDataCollectionBase
565 and use them instead of overriding them, such as, List.
567 * System.Data/DataColumn.cs
568 * System.Data/DataTable.cs: tweaks to retrieve
569 meta data from the database
571 * System.Data.SqlClient/PostgresLibrary.cs -
572 added method OidToType to convert PostgreSQL oid type
573 to System.Type. Renamed method OidTypeToSystem
574 to ConvertPgTypeToSystem for converting the data value
575 from a PostgreSQL type to a .NET System type.
577 * System.Data.SqlClient/SqlCommand.cs: implemented
578 method ExecuteReader which returns a SqlDataReader
579 for a light forward only read only result set.
580 It works on types int4 ==> Int32 and
581 varchar ==> String. Other types
584 * System.Data.SqlClient/SqlConnection.cs: added comment
586 * System.Data.SqlClient/SqlDataReader.cs: implemented
587 class. It works, but still lots to do.
589 * Test/ReadPostgresData.cs: stuff
591 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
592 to display meta data and the data
594 2002-05-03 Duncan Mak <duncan@ximian.com>
596 * TODO: Took out all the Exceptions. They should be all done now.
598 * System.Data/ConstraintException.cs:
599 * System.Data/DBConcurrencyException.cs:
600 * System.Data/DataException.cs:
601 * System.Data/DeletedRowInaccessibleException.cs:
602 * System.Data/DuplicateNameException.cs:
603 * System.Data/EvaluateException.cs:
604 * System.Data/InRowChangingEventException.cs:
605 * System.Data/InvalidConstraintException.cs:
606 * System.Data/InvalidExpressionException.cs:
607 * System.Data/MissingPrimaryKeyException.cs:
608 * System.Data/NoNullAllowedException.cs:
609 * System.Data/ReadOnlyException.cs:
610 * System.Data/RowNotInTableException.cs:
611 * System.Data/StrongTypingException.cs:
612 * System.Data/SyntaxErrorException.cs:
613 * System.Data/TypeDataSetGeneratorException.cs:
614 * System.Data/VersionNotFoundException.cs: Added to CVS.
616 * System.Data.SqlTypes/SqlNullValueException.cs:
617 * System.Data.SqlTypes/SqlTruncateException.cs:
618 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
620 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
622 * System.Data/DataViewSettingCollection.cs: implemented.
624 * System.Data/DataRowView.cs: new stubs.
626 * System.Data.SqlTypes/SqlByte.cs:
627 * System.Data.SqlTypes/SqlDateTime.cs:
628 * System.Data.SqlTypes/SqlDecimal.cs:
629 * System.Data.SqlTypes/SqlDouble.cs:
630 * System.Data.SqlTypes/SqlGuid.cs:
631 * System.Data.SqlTypes/SqlInt16.cs:
632 * System.Data.SqlTypes/SqlInt64.cs:
633 * System.Data.SqlTypes/SqlMoney.cs:
634 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
635 by Tim Coleman <tcoleman@opentext.com>
637 * System.Data.build: excluded newly-added files.
639 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
641 * System.Data.SqlClient/PostgresLibrary.cs: included new
642 internal class that will be a helper class in using
643 PostgreSQL. PostgresLibrary is used for the
644 pinvoke methods to the PostgreSQL Client
645 native C library libpq while the class PostgresHelper
646 is used for wrapper or helper methods. It currently only
647 has one static method OidTypeToSystem in converting
648 PostgreSQL types to .NET System.<type>s, such as,
649 a PostgreSQL int8 becomes a .NET System.Int64.
650 Only a few types have been added, such as, int2,
651 int4, int8, varchar, text, bool, and char. Other types
654 * System.Data.SqlClient/SqlCommand.cs: implemented
655 method ExecuteScalar which allows us to do aggregate
656 functions, such as, count, avg, min, max, and sum. We
657 also are able to retrieve the result, convert it to the .NET type
658 as an object. The user of the returned object must explicitly cast.
660 * Test/ReadPostgresData.cs: updated sample
661 to help us learn to retrieve data in System.Data.SqlClient
664 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
666 * System.Data.build: added /nowarn: nnnn arguments
667 so you will not get a ton of warnings. The warnings
668 being excluded are: 1595, 0067, 0109, 0169, and 0649
670 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
672 * System.Data.build: modified to exclude more
675 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
677 * System.Data.SqlClient/SqlClientPermission.cs: added missing
680 * System.Data/MergeFailedEventArgs.cs: new class, contributed
681 by John Dugaw <jdugaw@unizenconsulting.com>.
683 * System.Data.build: excluded new files from build.
685 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
687 * Test/ReadPostgresData.cs: added - Uses the
688 PostgresLibrary to retrieve a recordset.
689 This is not meant to be used in Production, but as a
690 learning aid in coding
691 class System.Data.SqlClient.SqlDataReader.
692 This sample does work.
694 * Test/TestSqlDataReader.cs: added - used
695 to test SqlDataReader (does not work yet)
696 Forgot to add to ChangeLog on last commit.
698 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
700 * System.Data/DataViewSetting.cs: new class.
702 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
704 * System.Data/DataViewManager.cs: new class.
706 * System.Data.SqlTypes/INullable.cs: properties for interfaces
707 don't have implementation.
709 * System.Data.SqlTypes/SqlInt32.cs:
710 * System.Data.SqlTypes/SqlString.cs:
711 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
714 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
717 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
719 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
720 for correctly hiding parent class' members.
721 (AddRange): use 'override' keyword on overriden method.
723 (Contains): likewise.
725 (OnCollectionChanged): likewise.
726 (OnCollectionChanging): likewise.
727 (RemoveCore): likewise.
729 * System.Data/DataColumnCollection.cs: use 'new' keyword.
731 * System.Data/DataSet.cs: added missing 'using's.
733 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
735 * System.Data/DataSet.cs:
736 * System.Data/DataTableCollection.cs:
737 * System.Data/DataView.cs: compilation fixes on Linux.
739 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
741 * System.Data/DataRelation.cs
742 * System.Data/ForeignKeyConstraint.cs
743 * System.Data/UniqueConstraint.cs: added more stubs
745 * System.Data/DataTableRelationCollection.cs: added back to cvs
746 and modified for compile errors. DataRelationCollection is an
747 abstract class and there must be a class that implements for
748 DataTable/DataSet. DataTableRelationCollection was changed
749 to an internal class.
751 * System.Data.build: modified - new files added
752 also wanted to include files/classes in the build
753 so we can get a compilable forward read only result set.
754 It compiles now using csc/nant with warnings, but this
755 is a start for adding functionality for the result set.
756 Classes associated with/and DataSet are still excluded.
758 * TODO: modified - updated to do list for System.Data
760 * System.Data/Constraint.cs
761 * System.Data/ConstraintCollection.cs
762 * System.Data/DataRelationCollection.cs
763 * System.Data/DataRow.cs
764 * System.Data/DataRowChangeEventArgs.cs
765 * System.Data/DataRowCollection.cs
766 * System.Data/DataTable.cs
767 * System.Data/DataTableCollection.cs
768 * System.Data/InternalDataCollectionBase.cs
769 * System.Data/PropertyCollection.cs: modified -
770 changes to compile SqlDataReader/DataTable and
773 * System.Data/IDbCommand.cs
774 * System.Data.SqlClient/SqlCommand.cs: modified -
775 un-commented overloaded methods ExecuteReader
776 which returns a SqlDataReader
778 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
780 * System.Data/DataTableCollection.cs: more implementation.
781 (Count): added 'override' keyword, as pointer out by Martin.
783 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
784 only call Array.Copy when there is really stuff to be copied.
785 (CopyTo): don't create the temporary array, it's not needed.
787 * System.Data.build: excluded newly added file from build.
789 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
791 * System.Data/DataTableRelationCollection.cs: removed, it's not
792 on MS SDK documentation.
794 * System.Data/DataTableCollection.cs: new class.
796 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
798 * System.Data/DataRowChangeEventArgs.cs
799 * System.Data/DataRowCollection.cs
800 * System.Data/DataView.cs
801 * System.Data/PropertyCollection.cs: added new stubs
803 * System.Data.build: modified - added new files to exclude
806 * TODO: modified - removed files from TODO list
807 that were stubbed above
809 * System.Data/DataColumn.cs
810 * System.Data/DataRow.cs: modified - various tweaks
811 and added internal method SetTable to set the reference
814 * System.Data/DataSet.cs: modified - class was not
817 * System.Data/DataTable.cs: modified - temporarily commented
818 DataSet and DataView references - trying to compile a SqlDataReader,
819 DataTable, and dependencies for a forward read-only result set.
820 SqlDataAdapter, DataSet, and DataView will come later once we can get
821 a forward read only result set working.
823 * System.Data/IDataRecord.cs: modified - source code lines should
826 * System.Data/InternalDataCollectionBase.cs: modified - started
827 implementing this base class for collection of data rows,
828 columns, tables, relations, and constraints
830 * System.Data.SqlClient/SqlException.cs: modified -
831 call base(message) so a unhandled exception displays
832 the message of a SQL error instead of the
833 default SystemException message
835 * Test/TestSqlException.cs: modified -
836 handle the rollback properly for a SqlException on a
839 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
841 * System.Data.build: modified - added new
842 files to exclude from build
844 * System.Data/Constraint.cs
845 * System.Data/ConstraintCollection.cs
846 * System.Data/InternalDataCollectionBase.cs: added -
847 stubs which are needed to build DataTable.cs
849 * TODO: modified - added more classes TODO and
850 added more stuff TODO, such as, create script
851 to create test database monotestdb for testing
852 classes in System.Data
854 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
856 * System.Data.Common/DataAdapter.cs:
857 * System.Data.Common/DataColumnMappingCollection.cs:
858 * System.Data.Common/DataTableMappingCollection.cs:
859 * System.Data.Common/DbDataPermission.cs:
860 * System.Data.Common/DbDataPermissionAttribute.cs: some
861 compilation errors fixed.
863 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
865 * TODO: modified - added classes TODO, and
866 a poor attempt at System.Data plan
868 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
870 * ChangeLog: modified - put tabs where they belong
872 * System.Data.SqlClient/SqlDataReader.cs
873 * System.Data/DataColumn.cs: modified - compile errors
874 trying to compile SqlDataAdapter and dependencies
876 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
878 * System.Data.SqlTypes/SqlBoolean.cs
879 * System.Data.SqlTypes/SqlCompareOptions.cs
880 * System.Data.SqlTypes/SqlInt32.cs
881 * System.Data.SqlTypes/SqlString.cs: added - new stubs
883 * System.Data/DataTable.cs
884 * System.Data.SqlClient/SqlCommand.cs
885 * System.Data.SqlClient/SqlConnection.cs
886 * System.Data.SqlClient/SqlError.cs
887 * System.Data.SqlClient/SqlTransaction.cs: modified -
890 * System.Data.SqlClient/SqlException.cs: modified -
891 missing Message on indexer for Message property
893 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
895 * System.Data.SqlClient/SqlCommand.cs: modified - to
896 compile using mcs. This problem is
897 returning a stronger type in csc vs. msc
899 * System.Data.SqlClient/SqlConnection.cs: modified - msc
900 can not do a using PGconn = IntPtr; and then declare
901 with PGconn pgConn = IntPtr.Zero;
902 Thiw works under csc though. Had to comment using and
903 changed declaration to IntPtr pgConn = IntPtr.Zero;
904 Also, got rid of compile warnings for hostaddr and port.
906 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
907 rid of compile warnings. Commented MonoTODO attribute because mcs
908 doesn't seem to work with C# array property indexer (Item)
911 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
912 commented MonoTODO attribute for indexer for mcs compiling
914 * Test/TestSqlIsolationLevel.cs:
915 * Test/TestSqlInsert.cs:
916 * Test/TestSqlException.cs: modified -
917 removed extra ExecuteNonQuery which caused two inserted rows
919 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
921 * System.Data/StateChangeEventArgs.cs - added
922 needed to compile System.Data.dll with mcs.
924 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
926 * System.Data.OleDb: added directory - for OleDb database
929 * System.Data.SqlClient/SqlClientPermission.cs
930 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
931 * System.Data.SqlClient/SqlCommandBuilder.cs
932 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
933 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
934 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
935 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
936 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
937 * Test/TestSqlException.cs
938 * Test/TestSqlIsolationLevel.cs: added - more tests
940 * System.Data.build: modified - added new files - excludes these too
942 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
944 * System.Data.SqlClient/SqlConnection.cs
945 * System.Data.SqlClient/SqlCommand.cs
946 * System.Data.SqlClient/SqlTransaction.cs
947 * System.Data.SqlClient/SqlException.cs
948 * System.Data.SqlClient/SqlErrorCollection.cs
949 * System.Data.SqlClient/SqlError.cs: modified - transaction and
950 exception/error handling. SqlConnection(connectionString)
951 constructor should not automatically connect.
953 * System.Data.SqlClient/SqlDataReader.cs
954 * System.Data.SqlClient/SqlDataAdapter.cs
955 * System.Data.SqlClient/SqlParameter.cs
956 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
957 added using System.ComponentModel;
959 * Test/TestSqlInsert.cs: modified - to use transaction
961 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
963 * System.Data/DataRow.cs: new skeletons.
965 * System.Data.Common/DataAdapter.cs:
966 * System.Data.Common/DataColumnMapping.cs:
967 * System.Data.Common/DataColumnMappingCollection.cs:
968 * System.Data.Common/DataTableMapping.cs:
969 * System.Data.Common/DataTableMappingCollection.cs:
970 * System.Data.Common/DbDataAdapter.cs:
971 * System.Data.Common/RowUpdatedEventArgs.cs:
972 * System.Data.SqlClient/SqlDataAdapter.cs:
973 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
976 * System.Data.Common/DbDataRecord.cs:
977 * System.Data.Common/DbEnumerator.cs: removed MS implementation
980 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
982 * Test/TestSqlInsert.cs: modified - do
983 a SQL DELETE before SQL INSERT of row so you can use this
986 * System.Data.SqlClient/SqlTransaction.cs: modified - default
987 IsolationLevel for PostgreSQL is ReadCommitted. However,
988 PostgreSQL allows Serializable as well.
989 (Thanks to Gonzalo for that!)
991 * System.Data.SqlClient/SqlConnection.cs: modified
992 * System.Data.SqlClient/SqlCommand.cs: modified
993 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
994 working; however, we still need to implement SQL errors
995 and exceptions to properly handle transactions. Also, added
996 status and error message support from the PostgreSQL database.
997 Currently, this does a Console.WriteLine() to display the
998 status and error messages, but this is a TODO
999 for SQL errors and exceptions.
1001 * System.Data/TODOAttribute.cs: added - needed MonoTODO
1002 attribute for System.Data.dll assembly
1004 * System.Data/IDbCommand.cs: modified - commented
1005 overloaded method ExecuteReader
1006 so System.Data.SqlClient.SqlCommand can compile
1008 * System.Data/IDbCommand.cs: modified
1009 * System.Data/IDbConnection.cs: modified - added using System;
1010 * System.Data/IDataParameter.cs
1012 * System.Data.build: modified - build classes
1013 in System.Data.SqlClient and exclude others in System.Data
1015 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
1016 parameter data type from IntPtr to enum ExecStatusType
1018 * ChangeLog: modified - corrected previous entries in log
1020 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
1022 * System.Data.Common/DataColumnMappingCollection.cs: added basic
1023 implementation. Still missing some stuff.
1025 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1027 * System.Data.SqlClient/SqlConnection.cs: modified - got
1028 to compile, run, and connect to PostgreSQL database
1030 * System.Data.SqlClient/SqlCommand.cs: modified - got
1031 to compile, run, and execute a SQL INSERT command
1032 which successfully inserted a row
1033 into the PostgreSQL database
1035 * System.Data.SqlClient/SqlTransaction.cs: modified
1036 * System.Data.SqlClient/SqlParameter.cs: modified
1037 * System.Data.SqlClient/SqlParameterCollection.cs: modified
1038 * System.Data.SqlClient/SqlError.cs: modified
1039 * System.Data.SqlClient/SqlErrorCollection.cs: modified
1040 * System.Data.SqlClient/SqlException.cs: modified
1041 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
1043 * System.Data.SqlClient/SqlAdapter: modified
1044 * System.Data.SqlClient/SqlReader: modified - add more stubs
1046 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
1048 * Test/TestSqlInsert.cs: added
1050 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
1052 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
1053 class SqlConnecition
1054 * System.Data.SqlClient/SqlErrorCollection.cs: added
1055 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
1057 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
1059 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
1060 * System.Data.IDbTransaction: Added Interface to IDisposable.
1061 * System.Data.IDbCommand: Fixed Capitalization of class name.
1062 * System.Data.IDbConnection: Fixed Capitalization of class name.
1064 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1066 * System.Data.Common/DbDataPermissionAttribute.cs:
1067 * System.Data.Common/DataAdapter.cs:
1068 * System.Data.Common/DataColumnMapping.cs:
1069 * System.Data.Common/DbDataPermission.cs: added some implementation.
1071 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
1073 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
1074 syntax, as pointed out by Levent Camlibel.
1076 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
1078 * System.Data.SqlTypes/SqlBinary.cs:
1079 * System.Data.SqlTypes/INullable.cs: new skeletons.
1081 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
1083 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
1084 contains all calls the the PostgreSQL client library, to be used
1085 everywhere in System.Data.SqlClient.
1087 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
1089 * System.Data.SqlClient/SqlConnection.cs: implemented basic
1092 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
1094 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
1096 * System.Data.Common/DbDataRecord.cs:
1097 * System.Data.Common/DbEnumerator.cs:
1098 * System.Data.Common/RowUpdatedEventArgs.cs:
1099 * System.Data.Common/RowUpdatingEventArgs.cs:
1100 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
1102 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
1104 * System.Data.Common/DataTableMappingCollection.cs:
1105 * System.Data.Common/DbDataAdapter.cs:
1106 * System.Data.Common/DbDataPermission.cs:
1107 * System.Data.Common/DataTableMapping.cs: new skeletons.
1109 * System.Data.SqlClient/SqlDataAdapter.cs:
1110 * System.Data.SqlClient/SqlDataReader.cs:
1111 * System.Data.SqlClient/SqlErrors.cs:
1112 * System.Data.SqlClient/SqlError.cs:
1113 * System.Data.SqlClient/SqlException.cs:
1114 * System.Data.SqlClient/SqlParameter.cs:
1115 * System.Data.SqlClient/SqlParameterCollection.cs:
1116 * System.Data.SqlClient/SqlTransaction.cs:
1117 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
1119 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1121 * System.Data.Common/DataColumnMapping.cs:
1122 * System.Data.Common/DataColumnMappingCollection.cs:
1123 * System.Data.Common/DataAdapter.cs: created skeletons.
1125 * System.Data.build: exclude new directories from build.
1127 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
1129 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
1131 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
1132 implemented (2 methods).
1134 2002-03-24 Duncan Mak <duncan@ximian.com>
1136 * System.Data.build: Excluded System.Data.SqlClient from the build.
1137 The stubs are incomplete and they are stopping the build.
1139 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
1141 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
1143 * System.Data.SqlClient/*: added skeletons for the SQL managed
1144 provider for ADO.Net, to be based initially in PostgreSQL.
1146 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
1148 Changed the Namespace on some Enums from mono.System.Data to System.Data
1150 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
1152 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
1153 default name if the ColumnName is null.
1154 * DataSet.cs : Added
1155 * DataTable.cs : Added
1156 * DataRelationCollection.cs : Added
1157 * DataTableRelationCollection.cs : Added
1158 * DataColumn : Added
1160 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
1162 * DataColumnChangeEventArgs.cs : Added
1163 * DataColumnCollection.cs : Added
1165 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
1167 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
1168 * Updated all Enums, Interfaces, and Delegates in System.Data