1 2004-10-06 Umadevi S <sumadevi@novell.com>
2 * System.Data.dll.sources : Added ISqlNotificationReceiver, SqlNotifcationType,
3 SqlNotificationInfo, SqlNotificationSource
5 2004-09-15 Sebastien Pouliot <sebastien@ximian.com>
7 * System.Data_test.dll.sources: Added OdbcPermission, OleDbPermission
8 and SqlClientPermission unit tests to the build.
10 2004-09-14 Sebastien Pouliot <sebastien@ximian.com>
12 * System.Data_test.dll.sources: Added DBDataPermission unit tests to
15 2004-09-14 Umadevi S <sumadevi@novell.com>
16 * Added System.Data.SqlTypes/SqlNotFilledException.cs,System.Data.SqlTypes/
17 SqlAlreadyFilledException.cs to System.Data.dll.sources
19 2004-09-13 Sebastien Pouliot <sebastien@ximian.com>
21 * Makefile: Added /nowarn:618 when compiling unit test assembly to
22 remove nunit obsolete warnings.
23 * System.Data.dll.sources: Added System.Data.Common.DbConnectionOptions
24 (NET_2_0) and System.Data.Common/PermissionHelper to the build.
25 * System.Data_test.dll.sources: Added {DBData|Odbc|OleDb|SqlClient}
26 PermissionAttribute unit tests to the build.
28 2004-08-25 Nick Drochak <ndrochak@ieee.com>
30 * Makefile: Cut down the the build noise.
32 2004-08-19 Gert Driesen <drieseng@users.sourceforge.net>
33 * Added System.Data.SqlClient/SqlConnectionTest.cs to
34 System.Data_test.dll.sources
36 2004-07-14 Umadevi S <sumadevi@novell.com>
37 * Added System.Data.SqlTypes/StorageState.cs to System.data.dll.sources
39 2004-07-09 Umadevi S <sumadevi@novell.com>
40 * Added System.Data.Sql/IUdtSerializationContext.cs and System.Data.Sql/SqlFacetAttribute.cs to system.data.dll.sources
42 2004-06-02 Umadevi S <sumadevi@novell.com>
43 * added System.Data/DataTableTypeConverter to system.data.dll.sources
45 2004-05-27 Umadevi S <sumadevi@novell.com>
46 * added files DataTableMappingCollectionTest and DataColumnMappingCollectionTest to system.data_test.dll.sources
48 2004-05-26 Umadevi S <sumadevi@novell.com>
49 * Added files DataTableCollectionTest and DataRelationCollectionTest to the system.data_test.dll.sources
51 2004-05-20 Umadevi S <sumadevi@novell.com>
52 * Fixed bug 58406- implemented the hasrow method, test program used
53 to test with the bug report
55 2004-05-19 Boris Kirzner <borisk@mainsoft.com>
56 * System.Data.dll.sources : Added DataContainer.cs
58 2004-05-19 Boris Kirzner <borisk@mainsoft.com>
59 * System.Data.dll.sources : Added RecordCache.cs
61 2004-05-14 Umadevi S <sumadevi@novell.com>
62 * System.Data.dll.sources : Added SQLDebugging.cs
64 2004-05-14 Umadevi S <sumadevi@novell.com>
65 * System.Data.dll.sources : Added OdbcParameterConverter.cs
67 2004-05-14 Umadevi S <sumadevi@novell.com>
68 * System.Data.dll.sources : Added OdbcCategoryAttribute.cs OdbcDescriptionAttribute.cs
70 2004-05-14 Umadevi S <sumadevi@novell.com>
71 * System.Data.dll.sources : Added OdbcCommandBuilder.cs
73 2004-05-14 Umadevi S <sumadevi@novell.com>
74 * System.Data.dll.sources : Added OdbcInfoMessageEventArgs.cs, OdbcInfoMessageEventHandler.cs
76 2004-05-14 Umadevi S <sumadevi@novell.com>
77 * System.Data.dll.sources : Added OdbcPermission.cs,OdbcPermissionAttribute.cs
79 2004-05-13 Umadevi S <sumadevi@novell.com>
81 * System.Data.dll.sources : added OleDbParameterConverter.cs
84 2004-05013 Umadevi S <sumadevi@novell.com>
86 * System.Data.dll.sources : added RelationshipConverter.cs
88 2004-05-07 Atsushi Enomoto <atsushi@ximian.com>
90 * System.Data.dll.sources : added XmlDataInferenceLoader.cs and
93 2004-04-26 Jackson Harper <jackson@ximian.com>
95 * Makefile: output to profile directory.
97 2004-04-26 Atsushi Enomoto <atsushi@ximian.com>
99 * System.Data.dll.sources : added CustomDataClassGenerator.cs.
101 2004-04-19 Atsushi Enomoto <atsushi@ximian.com>
103 * System.Data_test.dll.sources : added DataSetInferXmlSchemaTest.cs.
105 2004-04-19 Atsushi Enomoto <atsushi@ximian.com>
107 * System.Data.dll.sources : Added XmlSchemaDataImporter.cs
109 2004-04-15 Atsushi Enomoto <atsushi@ximian.com>
111 * System.Data_test.dll.sources :
112 added DataSetReadXmlSchemaTest.cs and DataSetAssertion.cs.
114 2004-04-14 Atsushi Enomoto <atsushi@ximian.com>
116 * System.Data_test.dll.sources : added DataSetReadXmlTest.cs.
118 2004-04-13 Atsushi Enomoto <atsushi@ximian.com>
120 * System.Data_test.dll.sources : added XmlDataDocumentTest2.cs.
122 2004-04-05 Lluis Sanchez Gual <lluis@ximian.com>
124 * System.Data.dll.sources: removed SqlConnectionPool.cs.
126 2004-03-29 Juraj Skripsky <juraj@hotfeet.ch>
128 * System.Data.dll.sources : added classes in Mono.Data.SqlExpressions
129 * Makefile : add jay-target for Mono.Data.SqlExpressions/Parser.cs
131 2004-03-12 Andreas Nahr <ClassDevelopment@A-SoftTech.com>
133 * System.Data.dll.sources : added classes
135 2004-03-04 Eran Domb <erand@mainsoft.com>
137 * System.Data.dll.sources : added Node.cs, ComparerFactory.cs.
139 2004-03-03 Atsushi Enomoto <atsushi@ximian.com>
141 * System.Data.dll.sources : added Index.cs.
143 2004-01-21 Atsushi Enomoto <atsushi@ximian.com>
145 * System.Data_test.dll.sources : Added TypedDataSetGeneratorTest.cs.
147 2004-01-20 Atsushi Enomoto <atsushi@ximian.com>
149 * System.Data.dll.sources: Added missing TypedDataSetGenerator.cs.
151 2003-12-28 Tim Coleman <tim@timcoleman.com>
152 * System.Data.dll.sources:
153 Add new .NET 1.2 sources.
155 2003-12-21 Tim Coleman <tim@timcoleman.com>
156 * System.Data.dll.sources:
157 Add new .NET 1.2 sources.
159 2003-12-19 Tim Coleman <tim@timcoleman.com>
160 * System.Data.dll.sources:
161 Add new .NET 1.2 sources.
163 2003-12-16 Tim Coleman <tim@timcoleman.com>
164 * System.Data.dll.sources:
165 Add new .NET 1.2 sources.
167 2003-11-26 Tim Coleman <tim@timcoleman.com>
168 * System.Data.dll.sources:
169 Add many new System.Data classes for NET_2_0 build.
171 2003-11-25 Tim Coleman <tim@timcoleman.com>
172 * System.Data.dll.sources:
173 Add System.Data/IDataSources.cs to build
175 2003-07-18 Andreas Nahr <ClassDevelopment@A-SoftTech.com>
177 * System.Data.dll.sources: Assembly/Locale.cs added, Assembly/AssemblyInfo.cs added
179 2003-07-18 Peter Williams <peter@newton.cx>
181 * Makefile (EXTRA_DISTFILES): NUnit.Prefs is not
184 2003-07-16 Peter Williams <peter@newton.cx>
186 * Makefile: Flip around for the new default build
189 2003-06-16 Tim Coleman <tim@timcoleman.com>
190 * System.Data.Common/DbDataAdapter.cs:
191 Add the DataTable to the result set even if it contains
192 no rows. Based on report by Krieg Andreas.
194 2003-03-17 Daniel Morgan <danmorg@sc.rr.com>
196 * System.Data.build: on windows build, ignore
197 warnings CS0219: "The variable xxx is assigned but its value is
198 never used" and CS0168: "The variable xxx
199 is declared but never used"
201 * System.Data/DataRow.cs: flush
203 * System.Data/DataSet.cs: start implementation on Clear(),
204 and WriteXml() should write the start element <?xml ... ?> at the top
207 * System.Data/DataTable.cs: TODO/FIXME notes. Start implementation
208 of Compute() - still not working
210 2003-03-16 Daniel Morgan <danmorg@sc.rr.com>
212 * System.Data/DataRowView.cs: in the constructor pass
213 DataRow in instead of int index of the DataRow
216 * System.Data/DataTable.cs: implement sorting
217 for method Select(filterExpression,sort)
219 * System.Data/DataView.cs: more implementation -
220 Now, If Sort, RowFilter, or RowStateFilter is set, an
221 enumerated DataRowViews will be a view with those
222 properties applied. Still need to implement event handling
225 2003-03-13 Tim Coleman <tim@timcoleman.com>
226 * System.Data.SqlClient/SqlCommandBuilder.cs:
227 Change "where" variable name to "whereClause" at the
228 request of Rhys Weatherley <rweather@zip.com.au>
230 2003-03-10 Daniel Morgan <danmorg@sc.rr.com>
232 * System.Data.SqlClient/SqlDataReader.cs: when
233 the data reader is closed, this SqlDataReader referenced
234 in SqlConnection needs to be null
236 * System.Data.Common/DbDataAdapter.cs: for SelectCommands executed that
237 have no result set, such as, DDL like CREATE TABLE or DML like INSERT,
238 the data reader needs to be immediately closed, and 0 returned
239 as the number of rows added or refreshed
241 2003-02-18 Daniel Morgan <danmorg@sc.rr.com>
243 * DataTableRelationCollection.cs: removed file
244 because its internally in file DataRelationCollection.cs
246 2003-02-18 Alan Tam <Tam@SiuLung.com>
248 * DataRelation.cs: Added storage required to hold the relations.
249 Checking of constraints are not implemented yet.
250 * DataRelationCollection.cs: Implemented DataSetRelationCollection
251 and DataTableRelationCollection, both as inner class of the abstract class
252 DataRelationCollection (like Microsoft although not documented in ECMA).
253 * DataRow.cs: Implemented GetChildRows in a extremely slow way.
254 Need to implement caching like Microsoft later.
255 * DataSet.cs: Uncomment DataRelation related members. Uncomment
256 code for Nested XML. Implemented WriteTable(XmlWriter, DataRow[],
257 XmlWriteMode) for use of Nested XML. Fixed a wrong modifier in
258 GetSerializationData.
259 * DataTable.cs: Uncomment DataRelation related members.
261 2003-02-11 Tim Coleman <tim@timcoleman.com>
262 * System.Data.SqlClient/SqlConnection.cs:
263 Close the data reader properly, and be sure
264 to close the data reader when the connection
267 2003-02-10 Nick Drochak <ndrochak@gol.com>
269 * System.Data.build: Keep the standalone tests out of the dll.
271 2003-02-09 Rodrigo Moya <rodrigo@ximian.com>
273 * System.Data.OleDb/OleDbConnection.cs:
274 * System.Data.OleDb/libgda.cs: upgraded to libgda 0.10.
276 2003-01-30 Ville Palo <vi64pa@koti.soon.fi>
278 * list: Added new file ExpressionElement.cs
280 2003-01-26 Daniel Morgan <danmorg@sc.rr.com>
282 * System.Data/DataColumn.cs: fix to not check for DataType being set
284 * System.Data/DataRow.cs: misc fixes
286 * Test/SqlTest.cs: accept connection parameters from
287 command line instead of being hard coded
289 * Test/System.Data_test.build: exclude building SqlTest.cs
291 * Test/System.Data/DataRowTest.cs
292 * Test/System.Data/DataColumnTest.cs: added new tests and numbered
293 all the tests so they can be easily identified
295 * Test/System.Data/DataRelationTest.cs: commented code that calls
296 DataSet's BeginEdit() and EndEdit() which causes a compile error
298 2003-01-24 Daniel Morgan <danmorg@sc.rr.com>
300 * System.Data/DataColumn.cs: fixes to be like .NET -
301 when setting AllowDBNull to false, determine if there is
302 any data that has DBNull.Value, implement AutoIncrement, do not
303 allow changing the DataType of the column if data has already been
304 set, check if the DataType is supported,
306 * System.Data/DataColumnCollection.cs: handle default ColumnName
309 * System.Data/DataRow.cs: fixes to be like .NET - a
310 data column gets initialized to all DBNull.Values not null,
311 implement AutoIncrement, when setting ItemArray if the item array being
312 set has less items than the number of columns in the table set those last
313 columns to DBNull.Value, after setting ItemArray values do an EndEdit(),
314 both a null and DBNull.Value get set to a DBNull.Value, only use DefaultValue
315 and AutoIncrement if the value is set to null while DBNull.Value only gets set
318 2003-01-17 Daniel Morgan <danmorg@sc.rr.com>
320 * System.Data.SqlClient.SqlConnection.cs: add connection
321 parameter UID which is the same thing as User ID
323 2003-01-13 Ville Palo <vi64pa@koti.soon.fi>
325 * System.Xml/XmlDataDocument.cs: lots of bugfixes and more implemented
328 2003-01-08 Gonzalo Paniagua Javier <gonzalo@ximian.com>
330 * list: added System.Data/DataTablePropertyDescriptor.cs
332 2002-12-27 Ville Palo <vi64pa@koti.soon.fi>
334 * list: Added System.Data/XmlDataLoader.cs
336 2002-12-16 Ville Palo <vi64pa@koti.soon.fi>
338 * System.Xml/XmlDataDocument.cs: Now rollback works. It means all
339 types of transactions works, i guess ;)
341 2002-12-14 Ville Palo <vi64pa@koti.soon.fi>
343 * System.Xml/XmlDataDocument.cs: Adding row via XmlDataDocument to
344 DataSet's datatable is now possible.
346 2002-12-11 Ville Palo <vi64pa@koti.soon.fi>
348 * System.Xml/XmlDataDocument.cs: Implemented GetRowFromElement() and
349 GetElementFromRowElement () -methods. Somefixed and little clean up.
351 2002-12-10 Gonzalo Paniagua Javier <gonzalo@ximian.com>
353 * System.Data.SqlClient/SqlCommand.cs:
354 (CloseReader): don't get the output parameters here.
355 (GetOutputParameters): don't skip the stream. The parameters will be
358 * System.Data.SqlClient/SqlConnection.cs: don't try to execute
359 'sp_reset_connection'.
361 * System.Data.SqlClient/SqlDataReader.cs: get the output parameters
362 after the end of the results.
364 2002-12-04 Ville Palo <vi64pa@koti.soon.fi>
366 * System.Xml/XmlDataDocument.cs: Now this works in both ways,
367 DataSet <--> XmlDataDocument.cs at some level at least.
369 2002-12-02 Ville Palo <vi64pa@koti.soon.fi>
371 * System.Xml/XmlDataDocument.cs : some fixes and some imlemented
374 2002-12-01 Tim Coleman <tim@timcoleman.com>
375 * System.Data.SqlClient/SqlDataReader.cs:
376 Change to reflect TdsSchemaInfo -> TdsDataColumnCollection
379 2002-12-01 Ville Palo <vi64pa@koti.soon.fi>
381 * list: Added XmlDataDocument.cs
382 * System.Xml/XmlDataDocument.cs: more implementation.
384 2002-11-30 Daniel Morgan <danmorg@sc.rr.com>
386 * System.Data.Odbc/OdbcDataReader.cs: implemented GetValues() method
387 needed by OdbcDataAdapter
389 * System.Data.Odbc/OdbcDataAdapter.cs
390 * System.Data.Odbc/OdbcRowUpdatedEventArgs.cs
391 * System.Data.Odbc/OdbcRowUpdatedEventHandler.cs
392 * System.Data.Odbc/OdbcRowUpdatingEventArgs.cs
393 * System.Data.Odbc/OdbcRowUpdatingEventHandler.cs: added files for an
396 * list: added new files to linux build
397 in namespace System.Data.Odbc for the ODBC Data Adapter
399 * System.Xml/XmlDataDocument.cs: commented method
400 protected internal override XPathNavigator CreateNavigator(XmlNode node)
401 because it would not compile on .NET Framework. Added
402 a FIXME comment there
404 2002-11-29 Ville Palo <vi64pa@koti.soon.fi>
406 * System.Xml/XmlDataDocument.cs: Started to implement.
408 2002-11-26 Tim Coleman <tim@timcoleman.com>
409 * System.Data.SqlClient/SqlCommand.cs:
410 * System.Data.SqlClient/SqlConnection.cs:
411 * System.Data.SqlClient/SqlDataReader.cs:
412 * System.Data.SqlClient/SqlParameter.cs:
413 * System.Data.SqlClient/SqlParameterCollection.cs:
414 * System.Data.SqlClient/SqlTransaction.cs:
415 Many changes around restructuring of parameter
416 information so that the Sybase provider supports
419 2002-11-25 Ville Palo <vi64pa@koti.soon.fi>
421 * System.Data/DataSet.cs : Started to implement ReadXmlSchema -method
423 2002-11-21 Tim Coleman <tim@timcoleman.com>
425 * System.Data.SqlClient/SqlCommand.cs:
426 * System.Data.SqlClient/SqlConnection.cs:
427 * System.Data.SqlClient/SqlConnectionPool.cs:
428 * System.Data.SqlClient/SqlDataReader.cs:
429 * System.Data.SqlClient/SqlException.cs:
430 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs:
431 * System.Data.SqlClient/SqlParameter.cs:
432 * System.Data.SqlClient/SqlTransaction.cs:
433 * System.Data.SqlClient/SqlXmlTextReader.cs:
434 * System.Data.SqlTypes/SqlDecimal.cs:
435 Modify to accept new Mono.Data.Tds.Protocol
436 namespace in Mono.Data.Tds assembly, replacing
437 Mono.Data.TdsClient.Internal
439 2002-11-20 Ville Palo <vi64pa@koti.soon.fi>
441 * System.Data.SqlTypes/SqlDecimal.cs: Ported some divide-stuff from
442 decimal.c file. Does not work correctly yet.
444 2002-11-18 Tim Coleman <tim@timcoleman.com>
445 * System.Data.SqlClient/SqlConnection.cs:
446 BeginTransaction bug.
447 * System.Data.SqlClient/SqlParameter.cs:
448 Add some comments to describe what is going on.
449 * System.Data.SqlClient/SqlCommand.cs:
451 * System.Data.SqlClient/SqlDataReader.cs:
452 Add support to get SQL Types
454 2002-11-16 Daniel Morgan <danmorg@sc.rr.com>
456 * System.Data/DataView.cs: fix bug
457 with DataViewEnumerator causing InvalidOperationException
460 2002-11-15 Tim Coleman <tim@timcoleman.com>
461 * System.Data.Common/DbDataPermission.cs:
462 * System.Data.SqlClient/SqlClientPermission.cs:
463 Make these agree on the class status page.
464 * System.Data.SqlClient/SqlCommand.cs:
465 - Fix up handling of GUID and [Var]Binary, and Image types
466 * System.Data.SqlClient/SqlParameter.cs:
467 - Provide support for conversion between Type,
468 DbType, SqlDbType, and the SQL server type names.
469 - Fix up handling of GUID and [Var]Binary types
470 * System.Data.SqlClient/SqlParameterCollection.cs:
471 Correct all of the Add methods.
473 - Add more types to test: unique identifier, binary,
474 image, smalldatetime, money, smallmoney, timestamp
476 2002-11-14 Daniel Morgan <danmorg@sc.rr.com>
478 * System.Data/DataColumnPropertyDescriptor.cs
479 * System.Data/DataRowView.cs
480 * System.Data/DataView.cs
481 * System.Data.Common/DbDataRecord.cs: a little bit more
482 implementation for data binding purposes
484 * Test/PostgresTest.cs
485 * Test/TestSqlDataAdapter.cs
486 * Test/TestSqlException.cs
487 * TestSqlParameters.cs: fixed test for PostgreSQL's new home
488 at Mono.Data.PostgreSqlClient
490 2002-11-14 Tim Coleman <tim@timcoleman.com>
491 * System.Data.SqlClient/SqlCommand.cs:
492 Slight reformatting of Bit values and sql statements
493 * System.Data.SqlClient/SqlDataReader.cs:
494 Implement RecordsAffected
496 * System.Data.SqlClient/SqlParameter.cs:
497 Propertly support Char/NChar
498 * System.Data.SqlClient/SqlXmlTextReader.cs:
499 Add Close () to the Dispose () method
501 2002-11-13 Tim Coleman <tim@timcoleman.com>
503 New class added for testing SqlClient
504 * System.Data.SqlClient/SqlCommand.cs:
505 Add handling for SqlDbType.Bit
506 * System.Data.SqlClient/SqlConnection.cs:
507 Implement Dispose () methods.
508 Change ConnectionString setter
509 * System.Data.SqlClient/SqlDataReader.cs:
510 Implement Dispose () methods.
511 Set RecordsAffected to -1 by default. Need to
512 set this correctly in the future.
513 * System.Data.SqlClient/SqlCommandBuilder.cs:
514 * System.Data.SqlClient/SqlDataAdapter.cs:
515 * System.Data.SqlClient/SqlTransaction.cs:
516 * System.Data.SqlClient/SqlXmlTextReader.cs:
517 Implement Dispose () methods.
519 2002-11-12 Tim Coleman <tim@timcoleman.com>
521 Remove Mono.Data.TdsClient.Internal/TdsContext.cs
522 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
523 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
524 Complete these classes
525 * System.Data.Common/DbDataAdapter.cs:
526 Experimental support for FillSchema ()
528 2002-11-11 Tim Coleman <tim@timcoleman.com>
529 * System.Data/ResDescriptionAttribute.cs:
531 New internal class added
532 * System.Data/Constraint.cs:
533 * System.Data/ConstraintCollection.cs:
534 * System.Data/DBConcurrencyException.cs:
535 * System.Data/DataColumn.cs:
536 * System.Data/DataColumnCollection.cs:
537 * System.Data/DataRelation.cs:
538 * System.Data/DataRelationCollection.cs:
539 * System.Data/DataRow.cs:
540 * System.Data/DataRowBuilder.cs:
541 * System.Data/DataRowBuilder.cs:
542 * System.Data/DataRowCollection.cs:
543 * System.Data/DataSet.cs:
544 * System.Data/DataTable.cs:
545 * System.Data/DataTableCollection.cs:
546 * System.Data/DataView.cs:
547 * System.Data/DataViewManager.cs:
548 * System.Data/DataViewSetting.cs:
549 * System.Data/DataViewSettingCollection.cs:
550 * System.Data/ForeignKeyConstraint.cs:
551 * System.Data/ForeignKeyConstraint.cs:
552 * System.Data/InternalDataCollectionBase.cs:
553 * System.Data/MergeFailedEventArgs.cs:
554 * System.Data/StrongTypingException.cs:
555 * System.Data/TypeDataSetGeneratorException.cs:
556 * System.Data/UniqueConstraint.cs:
557 * System.Data.Common/DataAdapter.cs:
558 * System.Data.Common/DataColumnMapping.cs:
559 * System.Data.Common/DataColumnMappingCollection.cs:
560 * System.Data.Common/DataTableMapping.cs:
561 * System.Data.Common/DataTableMappingCollection.cs:
562 * System.Data.Common/DbDataAdapter.cs:
563 * System.Data.Common/DbDataPermission.cs:
564 * System.Data.Common/DbDataPermissionAttribute.cs:
565 * System.Data.Common/DbEnumerator.cs:
566 * System.Data.SqlClient/SqlCommand.cs:
567 * System.Data.SqlClient/SqlCommandBuilder.cs:
568 * System.Data.SqlClient/SqlConnection.cs:
569 * System.Data.SqlClient/SqlDataAdapter.cs:
570 * System.Data.SqlClient/SqlParameter.cs:
571 Add missing attributes, methods, properties based on information
572 from System.Data class status page on go-mono.com.
575 2002-11-10 Ville Palo <vi64pa@koti.soon.fi>
577 * System.Data.SqlTypes/SqlString.cs: Now all methods are implemented
579 2002-11-09 Tim Coleman <tim@timcoleman.com>
581 * System.Data/DataCategoryAttribute.cs:
582 Add new attribute based on corcompare
584 2002-11-09 Rodrigo Moya <rodrigo@ximian.com>
586 * System.Data.OleDb/OleDbDataAdapter.cs: cleaned up implementation,
587 based on the PgSql/SqlClient data adapter classes.
589 2002-11-09 Tim Coleman <tim@timcoleman.com>
591 Add new internal tds classes
592 * System.Data.Common/DbDataAdapter.cs:
593 * System.Data.SqlClient/SqlDataAdapter.cs:
594 Change event calling system
595 * System.Data.SqlClient/SqlClientPermission.cs:
596 * System.Data.SqlClient/SqlClientPermissionAttribute.cs:
597 * System.Data.SqlClient/SqlDataReader.cs:
599 * System.Data.SqlClient/SqlCommand.cs:
600 Some changes to make consistent with .NET based on Sql server traces
601 Implement command timeout
602 * System.Data.SqlClient/SqlCommandBuilder.cs:
603 Make sure that we only build a command if key info found
604 * System.Data.SqlClient/SqlConnection.cs:
605 Change event calling system
606 Some changes to make consistent with .NET based on Sql server traces
607 Implement connection timeout
608 * System.Data.SqlClient/SqlConnectionPool.cs:
609 Implement connection timeout
610 * System.Data.SqlClient/SqlError.cs:
611 Implement ToString ()
612 * System.Data.SqlClient/SqlException.cs:
613 Mucho implementation and cleanup
614 * System.Data.SqlClient/SqlParameter.cs:
616 * System.Data.SqlClient/SqlParameterCollection.cs:
618 * System.Data.SqlClient/SqlTransaction.cs:
619 Move some of the transaction creation to SqlConnection to be consistent
622 2002-11-08 Tim Coleman <tim@timcoleman.com>
623 * System.Data/DataRow.cs:
624 * System.Data/DataTable.cs:
625 Some fix-ups related to the DbDataAdapter to make it work.
626 * System.Data.Common/DbDataAdapter.cs:
627 Fix the Fill () and Update () methods. These now work
628 fairly well. Need mucho testing.
629 * System.Data.SqlClient/SqlCommandBuilder.cs:
630 Support table mappings and parameter source versions now.
631 * System.Data.SqlClient/SqlConnection.cs:
632 * System.Data.SqlClient/SqlTransaction.cs:
633 Add set accessor for transaction so that SqlTransaction.Commit ()
634 will remove itself from the connection.
635 * System.Data.SqlClient/SqlDataAdapter.cs:
636 Update/Insert/Delete command should be null by default.
637 * System.Data.SqlClient/SqlException.cs:
638 Remove a TODO attribute
639 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
640 Properly handle the SqlCommand object
642 2002-11-08 Ville Palo <vi64pa@koti.soon.fi>
644 * System.Data.SqlTypes/SqlDateTime.cs: Now the all methods are
647 2002-11-08 Gonzalo Paniagua Javier <gonzalo@ximian.com>
649 * System.Data.SqlTypes/SqlDecimal.cs: fixed build. Someone should check
650 my comments and do something more appropiate.
652 2002-11-07 Ville Palo <vi64pa@koti.soon.fi>
654 * System.Data.SqlTypes/SqlBinary.cs:
655 * System.Data.SqlTypes/SqlBoolean.cs:
656 * System.Data.SqlTypes/SqlByte.cs:
657 * System.Data.SqlTypes/SqlDateTime.cs:
658 * System.Data.SqlTypes/SqlDecimal.cs:
659 * System.Data.SqlTypes/SqlDouble.cs:
660 * System.Data.SqlTypes/SqlDecimal.cs:
661 * System.Data.SqlTypes/SqlGuid.cs:
662 * System.Data.SqlTypes/SqlInt16.cs:
663 * System.Data.SqlTypes/SqlInt32.cs:
664 * System.Data.SqlTypes/SqlInt64.cs:
665 * System.Data.SqlTypes/SqlMoney.cs:
666 * System.Data.SqlTypes/SqlSingle.cs:
667 * System.Data.SqlTypes/SqlString.cs: Implemented more methods and
668 fixed some. SqlBoolean Equals (object value) -method improvements to
671 2002-11-07 Tim Coleman <tim@timcoleman.com>
672 * System.Data.Common/DbDataAdapter.cs:
673 Remove NotImplementedException in Dispose
674 * System.Data.Common/FieldNameLookup.cs:
676 * System.Data.SqlClient/SqlCommand.cs:
677 Fix CommandText accessor (stack overflow)
678 Implement DeriveParameters method
679 * System.Data.SqlClient/SqlCommandBuilder.cs:
681 * System.Data.SqlClient/SqlConnection.cs:
682 Change application name to "Mono SqlClient Data Provider"
683 * System.Data.SqlClient/SqlDataReader.cs:
684 Add new schema information
685 * System.Data.SqlClient/SqlError.cs:
686 * System.Data.SqlClient/SqlErrorCollection.cs:
687 Remove internal methods, TODO attributes
688 * System.Data.SqlClient/SqlParameter.cs:
689 Add new internal constructor for DeriveParameters use
690 * System.Data.SqlClient/SqlParameterConverter.cs:
691 Add missing methods based on class status
693 2002-11-07 Nick Drochak <ndrochak@gol.com>
694 * list: add System.Data/ColumnDataPropertyDescriptor.cs
696 2002-11-04 Tim Coleman <tim@timcoleman.com>
698 Add Mono.Data.TdsClient.Internal.TdsInternalError
699 Add Mono.Data.TdsClient.Internal.TdsInternalErrorCollection
700 Add Mono.Data.TdsClient.Internal.TdsInternalErrorMessageEventHandler
701 Add Mono.Data.TdsClient.Internal.TdsInternalErrorMessageEventArgs
702 Add Mono.Data.TdsClient.Internal.TdsInternalInfoMessageEventHandler
703 Add Mono.Data.TdsClient.Internal.TdsInternalInfoMessageEventArgs
704 Remove Mono.Data.TdsClient.Internal.TdsPacketErrorResult
705 Remove Mono.Data.TdsClient.Internal.TdsPacketErrorResultCollection
706 Remove Mono.Data.TdsClient.Internal.TdsPacketMessageResult
707 * System.Data.Common/RowUpdatedEventArgs.cs:
708 * System.Data.Common/RowUpdatingEventArgs.cs:
710 * System.Data.SqlClient/SqlCommand.cs:
711 * System.Data.SqlClient/SqlDataReader.cs:
712 Remove checks for errors. These are now handled by events
713 * System.Data.SqlClient/SqlConnection.cs:
714 * System.Data.SqlClient/SqlError.cs:
715 * System.Data.SqlClient/SqlException.cs:
716 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs:
717 Add event handlers and triggers for errors, messages, state change
718 * System.Data.SqlClient/SqlParameter.cs:
719 Re-add refreshproperties
720 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
721 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs:
722 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
723 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs:
726 2002-11-04 Tim Coleman <tim@timcoleman.com>
728 Add Mono.Data.TdsClient.Internal.TdsBigDecimal
729 Add System.Data.SqlClient.SqlParameterConverter
730 Add System.Data.DataSysDescriptionAttribute
731 * System.Data/DataSysDescriptionAttribute.cs:
733 * System.Data.Common/DbDataPermission.cs:
734 Add CreateInstance method
735 * System.Data.SqlClient/SqlClientPermission.cs:
736 * System.Data.SqlClient/SqlError.cs:
737 Add Serializable attribute
738 * System.Data.SqlClient/SqlCommand.cs:
739 * System.Data.SqlClient/SqlConnection.cs:
740 * System.Data.SqlClient/SqlDataAdapter.cs:
741 * System.Data.SqlClient/SqlParameter.cs:
742 Add some missing property attributes
743 * System.Data.SqlClient/SqlCommandBuilder.cs:
744 Add some missing property attributes
746 * System.Data.SqlClient/SqlDataReader.cs:
747 Implement missing methods
748 * System.Data.SqlClient/SqlErrorCollection.cs:
749 Implement the properties
750 * System.Data.SqlClient/SqlException.cs:
751 Remove extra property accessors
752 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs:
753 Add internal constructor
754 * System.Data.SqlClient/SqlParameterCollection.cs:
755 Add internal constructor
756 Add property attributes
757 * System.Data.SqlClient/SqlParameterConverter.cs:
758 New internal class added
759 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
760 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
762 * System.Data.SqlTypes/SqlDecimal.cs:
763 Add implicit conversion from TdsBigDecimal to SqlDecimal
764 * System.Data.SqlTypes/SqlString.cs:
765 * System.Data.SqlTypes/SqlInt16.cs:
766 * System.Data.SqlTypes/SqlDateTime.cs:
767 Change code to remove compiler warnings
769 2002-11-04 Stuart Caborn <stuart.caborn@clearswift.com>
771 * list: added System.Data/XmlConstants.cs to
774 * System.Data/XmlConstants.cs: added -
775 * System.Data/DataTable.cs
776 * System.Data/DataSet.cs
777 * System.Data/DataColumn.cs
778 * System.Data/DataColumnCollection.cs
779 * System.Data/DataRelation.cs: modified -
780 Began initial implementation of WriteXml
781 and WriteXmlSchema. There is no support for DiffGrams
782 yet. In WriteSchema mode, relationships are missing,
783 all types are xs:string and the namespacing is not
784 working properly. Added support for Ordinals in the
785 DataColumnCollection and added support for
786 namespaces and prefixes.
788 2002-11-03 Ville Palo <vi64pa@koti.soon.fi>
790 * System.Data.SqlTypes/SqlBinary.cs: Finished and no errors generated
791 by NUnitConsole_mono.exe
793 2002-11-03 Tim Coleman (tim@timcoleman.com)
794 * System.Data.SqlClient/SqlCommand.cs:
795 Use SET NO_BROWSETABLE ON when CommandBehavior is KeyInfo
796 * System.Data.SqlClient/SqlDataReader.cs:
797 Get more schema info if available
799 Add Mono.Data.TdsClient.Internal.TdsColumnStatus
801 2002-11-02 Tim Coleman (tim@timcoleman.com)
802 * System.Data.SqlClient/SqlCommand.cs:
803 Change to use sp_executesql to run regular text queries.
804 Now, sp_executesql for text, sp_execute for prepared,
805 and execute for SPs means everything runs a procedure.
806 * System.Data.SqlClient/SqlParameter.cs:
807 Allow client to set parameter name in Prepare ()
808 * System.Data.SqlClient/SqlParameterCollection.cs:
809 Implement some methods
810 * System.Data.SqlClient/SqlDataReader.cs:
811 Since everything is an SP now, we know that when
812 we see DoneProc, that we are really done.
814 2002-11-01 Tim Coleman (tim@timcoleman.com) :
815 * System.Data.Common/DbEnumerator.cs :
816 Throw correct exception on Reset ()
817 Add ColumnSize to schema table.
818 * System.Data.SqlClient/SqlDataReader.cs :
819 Add ColumnSize to schema table.
820 * System.Data.SqlClient/SqlCommand.cs :
821 Change the way that preparing is handled.
822 Now uses sp_prepare on the server instead of temp
823 stored procedures because it's the Right Thing[tm] to do.
824 * System.Data.SqlClient/SqlConnection.cs :
825 Store data readers here rather than in command
826 * System.Data.SqlClient/SqlDataReader.cs :
827 More implementation, including binary types
828 * System.Data.SqlClient/SqlParameter.cs :
831 2002-10-31 Tim Coleman (tim@timcoleman.com)
832 * System.Data.Common/DbDataAdapter.cs :
833 Fix handling of nulls
834 * System.Data.Common/DbDataRecord.cs :
835 Change GetFieldType ()
836 * System.Data.Common/DbEnumerator.cs :
837 Add new schema information
838 * System.Data.Common/FieldNameLookup.cs :
839 Change definition of schema
840 * System.Data.Common/SchemaInfo.cs :
842 * System.Data.SqlClient/SqlDataReader.cs :
843 get more schema table data
845 Add Mono.Data.TdsClient.Internal.TdsSchemaInfo
847 2002-10-31 Ville Palo <vi64pa@koti.soon.fi>
856 * SqlString.cs: Some bugfixes and some TODOs but so much
859 2002-10-30 Tim Coleman (tim@timcoleman.com)
860 * System.Data.Common/FieldNameLookup.cs:
861 * System.Data.Common/SchemaInfo.cs:
862 * System.Data.SqlClient/SqlXmlTextReader.cs:
865 Class list changed in build
866 * System.Data.SqlClient/SqlCommand.cs:
867 Added support for command behaviors
868 Refactored a bunch of code
869 Implement ExecuteScalar
870 Implement ExecuteXmlReader
871 * System.Data.SqlClient/SqlConnection.cs:
872 Moved CheckForErrors here
873 * System.Data.SqlClient/SqlDataAdapter.cs:
875 * System.Data.SqlClient/SqlDataReader.cs:
876 Implement GetEnumerator
878 Add SqlDataReaderEnumerator private class
879 * System.Data.SqlClient/SqlParameter.cs:
880 Move some of the Prepare code from SqlCommand to here
881 * System.Data.SqlClient/SqlTransaction.cs:
882 Move error checking to SqlConnection
884 2002-10-29 Tim Coleman (tim@timcoleman.com)
885 * System.Data.SqlClient/SqlCommand.cs:
886 Added code to handle parameters for queries
887 * System.Data.SqlClient/SqlConnection.cs:
888 Properly handle resetting SqlConnections
889 * System.Data.SqlClient/SqlDataReader.cs:
890 Properly handle the case where no results are returned
891 * System.Data.SqlClient/SqlParameter.cs:
892 Default direction to Input
893 * System.Data.SqlClient/SqlParameterCollection.cs:
894 Implement GetEnumerator
896 2002-10-29 Rodrigo Moya <rodrigo@ximian.com>
898 * makefile.gnu: added Test directory.
900 2002-10-29 Ville Palo <vi64pa@koti.soon.fi>
902 * System.Data.SqlTypes/SqlGuid.cs: Fixed some bugs and finished
905 2002-10-28 Tim Coleman (tim@timcoleman.com)
906 * System.Data.SqlClient/SqlCommand.cs:
907 Add some error handling
908 * System.Data.SqlClient/SqlDataReader.cs:
909 Add some error handling
910 Add precision/scale to schema table
911 * System.Data.SqlClient/SqlException.cs:
912 Generate a SqlException from TDS error
914 * System.Data.SqlClient/SqlTransaction.cs:
915 Add some error handling
918 2002-10-28 Ville Palo <vi64pa@koti.soon.fi>
920 * System.Data.SqlTypes/SqlBinary.cs:
921 * System.Data.SqlTypes/SqlBoolean.cs:
922 * System.Data.SqlTypes/SqlByte.cs:
923 * System.Data.SqlTypes/SqlDateTime.cs:
924 * System.Data.SqlTypes/SqlDecimal.cs:
925 * System.Data.SqlTypes/SqlDouble.cs:
926 * System.Data.SqlTypes/SqlDecimal.cs:
927 * System.Data.SqlTypes/SqlDouble.cs:
928 * System.Data.SqlTypes/SqlGuid.cs:
929 * System.Data.SqlTypes/SqlInt16.cs:
930 * System.Data.SqlTypes/SqlInt32.cs:
931 * System.Data.SqlTypes/SqlInt64.cs:
932 * System.Data.SqlTypes/Money.cs:
933 * System.Data.SqlTypes/SqlSingle.cs:
934 * System.Data.SqlTypes/SqlString.cs:
935 * System.Data.SqlTypes/SqlSingle.cs: Fixed internal loop bugs and
936 some other minor fixes.
938 2002-10-27 Rodrigo Moya <rodrigo@ximian.com>
940 * System.Data.OleDb/OleDbDataAdapter.cs (Fill, FillSchema,
941 GetFillParameters, Update): added overloaded methods.
943 * System.Data.OleDb/OleDbCommand.cs:
944 * System.Data.OleDb/OleDbDataReader.cs:
945 * System.Data.OleDb/OleDbConnection.cs: removed limitation of one
946 data adapter at a time. Mono's version can open as many as you want,
949 2002-10-25 Tim Coleman (tim@timcoleman.com)
950 * System.Data.SqlClient/SqlConnectionPool.cs:
952 * System.Data.SqlClient/SqlClientPermission.cs:
953 * System.Data.SqlClient/SqlClientPermissionAttribute.cs:
954 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs:
955 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs:
956 * System.Data.SqlClient/SqlParameter.cs:
957 * System.Data.SqlClient/SqlParameterCollection.cs:
959 * System.Data.SqlClient/SqlCommand.cs:
960 * System.Data.SqlClient/SqlConnection.cs:
961 * System.Data.SqlClient/SqlException.cs:
962 * System.Data.SqlClient/SqlTransaction.cs:
963 New code based on work in TDS Client
965 New files added for SqlClient, and TdsClient.Internal
967 Added reference to System.EnterpriseServices.dll
968 Still leave SqlClient out of build until danmorg
971 2002-10-23 Ville Palo <vi64pa@koti.soon.fi>
973 * System.Data.SqlTypes/SqlDouble.cs:
974 * System.Data.SqlTypes/SqlSingle.cs: Finished
976 2002-10-23 Ville Palo <vi64pa@koti.soon.fi>
978 * System.Data.SqlTypes/SqlByte.cs:
979 * System.Data.SqlTypes/SqlBoolean.cs:
980 * System.Data.SqlTypes/SqlInt16.cs:
981 * System.Data.SqlTypes/SqlInt32.cs:
982 * System.Data.SqlTypes/SqlInt64.cs: Finished.
984 2002-10-21 Rodrigo Moya <rodrigo@ximian.com>
986 * list: removed libodbchelper.cs file, which has been removed.
988 2002-10-16 Tim Coleamn <tim@timcoleman.com>
991 Exclude compiling of System.Data.SqlClient in
992 preparation for overhauls of that system.
994 2002-10-16 Daniel Morgan <danmorg@sc.rr.com>
999 * SqlClientPermission.cs
1000 * SqlClientPermissionAttribute.cs
1002 * SqlCommandBuilder.cs
1007 * SqlErrorCollection.cs
1009 * SqlInfoMessageEventArgs.cs
1010 * SqlInfoMessageEventHandler.cs
1012 * SqlParameterCollection.cs
1013 * SqlRowUpdatedEventArgs.cs
1014 * SqlRowUpdatedEventHandler.cs
1015 * SqlRowUpdatingEventArgs.cs
1016 * SqlRowUpdatingEventHandler.cs
1017 * SqlTransaction.cs: thanks to Miguel de Icaza, he
1018 copied files on the mono cvs server
1019 from mcs/class/System.Data/System.Data.SqlClient
1020 for the PostgreSQL provider
1021 to mcs/class/Mono.Data.PostgreSqlClient.
1023 mcs/class/System.Data/System.Data.SqlClient for
1024 the Microsoft SQL Server provider.
1025 Any Mono.Data.PostgreSqlClient/Sql*.cs files
1026 were copied on the cvs server
1027 to Mono.Data.PostgreSqlClient/PgSql*.cs files
1028 and the old Mono.Data.PostgreSqlClient/Sql*.cs
1029 files were removed. Copying, renaming, and removing
1030 was done on the cvs server so we could keep
1031 the cvs change history.
1033 2002-10-15 Daniel Morgan <danmorg@sc.rr.com>
1035 * System.Data.OleDb/libgda.cs: added more functions
1036 to platfrom invoke into shared library libgda
1038 * System.Data.OleDb/OleDbDataReader.cs: implemented
1039 GetSchemaTable() and GetFieldType()
1041 2002-10-13 Daniel Morgan <danmorg@sc.rr.com>
1043 * System.Data/DataRow.cs: don't throw exception
1044 if DBNull is false. Had to do comment this line
1045 to allow a typeof(Type).
1047 * System.Data.SqlClient/SqlCommand.cs: the "DataType"
1048 DataColumn and DataRows in a DataTable for a schema should
1049 be typeof Type, not string. This is to make it
1050 compatible with MS.NET
1052 * System.Data.SqlClient/SqlConnection.cs: the
1053 isolation level should be set before
1054 beginning the transaction
1056 * Test/SqlSharpCli.cs: change string to Type for
1057 "DataType" from a DataRow in a DataTable
1058 that contains a schema.
1060 2002-10-14 Rodrigo Moya <rodrigo@ximian.com>
1062 * list: added missing Odbc files.
1064 2002-10-09 Rodrigo Moya <rodrigo@ximian.com>
1066 * list: added System.Data.Odbc files.
1068 2002-10-09 Brian Ritchie <brianlritchie@hotmail.com>
1070 * System.Data.Odbc/*: added first version of ODBC managed provider.
1072 2002-10-07 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1074 * System.Data/ConstraintCollection.cs:
1075 * System.Data/DataColumnCollection.cs:
1076 * System.Data/DataRowCollection.cs:
1077 * System.Data/DataTableCollection.cs:
1078 * System.Data/InternalDataCollectionBase.cs: made List internal to fix
1079 the build with csc. It must be a mcs bug. I will try to get a test case.
1081 2002-10-06 Luis Fernandez <luifer@onetel.net.uk>
1083 * System.Data/Constraint.cs (AssertConstraint): added overloaded
1086 * System.Data/DataColumnCollection.cs: added constraints when needed.
1088 * System.Data/DataRow.cs: validate UniqueConstraint's.
1090 * System.Data/DataRowCollection.cs (ValidateDataRowInternal): new
1091 internal method to validate a given DataRow with respect to the
1094 * System.Data/ForeignKeyConstraint.cs (AssertConstraint): stubs for
1095 new overloaded method.
1097 * System.Data/UniqueConstraint.cs: added implementation.
1098 (AseertConstraint): implemented new overloaded method.
1100 2002-10-01 Rodrigo Moya <rodrigo@ximian.com>
1102 * System.Data.OleDb/OleDbConnection.cs (Open): commented code from
1103 last commit, which wasn't supposed to be in CVS yet.
1105 2002-10-01 Luis Fernandez <luifer@onetel.net.uk>
1107 * System.Data/DataColumn.cs:
1108 * System.Data/DataRow.cs:
1109 * System.Data/DataRowCollection.cs:
1110 * System.Data/DataTable.cs: some fixes and implementation.
1112 2002-09-28 Vladimir Vukicevic <vladimir@pobox.com>
1114 * System.Data.OleDb/OleDbConnection.cs: Close
1115 reader properly in call to ExecuteScalar().
1117 2002-09-07 Rodrigo Moya <rodrigo@ximian.com>
1119 * System.Data.OleDb/OleDbConnection.cs (Open): changed to use OleDb
1120 connection strings, which are then converted to GDA connection
1121 strings, instead of using directly GDA data source names.
1123 * System.Data.OleDb/libgda.cs: added more needed functions.
1125 2002-09-06 Franklin Wise <gracenote@earthlink.net>
1127 * System.Data/DataColumn.cs: More flushing out.
1129 * System.Data/ForeignKeyConstraint.cs: Implemented GetHashCode()
1131 * System.Data/UniqueKeyConstraint.cs: Implemented GetHashCode()
1133 * Tests: See Changelog for System.Data/Test
1135 2002-09-04 Franklin Wise <gracenote@earthlink.net>
1137 * Tests: See Changelog for System.Data/Test
1140 System.Data/DataColumnCollectionTest.cs
1141 System.Data/DataRowCollectionTest.cs
1142 System.Data/DataRowTest.cs
1144 * System.Data/DataColumn.cs: Flushing out validation, type conversion for
1145 autoincrement. Added lots of TODO's.
1146 * System.Data/DataColumnCollection.cs: Wrote out add logic as a comment.
1147 Tagged implementation with FIXME tags. Lot's more validation
1148 and setup needs to be done, much of which is now tagged as todo's
1151 * System.Data/DataRow.cs: Lot's of fixme's added.
1153 * System.Data/DataRowCollection.cs: TODO's added.
1155 * System.Data/DataTable.cs: Implemented PrimaryKey.
1157 * System.Data/UniqueConstraint.cs: Implemented related PrimaryKey
1160 2002-08-25 Rodrigo Moya <rodrigo@ximian.com>
1162 * System.Data.OleDb/OleDbTransaction.cs (OleDbTransaction): manage
1163 correctly the isolation level.
1164 (IsolationLevel): likewise.
1165 (~OleDbTransaction): implemented.
1167 * System.Data.OleDb/libgda.cs: added more needed stuff.
1169 2002-08-22 Daniel Morgan <danmorg@sc.rr.com>
1171 * System.Data.SqlClient/SqlParameter.cs: flush
1173 * System.Data.SqlClient/SqlParameterCollection.cs: fixes
1174 for the Item property, IndexOf, and Contains.
1176 * Test/SqlSharpCli.cs: added input parameters support.
1177 when a query is executed, if a parameter name matches
1178 a SQL# internal variable name, it uses that value for the parameter; otherwise,
1179 the user is prompted for the parameter value. Currently, it only supports
1182 2002-08-21 Rodrigo Moya <rodrigo@ximian.com>
1184 * System.Data.OleDb/libgda.cs: adapted to changes in libgda (get_vtype
1185 and get_type for GdaValue).
1187 * System.Data.OleDb/OleDbDataReader.cs: adapted to changes in
1190 2002-08-20 Rodrigo Moya <rodrigo@ximian.com>
1192 * System.Data.OleDb/OleDbConnection.cs (DataReader): new internal
1194 (Close): set the dataReader to null.
1196 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader): set the
1197 connection's DataReader property to this object.
1198 (Close): set it to null here.
1199 (Depth, IsDbNull): implemented.
1200 (this): implemented the Item property with a string indexer.
1202 * System.Data.OleDb/OleDbCommand.cs (ExecuteNonQuery, ExecuteReader,
1203 ExecuteScalar): do nothing if there's already an open data reader.
1205 * System.Data.OleDb/libgda.cs: more API functions.
1207 * System.Data.OleDb/TestOleDb.cs (TestDataReader): close the data
1208 reader before continuing.
1210 2002-08-20 Franklin Wise <gracenote@earthlink.net>
1212 * System.Data/System.Data.build: added nowarn:0679
1214 * System.Data/System.DataTable: cleaned up class, added MonoTODO tags
1215 setup to begin implementing. Implemented ctor().
1217 * Tests: See System.Data\Test\ChangeLog
1220 2002-08-19 Rodrigo Moya <rodrigo@ximian.com>
1222 * System.Data.OleDb/OleDbSchemaGuid.cs: initialize static members.
1224 2002-08-19 Franklin Wise <gracenote@earthlink.net>
1226 * Tests: See System.Data\Test\ChangeLog
1228 * System.Data/UniqueConstraint.cs: More validation.
1230 * System.Data/ForeignKeyConstraint.cs: Added more validation rules.
1231 Another LAMESPEC tag. Implemented more of Add/Remove Setup/Cleanup
1234 * System.Data/DataTable.cs: Added more MonoTODO tags
1236 * class/System.Data/.cvsignore: added tmp & Temp
1238 * System.Data/Constraint.cs: Changed abstract helpers to virtual and
1241 * System.Data/ConstraintCollection.cs: Commented out unused line.
1243 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
1245 * System.Data.OleDb/OleDbConnection.cs (ChangeDatabase): implemented.
1247 * System.Data.OleDb/OleDbException.cs (OleDbException): added internal
1249 (ErrorCode, Message, Source, Errors): implemented.
1251 * System.Data.OleDb/OleDbError.cs: implemented the full class.
1253 * System.Data.OleDb/libgda.cs: added more libgda functions.
1255 * System.Data.OleDb/TestOleDb.cs (TestOleDb): display properties for
1256 the opened connection.
1258 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
1260 * System.Data.OleDb/OleDbConnection.cs (ServerVersion): implemented.
1262 * System.Data.OleDb/OleDbDataReader.cs (Close): clear the results
1263 ArrayList after releasing the items.
1264 (GetName, GetDateTime, GetDouble, GetSingle, GetInt16, GetInt32,
1265 GetOrdinal, GetString): implemented.
1266 (GetDataTypeName): made it get the type from the data model, not from
1267 the current value, which could not have been retrieved yet.
1268 (GetValue): call the Get* method corresponding with the data type of
1269 the requested column.
1271 * System.Data.OleDb/libgda.cs: added more libgda functions.
1272 (GdaTimestamp, GdaDate, GdaTime): new marshalled structures.
1274 * System.Data.OleDb/TestOleDb.cs (TestDateReader): display column
1275 titles via OleDbDataReader.GetName ().
1276 (TestOleDb): create temporary table with a date field.
1277 (InsertRow): set current date for the date field.
1279 2002-08-18 Rodrigo Moya <rodrigo@ximian.com>
1281 * System.Data.OleDb/OleDbDataReader.cs (this[]): made it just call
1282 GetValue, which will take care of all the work needed.
1283 (Close): implemented basic stuff.
1284 (~OleDbDataReader): implemented.
1286 * System.Data.OleDb/libgda.cs: added more needed functions.
1288 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
1290 * System.Data.OleDb/TestOleDb.cs: made it work with a temporary table
1292 (TestTransaction): added test for transactions.
1294 2002-08-16 Rodrigo Moya <rodrigo@ximian.com>
1296 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
1298 * System.Data.OleDb/OleDbDataReader.cs (GetBoolean): throw exceptions
1299 when there are errors.
1300 (GetByte, GetChar, GetDataTypeName, GetValue, Read): implemented.
1302 * System.Data.OleDb/TestOleDb.cs: added more testing code for data
1305 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
1307 * System.Data.OleDb/libgda.cs: added new needed libgda functions.
1309 * System.Data.OleDb/OleDbParameterCollection.cs (GdaParameterList):
1310 create an empty GdaParameterList.
1312 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): check values
1313 for NULL before passing them to Marshal.PtrToStructure, which issues
1314 an exception if the value is NULL.
1316 2002-08-15 Rodrigo Moya <rodrigo@ximian.com>
1318 * System.Data/UniqueConstraint.cs (UniqueConstraint): commented
1319 unreachable code to avoid compiler warning.
1321 * System.Data.OleDb/libgda.cs (GdaList): added new internal class.
1323 * System.Data.OleDb/OleDbConnection.cs (DataSource): implemented.
1324 (OpenReader): removed internal method.
1326 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader): split correctly
1327 the list of returned data models.
1329 2002-08-15 Franklin Wise <gracenote@earthlink.net>
1331 * System.Data/Constraint.cs: Added helper virtual functions
1333 * System.Data/ConstraintCollection.cs: Improved constraint removal,
1334 validation. Removed specific knowledge of subclasses of
1337 * System.Data/DataColumn.cs: Added static helper function to compare
1338 if two DataColumn arrays are the same.
1340 * System.Data/ForeignKeyConstraint.cs: Continued to flush out.
1342 * System.Data/UniqueConstraint.cs: Implemented. Still some constraint
1345 2002-08-13 Franklin Wise <gracenote@earthlink.net>
1347 * System.Data/DataRow.cs: Added several fixme tags.
1349 2002-08-13 Rodrigo Moya <rodrigo@ximian.com>
1351 * System.Data.SqlClient/SqlDataAdapter.cs (DeleteCommand,
1352 InsertCommand, SelectCommand, UpdateCommand): removed 'new' keyword
1353 to avoid compiler warnings.
1355 2002-08-12 Franklin Wise <gracenote@earthlink.net>
1357 * System.Data/Constraint.cs: Implemented
1359 * System.Data/UniqueConstraint.cs: GetHashCode() &
1360 special case Ctor. Still need to be implemented. LAMESPEC tags
1363 * System.Data/ConstraintCollection.cs: Clear() &
1364 AddRange() need to be finished. Several LAMESPEC tags.
1366 * Allow Constraint collection to be created in DataTable.
1368 * System.Data/ForeignKeyConstraint: Added a couple of
1371 * System.Data/DataColumnCollection New/Added DataColumns now have
1374 2002-08-11 Rodrigo Moya <rodrigo@ximian.com>
1376 * System.Data.OleDb/libgda.cs: added some GdaValue functions.
1378 * System.Data.OleDb/OleDbCommand.cs (OpenReader): removed this
1379 internal method, since we don't need it.
1380 (ExecuteReader): call SetupGdaCommand before executing the command
1381 via libgda functions.
1382 (ExecuteScalar): implemented.
1384 * System.Data.OleDb/OleDbDateReader.cs (OleDbDataReader): removed call
1385 to OleDbCommand.OpenReader.
1386 (GetBoolean): implemented.
1388 2002-08-08 Franklin Wise <gracenote@earthlink.net>
1390 * System.Data/IDbComand.cs: IDbCommand now inherits IDisposable
1392 * System.Data/IDbConnection.cs: IDbConnection now inherits IDisposable
1394 * System.Data.SqlTypes/SqlCompareOptions.cs: Enum now set to correct
1397 2002-08-06 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1399 * System.Data.OleDb/OleDbConnection.cs: little fixes to make it work
1400 and don't show a warning in Open.
1402 * System.Data.OleDb/TestOleDb.cs: added Close.
1404 2002-08-05 Rodrigo Moya <rodrigo@ximian.com>
1406 * System.Data.OleDb/OleDbConnection.cs (ConnectionString,
1407 ConnectionTimeout, ServerVersion, GdaConnection):
1409 (OleDbConnection): call libgda.gda_init on constructor.
1411 * System.Data.OleDb/libgda.cs (libgda): removed static constructor,
1412 which wasn't been called.
1414 * System.Data.OleDb/TestOleDb.cs (TestOleDb): updated to really
1417 2002-08-04 Rodrigo Moya <rodrigo@ximian.com>
1419 * list: added missing System.Data.OleDb and
1420 System.Data.Common files.
1422 * System.Data.OleDb/ChangeLog: removed and merged with
1423 System.Data's ChangeLog.
1425 * System.Data.OleDb/OleDbDataAdapter.cs:
1426 * System.Data.OleDb/OleDbPermission.cs: compilation fixes.
1428 2002-07-30 Rodrigo Moya <rodrigo@ximian.com>
1430 * System.Data.OleDb/OleDbDataReader.cs (FieldCount): implemented.
1431 (IsClosed, Item, RecordsAffected): implemented some properties.
1433 * libgda.cs: added GdaDataModel methods.
1435 2002-07-29 Rodrigo Moya <rodrigo@ximian.com>
1437 * System.Data.OleDb/OleDbDataReader.cs (OleDbDataReader constructor): changed to receive
1438 a second argument (ArrayList results).
1439 (NextResult): implemented.
1441 * System.Data.OleDb/OleDbCommand.cs: don't store the ArrayList of results, since we'll
1442 pass that to the OleDbDataReader.
1443 (OleDbCommand constructor): don't create the ArrayList of results.
1444 (GdaResults): removed property.
1445 (ExecuteReader): create a temporary ArrayList and pass that to the
1446 OleDbDataReader constructor.
1448 2002-07-28 Rodrigo Moya <rodrigo@ximian.com>
1450 * System.Data.OleDb/OleDbCommand.cs (ExecuteReader):
1451 (CreateParameter): implemented IDbCommand methods.
1452 (CommandText): don't create many GdaCommand's, only one is needed.
1453 (ExecuteNonQuery): set up the internal GDA command object.
1454 (ExecuteReader): use correctly the unique GDA command object.
1456 * System.Data.OleDb/libgda.cs: added new libgda calls.
1458 2002-07-27 Rodrigo Moya <rodrigo@ximian.com>
1460 * System.Data.OleDb/OleDbConnection.cs (CreateCommand):
1461 (BeginTransaction): implemented IDbConnection methods.
1463 2002-07-12 Rodrigo Moya <rodrigo@ximian.com>
1465 * list: added System.Data.OleDb files to file list.
1467 2002-07-11 Rodrigo Moya <rodrigo@ximian.com>
1469 * System.Data.OleDb/libgda.cs: added new libgda functions and some enumerations.
1471 * System.Data.OleDb/OleDbParameter.cs (IsNullable): removed explicit implementation
1472 of the set method for this property.
1474 * System.Data.OleDb/OleDbDataAdapter.cs (MissingMappingAction): implemented.
1475 (MissingSchemaAction): implemented.
1477 2002-07-10 Tim Coleman <tim@timcoleman.com>
1479 * System.Data.OleDb/OleDbCommandBuilder.cs: Added new methods, properties
1480 * System.Data.OleDb/OleDbConnection.cs: Modified constructor
1481 * System.Data.OleDb/OleDbError.cs: Added stubbs
1482 * System.Data.OleDb/OleDbException.cs: Added stubbs
1483 * System.Data.OleDb/OleDbInfoMessageEventArgs.cs: Added stubbs
1484 * System.Data.OleDb/OleDbInfoMessageEventHandler.cs: style change
1485 * System.Data.OleDb/OleDbParameter.cs: Added conversion from type to OleDbType
1486 * System.Data.OleDb/OleDbPermission.cs: Added stubbs
1487 * System.Data.OleDb/OleDbSchemaGuid.cs: Added stubbs
1488 * System.Data.OleDb/OleDbTransaction.cs: New constructors, changes to methods to
1489 support transaction nesting
1490 * System.Data.OleDb/libgda.cs: Added my name to this file
1492 2002-07-09 Tim Coleman <tim@timcoleman.com>
1494 * System.Data.OleDb/OleDbCommand.cs: Style changes, added new methods
1495 * System.Data.OleDb/OleDbConnection.cs: Style changes, added new methods
1496 * System.Data.OleDb/OleDbDataAdapter.cs: Implementation
1497 * System.Data.OleDb/OleDbDataReader.cs: Added stubbs
1498 * System.Data.OleDb/OleDbErrorCollection.cs: Added stubbs, some implementation
1499 * System.Data.OleDb/OleDbParameter.cs: Style changes, added new methods
1500 * System.Data.OleDb/OleDbParameterCollection.cs: Style changes, added new methods
1501 * System.Data.OleDb/OleDbPermissionAttribute.cs: Style changes, added new methods
1502 * System.Data.OleDb/OleDbRowUpdatedEventArgs.cs: Added stubbs
1503 * System.Data.OleDb/OleDbRowUpdatingEventArgs.cs: Added stubbs
1504 * System.Data.OleDb/OleDbTransaction.cs: Style changes, added new methods
1505 * System.Data.OleDb/OleDbType.cs: Fixed two typos
1506 * System.Data.OleDb/libgda.cs: Style changes, added new methods
1508 2002-07-09 Tim Coleman <tim@timcoleman.com>
1510 * System.Data.build: remove restriction on System.Data.OleDb build
1512 2002-06-03 Rodrigo Moya <rodrigo@ximian.com>
1514 * System.Data.OleDb/OleDbParameterCollection.cs (GetEnumerator, SyncRoot,
1515 IsSynchronized): implemented.
1517 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
1519 * System.Data.OleDb/OleDbTransaction.cs (Dispose): added missing method.
1521 * System.Data.OleDb/OleDbCommand.cs (Clone): added missing methods.
1522 (Parameters, Transaction, Connection): made these overload
1525 * System.Data.OleDb/OleDbParameterCollection.cs (IndexOf, Remove, RemoveAt):
1526 call m_list methods, not own ones.
1528 * System.Data.OleDb/OleDbParameter.cs: more implementation.
1530 2002-06-02 Rodrigo Moya <rodrigo@ximian.com>
1532 * System.Data.OleDb/OleDbTransaction.cs (Connection, IsolationLevel, Begin,
1533 Commit, Rollback): implemented.
1534 (GdaConnection): added new internal property.
1536 * System.Data.OleDb/OleDbParameter.cs:
1537 * System.Data.OleDb/OleDbParameterCollection.cs: implemented some methods and
1540 * System.Data.OleDb/libgda.cs: added yet more libgda API functions.
1542 2002-06-01 Rodrigo Moya <rodrigo@ximian.com>
1544 * System.Data.OleDb/libgda.cs: added new libgda API functions.
1546 * System.Data.OleDb/OleDbConnection.cs (Provider): implemented.
1547 (BeginTransaction): made it overload IDbConnection methods.
1548 (ChangeDatabase): new stub, needs some work on libgda for being
1551 (Close): implemented.
1552 (CreateCommand): implemented.
1553 (GetOleDbSchemaTable): new stub, until I understand what to do here.
1554 (Open): implemented basic stuff, which is just supporting connection
1555 strings that represent a GDA data source name. More to come.
1556 (InfoMessage, StateChange): added events.
1558 * System.Data.OleDb/TestOleDb.cs: test program for System.Data.OleDb.
1560 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
1562 * System.Data.OleDb/libgda.cs: added static constructor.
1563 (GdaClient): new static property to get the underlying GdaClient
1566 * System.Data.OleDb/OleDbConnection.cs: removed GDA initialization, which belongs to
1567 the static 'libgda' class.
1569 2002-05-29 Rodrigo Moya <rodrigo@ximian.com>
1571 * System.Data.OleDb/libgda.cs: static class for libgda API calls.
1573 * System.Data.OleDb/OleDbConnection.cs: implemented constructors.
1574 (ConnectionString, Connectiontimeout, Database, State):
1575 implemented class properties.
1576 (BeginTransaction): implemented.
1578 * System.Data.OleDb/OleDbTransaction.cs: implemented protected constructors.
1580 * System.Data.OleDb/TestGDA.cs: simple test for libgda API.
1582 2002-05-27 Rodrigo Moya <rodrigo@ximian.com>
1584 * System.Data.OleDb/*: started System.Data.OleDb provider, based on libgda.
1586 2002-06-06 Rodrigo Moya <rodrigo@ximian.com>
1588 * list: added missing PostgresTypes.cs file.
1590 2002-06-02 Francisco Jr. <fxjrlists@yahoo.com.br>
1592 * System.Data.SqlClient/SqlParameterCollection.cs: implemented missing
1595 2002-05-30 Daniel Morgan <danmorg@sc.rr.com>
1597 * System.Data.SqlClient/SqlConnection.cs: modifed -
1598 start to implement the interfaces properly and
1599 properly doing a Close(), Dispose(), and
1602 * Test/SqlSharpCli.cs: modified -
1603 add support for MySQL in Mono.Data.MySql
1604 and OleDb support in System.Data.OleDb. However,
1605 the OleDb support is commented right now.
1606 When the program starts up, a shorter help menu should
1607 display the most important commands: help and quit
1609 2002-05-28 Rodrigo Moya <rodrigo@ximian.com>
1611 * System.Data.build: exclude System.Data.OleDb files.
1613 2002-05-27 Daniel Morgan <danmorg@sc.rr.com>
1615 * System.Data.SqlClient/SqlCommand.cs: typo
1616 should be CommandBehavior.KeyInfo
1618 * Test/SqlSharpCli.cs: refactored and added a few more
1621 2002-05-27 Tim Coleman <tim@timcoleman.com>
1622 * list: update to compile properly (add missing
1623 files and switch path delimiter from '\' to '/').
1625 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
1627 * System.Data/DataRow.cs
1628 * System.Data.Common/DbDataAdapter.cs: fix to
1629 get Test/TestSqlDataAdapter.cs to work again
1631 * Test/TestSqlDataAdapter.cs: removed comment
1632 about SqlDataReader:NextResult() not being implemented; it
1633 bas been implemented
1635 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
1637 * System.Data/DataRow.cs: modified
1638 support setting of DBNull.Value
1639 using the Item indexer this[DataColumn]
1641 * System.Data.SqlClient/SqlCommand.cs: modified
1642 tweaks to show TODO's for other CommandBehavior.
1643 Set AllowDBNull column to true for IsKey row
1644 in schema DataTable.
1646 * System.Data.SqlClient/SqlConnection.cs: modified
1647 if transaction is in progress when a Close() is called,
1648 do a transaction Rollback.
1650 2002-05-26 Daniel Morgan <danmorg@sc.rr.com>
1652 * Test/SqlSharpCli.cs: added file
1653 My new toy. SQL# is a command-line tool to enter
1654 SQL commands and queries using Mono System.Data.
1655 It also serves as a test for Mono System.Data.
1657 * System.Data.SqlClient/SqlCommand.cs: modified
1658 - ExecuteNonQuery(), ExecuteScalar(), and ExecuteReader()
1659 should handle the results from SQL Commands and Queries.
1660 - Internal class SqlResult should not create schema Table
1661 for the result from a SQL Command. Also, set the RecordsRetrieved
1662 property for SqlDataReader.
1663 - Closing the SqlDataReader should Close() the SqlConnection for
1664 a CommandBehavior.CloseConnection.
1665 - Set defaults for SqlResult
1667 * System.Data.SqlClient/SqlConnection.cs: modified -
1668 when SqlDataReader is Close()
1669 should Close() the SqlConnection for
1670 a CommandBehavior.CloseConnection. Changed internal Property
1671 from OpenReader get/set to IsReaderOpen get and created
1672 internal methods OpenReader()/CloseReader() for SqlCommand to call.
1673 SqlConnection needs to be prevented from doing while SqlDataReader
1676 * System.Data.SqlClient/SqlDataReader.cs: modified -
1677 call SqlCommand's OpenReader() internal method. get
1678 RecordsRetrieved from SqlResult. set/reset default
1679 values for SqlDataReader.
1681 * Test/PostgresTest.cs
1682 * Test/TestExecuteScalar.cs
1683 * Test/TestSqlDataReader.cs: modified
1684 for the Execute...() methods in SqlCommand
1685 to test SQL Queries and Commands
1687 * Test/System.Data_test.build: modified
1688 exclude new file Test/SqlSharpCli.cs from
1691 2002-05-24 Tim Coleman <tim@timcoleman.com>
1692 * System.Data.Common/DbDataAdapter.cs: remove IDbCommands, except
1693 for get accessors. These should be implemented in derived classes. See
1694 SqlDataAdapter for clues.
1695 * System.Data.SqlClient/SqlDataAdapter.cs: implement IDbDataAdapter
1696 * System.Data.Common/DataAdapter.cs:
1697 * System.Data.Common/DataTableMappingCollection.cs:
1698 * System.Data.Common/DataTableMapping.cs:
1699 * System.Data.Common/DataColumnMappingCollection.cs:
1700 * System.Data.Common/DataColumnMapping.cs:
1701 Properly (I hope!) implement all of the appropriate interfaces
1705 2002-05-23 Tim Coleman <tim@timcoleman.com>
1706 * System.Data.SqlClient/SqlCommand.cs: include
1707 the BaseColumnName in the schema table. Was missed before.
1708 * System.Data.Common/DbDataAdapter.cs: Use DataTable
1709 mappings so that the DataSet and DataTable are more closely tied.
1710 Get schema information from the DataTable using GetSchemaTable ()
1711 Various other little fixes
1712 * System.Data.Common/DataColumnMappingCollection.cs:
1713 * System.Data.Common/DataTableMapping.cs:
1714 * System.Data.Common/DataTableMappingCollection.cs: Some
1715 implementation, enough to be used by DbDataAdapter.
1717 2002-05-23 Daniel Morgan <danmorg@sc.rr.com>
1719 * System.Data.SqlClient/SqlCommand.cs: set
1720 the "ProviderType" to the PostgreSQL type oid
1722 * System.Data.SqlClient/SqlDataReader.cs: fix
1723 for various properties and methods that
1724 return meta data: Item indexers this[name] and this[index],
1725 GetFieldType, GetName, and GetOrdinal. SqlDataAdapter
1728 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
1730 * System.Data/DataRow.cs: change suggested
1731 by tim: in Item indexer, do an EndEdit()
1733 * System.Data.SqlClient/SqlCommand.cs: more
1734 fixes to SqlResult. After setting each item in
1735 the DataRow, do an AcceptChanges() to commit
1736 the changes in the DataRow. For DataType, use a Type
1737 of System.String since System.Type nor System.Object
1740 * Test/TestSqlDataReader.cs
1741 * Test/PostgresTest.cs: updated to to be on
1742 the way schema table is suppose to work
1744 2002-05-22 Daniel Morgan <danmorg@sc.rr.com>
1746 * System.Data.SqlClient/SqlCommand.cs: more work on
1747 building the schema table
1749 2002-05-22 Tim Coleman <tim@timcoleman.com>
1750 * System.Data.SqlClient/SqlCommand.cs: preliminary work
1751 on getting the schema table correctly built.
1753 2002-05-21 Daniel Morgan <danmorg@sc.rr.com>
1755 * System.Data.SqlClient/ParmUtil.cs: added file - to
1756 provide utility for conversion of input parameters
1758 * System.Data.SqlClient/PostgresTypes.cs: added file -
1759 moved the PostgreHelper class to here. May eventually
1760 move the internal class PostgresTypes that's inside the
1761 SqlConnection to here as well.
1762 Handling of PostgreSQL <-> .NET types need to be though
1763 out more. Also, the PostgreHelper has a method to convert
1764 from .NET types to a string which can be put into used in
1765 an SQL statement to execute against a PostgreSQL database.
1766 This is the beginnings of parameters support. It currently
1767 only supports input parameters. Still need to do output,
1768 input/output, and return parameters.
1770 * Test/TestSqlParameters.cs: new test to test the input
1771 parameters in System.Data.SqlClient against a
1774 * System.Data.SqlClient/PostgresLibrary.cs: moved
1775 PostgresHelper class to file PostgresTypes.cs. Also
1776 moved struct PostgresType there too.
1778 * System.Data.SqlClient/SqlCommand.cs: added input
1781 * System.Data.SqlClient/SqlParameter.cs: got
1782 SqlParameter to work
1784 * System.Data.SqlClient/SqlParameterCollection.cs: got
1785 SqlParameterCollection to work
1787 * Test/System.Data_test.build: added files to exclude
1790 * System.Data.SqlClient/SqlConnection.cs: release resources
1793 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
1795 * System.Xml: added directory for classes with namespace
1796 System.Xml to go into the System.Data.dll assembly
1798 * System.Xml/XmlDataDocument: added file
1799 for stubbed concrete class XmlDataDocument which
1800 inherits from XmlDocument. Its purpose is to provide
1801 a W3C XML DOM Document for relational data and interacting
1804 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
1806 * System.Data.SqlClient/SqlCommand.cs: handle CommandTypes
1807 Text, TableDirect, and StoredProcedure
1809 * Test/PostgresTest.cs: changed call to version()
1810 stored procedure to use the CommandType of StoredProcedure
1812 * Test/TestSqlDataReader.cs: test all the CommandTypes
1814 2002-05-18 Daniel Morgan <danmorg@sc.rr.com>
1816 * System.Data.build: took out all excluded
1817 files except the ones in the Test directory
1818 because all files compile now. It does not
1819 mean they all work or have implementations
1822 * System.Data/DataRelationCollection.cs
1823 * System.Data/DataTableRelationCollection.cs
1824 * System.Data/InternalDataCollectionBase.cs
1825 * System.Data.Common/DbDataPermission.cs
1826 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs
1827 * System.Data.SqlClient/SqlClientPermission.cs
1828 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: changes
1829 to get all System.Data* files to compile.
1831 * System.Data.SqlClient/SqlCommand.cs: started coding
1832 to prevent SqlConnection and SqlCommand from doing
1833 anyting while fetching data using SqlDataReader. Also,
1834 started coding to undo this prevention once the
1835 SqlDataReader is closed.
1837 * System.Data.SqlClient/SqlConnection.cs: get database server
1838 version. Started coding to prevent connection from
1839 doing anything while fetching data and undo once the reader
1840 is closed. Include events SqlInfoMessage and StateChange.
1842 * System.Data.SqlClient/SqlDataReader.cs: start coding to
1843 prevent connection and command from doing anything while
1844 fetching data, and undo when closed.
1846 * Test/PostgresTest.cs: added test to get ServerVersion
1847 property from SqlConnection
1849 2002-05-18 Tim Coleman <tim@timcoleman.com>
1850 * System.Data/DataRow.cs: More implementation,
1851 as well as boundary checks and small semantic
1854 2002-05-18 Tim Coleman <tim@timcoleman.com>
1855 * System.Data/DataRow.cs: Try to reduce memory
1856 usage by only creating the original and proposed
1857 arrays as required in BeginEdit, and then destroying
1858 proposed during EndEdit, and original during AcceptChanges.
1859 * System.Data.Common/DbDataAdapter.cs: Make the
1860 startRecord and maxRecords parameters work correctly.
1862 2002-05-18 Tim Coleman <tim@timcoleman.com>
1863 * System.Data/DataRow.cs: Move the null check in
1864 ItemArray set to above the Invalid Cast check, so
1865 that we don't get null reference exceptions.
1867 2002-05-17 Daniel Morgan <danmorg@sc.rr.com>
1869 * System.Data.SqlClient/PostgresLibrary.cs: handle
1870 data value from database being NULL
1872 * System.Data.SqlClient/SqlCommand.cs: for ExecuteReader,
1873 allow multiple result sets. Added new internal class
1874 SqlResult to pass result set data from SqlCommand
1877 * System.Data.SqlClient/SqlDataReader.cs: allow
1878 multiple result sets.
1880 * System.Data.SqlClient/SqlConnection.cs: moved
1881 things around. Implement IDisposable.
1883 * Test/TestSqlDataReader.cs: test for execution
1884 of multiple result sets and display the results
1885 of these multiple results sets
1887 * Test/TestSqlDataAdapter.cs: tweaks
1889 2002-05-17 Tim Coleman <tim@timcoleman.com>
1890 * System.Data.Common/DbDataAdapter.cs:
1891 - More implementation of Fill methods
1892 - Get rid of isDirty flag, because we can just check
1894 - Do *not* remove DataTables before Filling them
1895 - Implicitly open the connection before doing a Fill
1896 if it does not exist.
1897 * System.Data.SqlClient/SqlDataAdapter.cs:
1899 * System.Data/DataTableCollection.cs:
1900 - Add DataSet to internal, undocumented constructor
1901 - When a table is created, set its DataSet property
1902 - Default table name for creation is "Table1" (see .NET)
1903 - Inherit the ArrayList list from InternalDataCollecitonBase
1904 and maintain a hashtable between table names and
1906 * System.Data/DataTable.cs:
1907 - Add internal dataSet field. This is used by
1908 DataTableCollection when the DataTable is constructed.
1909 * System.Data/DataSet.cs:
1910 - Pass a reference to the DataSet when constructing the
1911 DataTableCollection.
1913 2002-05-16 Tim Coleman <tim@timcoleman.com>
1914 * System.Data.Common/DbDataAdapter.cs:
1915 Use table.Rows.Add (itemArray) instead of
1916 table.Rows.Add (thisRow) to provide better
1918 * System.Data/DataRowCollection.cs:
1919 Some implementation of this class.
1920 * System.Data/InternalDataCollectionBase.cs:
1921 Some implementation. Most notably, this now
1922 has an enumerator so we can use foreach (DataRow row in table.Rows)
1923 in the test classes.
1924 * System.Data/DataTable.cs:
1925 Since DataRowCollection now accepts a DataTable in
1926 its internal constructor, we must pass one in.
1928 2002-05-16 Daniel Morgan <danmorg@sc.rr.com>
1930 * Test/TestSqlDataAdapter.cs: added new test
1931 for SqlDataAdapter, DataSet, DataTableCollection, DataTable,
1932 DataRowCollection, and DataRow. It tests retrieving data
1933 based on a SQL SELECT query. This test is based on Tim Coleman's
1936 2002-05-16 Tim Coleman <tim@timcoleman.com>
1937 * System.Data.Common/DbDataAdapter.cs:
1938 Use table.Rows.Add (thisRow) instead of
1939 table.ImportRow (thisRow)
1940 * System.Data/DataRowCollection.cs:
1941 Construct the ArrayList before using it
1943 2002-05-16 Tim Coleman <tim@timcoleman.com>
1944 * System.Data/DataTable.cs:
1945 Construct the DataRowCollection in the DataTable
1946 constructor. Otherwise, it's a null reference.
1948 2002-05-16 Tim Coleman <tim@timcoleman.com>
1949 * System.Data.SqlClient/SqlDataReader.cs:
1950 Modify GetValues to use Array.Copy() to copy
1951 the results from fields to values, rather than
1952 an assignment, which results in loss of data.
1954 2002-05-16 Tim Coleman <tim@timcoleman.com>
1955 * System.Data/DataRow.cs:
1956 More implementation and documentation. It should
1957 work more like expected, although there is no way
1958 to demonstrate this well yet. DataTable requires
1961 2002-05-15 Tim Coleman <tim@timcoleman.com>
1962 * System.Data/DataRow.cs:
1963 Minor tweaks as I determine exactly how to
1964 implement this class.
1967 2002-05-14 Duncan Mak <duncan@ximian.com>
1969 * System.Data/DataTable.cs (NewRow): Added missing paren to fix build.
1971 2002-05-14 Tim Coleman
1972 * System.Data/DataRow.cs:
1973 * System.Data/DataRowBuilder.cs:
1974 * System.Data/DataTable.cs:
1975 More implementation of these classes. DataRow
1976 can now (possibly) do some useful things.
1977 Still not sure what DataRowBuilder is all about,
1978 other than passing a DataTable in.
1980 2002-05-14 Tim Coleman
1981 * System.Data/DataRowBuilder.cs:
1982 Add stubb for this internal class.
1984 2002-05-13 Tim Coleman
1985 * System.Data.Common/DbDataAdapter.cs:
1986 The maxRecords check was not correct.
1988 2002-05-13 Tim Coleman
1989 * System.Data/DataTableCollection.cs:
1990 Fix an issue when adding a DataTable and size == 0.
1991 Now explicitly checks if size > 0 before doing Array.Copy ()
1992 * System.Data.Common/DbDataAdapter.cs:
1993 Move closer to a working implementation.
1994 Make the IDbCommand fields protected so that they can
1996 * System.Data.SqlClient/SqlDataAdapter.cs:
1997 This should inherit the IDbCommands instead of having its
1998 own. An explicit cast is used to force conversion between
1999 IDbCommand and SqlCommand
2001 2002-05-13 Tim Coleman
2002 * System.Data.Common/DataTableMappingCollection.cs:
2003 Some implementation to allow progress with DbDataAdapter
2005 2002-05-13 Tim Coleman
2006 * System.Data.Common/DbDataAdapter.cs:
2007 Modify to not break compile.
2009 2002-05-13 Tim Coleman
2010 * System.Data.build:
2011 include SqlDataAdapter, SqlRowUpdatedEventArgs,
2012 SqlRowUpdatingEventArgs, SqlRowUpdatedEventHandler,
2013 SqlRowUpdatingEventHandler in the build.
2015 2002-05-13 Tim Coleman
2016 * System.Data.Common/DbDataAdapter.cs:
2017 More implementation.
2018 * System.Data.Common/DataAdapter.cs:
2019 Correction of some of the stubbing, as well as a
2020 little bit more implementation
2022 2002-05-11 Tim Coleman
2023 * System.Data.SqlClient/SqlDataAdapter.cs:
2024 * System.Data.Common/DbDataAdapter.cs:
2025 Moved methods that weren't supposed to
2026 be in SqlDataAdapter out. They should be implemented
2030 2002-05-11 Tim Coleman
2031 * System.Data.SqlClient/SqlDataAdapter.cs:
2032 some implementation of this class. Note
2033 that none of the functionality has been
2034 tested yet, but I felt it should be checked
2035 in at this point as it compiles.
2036 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs:
2037 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs:
2038 Modified so that they will compile properly.
2039 Needed to include SqlDataAdapter in the build.
2041 2002-05-11 Rodrigo Moya <rodrigo@ximian.com>
2043 * System.Data/DataTable.cs (Clear): implemented.
2044 (DataTable): removed repeated code in constructors, and call the
2045 basic constructor from the others.
2047 * System.Data/DataColumn.cs: some tweaks.
2049 * System.Data/DataRow.cs (RowState): implemented.
2050 (CancelEdit): set rowState property back to Unchanged.
2051 (RejectChanges): call CancelEdit.
2052 (Delete): set rowState to Deleted.
2054 2002-05-11 Daniel Morgan <danmorg@sc.rr.com>
2056 * System.Data.build: added copy of System.Data.dll to Test directory
2057 for easy testing. Also, added clean for it too.
2059 * System.Data.SqlClient/PostgresLibrary.cs: changed setting of boolean
2060 from PostgreSQL data type to .NET type.
2062 * System.Data.SqlClient/SqlDataReader.cs: beginnings
2063 handling of a NULL value from the database
2065 * Test/PostgresTest.cs: added tests for NULL values retrieved
2068 * Test/ReadPostgresData.cs
2069 * Test/TestExecuteScalar.cs
2070 * Test/TestSqlDataReader.cs
2071 * Test/TestSqlException.cs
2072 * Test/TestSqlIsolationLevel.cs: updated tests to use databas user
2073 "postgres". These tests may eventually be removed since they
2076 2002-05-10 Rodrigo Moya <rodrigo@ximian.com>
2078 * System.Data.build: removed reference to non-existant
2079 TestDataColumn.cs file.
2081 * System.Data/DataSet.cs: added some implementation.
2083 2002-05-09 Daniel Morgan <danmorg@sc.rr.com>
2085 * System.Data.SqlClient/PostgresLibrary.cs: got
2086 PostgreSQL data types time, date, timestamp (DateTime like)
2087 mapped to .NET System.DateTime working based
2088 on ISO DateTime formatting "YYYY-MM-DD hh:mi:ss.ms"
2089 Also mapped pg type boolean to .net Boolean
2091 * SqlClient/SqlConnection.cs: run SQL command to set
2094 * Test/PostgresTest.cs: added test for an UPDATE SQL command,
2095 added tests for aggregates min(), max(), sum(), count(). could
2096 not get avg() to work due to some formatting error; someone claimed
2097 that it was my locale settings. added tests for SELECT of columns
2098 of type boolean, float, double, date, time, and timestamp. They
2099 have not been fully tested, but its a start.
2101 2002-05-09 Tim Coleman <tim@timcoleman.com>
2102 * System.Data.SqlTypes/SqlDecimal.cs: Implementations of
2103 addition, subtraction, and multiplication for the
2104 SqlDecimal type, as well as modification of some other
2105 operations. More to come on this one.
2107 2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
2109 * Test/System.Data_test.build: excluded TestDataColumn, which
2110 should be replaced with a nunit test.
2112 * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
2114 2002-05-07 Tim Coleman <tim@timcoleman.com>
2128 Fix the broken build I made before. Bad
2131 2002-05-07 Tim Coleman <tim@timcoleman.com>
2133 Fix a symantic error I made in SqlString
2134 Equals where I copied and pasted wrongly
2136 2002-05-07 Tim Coleman <tim@timcoleman.com>
2141 * SqlCompareOptions.cs:
2152 Implement CompareTo, Equals, and String conversions
2155 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
2157 * Test/PostgresTest.cs: modified to run completely. There
2158 are many TODOs in System.Data, so not all data types are
2159 included in the SELECT SQL query. Also, I made it to where
2161 using "host=localhost;dbname=test;user=postgres"
2162 instead of my userid and password. When more types are included,
2165 2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
2167 * Test/PostgresTest.cs: added - ported
2168 libgda postgres-test.c originally by
2169 Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
2172 2002-05-05 Tim Coleman <tim@timcoleman.com>
2173 * System.Data.SqlTypes/SqlBinary.cs:
2174 * System.Data.SqlTypes/SqlBoolean.cs:
2175 * System.Data.SqlTypes/SqlByte.cs:
2176 * System.Data.SqlTypes/SqlDateTime.cs:
2177 * System.Data.SqlTypes/SqlDecimal.cs:
2178 * System.Data.SqlTypes/SqlDouble.cs:
2179 * System.Data.SqlTypes/SqlGuid.cs:
2180 * System.Data.SqlTypes/SqlInt16.cs:
2181 * System.Data.SqlTypes/SqlInt32.cs:
2182 * System.Data.SqlTypes/SqlInt64.cs:
2183 * System.Data.SqlTypes/SqlMoney.cs:
2184 * System.Data.SqlTypes/SqlSingle.cs:
2185 * System.Data.SqlTypes/SqlString.cs:
2186 More implementation, and code clean-up for consistency.
2187 Also, I had implemented many conversions as explicit
2188 that should have been implicit. This should remove
2189 many of the red X's and green pluses from the
2190 System.Data.SqlTypes namespace.
2192 2002-05-05 Miguel de Icaza <miguel@ximian.com>
2194 * System.Data/DataSet.cs: Remove [Serializable] attributes from
2195 methods, those only apply to structs or classes.
2197 Stub out ISerializable, ISupportInitialize, and IListSource methods
2199 * System.Data/DataRowView.cs: Stub out interface methods for
2200 IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
2202 * System.Data/DataView.cs: Comment out non-implemented
2205 * System.Data/DataViewSettingsCollection.cs: Type cast variables
2206 to the correct type to make it compile.
2208 * System.Data/DataViewSettings.cs: remove reference to
2209 non-existance type ApplyDefaultSort, it is a boolean.
2212 2002-05-05 Tim Coleman <tim@timcoleman.com>
2213 * System.Data.SqlTypes/SqlBinary.cs:
2214 * System.Data.SqlTypes/SqlBoolean.cs:
2215 * System.Data.SqlTypes/SqlByte.cs:
2216 * System.Data.SqlTypes/SqlDecimal.cs:
2217 * System.Data.SqlTypes/SqlDouble.cs:
2218 * System.Data.SqlTypes/SqlGuid.cs:
2219 * System.Data.SqlTypes/SqlInt16.cs:
2220 * System.Data.SqlTypes/SqlInt32.cs:
2221 * System.Data.SqlTypes/SqlInt64.cs:
2222 * System.Data.SqlTypes/SqlMoney.cs:
2223 * System.Data.SqlTypes/SqlSingle.cs:
2224 * System.Data.SqlTypes/SqlString.cs:
2225 Various fixes, including adding the SqlNullValueException
2226 when trying to retrieve the value of a null SqlType,
2227 and when casting values, a Null of type A converts to a
2230 2002-05-04 Daniel Morgan <danmorg@sc.rr.com>
2232 * System.Data.SqlClient/PostgresLibrary.cs
2233 * System.Data.SqlClient/SqlCommand.cs
2234 * System.Data.SqlClient/SqlConnection.cs
2235 * System.Data.SqlClient/SqlDataReader.cs
2236 oid should not be hard coded because they
2237 can change from one version of PostgreSQL
2238 to the next. Use the typname's instead.
2239 The PostgreSQL type data retrieves
2240 at database connection time. Any unimplemented
2241 types just default to string. These were things
2242 suggested by Gonzalo.
2244 * Test/ReadPostgresData.cs - stuff
2245 * Test/TestSqlDataReader.cs - stuff
2247 * System.Data.SqlTypes/SqlInt32.cs - added a using
2249 2002-05-03 Tim Coleman <tim@timcoleman.com>
2250 * System.Data.build: Fix the build so that test depends on build
2252 2002-05-03 Tim Coleman <tim@timcoleman.com>
2253 * System.Data.SqlTypes/SqlByte.cs:
2254 * System.Data.SqlTypes/SqlDateTime.cs:
2255 * System.Data.SqlTypes/SqlDecimal.cs:
2256 * System.Data.SqlTypes/SqlDouble.cs:
2257 * System.Data.SqlTypes/SqlGuid.cs:
2258 * System.Data.SqlTypes/SqlInt16.cs:
2259 * System.Data.SqlTypes/SqlInt64.cs:
2260 * System.Data.SqlTypes/SqlMoney.cs:
2261 * System.Data.SqlTypes/SqlSingle.cs:
2262 These files were mysteriously excluded from the last
2263 patch I made and sent to Rodrigo
2264 * System.Data.build: include the System.Data.SqlTypes in the build
2266 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
2268 * System.Data.build: removed comments
2270 * System.Data.SqlClient/PostgresLibrary.cs: changed
2271 the hard-coded PostgreSQL oid type int's to using an
2272 enum. Also, added PostgreSQL bpchar (character) type.
2274 * Test/TestSqlDataReader.cs: updated test
2275 to include new bpchar PostgreSQL type
2277 2002-05-03 Rodrigo Moya <rodrigo@ximian.com>
2279 * System.Data.SqlTypes/SqlBinary.cs:
2280 * System.Data.SqlTypes/SqlBoolean.cs:
2281 * System.Data.SqlTypes/SqlInt32.cs:
2282 * System.Data.SqlTypes/SqlString.cs: more implementation, by
2283 Tim Coleman <tcoleman@opentext.com>.
2285 2002-05-03 Daniel Morgan <danmorg@sc.rr.com>
2287 * Test/TestExecuteScalar.cs: added test for
2288 method ExecuteScalar in class SqlCommand.
2290 * System.Data/DataColumnCollection.cs - it should
2291 inherit properties from base InternalDataCollectionBase
2292 and use them instead of overriding them, such as, List.
2294 * System.Data/DataColumn.cs
2295 * System.Data/DataTable.cs: tweaks to retrieve
2296 meta data from the database
2298 * System.Data.SqlClient/PostgresLibrary.cs -
2299 added method OidToType to convert PostgreSQL oid type
2300 to System.Type. Renamed method OidTypeToSystem
2301 to ConvertPgTypeToSystem for converting the data value
2302 from a PostgreSQL type to a .NET System type.
2304 * System.Data.SqlClient/SqlCommand.cs: implemented
2305 method ExecuteReader which returns a SqlDataReader
2306 for a light forward only read only result set.
2307 It works on types int4 ==> Int32 and
2308 varchar ==> String. Other types
2311 * System.Data.SqlClient/SqlConnection.cs: added comment
2313 * System.Data.SqlClient/SqlDataReader.cs: implemented
2314 class. It works, but still lots to do.
2316 * Test/ReadPostgresData.cs: stuff
2318 * Test/TestSqlDataReader.cs: updated test for SqlDataReader
2319 to display meta data and the data
2321 2002-05-03 Duncan Mak <duncan@ximian.com>
2323 * TODO: Took out all the Exceptions. They should be all done now.
2325 * System.Data/ConstraintException.cs:
2326 * System.Data/DBConcurrencyException.cs:
2327 * System.Data/DataException.cs:
2328 * System.Data/DeletedRowInaccessibleException.cs:
2329 * System.Data/DuplicateNameException.cs:
2330 * System.Data/EvaluateException.cs:
2331 * System.Data/InRowChangingEventException.cs:
2332 * System.Data/InvalidConstraintException.cs:
2333 * System.Data/InvalidExpressionException.cs:
2334 * System.Data/MissingPrimaryKeyException.cs:
2335 * System.Data/NoNullAllowedException.cs:
2336 * System.Data/ReadOnlyException.cs:
2337 * System.Data/RowNotInTableException.cs:
2338 * System.Data/StrongTypingException.cs:
2339 * System.Data/SyntaxErrorException.cs:
2340 * System.Data/TypeDataSetGeneratorException.cs:
2341 * System.Data/VersionNotFoundException.cs: Added to CVS.
2343 * System.Data.SqlTypes/SqlNullValueException.cs:
2344 * System.Data.SqlTypes/SqlTruncateException.cs:
2345 * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
2347 2002-05-02 Rodrigo Moya <rodrigo@ximian.com>
2349 * System.Data/DataViewSettingCollection.cs: implemented.
2351 * System.Data/DataRowView.cs: new stubs.
2353 * System.Data.SqlTypes/SqlByte.cs:
2354 * System.Data.SqlTypes/SqlDateTime.cs:
2355 * System.Data.SqlTypes/SqlDecimal.cs:
2356 * System.Data.SqlTypes/SqlDouble.cs:
2357 * System.Data.SqlTypes/SqlGuid.cs:
2358 * System.Data.SqlTypes/SqlInt16.cs:
2359 * System.Data.SqlTypes/SqlInt64.cs:
2360 * System.Data.SqlTypes/SqlMoney.cs:
2361 * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
2362 by Tim Coleman <tcoleman@opentext.com>
2364 * System.Data.build: excluded newly-added files.
2366 2002-05-02 Daniel Morgan <danmorg@sc.rr.com>
2368 * System.Data.SqlClient/PostgresLibrary.cs: included new
2369 internal class that will be a helper class in using
2370 PostgreSQL. PostgresLibrary is used for the
2371 pinvoke methods to the PostgreSQL Client
2372 native C library libpq while the class PostgresHelper
2373 is used for wrapper or helper methods. It currently only
2374 has one static method OidTypeToSystem in converting
2375 PostgreSQL types to .NET System.<type>s, such as,
2376 a PostgreSQL int8 becomes a .NET System.Int64.
2377 Only a few types have been added, such as, int2,
2378 int4, int8, varchar, text, bool, and char. Other types
2381 * System.Data.SqlClient/SqlCommand.cs: implemented
2382 method ExecuteScalar which allows us to do aggregate
2383 functions, such as, count, avg, min, max, and sum. We
2384 also are able to retrieve the result, convert it to the .NET type
2385 as an object. The user of the returned object must explicitly cast.
2387 * Test/ReadPostgresData.cs: updated sample
2388 to help us learn to retrieve data in System.Data.SqlClient
2391 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
2393 * System.Data.build: added /nowarn: nnnn arguments
2394 so you will not get a ton of warnings. The warnings
2395 being excluded are: 1595, 0067, 0109, 0169, and 0649
2397 2002-05-01 Daniel Morgan <danmorg@sc.rr.com>
2399 * System.Data.build: modified to exclude more
2400 files from the build
2402 2002-05-01 Rodrigo Moya <rodrigo@ximian.com>
2404 * System.Data.SqlClient/SqlClientPermission.cs: added missing
2407 * System.Data/MergeFailedEventArgs.cs: new class, contributed
2408 by John Dugaw <jdugaw@unizenconsulting.com>.
2410 * System.Data.build: excluded new files from build.
2412 2002-04-29 Daniel Morgan <danmorg@sc.rr.com>
2414 * Test/ReadPostgresData.cs: added - Uses the
2415 PostgresLibrary to retrieve a recordset.
2416 This is not meant to be used in Production, but as a
2417 learning aid in coding
2418 class System.Data.SqlClient.SqlDataReader.
2419 This sample does work.
2421 * Test/TestSqlDataReader.cs: added - used
2422 to test SqlDataReader (does not work yet)
2423 Forgot to add to ChangeLog on last commit.
2425 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
2427 * System.Data/DataViewSetting.cs: new class.
2429 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
2431 * System.Data/DataViewManager.cs: new class.
2433 * System.Data.SqlTypes/INullable.cs: properties for interfaces
2434 don't have implementation.
2436 * System.Data.SqlTypes/SqlInt32.cs:
2437 * System.Data.SqlTypes/SqlString.cs:
2438 * System.Data.SqlTypes/SqlBoolean.cs: removed destructor, since
2439 these are strctures.
2441 * System.Data.SqlClient/SqlClientPermissionAttribute.cs: added
2444 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
2446 * System.Data/DataTableRelationCollection.cs: use 'new' keyword
2447 for correctly hiding parent class' members.
2448 (AddRange): use 'override' keyword on overriden method.
2450 (Contains): likewise.
2451 (IndexOf): likewise.
2452 (OnCollectionChanged): likewise.
2453 (OnCollectionChanging): likewise.
2454 (RemoveCore): likewise.
2456 * System.Data/DataColumnCollection.cs: use 'new' keyword.
2458 * System.Data/DataSet.cs: added missing 'using's.
2460 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
2462 * System.Data/DataSet.cs:
2463 * System.Data/DataTableCollection.cs:
2464 * System.Data/DataView.cs: compilation fixes on Linux.
2466 2002-04-28 Daniel Morgan <danmorg@sc.rr.com>
2468 * System.Data/DataRelation.cs
2469 * System.Data/ForeignKeyConstraint.cs
2470 * System.Data/UniqueConstraint.cs: added more stubs
2472 * System.Data/DataTableRelationCollection.cs: added back to cvs
2473 and modified for compile errors. DataRelationCollection is an
2474 abstract class and there must be a class that implements for
2475 DataTable/DataSet. DataTableRelationCollection was changed
2476 to an internal class.
2478 * System.Data.build: modified - new files added
2479 also wanted to include files/classes in the build
2480 so we can get a compilable forward read only result set.
2481 It compiles now using csc/nant with warnings, but this
2482 is a start for adding functionality for the result set.
2483 Classes associated with/and DataSet are still excluded.
2485 * TODO: modified - updated to do list for System.Data
2487 * System.Data/Constraint.cs
2488 * System.Data/ConstraintCollection.cs
2489 * System.Data/DataRelationCollection.cs
2490 * System.Data/DataRow.cs
2491 * System.Data/DataRowChangeEventArgs.cs
2492 * System.Data/DataRowCollection.cs
2493 * System.Data/DataTable.cs
2494 * System.Data/DataTableCollection.cs
2495 * System.Data/InternalDataCollectionBase.cs
2496 * System.Data/PropertyCollection.cs: modified -
2497 changes to compile SqlDataReader/DataTable and
2500 * System.Data/IDbCommand.cs
2501 * System.Data.SqlClient/SqlCommand.cs: modified -
2502 un-commented overloaded methods ExecuteReader
2503 which returns a SqlDataReader
2505 2002-04-28 Rodrigo Moya <rodrigo@ximian.com>
2507 * System.Data/DataTableCollection.cs: more implementation.
2508 (Count): added 'override' keyword, as pointer out by Martin.
2510 * System.Data.Common/DataColumnMappingCollection.cs (Add, AddRange):
2511 only call Array.Copy when there is really stuff to be copied.
2512 (CopyTo): don't create the temporary array, it's not needed.
2514 * System.Data.build: excluded newly added file from build.
2516 2002-04-27 Rodrigo Moya <rodrigo@ximian.com>
2518 * System.Data/DataTableRelationCollection.cs: removed, it's not
2519 on MS SDK documentation.
2521 * System.Data/DataTableCollection.cs: new class.
2523 2002-04-27 Daniel Morgan <danmorg@sc.rr.com>
2525 * System.Data/DataRowChangeEventArgs.cs
2526 * System.Data/DataRowCollection.cs
2527 * System.Data/DataView.cs
2528 * System.Data/PropertyCollection.cs: added new stubs
2530 * System.Data.build: modified - added new files to exclude
2533 * TODO: modified - removed files from TODO list
2534 that were stubbed above
2536 * System.Data/DataColumn.cs
2537 * System.Data/DataRow.cs: modified - various tweaks
2538 and added internal method SetTable to set the reference
2541 * System.Data/DataSet.cs: modified - class was not
2544 * System.Data/DataTable.cs: modified - temporarily commented
2545 DataSet and DataView references - trying to compile a SqlDataReader,
2546 DataTable, and dependencies for a forward read-only result set.
2547 SqlDataAdapter, DataSet, and DataView will come later once we can get
2548 a forward read only result set working.
2550 * System.Data/IDataRecord.cs: modified - source code lines should
2553 * System.Data/InternalDataCollectionBase.cs: modified - started
2554 implementing this base class for collection of data rows,
2555 columns, tables, relations, and constraints
2557 * System.Data.SqlClient/SqlException.cs: modified -
2558 call base(message) so a unhandled exception displays
2559 the message of a SQL error instead of the
2560 default SystemException message
2562 * Test/TestSqlException.cs: modified -
2563 handle the rollback properly for a SqlException on a
2566 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
2568 * System.Data.build: modified - added new
2569 files to exclude from build
2571 * System.Data/Constraint.cs
2572 * System.Data/ConstraintCollection.cs
2573 * System.Data/InternalDataCollectionBase.cs: added -
2574 stubs which are needed to build DataTable.cs
2576 * TODO: modified - added more classes TODO and
2577 added more stuff TODO, such as, create script
2578 to create test database monotestdb for testing
2579 classes in System.Data
2581 2002-04-23 Rodrigo Moya <rodrigo@ximian.com>
2583 * System.Data.Common/DataAdapter.cs:
2584 * System.Data.Common/DataColumnMappingCollection.cs:
2585 * System.Data.Common/DataTableMappingCollection.cs:
2586 * System.Data.Common/DbDataPermission.cs:
2587 * System.Data.Common/DbDataPermissionAttribute.cs: some
2588 compilation errors fixed.
2590 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
2592 * TODO: modified - added classes TODO, and
2593 a poor attempt at System.Data plan
2595 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
2597 * ChangeLog: modified - put tabs where they belong
2599 * System.Data.SqlClient/SqlDataReader.cs
2600 * System.Data/DataColumn.cs: modified - compile errors
2601 trying to compile SqlDataAdapter and dependencies
2603 2002-04-23 Daniel Morgan <danmorg@sc.rr.com>
2605 * System.Data.SqlTypes/SqlBoolean.cs
2606 * System.Data.SqlTypes/SqlCompareOptions.cs
2607 * System.Data.SqlTypes/SqlInt32.cs
2608 * System.Data.SqlTypes/SqlString.cs: added - new stubs
2610 * System.Data/DataTable.cs
2611 * System.Data.SqlClient/SqlCommand.cs
2612 * System.Data.SqlClient/SqlConnection.cs
2613 * System.Data.SqlClient/SqlError.cs
2614 * System.Data.SqlClient/SqlTransaction.cs: modified -
2617 * System.Data.SqlClient/SqlException.cs: modified -
2618 missing Message on indexer for Message property
2620 2002-04-21 Daniel Morgan <danmorg@sc.rr.com>
2622 * System.Data.SqlClient/SqlCommand.cs: modified - to
2623 compile using mcs. This problem is
2624 returning a stronger type in csc vs. msc
2626 * System.Data.SqlClient/SqlConnection.cs: modified - msc
2627 can not do a using PGconn = IntPtr; and then declare
2628 with PGconn pgConn = IntPtr.Zero;
2629 Thiw works under csc though. Had to comment using and
2630 changed declaration to IntPtr pgConn = IntPtr.Zero;
2631 Also, got rid of compile warnings for hostaddr and port.
2633 * System.Data.SqlClient/SqlErrorCollection.cs: modified - got
2634 rid of compile warnings. Commented MonoTODO attribute because mcs
2635 doesn't seem to work with C# array property indexer (Item)
2638 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
2639 commented MonoTODO attribute for indexer for mcs compiling
2641 * Test/TestSqlIsolationLevel.cs:
2642 * Test/TestSqlInsert.cs:
2643 * Test/TestSqlException.cs: modified -
2644 removed extra ExecuteNonQuery which caused two inserted rows
2646 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
2648 * System.Data/StateChangeEventArgs.cs - added
2649 needed to compile System.Data.dll with mcs.
2651 2002-04-20 Daniel Morgan <danmorg@sc.rr.com>
2653 * System.Data.OleDb: added directory - for OleDb database
2656 * System.Data.SqlClient/SqlClientPermission.cs
2657 * System.Data.SqlClient/SqlClientPermissionAttribute.cs
2658 * System.Data.SqlClient/SqlCommandBuilder.cs
2659 * System.Data.SqlClient/SqlInfoMessageEventHandler.cs
2660 * System.Data.SqlClient/SqlRowUpdatedEventArgs.cs
2661 * System.Data.SqlClient/SqlRowUpdatedEventHandler.cs
2662 * System.Data.SqlClient/SqlRowUpdatingEventArgs.cs
2663 * System.Data.SqlClient/SqlRowUpdatingEventHandler.cs
2664 * Test/TestSqlException.cs
2665 * Test/TestSqlIsolationLevel.cs: added - more tests
2667 * System.Data.build: modified - added new files - excludes these too
2669 * System.Data.SqlClient/PostgresLibrary.cs - modified - comment
2671 * System.Data.SqlClient/SqlConnection.cs
2672 * System.Data.SqlClient/SqlCommand.cs
2673 * System.Data.SqlClient/SqlTransaction.cs
2674 * System.Data.SqlClient/SqlException.cs
2675 * System.Data.SqlClient/SqlErrorCollection.cs
2676 * System.Data.SqlClient/SqlError.cs: modified - transaction and
2677 exception/error handling. SqlConnection(connectionString)
2678 constructor should not automatically connect.
2680 * System.Data.SqlClient/SqlDataReader.cs
2681 * System.Data.SqlClient/SqlDataAdapter.cs
2682 * System.Data.SqlClient/SqlParameter.cs
2683 * System.Data.SqlClient/SqlParameterCollection.cs: modified -
2684 added using System.ComponentModel;
2686 * Test/TestSqlInsert.cs: modified - to use transaction
2688 2002-04-17 Rodrigo Moya <rodrigo@ximian.com>
2690 * System.Data/DataRow.cs: new skeletons.
2692 * System.Data.Common/DataAdapter.cs:
2693 * System.Data.Common/DataColumnMapping.cs:
2694 * System.Data.Common/DataColumnMappingCollection.cs:
2695 * System.Data.Common/DataTableMapping.cs:
2696 * System.Data.Common/DataTableMappingCollection.cs:
2697 * System.Data.Common/DbDataAdapter.cs:
2698 * System.Data.Common/RowUpdatedEventArgs.cs:
2699 * System.Data.SqlClient/SqlDataAdapter.cs:
2700 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: compilation
2703 * System.Data.Common/DbDataRecord.cs:
2704 * System.Data.Common/DbEnumerator.cs: removed MS implementation
2707 2002-04-17 Daniel Morgan <danmorg@sc.rr.com>
2709 * Test/TestSqlInsert.cs: modified - do
2710 a SQL DELETE before SQL INSERT of row so you can use this
2713 * System.Data.SqlClient/SqlTransaction.cs: modified - default
2714 IsolationLevel for PostgreSQL is ReadCommitted. However,
2715 PostgreSQL allows Serializable as well.
2716 (Thanks to Gonzalo for that!)
2718 * System.Data.SqlClient/SqlConnection.cs: modified
2719 * System.Data.SqlClient/SqlCommand.cs: modified
2720 * System.Data.SqlClient/SqlTransaction.cs: modified - got transactions
2721 working; however, we still need to implement SQL errors
2722 and exceptions to properly handle transactions. Also, added
2723 status and error message support from the PostgreSQL database.
2724 Currently, this does a Console.WriteLine() to display the
2725 status and error messages, but this is a TODO
2726 for SQL errors and exceptions.
2728 * System.Data/TODOAttribute.cs: added - needed MonoTODO
2729 attribute for System.Data.dll assembly
2731 * System.Data/IDbCommand.cs: modified - commented
2732 overloaded method ExecuteReader
2733 so System.Data.SqlClient.SqlCommand can compile
2735 * System.Data/IDbCommand.cs: modified
2736 * System.Data/IDbConnection.cs: modified - added using System;
2737 * System.Data/IDataParameter.cs
2739 * System.Data.build: modified - build classes
2740 in System.Data.SqlClient and exclude others in System.Data
2742 * System.Data.SqlClient/PostgresLibrary.cs: modified - change
2743 parameter data type from IntPtr to enum ExecStatusType
2745 * ChangeLog: modified - corrected previous entries in log
2747 2002-04-16 Rodrigo Moya <rodrigo@ximian.com>
2749 * System.Data.Common/DataColumnMappingCollection.cs: added basic
2750 implementation. Still missing some stuff.
2752 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
2754 * System.Data.SqlClient/SqlConnection.cs: modified - got
2755 to compile, run, and connect to PostgreSQL database
2757 * System.Data.SqlClient/SqlCommand.cs: modified - got
2758 to compile, run, and execute a SQL INSERT command
2759 which successfully inserted a row
2760 into the PostgreSQL database
2762 * System.Data.SqlClient/SqlTransaction.cs: modified
2763 * System.Data.SqlClient/SqlParameter.cs: modified
2764 * System.Data.SqlClient/SqlParameterCollection.cs: modified
2765 * System.Data.SqlClient/SqlError.cs: modified
2766 * System.Data.SqlClient/SqlErrorCollection.cs: modified
2767 * System.Data.SqlClient/SqlException.cs: modified
2768 * System.Data.SqlClient/PostgresLibrary.cs: modified - to compile
2770 * System.Data.SqlClient/SqlAdapter: modified
2771 * System.Data.SqlClient/SqlReader: modified - add more stubs
2773 2002-04-16 Daniel Morgan <danmorg@sc.rr.com>
2775 * Test/TestSqlInsert.cs: added
2777 2002-04-15 Daniel Morgan <danmorg@sc.rr.com>
2779 * System.Data.SqlClient/SqlInfoMessageEventArgs.cs: added - using in
2780 class SqlConnecition
2781 * System.Data.SqlClient/SqlErrorCollection.cs: added
2782 * System.Data.SqlClient/SqlErrors.cs: removed - no such class SqlErrors
2784 2002-04-15 Christopher Podurgiel <cpodurgiel@msn.com>
2786 * System.Data.IDbDataParameter: Added Interface to IDataParameter.
2787 * System.Data.IDbTransaction: Added Interface to IDisposable.
2788 * System.Data.IDbCommand: Fixed Capitalization of class name.
2789 * System.Data.IDbConnection: Fixed Capitalization of class name.
2791 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
2793 * System.Data.Common/DbDataPermissionAttribute.cs:
2794 * System.Data.Common/DataAdapter.cs:
2795 * System.Data.Common/DataColumnMapping.cs:
2796 * System.Data.Common/DbDataPermission.cs: added some implementation.
2798 2002-04-15 Rodrigo Moya <rodrigo@ximian.com>
2800 * System.Data.SqlClient/SqlConnection.cs: fixed constructor chaining
2801 syntax, as pointed out by Levent Camlibel.
2803 2002-04-14 Rodrigo Moya <rodrigo@ximian.com>
2805 * System.Data.SqlTypes/SqlBinary.cs:
2806 * System.Data.SqlTypes/INullable.cs: new skeletons.
2808 2002-04-14 Daniel Morgan <danmorg@sc.rr.com>
2810 * System.Data.SqlClient/PostgresLibrary.cs: new internal class, which
2811 contains all calls the the PostgreSQL client library, to be used
2812 everywhere in System.Data.SqlClient.
2814 2002-03-30 Rodrigo Moya <rodrigo@ximian.com>
2816 * System.Data.SqlClient/SqlConnection.cs: implemented basic
2819 * System.Data.SqlTypes/SqlNullValueException.cs: new skeletons.
2821 2002-03-29 Rodrigo Moya <rodrigo@ximian.com>
2823 * System.Data.Common/DbDataRecord.cs:
2824 * System.Data.Common/DbEnumerator.cs:
2825 * System.Data.Common/RowUpdatedEventArgs.cs:
2826 * System.Data.Common/RowUpdatingEventArgs.cs:
2827 * System.Data.Common/DbDataPermissionAttribute.cs: new skeletons.
2829 2002-03-28 Rodrigo Moya <rodrigo@ximian.com>
2831 * System.Data.Common/DataTableMappingCollection.cs:
2832 * System.Data.Common/DbDataAdapter.cs:
2833 * System.Data.Common/DbDataPermission.cs:
2834 * System.Data.Common/DataTableMapping.cs: new skeletons.
2836 * System.Data.SqlClient/SqlDataAdapter.cs:
2837 * System.Data.SqlClient/SqlDataReader.cs:
2838 * System.Data.SqlClient/SqlErrors.cs:
2839 * System.Data.SqlClient/SqlError.cs:
2840 * System.Data.SqlClient/SqlException.cs:
2841 * System.Data.SqlClient/SqlParameter.cs:
2842 * System.Data.SqlClient/SqlParameterCollection.cs:
2843 * System.Data.SqlClient/SqlTransaction.cs:
2844 * System.Data.SqlClient/SqlCommand.cs: fixed skeletons.
2846 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
2848 * System.Data.Common/DataColumnMapping.cs:
2849 * System.Data.Common/DataColumnMappingCollection.cs:
2850 * System.Data.Common/DataAdapter.cs: created skeletons.
2852 * System.Data.build: exclude new directories from build.
2854 2002-03-27 Rodrigo Moya <rodrigo@ximian.com>
2856 * System.Data.SqlClient/SqlTransaction.cs: started implementation.
2858 * System.Data.SqlClient/SqlConnection.cs (BeginTransaction):
2859 implemented (2 methods).
2861 2002-03-24 Duncan Mak <duncan@ximian.com>
2863 * System.Data.build: Excluded System.Data.SqlClient from the build.
2864 The stubs are incomplete and they are stopping the build.
2866 * System.Data.SqlClient/SqlCommand.cs: Replaced 'implements' with ':'.
2868 2002-03-24 Rodrigo Moya <rodrigo@ximian.com>
2870 * System.Data.SqlClient/*: added skeletons for the SQL managed
2871 provider for ADO.Net, to be based initially in PostgreSQL.
2873 2002-03-15 Christopher Podurgiel <cpodurgiel@msn.com>
2875 Changed the Namespace on some Enums from mono.System.Data to System.Data
2877 2002-03-01 Christopher Podurgiel <cpodurgiel@msn.com>
2879 * DataColumnCollection.cs : When an existing DataColumn is added, will now Assign a
2880 default name if the ColumnName is null.
2881 * DataSet.cs : Added
2882 * DataTable.cs : Added
2883 * DataRelationCollection.cs : Added
2884 * DataTableRelationCollection.cs : Added
2885 * DataColumn : Added
2887 2002-02-11 Christopher Podurgiel <cpodurgiel@msn.com>
2889 * DataColumnChangeEventArgs.cs : Added
2890 * DataColumnCollection.cs : Added
2892 2002-02-10 Christopher Podurgiel <cpodurgiel@msn.com>
2894 * Removed *.cs from System.Data as the correct files are in mcs/class/System.Data/System.Data
2895 * Updated all Enums, Interfaces, and Delegates in System.Data