1 2008-09-13 Atsushi Enomoto <atsushi@ximian.com>
3 * SqlDependency.cs : wrong namespace.
5 2008-08-14 Gert Driesen <drieseng@users.sourceforge.net>
7 * SqlConnection.cs: Use constants for min/max values. When value is
8 zero-length string, then fallback to default value for boolean and
9 integer backed properties. Throw ArgumentException when min pool size
10 exceeds max pool size. Check whether value for 'MARS' is a bool.
11 The 'user instance' property is 2.0 only.
13 2008-08-14 Gert Driesen <drieseng@users.sourceforge.net>
15 * SqlConnection.cs: Convert keywords to lowercase instead of uppercase
16 to avoid further case changes in exception messages.
18 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
20 * SqlCommand.cs (ExecuteReader): When behavior includes SingleRow,
21 then only return a single result. Fixes bug #412569.
23 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
25 * SqlCommand.cs: Fixed order of arguments for ArgumentException in
27 * SqlConnection.cs (ChangePassword): Do not allow empty connection
28 string. Updated exception messages.
30 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
32 * SqlCommand.cs: Fixed param name in ArgumentException for negative
33 CommandTimeout to match MS. On 2.0 profile, throw NRE in Prepare
34 when connection is NULL. In Prepare, return immediately after
35 connection check (2.0 only) for stored procedures, or when no
36 parameters are added. Added check to see if transaction is
37 associated with same connection as the command and updated
40 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
42 * SqlCommand.cs: Added bool argument to ValidateCommand to specify
43 whether an async method is being executed. Minor changes to exception
46 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
48 * SqlCommand.cs: Avoid NRE in CloseDataReader when connection is NULL.
49 Fixes bug #412584. Removed unused moreResults eargument from
50 CloseDataReader. Removed behavior argument from Execute, and have it
51 use the behavior field instead. In ValidateCommand, throw
52 InvalidOperationException instead of NRE when Connection is NULL.
53 * SqlDataReader.cs: Sync with SqlCommand's CloseDataReader signature
56 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
58 * SqlCommand.cs: (Transaction): On the 1.0 profile, do not allow
59 Transaction to be set when a reader is open for the current connection.
62 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
64 * SqlCommand.cs (Connection): Do not throw InvalidOperationException
65 if transaction is in progress. Fixes bug #412576. On 1.0 profile, throw
66 InvalidOperationException when a reader is open for the current
67 connection. Do not set transaction to NULL when changing connection,
68 instead set it to null in Transaction when transaction is no longer
71 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
73 * SqlConnection.cs: Use null as default value for connectionString
74 field. Remove Init method, as initialization is done in
75 SetDefaultConnectionParameters. Initialize parms in
76 SetDefaultConnectionParameters to avoid calling Reset on newly
77 initialized collection. In Dispose (bool), also invoke base.Dispose if
78 SqlConnection was already disposed. Fixes bug #412571.
80 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
82 * SqlConnection.cs (ChangeState): Return immediately when new state
83 equals original state. Fixes bug #412574. Removed extra whitespace.
85 2008-07-23 Veerapuram Varadhan <vvaradhan@novell.com>
87 * SqlDataReader.cs (NextResult): Memleak fix - mark datatypeNames
88 array to be GCed along with schemaTable.
90 2008-07-23 Veerapuram Varadhan <vvaradhan@novell.com>
92 * SqlDataReader.cs: Do not generate schemaTable unless otherwise
93 asked for; use command.Tds.Columns instead. Improves performance
96 2008-07-10 Veerapuram Varadhan <vvaradhan@novell.com>
99 * SqlCommand.cs (GetOutputParameters): Update parameter values iff
100 parameter direction is InputOutput or Output.
102 2008-07-06 Gert Driesen <drieseng@users.sourceforge.net>
104 * SqlException.cs: Modified HResult/ErrorCode to match MS. Removed
105 unused FromTdsInternalException overload. Removed unnecessary check
106 for Errors.Count. Minor code formatting.
108 2008-07-03 Rodrigo Kumpera <rkumpera@novell.com>
110 * SqlConnection.cs: Remove connStringParameters as nobody uses it.
112 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
114 * SqlDataReader.cs: Do all column accesses with int indexes.
116 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
118 * SqlDataReader.cs (GetSchemaTable): All column index are constants,
121 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
123 * SqlDataReader.cs (GetSchemaTable): Calculate column indexes
124 outside of the row loop.
126 2008-07-01 Marek Habersack <mhabersack@novell.com>
128 * SqlDataReader.cs: use named properties in TdsDataColumn for the
131 2008-06-30 Zoltan Varga <vargaz@gmail.com>
133 * SqlDataReader.cs: Allocate 'schemaTable' lazily.
134 (GetSchemaValue): Avoid some hash table lookups
136 2008-06-27 Zoltan Varga <vargaz@gmail.com>
138 * SqlDataReader.cs (ConstructSchemaTable): Avoid unneccessary reflection calls.
140 2008-06-23 Veerapuram Varadhan <vvaradhan@novell.com>
142 * SqlDependency.cs: New
144 2008-06-12 Veerapuram Varadhan <vvaradhan@novell.com>
146 Patch by Christian Hergert <christian.hergert@gmail.com>
147 * SqlConnection.cs (Open): Do not reset the connection as it is already
148 done in the TdsConnectionPool itself.
150 2008-06-12 Marek Habersack <mhabersack@novell.com>
152 * SqlParameterCollection.cs: this [int] must check the range and
153 throw an exception if necessary.
155 * SqlCommand.cs: throw IOEX when stored procedure is not found in
156 DeriveParameters. All procedures in MS SQL will report at least
157 one parameter - the return value.
159 2008-06-10 Veerapuram Varadhan <vvaradhan@novell.com>
161 * SqlConnection.cs: TdsConnectionPool.GetConnectionPool() now returns
162 IDictionary<TKey, TValue>.
164 2008-06-09 Ankit Jain <jankit@novell.com>
166 * SqlCommand.cs: Use Tds instead of ITds now.
167 * SqlConnection.cs: Likewise.
169 2008-05-27 Gert Driesen <drieseng@users.sourceforge.net>
171 * SqlConnection.cs: Added support for '.' as alias for localhost.
172 Improve exception message when TCP/IP protocol is not enabled.
174 2008-05-17 Gert Driesen <drieseng@users.sourceforge.net>
176 * SqlDataReader.cs (GetInt64): Removed workaround for TDS 7.0 handling
177 of bigint column type as this is handled in Mono.Data.Tds.
179 2008-05-14 Marek Habersack <mhabersack@novell.com>
181 * SqlConnection.cs: added support for USER INSTANCE keyword in the
184 2008-04-22 Veerapuram Varadhan <vvaradhan@novell.com>
187 * SqlCommand.cs: Handle exceptions sanely and do not close
188 connection on TdsTimeoutException.
190 2008-04-21 Gert Driesen <drieseng@users.sourceforge.net>
192 * SqlBulkCopyColumnMappingCollection.cs: Changed argument names to
193 match MS. Code formatting.
194 * SqlCommand.cs: Changed argument names to match MS. Code formatting.
195 Do not include explicit IDbCommand implementation on 2.0 profile.
196 * SqlCommandBuilder.cs: Changed argument names to match MS. Code
198 * SqlDataReader.cs: Changed argument names to match MS. Code
200 * SqlParameterCollection.cs: Do not include IList, ICollection and
201 IDataParameterCollection explicit interface implementation on 2.0
202 profile. Code formatting.
203 * SqlConnection.cs: Changed argument names to match MS.
204 * SqlDataAdapter.cs: Changed argument names to match MS.
205 * SqlTransaction.cs: Do not include explicit interface implementation
206 of IDbTransaction.Connection on 2.0 profile. Code formatting.
208 2008-04-19 Robert Jordan <robertj@gmx.net>
210 * SqlParameterCollection.cs (AddRange(SqlParameter[])):
211 Fix endless recursion.
213 2008-04-08 Marek Habersack <mhabersack@novell.com>
215 * SqlConnection.cs: TCP port discovery via UDP port 1434 should
216 honor the timeout specified in the connection string (or the
217 default one). In some environments 100 microseconds might not be
218 enough to discover the port.
220 2008-04-01 Marek Habersack <mhabersack@novell.com>
222 * SqlParameter.cs: ConvertToFrameworkType must handle empty
223 strings gracefully - a DBNull.Value must be returned in this
226 * SqlCommand.cs: DeriveParameters should split the stored
227 procedure name into the schema name and procedure name before
228 querying its parameters.
230 2008-03-03 Ankit Jain <jankit@novell.com>
232 * SqlClientMetaDataCollectionNames.cs: Set the field values.
234 2007-10-21 Gert Driesen <drieseng@users.sourceforge.net>
236 * SqlCommand.cs: Use ExceptionHelper.CheckEnumValue for enum checks.
238 2007-10-20 Gert Driesen <drieseng@users.sourceforge.net>
240 * SqlCommand.cs: Added constant for default CommandTimeout, instead
241 of using a magic number. Avoid unnecessary initialization. Fixed
242 default value for DesignTimeVisible. Return zero-length string if
243 CommandText is null. Use ExceptionHelper.InvalidEnumValueException
244 to avoid code duplication. Spaces to tabs and code formatting.
245 * SqlConnection.cs: Use different default package size on 2.0 profile.
246 Added constants for default values, instead of using magic numbers.
247 Avoid unnecessary initialization. In PacketSize, return default or
248 configured packet size when connection is not open. Use
249 ExceptionHelper.ConnectionClosed instead of local method. Removed
250 use of some hardcoded values in SetDefaultConnectionParameters, and
251 use Environment.MachineName as default WorkstationId instead of
252 DNS host name. Code formatting.
253 * SqlDataAdapter.cs: In default ctor, set SelectCommand to null.
254 Avoid unnecessary initializations. Use direct assignment in
255 IDbDataAdapter implementation. Fixed exception message for negative
256 UpdateBatchSize. In Dispose override, make sure to invoke base
259 2007-10-19 Gert Driesen <drieseng@users.sourceforge.net>
261 * SqlTransaction.cs: Clear connection in commit. In IsolationLevel,
262 throw IOE if transaction is no longer open.
264 2007-10-19 Gert Driesen <drieseng@users.sourceforge.net>
266 * SqlTransaction.cs: Avoid unnecessary initialization. Remove
267 isRolledBack since its essentially the same as isOpen. Use
268 ExceptionHelper.TransactionNotUsable instead of duplicating code.
269 On 2.0 profile, ignore call to Rollback when transaction was already
272 2007-10-18 Gert Driesen <drieseng@users.sourceforge.net>
274 * SqlConnection.cs: Avoid unnecessary initialization. Use string.Empty
275 for assigning zero-length string, and use String.Length to check for
276 zero-length string. Added support for IsolationLevel.Snapshot.
277 Added StructuredTypeMembers schema collection and restrictions. Fixed
278 table name for MetaDataCollections collection. Implemented
279 DataSourceInformation collection. Added missing data types (probably
280 introduced in 2.0 SP1). In GetSchema, throw InvalidOperationException
281 if connection is closed and throw NotImplementedException for
282 StructuredTypeMembers collection.
284 2007-10-18 Gert Driesen <drieseng@users.sourceforge.net>
286 * SqlConnection.cs: On 1.0 profile, IsolationLevel.Unspecified is
287 not valid. On 2.0 profile, when IsolationLevel.Unspecified is passed
288 make sure to also set SqlTransaction.IsolationLevel to
289 ReadCommitted. Modified exceptions to match MS.
291 2007-10-17 Nagappan <anagappan@novell.com>
293 * SqlParameter.cs (ConvertToFrameworkType): Added SqlDbType.Image.
295 2007-10-17 Nagappan <anagappan@novell.com>
297 * SqlConnection.cs: BeginTransaction does not handle
298 IsolationLevel.Unspecified, so the default is set as ReadCommited.
299 Thanks to Jerome Haltom <wasabi@larvalstage.net> for this patch. Fixes
301 * SqlTransaction.cs: If transaction count is greater then 0 then roll back.
302 Thanks to Jerome Haltom <wasabi@larvalstage.net> for this patch. Fixes
305 2007-10-15 Gert Driesen <drieseng@users.sourceforge.net>
307 * SqlException.cs: Do not hide Message on 2.0 profile. Fixes bug
310 2007-10-08 Marek Safar <marek.safar@gmail.com>
312 * SqlParameterCollection.cs (SetParameter): Fixed missing cast.
314 2007-09-27 Nagappan A <anagappan@novell.com>
316 * SqlConnection.cs: Added MonoTODO appropriately.
318 2007-09-26 Nagappan A <anagappan@novell.com>
320 * SqlCommandBuilder.cs: Code alignment.
322 2007-09-25 Nagappan A <anagappan@novell.com>
324 * SqlInitialCatalogConverter.cs, SqlDataSourceConverter.cs:
325 NetworkLibraryConverter.cs: Added new files.
327 * SqlParameter.cs: 2.0 attribute changes.
329 * SqlDataAdapter.cs: 2.0 attribute changes.
331 * SqlConnectionStringBuilder.cs: 2.0 attribute changes.
333 * SqlConnection.cs (ClearAllPools, ClearPool): Implemented 2.0
334 APIs, other 2.0 attribute changes.
336 * SqlCommandBuilder.cs (GetSchemaTable, InitializeCommand):
337 Implemented 2.0 APIs, other 2.0 attribute changes.
339 * SqlBulkCopyColumnMappingCollection.cs: Added constructor, 2.0
340 API compatibility changes.
342 * SqlException.cs: 2.0 attribute changes.
344 2007-08-13 Nagappan A <anagappan@novell.com>
346 * SqlConnection.cs (ConnectionString): 2.0 compatibility changes.
348 * SqlDataReader.cs (IsCommandBehavior): Fixed spelling mistake of
350 (Dispose): 2.0 compatibility changes.
352 * SqlBulkCopy.cs (SqlRowsCopied): Fixed spelling mistake of the
354 (RowsCopied): Generates event when NotifyAfter is set.
356 * SqlCommandBuilder.cs (Dispose, RefreshSchema): 2.0 compatibility
359 * SqlClientFactory.cs (CreateDataSourceEnumerator): Removed bogus
362 * SqlException.cs (Message): 2.0 compatibility changes.
364 2007-08-06 Nagappan A <anagappan@novell.com>
366 * SqlCommand.cs, SqlDataReader.cs, SqlConnection.cs: When the
367 server resets the connection, now the client code also disconnects
368 the session and remove the instance from pool. Fixes bug # 81933.
370 2007-07-31 Nagappan A <anagappan@novell.com>
372 * SqlCommand.cs (Transaction, Connection): IDbCommand Transaction
373 and Connection can be set to null. Fixes bug 82189.
375 2007-07-23 Nagappan A <anagappan@novell.com>
377 * SqlCommandBuilder.cs (ApplyParameterInfo, GetParameterName):
378 (GetParameterPlaceholder): Implemented 2.0 missing APIs.
380 2007-07-22 Nagappan A <anagappan@novell.com>
382 * SqlBulkCopy.cs (NotifyAfter): Implemented 2.0 property.
383 (GetColumnMetaData, GenerateColumnMetaData):
384 (ValidateColumnMapping): Implemented private method's to generate
385 and validate SqlBulkCopy headers.
386 (BulkCopyToServer): Private method to actually do the bulk copy
388 (WriteToServer): Implemented 2.0 missing overloaded methods.
389 (IDisposable.Dispose): Implemented 2.0 missing method.
391 * SqlBulkCopyColumnMappingCollection.cs (Add, CopyTo): Implemented
393 (Item): Implemented missing property.
395 * SqlBulkCopyColumnMapping.cs: Modified the implementation of
396 Constructors to use property.
398 * SqlDataReader.cs (GetSqlXml, IsCommandBehaviour): Added 2.0
400 (Connection): Added missing property.
402 * SqlParameter.cs (SetSqlDbType, ConvertToFrameworkType): Modified
403 method as internal from private.
405 * SqlConnection.cs: Fixed 2.0 missing feature.
407 * SqlException.cs: Fixed 2.0 missing feature.
409 * SqlClientPermission.cs: Fixed 2.0 missing feature.
411 2007-07-01 Gert Driesen <drieseng@users.sourceforge.net>
413 * ISqlNotificationReceiver.cs: Removed.
414 * SqlClientFactory.cs: Use SqlDataSourceEnumerator from S.D.Sql and
415 marked method todo. Avoid unnessary casts. Code formatting.
416 * SqlCommand.cs: Explicit interface implementation of IDbCommand not
417 necessary on 2.0 profile. Fixes API mismatches. Avoid unnecessary
418 casts. Code formatting.
419 * SqlConnection.cs: Also use RecommendAsConfigurable instead of
420 SettingBindableAttribute on 2.0. Use StateChange event from base class
421 on 2.0. Only explicitly implement IDbConnection methods on 1.0, since
422 these are implemented by base class on 2.0 profile. Removed extra
423 explicit implementation of IDisposable since the base class implements
424 this. Code formatting.
425 * SqlDataAdapter.cs: Dispose (bool) override not necessary on 2.0
426 profile. Stubbed ICloneable.Clone. Fixes API mismatches.
427 * SqlDataReader.cs: On 2.0, IDisposable.Dispose is implemented by
428 DbDataReader. Only 1.0 profile, explicitly implemented IEnumerable
429 GetEnumerator. Code formatting.
430 * SqlDataSourceEnumerator.cs: Removed.
431 * SQLDebugging.cs: Marked sealed on 2.0. Code formatting.
432 * SqlNotificationAuthType.cs: Removed.
433 * SqlNotificationInfo.cs: Added missing fields. Code formatting.
434 * SqlNotificationSource.cs: Added missing fields. Code formatting.
435 * SqlNotificationTransports.cs: Removed.
436 * SqlNotificationType.cs: Added missing Unknown field. Code formatting.
437 * SqlParameter.cs: Removed Browsable and EditorBrowsable attributes
438 from Precision and Scale. Fixes API mismatches. Code formatting fixes.
439 * SqlTransaction.cs: On 2.0 profile, Dispose method is exposed by
440 base class. Fixes API mismatches. Code formatting fixes.
442 2007-06-21 Nagappan A <anagappan@novell.com>
444 * SqlConnection.cs: Fixed compiler warning.
446 2007-06-11 Nagappan A <anagappan@novell.com>
448 * SqlConnection.cs (ParseDataSource): Adds tcp support in
449 connection string. Fixes bug # 80975.
451 * SqlCommand.cs (Dispose): On disposing the command object, don't
452 dispose connection and transaction.
454 2007-06-06 Nagappan A <anagappan@novell.com>
456 * SqlCommand.cs, SqlConnectionStringBuilder.cs, SqlConnection.cs:
457 Fixed 1.0 and 2.0 extras, errors as stated in class status page.
459 * SqlDataAdapter.cs, SqlParameter.cs:Fixed 1.0 and 2.0 extras,
460 errors as stated in class status page.
462 * SqlBulkCopyColumnMappingCollection.cs: Fixed 1.0 and 2.0 extras,
463 errors as stated in class status page.
465 2007-05-30 Nagappan A <anagappan@novell.com>
467 * SqlParameter.cs (SqlParameter): Updated constructor to use the
468 new TDS RPC implementation.
469 Fixed missing attributes.
470 (SetDbType): Added new case for sql_variant type.
471 (ConvertToFrameworkType): Implemented new private method to
472 convert the data type to framework type.
474 * SqlParameterCollection.cs: Fixed missing attributes and
475 implemented missing methods.
477 * SqlConnection.cs: Fixed missing attributes.
479 * SqlConnectionStringBuilder.cs: Certain attributes are missing or
480 its value or they are not appropriate. Fixed them.
482 * SqlDataReader.cs (GetData): Method is available only under 1.0
485 * SqlCommandBuilder.cs: Certain attributes are available only
486 under 2.0 profile, so moved them inside ifdef.
488 * SqlCommand.cs: Certain attributes are available only under 2.0
489 profile, so moved them inside ifdef.
491 * SqlBulkCopy.cs: Added new stubs.
493 * SqlBulkCopyColumnMappingCollection.cs: Added new stubs.
495 2007-05-29 Nagappan A <anagappan@novell.com>
497 * SqlCommand.cs (Dispose): Command.Dispose closing
498 connection. Fixes bug # 81710. Thanks to AMC <amc1999@gmail.com>
501 2007-05-10 Nagappan A <anagappan@novell.com>
503 * SqlClientMetaDataCollectionNames.cs: Fixed incorrect constructor
506 * SqlConnectionStringBuilder.cs: Fixed missing attributes.
508 2007-05-09 Igor Zelmanovich <igorz@mainsoft.com>
510 * SqlConnectionStringBuilder.cs: added MonoNotSupported attribute.
512 2007-04-03 Amit Biswas <amit@amitbiswas.com>
514 * SqlDataReader.cs (GetSqlBytes, GetProviderSpecificFieldType)
515 (GetProviderSpecificValue, GetProviderSpecificValues): Implemented
518 * SqlParameter.cs (XmlSchemaCollectionDatabase): Implemented missing property
519 (XmlSchemaCollectionName): Implemented missing property
520 (XmlSchemaCollectionOwningSchema): Implemented missing property
521 (SourceColumnNullMapping): Existing implementation was not correct, Replaced the implementation
522 (.ctor): Implemented mising constructor new in .net 2.0
524 * SqlErrorCollection.cs (CopyTo): Implemented missing API
526 * SqlParameter.cs (InferSqlType): Corrected bug related to default values of
528 (ResetSqlDbType): Implemented missing API
529 (ResetDbType): Implemented missing API
531 2007-03-09 Amit Biswas <amit@amitbiswas.com>
533 * SqlParameterCollection.cs (CopyTo): Implemented missing API
535 2007-04-02 Nagappan A <anagappan@novell.com>
537 * SqlParameter.cs: Variable name fix.
539 2007-03-20 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
541 * SqlClientFactory.cs: Added two using directives.
542 (CreateConnectionStringBuilder): Implemented the method.
543 (CreatePermission): Implemented the property.
545 * SqlCommand.cs: Added one using directive.
546 (Clone): Implemented the method.
547 (Dispose): Implemented the method.
548 (BeginExecuteXmlReader): Implemented the method.
550 * SqlCommandBuilder.cs (QuoteIdentifier): Implemented the method.
551 (UnquoteIdentifier): Implemented the method.
553 * SqlConnection.cs (ChangePassword): Implemented the method.
555 2007-03-19 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
557 * SqlClientFactory.cs (CanCreateDataSourceEnumerator): Implemented
560 * SqlCommand.cs (Notification): Implemented the property.
561 (NotificationAutoEnlist): Implemented the property.
563 * SqlDataReader.cs (VisibleFieldCount): Implemented the property.
565 * SqlConnectionStringBuilder.cs (TrustServerCertificate): Implemented
567 (TypeSystemVersion): Implemented the property.
568 (UserInstance): Implemented the property.
569 (ContextConnection): Implemented the property.
571 * SqlConnection.cs (FireInfoMessageEventOnUserErrors): Implemented
573 (StatisticsEnabled): Implemented the property.
575 * SqlDataAdapter.cs (UpdateBatchSize): Implemented the property.
577 * SqlParameter.cs: Implemented one attribute.
579 2007-03-16 Andreia Gaita <avidigal@novell.com>
581 * SqlParameter.cs: Move isVariableSizeType flag to TdsMetaParameter
582 so that the TdsMetaParameter can validate itself for valid size / values.
583 * SqlCommand.cs (Execute): Call Validate on TdsMetaParameter.
585 2007-03-14 Nagappan A <anagappan@novell.com>
587 * SqlCommand.cs (CommandType): Exception type thrown in 2.0
588 profile is different than 1.0, ArgumentOutOfRangeException.
589 (Connection): Exception type thrown in 2.0 profile is different
590 than 1.0, ArgumentOutOfRangeException.
591 (Execute): If Size property is 0 for String and Binary type, then
592 throw InvalidOperationException.
593 (ValidateCommand): Exception type thrown in 2.0 profile is
594 different than 1.0, NullReferenceException.
596 2007-03-09 Nagappan A <anagappan@novell.com>
598 * SqlDataReader.cs: Fixed syntax erros reported in class status
601 2007-03-09 Andreia Gaita <avidigal@novell.com>
603 * SqlCommand.cs (ExecuteScalar): Fix returned value for
604 stored procedure calls to return the first column of the
605 first row produced by the proc.
607 2007-03-08 Nagappan A <anagappan@novell.com>
609 * SqlCommand.cs (CloseDataReader): Checks whether the SQL
610 connection is created or not.
612 2007-03-07 Andreia Gaita <avidigal@novell.com>
614 * SqlCommand.cs (ExecuteScalar): when calling stored procedures,
615 implement support for return of output values in the parameter
618 2007-02-16 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
620 * SqlParameter.cs (CompareInfo): Implemented the property
622 (LocaleId): Written the property LocaleId.
623 (SqlValue): Written the propert SqlValue.
625 2007-02-15 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
627 * SqlCommand.cs: Added some attributes which were not implemented
628 for .NET 2.0 and removed extra attribute which are not there in
631 * SqlCommandBuilder.cs: Added some attributes that were not
632 implemented for .NET 2.0.
634 * SqlParameterCollection.cs: Added some attributes that were
635 not implemented for .NET 2.0.
637 * SqlConnectionStringBuilder.cs: Added some attributes that
638 were not implemented for .NET 2.0.
640 * SqlConnection.cs: Added attribute that was not implemented
643 * SqlParameter.cs: Added some attributes which were not
644 implemented for .NET 2.0 and removed some extra attributes which
645 are not there in .NET 2.0
647 2007-02-09 Nagappan A <anagappan@novell.com>
649 * SqlConnection.cs (SetConnectionString): Fixes bug # 80712. A
652 2007-01-08 Nagappan A <anagappan@novell.com>
654 * SqlTransaction.cs (Dispose): Fixed compliation warning.
656 * SqlDataReader.cs (GetValues): Length of elements to be copied was
657 decided based on the argument array passed, which caused a bug, if
658 the length of given array is more than actual column values.
660 * SqlCommandBuilder.cs (CatalogSeparator, SchemaSeparator)
661 (CatalogLocation): Implemented missing properties.
662 (CreateDeleteCommand, CreateInsertCommand, CreateUpdateCommand):
663 Modified private methods to take bool flag. If true, add actual
664 parameter name instead of p1, p2 etc.
665 (CreateParameter): Added overloaded private method to create
666 parameter with the actual column name.
667 (GetUpdateCommand, GetDeleteCommand, GetInsertCommand):
668 Implemented missing overloaded methods.
669 (SetRowUpdatingHandler): Implemented missing protected method.
671 * SqlCommand.cs: Fixed compilation warning. Removed bogus
674 2006-12-05 Nagappan A <anagappan@novell.com>
676 * SqlCommand.cs (Execute): If sql2 length is greater than 0, then
677 add ';' and the respective sql2 string and then execute the
678 string. Fixes bug # 79880.
680 2006-08-30 Nagappan A <anagappan@novell.com>
682 * SqlConnection.cs: Implemented SqlConnection.GetSchema ().
684 2006-09-08 Konstantin Triger <kostat@mainsoft.com>
686 * SqlClientFactory.cs: implemented SqlClientFactory.CreateConnection ().
688 2006-07-13 Senganal T <tsenganal@novell.com>
690 * SqlClientFactory.cs SqlCommand.cs SqlConnectionFactory.cs
691 SqlClientPermission.cs SqlParameterCollection.cs SqlDataReader.cs
692 SqlConnection.cs SqlParameter.cs SqlTransaction.cs :
695 2006-05-31 Gert Driesen <drieseng@users.sourceforge.net>
697 * SqlConnection.cs: Removed extra destructor, as destructor on
698 System.ComponentModel.Component already calls Dispose.
699 * SqlParameter.cs: Removed explicit interface implementation of
700 IDataParameter.ParameterName.
702 2006-05-26 Senganal T <tsenganal@novell.com>
705 - InferSqlType : if value is null or DBNull.Value, retain the
706 current parameter type.
708 2006-04-18 Senganal T <tsenganal@novell.com>
711 - SetConnectionString : set the pareameter to default values
712 if connection string is empty or null
713 - Open : Raise InvalidOperationException if Connection String
715 - Dispose : Test exception not raised if dispose called on a
716 connection with empty connection string
718 slight modification of the patch by Jonel Rienton
720 2006-04-07 Senganal T <tsenganal@novell.com>
722 * SqlCommandBuilder.cs :
723 * CreateDeleteCommand ()
724 * CreateUpdateCommand ()
725 * CreateInsertCommand ()
726 - Changed the signature. Do not need DataRow parameter
727 as the Query generated is parametric.
728 - Correct the null-check term in the WhereClause, set the
729 correct properties for null-check parameter
731 - Modified the generated query to match the query as
732 generated by 2.0. We now ignore null-check in the
733 whereclause if the Column does not allow nulls.
734 * ctor () : Set QuotePrefix and QuoteSuffix for 2.0 profile
735 * GetUpdateCommand ()
736 * GetInsertCommand ()
737 * GetDeleteCommand ()
738 - Do not create new command everytime. Create only if
740 * RefreshSchema : Reset the commands.
742 2006-02-17 Chris Toshok <toshok@ximian.com>
744 * SqlCommand.cs, SqlCommandBuilder.cs, SqlConnection.cs,
745 SqlDataAdapter.cs: remove DataSysDescription attributes for >= 2.0
747 2006-02-17 Chris Toshok <toshok@ximian.com>
749 * SqlDataReader.cs: remove VisibleFieldCount property.
751 2006-02-10 Senganal T <tsenganal@novell.com>
753 - GetBytes : Read binary/blob/clob data sequentially when
754 CommandBehavior is set to SequentialAcccess
755 - GetChars : Read String/clob data sequentially when CommandBehavior
756 is set to SequentialAccess
758 - ExecuteReader : set SequentialAccess property on TDS
759 - CloseDataReader : Reset the command behavior
761 2006-01-27 Senganal T <tsenganal@novell.com>
763 * SqlCommandBuilder.cs :
764 - Modified CreateUpdateCommand,CreateDeleteCommand , to not include
765 column name in the query if its a expression col.
766 Also, modified the queries to match the generated queries in ms.net
768 - Modifed Prepare, to check if Parameter is explicitly initialized
770 - Added CheckIfInitialized : Checks if datatype is explicitly set and
771 non-zero size is set for variable datatypes.
773 - Added code for GetSqlBinary ()
774 - Fixed GetFieldCount ()
775 - Added more checks and exceptions.
777 2006-01-17 Senganal T <tsenganal@novell.com>
779 * SqlCommandBuilder.cs
780 - Modified CreateNewCommand () : Clean up any existing parameter list
781 before reusing the command.Fixes #77225
783 2005-11-24 Senganal T <tsenganal@novell.com>
786 - Modifications to get the correct Packet Size
788 2005-11-21 Senganal T <tsenganal@novell.com>
790 * SqlClientFactory.cs
791 * SqlCommandBuilder.cs
792 * SqlParameterCollection.cs
798 Added stubs and other changes for ADO.NET 2.0 compatibility
800 2005-11-12 Gonzalo Paniagua Javier <gonzalo@ximian.com>
802 * SqlConnection.cs: don't throw NotImplementedException when using
803 'PERSIST SECUTIRY INFO'. Just do nothing.
805 2005-10-27 Senganal T <tsenganal@novell.com>
810 Made changes so that the number of rows affected can be got directly from
811 Tds regardsless of the type of query.Fixes bug #75698
813 2005-10-19 Senganal T <tsenganal@novell.com>
815 * SqlConnection.cs (SetProperties) :
816 - Added support for AttachDBFileName
818 2005-10-19 Senganal T <tsenganal@novell.com>
820 * SqlException.cs (Constructor)
821 - Modified the constructor, so that the message parameter
822 of base class is not the same as that of the Exception message.
825 2005-09-24 Sureshkumar T <tsureshkumar@novell.com>
827 * SqlParameterCollection.cs (AddWithValue): added method. patch
828 from awaddell@fnfr.com (Andy Waddell).
830 2005-09-21 Senganal T <tsenganal@novell.com>
834 - Set the correct Default Values for Parameters.
835 - Added Argument Checks (where missing) for the Properties and
836 throw the correct exception on error.
837 - Modified SetDefaultParameters() to make sure that the parameters
838 are all reset to default values everytime it is called.
839 - Modified SetProperties() to take into account the order of the
840 keywords in the ConnectionString.
842 SqlConnection Fixes for the failing sqlserver connected-mode testcases
843 in ProviderTest/System.Data.SqlClient/SqlConnectionTest.cs
845 2005-09-21 Senganal T <tsenganal@novell.com>
847 * SqlTransaction.cs : Modifed the Rollback() method, so that
848 connection can be used for another transaction after the previous
849 transaction is rolled back. fixes bug 75904
851 2005-09-02 Umadevi S <sumadevi@novell.com>
853 * Removed SqlResultSet.cs file
855 2005-08-26 Sureshkumar T <tsureshkumar@novell.com>
857 * SqlConnection.cs (Open): enable sp_reset_connection.
859 2005-08-25 Sureshkumar T <tsureshkumar@novell.com>
861 * SqlCommandBuilder.cs: BuildInformation (): continue on columns
862 who don't have basetablename.
864 2005-08-12 Daniel Morgan <danielmorgan@verizon.net>
866 * SqlCommandBuilder.cs: update command builder based on
867 OdbcCommandBuilder latest changes to fix regression
870 2005-08-05 Sureshkumar T <tsureshkumar@novell.com>
872 * SqlCommandBuilder.cs: Set SourceVersion property to the created
873 parameters as it is used by the Adapter's Update method.
875 2005-07-22 Sureshkumar T <tsureshkumar@novell.com>
877 * SqlCommandBuilder.cs, SqlParameterCollection.cs,
878 SqlConnection.cs, SqlParameter.cs:
879 - updated attributes & attribute descriptions to match with
882 2005-07-16 Daniel Morgan <danielmorgan@verizon.net>
884 * SqlCommandBuilder.cs: CreateUpdateCommand should get the current value, not
885 the orginal value when setting one of the SET variables
887 2005-07-15 Sureshkumar T <tsureshkumar@novell.com>
889 * SqlCommandBuilder.cs:
890 - set_DataAdapter: unsubscribe event if DataAdapter is reset.
891 - CreateInsertCommand, CreateUpdateCommand, CreateDeleteCommand:
892 if column mapping is missing, use the source column name. use
893 proper version to get the data.
894 - RowUpdatingHandler: set status to continue to actually process
897 2005-07-04 Ben Maurer <bmaurer@ximian.com>
899 * SqlError.cs: Patch from dezelin@gmail.com to fix serialization.
901 2005-06-29 Sureshkumar T <tsureshkumar@novell.com>
903 * SqlConnection.cs: Open (): catch TdsInternalException and throw
905 * SqlException.cs: code re-organised to pass message as well with
908 2005-06-23 Sureshkumar T <tsureshkumar@novell.com>
910 * SqlConnectionStringBuilder.cs: simplified multiple keyword
911 mappings and allowed-key checking. fixed Item, Remove,
912 ContainsKey, ShoudSerialize, TryGetValue implementations.
914 2005-06-21 Sureshkumar T <tsureshkumar@novell.com>
916 * SqlConnectionStringBuilder.cs: Connection String Builder class
917 for SqlClient Data Provider.
919 2005-06-01 Gonzalo Paniagua Javier <gonzalo@ximian.com>
921 * SqlParameter.cs: moved the 'using S.D.SqlTypes' out of NET_2_0. Fixes
924 2005-06-01 Sureshkumar T <tsureshkumar@novell.com>
926 * SqlParameter.cs: Parameter's value can be SqlTypes. Convert to
927 framework type to pass to TDS layer. Fixes bug #75044.
929 2005-05-24 Umadevi S <sumadevi@novell.com>
930 * fixed some 2.0 and 1.0 specific fields/attributes for various classes.
931 * Added SqlClientMetaDataCollectionNames.cs, Implemented some 2.0
932 properties for SqlParameterCollection for the bulkcopy feature.
935 2005-05-20 Kornél Pál <http://www.kornelpal.hu/>
937 * Fixed Bug #53169 - SqlDataReader incorrectly returns bigint as decimal
938 Note: The fix works around the limitations of TDS 7.0 to avoid this
939 difference between Mono and .NET Framework TDS 8.0 should be used instead.
941 2005-05-20 Umadevi S <sumadevi@novell.com>
943 * Fixed Bug 74948 - SqlParameter also takes DBNull Value.
944 Correct some attributes stuff of 1.1 and 2.0 for SqlParameter.cs
946 2005-05-20 Umadevi S <sumadevi@novell.com>
948 * Continuing on implementation for bulkcopy and notification
949 Added files SqlNotificationEventArgs.cs, OnChangeEventHandler.cs
950 Modified SqlRowUpdatingEventArgs.cs
952 2005-05-19 Umadevi S <sumadevi@novell.com>
954 * For implementation of bulkcopy and notifications added files
955 SqlBulkCopyOptions.cs,SqlBulkCopyColumnMapping.cs,SqlNotificationAuthType.cs
956 SqlNotificationTransports.cs,SqlRowsCopiedEventArgs.cs, SqlRowsCopiedEventHandler.cs
958 2005-05-19 Umadevi S <sumadevi@novell.com>
960 * Corrected types,enum values of SqlNotificationType,SqlNotificationSource,
961 SqlNotificationInfo and added new method in SqlRowUpdatingEventArgs.cs
962 (For implementation of bulkcopy/notifications)
964 2005-04-19 Sureshkumar T <tsureshkumar@novell.com>
966 * SqlDataReader.cs: NextResult (): Re-create schema table for each
967 result set. don't re-use, as it may be referenced from somewhere.
969 2005-04-07 Sureshkumar T <tsureshkumar@novell.com>
970 Ankit Jain <radical@corewars.org>
972 * SqlConnection.cs: Implemented additional connection string
973 property "Asynchronous Processing".
975 * SqlCommand.cs: Implemented Asynchronous command execution API.
977 * SqlAsyncState.cs: A internal state object for asynchronous
980 * SqlAsyncResult.cs: Added. Class to hold result for asynchronous
983 2005-03-28 Sureshkumar T <tsureshkumar@novell.com>
985 * SqlCommand.cs: Execute: Add a semicolon at the end of
986 CommandText. Multiple semicolon's are not being complained.
990 2005-03-11 Gonzalo Paniagua Javier <gonzalo@ximian.com>
992 * SqlConnection.cs: added a finalizer for correct implementation of the
995 2005-03-11 Gonzalo Paniagua Javier <gonzalo@ximian.com>
997 * SqlException.cs: make it serialization-compatible with MS. Patch by
998 Aleksandar Dezelin. Closes bug #73596.
1000 2005-03-08 Sureshkumar T <tsureshkumar@novell.com>
1002 * SqlDataReader.cs: Call base constructor with CommandBehavior
1003 parameter instead of passing DbCommand object. The internal base
1004 class with DbCommand Parameter is removed.
1006 2005-03-07 Sureshkumar T <tsureshkumar@novell.com>
1008 * SqlCommand.cs : Set CommandBehavior on
1009 ExecuteReader,ExecuteScalar,ExecuteNonQuery. This is used in
1012 This fixes bug #73252.
1014 2005-03-03 Sureshkumar T <tsureshkumar@novell.com>
1016 * SqlClientFactory.cs: While creating command, create using
1017 DbConnectionFactory as DbConnectionBase.CreateDbCommand needs to
1018 have a connection factory.
1020 * SqlConnection.cs: Added an internal constructor which takes
1021 DbConnectionFactory.
1023 * SqlConnectionFactory.cs: Added. Concrete class for abstract
1024 factory DbConnectionFactory.
1026 2005-02-22 Sureshkumar T <tsureshkumar@novell.com>
1028 * SqlDataReader.cs: GetBytes: return the length of the data if
1029 output buffer is null. if not, copy the values to buffer and
1030 return the bytes actually read.
1032 2005-02-02 Sureshkumar T <tsureshkumar@novell.com>
1035 - Database: return db name from database if connection open,
1036 otherwise take from connection string.
1037 - Set default values for parameters in the constructor itself.
1038 - Dangling else problem with Close method.
1039 - reset values of parms (TdsConnectionParameters) rather setting
1041 - set disposed to false in Open method
1042 - finally call base.Dispose in Dispose (bool)
1044 Fixes nunit regressions SqlConnectionTest:DefaultConnectionValues
1045 and SqlConnectionTest:DatabaseSynonyms.
1047 2005-01-27 Sureshkumar T <tsureshkumar@novell.com>
1049 * SqlCommand.cs (DeriveParameters): Change parameter name to
1051 * SqlParameter.cs (SqlParameter (object [])) : call default
1052 constructor to create Tds.Metaparameter.
1056 2005-01-03 Sureshkumar T <tsureshkumar@novell.com>
1058 * SqlCommand.cs: Fixed bug #68973. Reset Tds.RecordsAffected to 0
1059 for each execute statement.
1061 2004-11-25 Sureshkumar T <tsureshkumar@novell.com>
1063 These changes are for 2.0 profile only. These changes implement
1064 the generic data base access technique using Provider Factory
1065 Implementation. These classes need to be dervided from abstract
1066 base classes so that the corresponding factory classes are
1067 created when calling CreateCommand, CreateParameter, etc.
1069 * SqlClientFactory.cs: Provider Factory class Implementaion for SqlServer
1070 * SqlParameter.cs: Change base classes and override methods.
1071 * SqlParameterCollection.cs: Change base classes and override methods.
1072 * SqlTransaction.cs: Change base classes and override methods.
1073 * SqlDataSourceEnumerator.cs: DataSource Enumerator stubs.
1074 * SqlDataReader.cs: Change base classes and override methods.
1075 * SqlConnection.cs: Change base classes and override methods.
1076 * SqlCommandBuilder.cs: Change base classes and override methods.
1077 * SqlCommand.cs: Change base classes and override necessary methods.
1079 2004-10-14 Umadevi S <sumadevi@novell.com>
1080 * SqlCommand.cs - Implemented the clone method correctly.
1083 2004-10-06 Umadevi S <sumadevi@novell.com>
1084 * ISqlNoticationReceiver.cs - changed namespace
1085 * Added files SqlNotificationType.cs, SqlNotificationInfo.cs, SqlNotificationSource.cs
1087 2004-09-24 Umadevi S <sumadevi@novell.com>
1088 * SqlTransaction.cs - Dispose will not call rollback incase the transaction is not open.
1090 2004-09-14 Sebastien Pouliot <sebastien@ximian.com>
1092 * SqlClientPermission.cs: Added internal constructor accepting an Sql
1093 ClientPermissionAttribute parameter (using base class protected ctor).
1094 * SqlClientPermissionAttribute.cs: Copy now use the new SqlClient
1095 Permission constructor.
1097 2004-09-13 Sebastien Pouliot <sebastien@ximian.com>
1099 * SqlClientPermission.cs: Mostly completed (needs tests).
1100 * SqlClientPermissionAttribute.cs: Completed.
1102 2004-09-02 Umadevi S <sumadevi@novell.com>
1103 * SqlCommand.cs - ExecuteNonQuery to return -1 incase of executing a storedprocedure
1105 2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
1107 * SqlConnection.cs: added TODO on ConnectionString for keywords
1108 that are not yet implemented. check value of Integrated Security
1109 keyword, check value of bool keywords, improve error reporting
1110 for int keywords, added support for the following keyword
1111 synonyms : APP, TIMEOUT, NETWORK, PERSISTSECURITYINFO, WSID,
1112 LANGUAGE, USER. Throw NotImplementedException when encrypt keyword
1113 is set to true, enlist keyword is set to false or attachdbfilename
1114 keyword (or one of its synonyms) is set. Added FIXME for PERSIST
1115 SECURITY INFO keyword, throwing a NotImplementedException here
1116 would break lots of apps
1118 2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
1120 * SqlConnection.cs - spaces to tabs
1122 2004-08-12 Sureshkumar T <tsureshkumar@novell.com>
1123 * SqlDataReader.cs - In Close method, the remaining resultsets are drained
1124 out, to read output parameters & to avoid stream overlap
1126 2004-06-30 Umadevi S <sumadevi@novell.com>
1127 * SqlCommand.cs : In the Execute Method the commandbehavior parameters were ignored correct
1130 2004-06-22 Atsushi Enomoto <atsushi@ximian.com>
1132 * SqlCommandBuilder.cs : Avoid cast exception caused by DbNull.
1134 2004-06-18 Umadevi S <sumadevi@novell.com>
1135 * SqlCommand.cs - ExecuteNonQuery returns -1 in all cases except
1136 insert,update or delete.
1138 2004-06-18 Umadevi S <sumadevi@novell.com>
1139 * SqlConnection.cs - handled null being passed as a connectionstring
1140 - checked for minimal set of parameters in connectionstring.
1141 - handled unrecogonized keywords similar to MS.NET
1143 2004-06-17 Umadevi S <sumadevi@novell.com>
1144 * SqlTransaction.cs - fixed multiple rollbacks being called causes invalidoperationexception
1146 2004-06-04 Gert Driesen <drieseng@users.sourceforge.net>
1148 * SqlClientPermission.cs: removed extra CreateInstance
1151 2004-06-02 Gert Driesen <drieseng@users.sourceforge.net>
1153 * SQLDebugging.cs: added missing attributes, marked ctor
1154 public to match MS.NET
1156 2004-05-22 Atsushi Enomoto <atsushi@ximian.com>
1158 * SqlClientPermission.cs : don't use chained obsolete .ctor.
1160 2004-05-20 Gert Driesen (drieseng@users.sourceforge.net)
1162 * SqlClientPermissionAttribute.cs: change AllowMultiple and
1163 Inherited to match .NET
1165 2004-05-20 Umadevi S <sumadevi@novell.com>
1167 * Fixed bug 58406- implemented the hasrow method, test program used
1168 to test with the bug report
1170 2004-05-13 Umadevi S <sumadevi@novell.com>
1172 * SqlClientPermission.cs, SqlDataReader.cs - added missing methods with TODO tags
1173 * SqlCommand.cs, SqlDataAdapter.cs - implemented ToolboxItemAttribute
1174 * SQLDebugging.cs - Added new file with a TODO tag
1176 2004-04-05 Lluis Sanchez Gual <lluis@ximian.com>
1178 * SqlConnection.cs: Use connection pool implemented in Mono.Data.Tds.
1180 2004-04-01 Lluis Sanchez Gual <lluis@ximian.com>
1182 * SqlDataReader.cs: Null values are now represented with DBNull instances.
1185 2004-03-14 Tim Coleman <tim@timcoleman.com>
1186 * SqlCommand.cs SqlConnection.cs:
1187 Changes from two patches by Andres Taylor
1188 <andres@rotselleri.com>
1190 2004-03-12 Andreas Nahr <ClassDevelopment@A-SoftTech.com>
1192 * SqlParameter.cs: DO NOT USE the consts scheme if types can be referenced directly!
1194 2004-01-10 Atsushi Enomoto <atsushi@ximian.com>
1196 * SqlClientPermission.cs : Fixed NET_2_0 build related to
1197 obsolete attribute problem (see DbDataPermission.cs)
1199 2003-12-28 Tim Coleman <tim@timcoleman.com>
1201 Stubbed out this class.
1203 2003-12-23 Tim Coleman <tim@timcoleman.com>
1205 Improved connection string parsing. See
1206 System.Data.Common.DbConnectionString for source.
1208 2003-12-21 Tim Coleman <tim@timcoleman.com>
1210 Enable Integrated Security
1212 2003-12-19 Tim Coleman <tim@timcoleman.com>
1213 * ISqlNotificationReceiver.cs SqlResultSet.cs:
1215 * SqlClientPermission.cs:
1216 Fix constructor for 1.2
1218 2003-12-04 John Luke <jluke@cfl.rr.com>
1220 * SqlXmlTextReader.cs: applied patch from Chris Masters <neeeeeep@bigpond.com>
1221 fix peek so it checks if it is at the end and also to make sure that if Read()
1222 advances the position past the end of the localBuffer array, it makes
1223 a call to GetNextBuffer(). fixes bug #40253 System.IndexOutOfRangeException when
1224 using SqlCommand.ExecuteXmlReader()
1226 2003-11-20 Joerg Rosenkranz <JoergR@voelcker.com>
1228 * SqlConnection (SetDefaultConnectionParameters):
1229 Changed default value of WORKSTATION ID to reflect real
1230 host name instead of "localhost".
1232 2003-11-16 Ben Maurer <bmaurer@users.sourceforge.net>
1234 * SqlParameterCollection.cs (Clear): Clear needs to take
1235 the parameter out of the collection so that it can be used
1240 2003-10-03 Diego Caravana <diego@toth.it>
1242 * SqlCommand.cs: no change.
1244 * SqlConnection.cs (Close): Added checks for null instance
1247 * SqlParameter.cs (Direction): Now handles parameters of type
1248 ReturnValue and InputOutput.
1250 * SqlParameterCollection.cs (IndexOf(string)): Search for
1251 SqlParameter object in list is done by obtaining ParameterName
1252 attribute, not directly through list.IndexOf().
1254 2003-08-22 Duncan Mak <duncan@ximian.com>
1256 * SqlCommand.cs (ExecuteNonQuery): Return
1257 Connection.Tds.RecordsAffected if it is successful. Patch from
1258 Jörg Rosenkranz <joergr@voelcker.com>.
1260 This is part of a fix to bug #40315.
1262 2003-08-20 Duncan Mak <duncan@ximian.com>
1264 * SqlConnectionPool.cs (ReleaseConnection): A patch from Joerg
1265 Rosenkranz <JoergR@voelcker.com>. Currently, if a connection is
1266 closed by an external event (network problem, etc.) it is pushed
1267 back into the connection pool. The next Open call retrieves this
1268 invalid connection which leads to exceptions when executing
1271 This patch fixes this problem. This closes bug #47429.
1273 2003-07-04 Miguel de Icaza <miguel@ximian.com>
1275 * SqlDataReader.cs: Added extra information to the exceptions
1276 thrown by all the GetXXXX methods.
1278 2003-03-15 Daniel Morgan <danmorg@sc.rr.com>
1280 * SqlConnection.cs: if Server in the ConnectionString
1281 is set to "(local", use "localhost" as the hostname
1284 2003-03-04 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1286 * SqlException.cs: implemented GetObjectData ().
1288 2003-02-16 Daniel Morgan <danmorg@sc.rr.com>
1290 * ChangeLog: added this file
1292 * SqlConnection.cs: - parse data source for 3 possible uses:
1294 "Server=hostname\\instancename",
1295 "Server=hostname,port" and open the connection based on the
1296 resulting server name and port.
1297 - Added support for named instances
1298 by discovery of the sql server tcp port via the sql monitor (udp port 1434)
1299 thanks to Phillip Jerkins (Phillip.Jerkins@morgankeegan.com) contribution.
1300 Also, thanks to Gonzalo and Tim for their help with timeouts.