1 2008-09-20 Veerapuram Varadhan <vvaradhan@novell.com>
3 * SqlCommand.cs (DeriveParameters): Handle no square brackets
4 case in schema/procedure names.
6 2008-09-17 Veerapuram Varadhan <vvaradhan@novell.com>
8 * SqlCommand.cs (DeriveParameters): Escape/trim both
9 schema/procedure names before passing as parameter values.
11 2008-09-13 Atsushi Enomoto <atsushi@ximian.com>
13 * SqlDependency.cs : wrong namespace.
15 2008-08-14 Gert Driesen <drieseng@users.sourceforge.net>
17 * SqlConnection.cs: Use constants for min/max values. When value is
18 zero-length string, then fallback to default value for boolean and
19 integer backed properties. Throw ArgumentException when min pool size
20 exceeds max pool size. Check whether value for 'MARS' is a bool.
21 The 'user instance' property is 2.0 only.
23 2008-08-14 Gert Driesen <drieseng@users.sourceforge.net>
25 * SqlConnection.cs: Convert keywords to lowercase instead of uppercase
26 to avoid further case changes in exception messages.
28 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
30 * SqlCommand.cs (ExecuteReader): When behavior includes SingleRow,
31 then only return a single result. Fixes bug #412569.
33 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
35 * SqlCommand.cs: Fixed order of arguments for ArgumentException in
37 * SqlConnection.cs (ChangePassword): Do not allow empty connection
38 string. Updated exception messages.
40 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
42 * SqlCommand.cs: Fixed param name in ArgumentException for negative
43 CommandTimeout to match MS. On 2.0 profile, throw NRE in Prepare
44 when connection is NULL. In Prepare, return immediately after
45 connection check (2.0 only) for stored procedures, or when no
46 parameters are added. Added check to see if transaction is
47 associated with same connection as the command and updated
50 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
52 * SqlCommand.cs: Added bool argument to ValidateCommand to specify
53 whether an async method is being executed. Minor changes to exception
56 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
58 * SqlCommand.cs: Avoid NRE in CloseDataReader when connection is NULL.
59 Fixes bug #412584. Removed unused moreResults eargument from
60 CloseDataReader. Removed behavior argument from Execute, and have it
61 use the behavior field instead. In ValidateCommand, throw
62 InvalidOperationException instead of NRE when Connection is NULL.
63 * SqlDataReader.cs: Sync with SqlCommand's CloseDataReader signature
66 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
68 * SqlCommand.cs: (Transaction): On the 1.0 profile, do not allow
69 Transaction to be set when a reader is open for the current connection.
72 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
74 * SqlCommand.cs (Connection): Do not throw InvalidOperationException
75 if transaction is in progress. Fixes bug #412576. On 1.0 profile, throw
76 InvalidOperationException when a reader is open for the current
77 connection. Do not set transaction to NULL when changing connection,
78 instead set it to null in Transaction when transaction is no longer
81 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
83 * SqlConnection.cs: Use null as default value for connectionString
84 field. Remove Init method, as initialization is done in
85 SetDefaultConnectionParameters. Initialize parms in
86 SetDefaultConnectionParameters to avoid calling Reset on newly
87 initialized collection. In Dispose (bool), also invoke base.Dispose if
88 SqlConnection was already disposed. Fixes bug #412571.
90 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
92 * SqlConnection.cs (ChangeState): Return immediately when new state
93 equals original state. Fixes bug #412574. Removed extra whitespace.
95 2008-07-23 Veerapuram Varadhan <vvaradhan@novell.com>
97 * SqlDataReader.cs (NextResult): Memleak fix - mark datatypeNames
98 array to be GCed along with schemaTable.
100 2008-07-23 Veerapuram Varadhan <vvaradhan@novell.com>
102 * SqlDataReader.cs: Do not generate schemaTable unless otherwise
103 asked for; use command.Tds.Columns instead. Improves performance
106 2008-07-10 Veerapuram Varadhan <vvaradhan@novell.com>
109 * SqlCommand.cs (GetOutputParameters): Update parameter values iff
110 parameter direction is InputOutput or Output.
112 2008-07-06 Gert Driesen <drieseng@users.sourceforge.net>
114 * SqlException.cs: Modified HResult/ErrorCode to match MS. Removed
115 unused FromTdsInternalException overload. Removed unnecessary check
116 for Errors.Count. Minor code formatting.
118 2008-07-03 Rodrigo Kumpera <rkumpera@novell.com>
120 * SqlConnection.cs: Remove connStringParameters as nobody uses it.
122 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
124 * SqlDataReader.cs: Do all column accesses with int indexes.
126 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
128 * SqlDataReader.cs (GetSchemaTable): All column index are constants,
131 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
133 * SqlDataReader.cs (GetSchemaTable): Calculate column indexes
134 outside of the row loop.
136 2008-07-01 Marek Habersack <mhabersack@novell.com>
138 * SqlDataReader.cs: use named properties in TdsDataColumn for the
141 2008-06-30 Zoltan Varga <vargaz@gmail.com>
143 * SqlDataReader.cs: Allocate 'schemaTable' lazily.
144 (GetSchemaValue): Avoid some hash table lookups
146 2008-06-27 Zoltan Varga <vargaz@gmail.com>
148 * SqlDataReader.cs (ConstructSchemaTable): Avoid unneccessary reflection calls.
150 2008-06-23 Veerapuram Varadhan <vvaradhan@novell.com>
152 * SqlDependency.cs: New
154 2008-06-12 Veerapuram Varadhan <vvaradhan@novell.com>
156 Patch by Christian Hergert <christian.hergert@gmail.com>
157 * SqlConnection.cs (Open): Do not reset the connection as it is already
158 done in the TdsConnectionPool itself.
160 2008-06-12 Marek Habersack <mhabersack@novell.com>
162 * SqlParameterCollection.cs: this [int] must check the range and
163 throw an exception if necessary.
165 * SqlCommand.cs: throw IOEX when stored procedure is not found in
166 DeriveParameters. All procedures in MS SQL will report at least
167 one parameter - the return value.
169 2008-06-10 Veerapuram Varadhan <vvaradhan@novell.com>
171 * SqlConnection.cs: TdsConnectionPool.GetConnectionPool() now returns
172 IDictionary<TKey, TValue>.
174 2008-06-09 Ankit Jain <jankit@novell.com>
176 * SqlCommand.cs: Use Tds instead of ITds now.
177 * SqlConnection.cs: Likewise.
179 2008-05-27 Gert Driesen <drieseng@users.sourceforge.net>
181 * SqlConnection.cs: Added support for '.' as alias for localhost.
182 Improve exception message when TCP/IP protocol is not enabled.
184 2008-05-17 Gert Driesen <drieseng@users.sourceforge.net>
186 * SqlDataReader.cs (GetInt64): Removed workaround for TDS 7.0 handling
187 of bigint column type as this is handled in Mono.Data.Tds.
189 2008-05-14 Marek Habersack <mhabersack@novell.com>
191 * SqlConnection.cs: added support for USER INSTANCE keyword in the
194 2008-04-22 Veerapuram Varadhan <vvaradhan@novell.com>
197 * SqlCommand.cs: Handle exceptions sanely and do not close
198 connection on TdsTimeoutException.
200 2008-04-21 Gert Driesen <drieseng@users.sourceforge.net>
202 * SqlBulkCopyColumnMappingCollection.cs: Changed argument names to
203 match MS. Code formatting.
204 * SqlCommand.cs: Changed argument names to match MS. Code formatting.
205 Do not include explicit IDbCommand implementation on 2.0 profile.
206 * SqlCommandBuilder.cs: Changed argument names to match MS. Code
208 * SqlDataReader.cs: Changed argument names to match MS. Code
210 * SqlParameterCollection.cs: Do not include IList, ICollection and
211 IDataParameterCollection explicit interface implementation on 2.0
212 profile. Code formatting.
213 * SqlConnection.cs: Changed argument names to match MS.
214 * SqlDataAdapter.cs: Changed argument names to match MS.
215 * SqlTransaction.cs: Do not include explicit interface implementation
216 of IDbTransaction.Connection on 2.0 profile. Code formatting.
218 2008-04-19 Robert Jordan <robertj@gmx.net>
220 * SqlParameterCollection.cs (AddRange(SqlParameter[])):
221 Fix endless recursion.
223 2008-04-08 Marek Habersack <mhabersack@novell.com>
225 * SqlConnection.cs: TCP port discovery via UDP port 1434 should
226 honor the timeout specified in the connection string (or the
227 default one). In some environments 100 microseconds might not be
228 enough to discover the port.
230 2008-04-01 Marek Habersack <mhabersack@novell.com>
232 * SqlParameter.cs: ConvertToFrameworkType must handle empty
233 strings gracefully - a DBNull.Value must be returned in this
236 * SqlCommand.cs: DeriveParameters should split the stored
237 procedure name into the schema name and procedure name before
238 querying its parameters.
240 2008-03-03 Ankit Jain <jankit@novell.com>
242 * SqlClientMetaDataCollectionNames.cs: Set the field values.
244 2007-10-21 Gert Driesen <drieseng@users.sourceforge.net>
246 * SqlCommand.cs: Use ExceptionHelper.CheckEnumValue for enum checks.
248 2007-10-20 Gert Driesen <drieseng@users.sourceforge.net>
250 * SqlCommand.cs: Added constant for default CommandTimeout, instead
251 of using a magic number. Avoid unnecessary initialization. Fixed
252 default value for DesignTimeVisible. Return zero-length string if
253 CommandText is null. Use ExceptionHelper.InvalidEnumValueException
254 to avoid code duplication. Spaces to tabs and code formatting.
255 * SqlConnection.cs: Use different default package size on 2.0 profile.
256 Added constants for default values, instead of using magic numbers.
257 Avoid unnecessary initialization. In PacketSize, return default or
258 configured packet size when connection is not open. Use
259 ExceptionHelper.ConnectionClosed instead of local method. Removed
260 use of some hardcoded values in SetDefaultConnectionParameters, and
261 use Environment.MachineName as default WorkstationId instead of
262 DNS host name. Code formatting.
263 * SqlDataAdapter.cs: In default ctor, set SelectCommand to null.
264 Avoid unnecessary initializations. Use direct assignment in
265 IDbDataAdapter implementation. Fixed exception message for negative
266 UpdateBatchSize. In Dispose override, make sure to invoke base
269 2007-10-19 Gert Driesen <drieseng@users.sourceforge.net>
271 * SqlTransaction.cs: Clear connection in commit. In IsolationLevel,
272 throw IOE if transaction is no longer open.
274 2007-10-19 Gert Driesen <drieseng@users.sourceforge.net>
276 * SqlTransaction.cs: Avoid unnecessary initialization. Remove
277 isRolledBack since its essentially the same as isOpen. Use
278 ExceptionHelper.TransactionNotUsable instead of duplicating code.
279 On 2.0 profile, ignore call to Rollback when transaction was already
282 2007-10-18 Gert Driesen <drieseng@users.sourceforge.net>
284 * SqlConnection.cs: Avoid unnecessary initialization. Use string.Empty
285 for assigning zero-length string, and use String.Length to check for
286 zero-length string. Added support for IsolationLevel.Snapshot.
287 Added StructuredTypeMembers schema collection and restrictions. Fixed
288 table name for MetaDataCollections collection. Implemented
289 DataSourceInformation collection. Added missing data types (probably
290 introduced in 2.0 SP1). In GetSchema, throw InvalidOperationException
291 if connection is closed and throw NotImplementedException for
292 StructuredTypeMembers collection.
294 2007-10-18 Gert Driesen <drieseng@users.sourceforge.net>
296 * SqlConnection.cs: On 1.0 profile, IsolationLevel.Unspecified is
297 not valid. On 2.0 profile, when IsolationLevel.Unspecified is passed
298 make sure to also set SqlTransaction.IsolationLevel to
299 ReadCommitted. Modified exceptions to match MS.
301 2007-10-17 Nagappan <anagappan@novell.com>
303 * SqlParameter.cs (ConvertToFrameworkType): Added SqlDbType.Image.
305 2007-10-17 Nagappan <anagappan@novell.com>
307 * SqlConnection.cs: BeginTransaction does not handle
308 IsolationLevel.Unspecified, so the default is set as ReadCommited.
309 Thanks to Jerome Haltom <wasabi@larvalstage.net> for this patch. Fixes
311 * SqlTransaction.cs: If transaction count is greater then 0 then roll back.
312 Thanks to Jerome Haltom <wasabi@larvalstage.net> for this patch. Fixes
315 2007-10-15 Gert Driesen <drieseng@users.sourceforge.net>
317 * SqlException.cs: Do not hide Message on 2.0 profile. Fixes bug
320 2007-10-08 Marek Safar <marek.safar@gmail.com>
322 * SqlParameterCollection.cs (SetParameter): Fixed missing cast.
324 2007-09-27 Nagappan A <anagappan@novell.com>
326 * SqlConnection.cs: Added MonoTODO appropriately.
328 2007-09-26 Nagappan A <anagappan@novell.com>
330 * SqlCommandBuilder.cs: Code alignment.
332 2007-09-25 Nagappan A <anagappan@novell.com>
334 * SqlInitialCatalogConverter.cs, SqlDataSourceConverter.cs:
335 NetworkLibraryConverter.cs: Added new files.
337 * SqlParameter.cs: 2.0 attribute changes.
339 * SqlDataAdapter.cs: 2.0 attribute changes.
341 * SqlConnectionStringBuilder.cs: 2.0 attribute changes.
343 * SqlConnection.cs (ClearAllPools, ClearPool): Implemented 2.0
344 APIs, other 2.0 attribute changes.
346 * SqlCommandBuilder.cs (GetSchemaTable, InitializeCommand):
347 Implemented 2.0 APIs, other 2.0 attribute changes.
349 * SqlBulkCopyColumnMappingCollection.cs: Added constructor, 2.0
350 API compatibility changes.
352 * SqlException.cs: 2.0 attribute changes.
354 2007-08-13 Nagappan A <anagappan@novell.com>
356 * SqlConnection.cs (ConnectionString): 2.0 compatibility changes.
358 * SqlDataReader.cs (IsCommandBehavior): Fixed spelling mistake of
360 (Dispose): 2.0 compatibility changes.
362 * SqlBulkCopy.cs (SqlRowsCopied): Fixed spelling mistake of the
364 (RowsCopied): Generates event when NotifyAfter is set.
366 * SqlCommandBuilder.cs (Dispose, RefreshSchema): 2.0 compatibility
369 * SqlClientFactory.cs (CreateDataSourceEnumerator): Removed bogus
372 * SqlException.cs (Message): 2.0 compatibility changes.
374 2007-08-06 Nagappan A <anagappan@novell.com>
376 * SqlCommand.cs, SqlDataReader.cs, SqlConnection.cs: When the
377 server resets the connection, now the client code also disconnects
378 the session and remove the instance from pool. Fixes bug # 81933.
380 2007-07-31 Nagappan A <anagappan@novell.com>
382 * SqlCommand.cs (Transaction, Connection): IDbCommand Transaction
383 and Connection can be set to null. Fixes bug 82189.
385 2007-07-23 Nagappan A <anagappan@novell.com>
387 * SqlCommandBuilder.cs (ApplyParameterInfo, GetParameterName):
388 (GetParameterPlaceholder): Implemented 2.0 missing APIs.
390 2007-07-22 Nagappan A <anagappan@novell.com>
392 * SqlBulkCopy.cs (NotifyAfter): Implemented 2.0 property.
393 (GetColumnMetaData, GenerateColumnMetaData):
394 (ValidateColumnMapping): Implemented private method's to generate
395 and validate SqlBulkCopy headers.
396 (BulkCopyToServer): Private method to actually do the bulk copy
398 (WriteToServer): Implemented 2.0 missing overloaded methods.
399 (IDisposable.Dispose): Implemented 2.0 missing method.
401 * SqlBulkCopyColumnMappingCollection.cs (Add, CopyTo): Implemented
403 (Item): Implemented missing property.
405 * SqlBulkCopyColumnMapping.cs: Modified the implementation of
406 Constructors to use property.
408 * SqlDataReader.cs (GetSqlXml, IsCommandBehaviour): Added 2.0
410 (Connection): Added missing property.
412 * SqlParameter.cs (SetSqlDbType, ConvertToFrameworkType): Modified
413 method as internal from private.
415 * SqlConnection.cs: Fixed 2.0 missing feature.
417 * SqlException.cs: Fixed 2.0 missing feature.
419 * SqlClientPermission.cs: Fixed 2.0 missing feature.
421 2007-07-01 Gert Driesen <drieseng@users.sourceforge.net>
423 * ISqlNotificationReceiver.cs: Removed.
424 * SqlClientFactory.cs: Use SqlDataSourceEnumerator from S.D.Sql and
425 marked method todo. Avoid unnessary casts. Code formatting.
426 * SqlCommand.cs: Explicit interface implementation of IDbCommand not
427 necessary on 2.0 profile. Fixes API mismatches. Avoid unnecessary
428 casts. Code formatting.
429 * SqlConnection.cs: Also use RecommendAsConfigurable instead of
430 SettingBindableAttribute on 2.0. Use StateChange event from base class
431 on 2.0. Only explicitly implement IDbConnection methods on 1.0, since
432 these are implemented by base class on 2.0 profile. Removed extra
433 explicit implementation of IDisposable since the base class implements
434 this. Code formatting.
435 * SqlDataAdapter.cs: Dispose (bool) override not necessary on 2.0
436 profile. Stubbed ICloneable.Clone. Fixes API mismatches.
437 * SqlDataReader.cs: On 2.0, IDisposable.Dispose is implemented by
438 DbDataReader. Only 1.0 profile, explicitly implemented IEnumerable
439 GetEnumerator. Code formatting.
440 * SqlDataSourceEnumerator.cs: Removed.
441 * SQLDebugging.cs: Marked sealed on 2.0. Code formatting.
442 * SqlNotificationAuthType.cs: Removed.
443 * SqlNotificationInfo.cs: Added missing fields. Code formatting.
444 * SqlNotificationSource.cs: Added missing fields. Code formatting.
445 * SqlNotificationTransports.cs: Removed.
446 * SqlNotificationType.cs: Added missing Unknown field. Code formatting.
447 * SqlParameter.cs: Removed Browsable and EditorBrowsable attributes
448 from Precision and Scale. Fixes API mismatches. Code formatting fixes.
449 * SqlTransaction.cs: On 2.0 profile, Dispose method is exposed by
450 base class. Fixes API mismatches. Code formatting fixes.
452 2007-06-21 Nagappan A <anagappan@novell.com>
454 * SqlConnection.cs: Fixed compiler warning.
456 2007-06-11 Nagappan A <anagappan@novell.com>
458 * SqlConnection.cs (ParseDataSource): Adds tcp support in
459 connection string. Fixes bug # 80975.
461 * SqlCommand.cs (Dispose): On disposing the command object, don't
462 dispose connection and transaction.
464 2007-06-06 Nagappan A <anagappan@novell.com>
466 * SqlCommand.cs, SqlConnectionStringBuilder.cs, SqlConnection.cs:
467 Fixed 1.0 and 2.0 extras, errors as stated in class status page.
469 * SqlDataAdapter.cs, SqlParameter.cs:Fixed 1.0 and 2.0 extras,
470 errors as stated in class status page.
472 * SqlBulkCopyColumnMappingCollection.cs: Fixed 1.0 and 2.0 extras,
473 errors as stated in class status page.
475 2007-05-30 Nagappan A <anagappan@novell.com>
477 * SqlParameter.cs (SqlParameter): Updated constructor to use the
478 new TDS RPC implementation.
479 Fixed missing attributes.
480 (SetDbType): Added new case for sql_variant type.
481 (ConvertToFrameworkType): Implemented new private method to
482 convert the data type to framework type.
484 * SqlParameterCollection.cs: Fixed missing attributes and
485 implemented missing methods.
487 * SqlConnection.cs: Fixed missing attributes.
489 * SqlConnectionStringBuilder.cs: Certain attributes are missing or
490 its value or they are not appropriate. Fixed them.
492 * SqlDataReader.cs (GetData): Method is available only under 1.0
495 * SqlCommandBuilder.cs: Certain attributes are available only
496 under 2.0 profile, so moved them inside ifdef.
498 * SqlCommand.cs: Certain attributes are available only under 2.0
499 profile, so moved them inside ifdef.
501 * SqlBulkCopy.cs: Added new stubs.
503 * SqlBulkCopyColumnMappingCollection.cs: Added new stubs.
505 2007-05-29 Nagappan A <anagappan@novell.com>
507 * SqlCommand.cs (Dispose): Command.Dispose closing
508 connection. Fixes bug # 81710. Thanks to AMC <amc1999@gmail.com>
511 2007-05-10 Nagappan A <anagappan@novell.com>
513 * SqlClientMetaDataCollectionNames.cs: Fixed incorrect constructor
516 * SqlConnectionStringBuilder.cs: Fixed missing attributes.
518 2007-05-09 Igor Zelmanovich <igorz@mainsoft.com>
520 * SqlConnectionStringBuilder.cs: added MonoNotSupported attribute.
522 2007-04-03 Amit Biswas <amit@amitbiswas.com>
524 * SqlDataReader.cs (GetSqlBytes, GetProviderSpecificFieldType)
525 (GetProviderSpecificValue, GetProviderSpecificValues): Implemented
528 * SqlParameter.cs (XmlSchemaCollectionDatabase): Implemented missing property
529 (XmlSchemaCollectionName): Implemented missing property
530 (XmlSchemaCollectionOwningSchema): Implemented missing property
531 (SourceColumnNullMapping): Existing implementation was not correct, Replaced the implementation
532 (.ctor): Implemented mising constructor new in .net 2.0
534 * SqlErrorCollection.cs (CopyTo): Implemented missing API
536 * SqlParameter.cs (InferSqlType): Corrected bug related to default values of
538 (ResetSqlDbType): Implemented missing API
539 (ResetDbType): Implemented missing API
541 2007-03-09 Amit Biswas <amit@amitbiswas.com>
543 * SqlParameterCollection.cs (CopyTo): Implemented missing API
545 2007-04-02 Nagappan A <anagappan@novell.com>
547 * SqlParameter.cs: Variable name fix.
549 2007-03-20 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
551 * SqlClientFactory.cs: Added two using directives.
552 (CreateConnectionStringBuilder): Implemented the method.
553 (CreatePermission): Implemented the property.
555 * SqlCommand.cs: Added one using directive.
556 (Clone): Implemented the method.
557 (Dispose): Implemented the method.
558 (BeginExecuteXmlReader): Implemented the method.
560 * SqlCommandBuilder.cs (QuoteIdentifier): Implemented the method.
561 (UnquoteIdentifier): Implemented the method.
563 * SqlConnection.cs (ChangePassword): Implemented the method.
565 2007-03-19 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
567 * SqlClientFactory.cs (CanCreateDataSourceEnumerator): Implemented
570 * SqlCommand.cs (Notification): Implemented the property.
571 (NotificationAutoEnlist): Implemented the property.
573 * SqlDataReader.cs (VisibleFieldCount): Implemented the property.
575 * SqlConnectionStringBuilder.cs (TrustServerCertificate): Implemented
577 (TypeSystemVersion): Implemented the property.
578 (UserInstance): Implemented the property.
579 (ContextConnection): Implemented the property.
581 * SqlConnection.cs (FireInfoMessageEventOnUserErrors): Implemented
583 (StatisticsEnabled): Implemented the property.
585 * SqlDataAdapter.cs (UpdateBatchSize): Implemented the property.
587 * SqlParameter.cs: Implemented one attribute.
589 2007-03-16 Andreia Gaita <avidigal@novell.com>
591 * SqlParameter.cs: Move isVariableSizeType flag to TdsMetaParameter
592 so that the TdsMetaParameter can validate itself for valid size / values.
593 * SqlCommand.cs (Execute): Call Validate on TdsMetaParameter.
595 2007-03-14 Nagappan A <anagappan@novell.com>
597 * SqlCommand.cs (CommandType): Exception type thrown in 2.0
598 profile is different than 1.0, ArgumentOutOfRangeException.
599 (Connection): Exception type thrown in 2.0 profile is different
600 than 1.0, ArgumentOutOfRangeException.
601 (Execute): If Size property is 0 for String and Binary type, then
602 throw InvalidOperationException.
603 (ValidateCommand): Exception type thrown in 2.0 profile is
604 different than 1.0, NullReferenceException.
606 2007-03-09 Nagappan A <anagappan@novell.com>
608 * SqlDataReader.cs: Fixed syntax erros reported in class status
611 2007-03-09 Andreia Gaita <avidigal@novell.com>
613 * SqlCommand.cs (ExecuteScalar): Fix returned value for
614 stored procedure calls to return the first column of the
615 first row produced by the proc.
617 2007-03-08 Nagappan A <anagappan@novell.com>
619 * SqlCommand.cs (CloseDataReader): Checks whether the SQL
620 connection is created or not.
622 2007-03-07 Andreia Gaita <avidigal@novell.com>
624 * SqlCommand.cs (ExecuteScalar): when calling stored procedures,
625 implement support for return of output values in the parameter
628 2007-02-16 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
630 * SqlParameter.cs (CompareInfo): Implemented the property
632 (LocaleId): Written the property LocaleId.
633 (SqlValue): Written the propert SqlValue.
635 2007-02-15 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
637 * SqlCommand.cs: Added some attributes which were not implemented
638 for .NET 2.0 and removed extra attribute which are not there in
641 * SqlCommandBuilder.cs: Added some attributes that were not
642 implemented for .NET 2.0.
644 * SqlParameterCollection.cs: Added some attributes that were
645 not implemented for .NET 2.0.
647 * SqlConnectionStringBuilder.cs: Added some attributes that
648 were not implemented for .NET 2.0.
650 * SqlConnection.cs: Added attribute that was not implemented
653 * SqlParameter.cs: Added some attributes which were not
654 implemented for .NET 2.0 and removed some extra attributes which
655 are not there in .NET 2.0
657 2007-02-09 Nagappan A <anagappan@novell.com>
659 * SqlConnection.cs (SetConnectionString): Fixes bug # 80712. A
662 2007-01-08 Nagappan A <anagappan@novell.com>
664 * SqlTransaction.cs (Dispose): Fixed compliation warning.
666 * SqlDataReader.cs (GetValues): Length of elements to be copied was
667 decided based on the argument array passed, which caused a bug, if
668 the length of given array is more than actual column values.
670 * SqlCommandBuilder.cs (CatalogSeparator, SchemaSeparator)
671 (CatalogLocation): Implemented missing properties.
672 (CreateDeleteCommand, CreateInsertCommand, CreateUpdateCommand):
673 Modified private methods to take bool flag. If true, add actual
674 parameter name instead of p1, p2 etc.
675 (CreateParameter): Added overloaded private method to create
676 parameter with the actual column name.
677 (GetUpdateCommand, GetDeleteCommand, GetInsertCommand):
678 Implemented missing overloaded methods.
679 (SetRowUpdatingHandler): Implemented missing protected method.
681 * SqlCommand.cs: Fixed compilation warning. Removed bogus
684 2006-12-05 Nagappan A <anagappan@novell.com>
686 * SqlCommand.cs (Execute): If sql2 length is greater than 0, then
687 add ';' and the respective sql2 string and then execute the
688 string. Fixes bug # 79880.
690 2006-08-30 Nagappan A <anagappan@novell.com>
692 * SqlConnection.cs: Implemented SqlConnection.GetSchema ().
694 2006-09-08 Konstantin Triger <kostat@mainsoft.com>
696 * SqlClientFactory.cs: implemented SqlClientFactory.CreateConnection ().
698 2006-07-13 Senganal T <tsenganal@novell.com>
700 * SqlClientFactory.cs SqlCommand.cs SqlConnectionFactory.cs
701 SqlClientPermission.cs SqlParameterCollection.cs SqlDataReader.cs
702 SqlConnection.cs SqlParameter.cs SqlTransaction.cs :
705 2006-05-31 Gert Driesen <drieseng@users.sourceforge.net>
707 * SqlConnection.cs: Removed extra destructor, as destructor on
708 System.ComponentModel.Component already calls Dispose.
709 * SqlParameter.cs: Removed explicit interface implementation of
710 IDataParameter.ParameterName.
712 2006-05-26 Senganal T <tsenganal@novell.com>
715 - InferSqlType : if value is null or DBNull.Value, retain the
716 current parameter type.
718 2006-04-18 Senganal T <tsenganal@novell.com>
721 - SetConnectionString : set the pareameter to default values
722 if connection string is empty or null
723 - Open : Raise InvalidOperationException if Connection String
725 - Dispose : Test exception not raised if dispose called on a
726 connection with empty connection string
728 slight modification of the patch by Jonel Rienton
730 2006-04-07 Senganal T <tsenganal@novell.com>
732 * SqlCommandBuilder.cs :
733 * CreateDeleteCommand ()
734 * CreateUpdateCommand ()
735 * CreateInsertCommand ()
736 - Changed the signature. Do not need DataRow parameter
737 as the Query generated is parametric.
738 - Correct the null-check term in the WhereClause, set the
739 correct properties for null-check parameter
741 - Modified the generated query to match the query as
742 generated by 2.0. We now ignore null-check in the
743 whereclause if the Column does not allow nulls.
744 * ctor () : Set QuotePrefix and QuoteSuffix for 2.0 profile
745 * GetUpdateCommand ()
746 * GetInsertCommand ()
747 * GetDeleteCommand ()
748 - Do not create new command everytime. Create only if
750 * RefreshSchema : Reset the commands.
752 2006-02-17 Chris Toshok <toshok@ximian.com>
754 * SqlCommand.cs, SqlCommandBuilder.cs, SqlConnection.cs,
755 SqlDataAdapter.cs: remove DataSysDescription attributes for >= 2.0
757 2006-02-17 Chris Toshok <toshok@ximian.com>
759 * SqlDataReader.cs: remove VisibleFieldCount property.
761 2006-02-10 Senganal T <tsenganal@novell.com>
763 - GetBytes : Read binary/blob/clob data sequentially when
764 CommandBehavior is set to SequentialAcccess
765 - GetChars : Read String/clob data sequentially when CommandBehavior
766 is set to SequentialAccess
768 - ExecuteReader : set SequentialAccess property on TDS
769 - CloseDataReader : Reset the command behavior
771 2006-01-27 Senganal T <tsenganal@novell.com>
773 * SqlCommandBuilder.cs :
774 - Modified CreateUpdateCommand,CreateDeleteCommand , to not include
775 column name in the query if its a expression col.
776 Also, modified the queries to match the generated queries in ms.net
778 - Modifed Prepare, to check if Parameter is explicitly initialized
780 - Added CheckIfInitialized : Checks if datatype is explicitly set and
781 non-zero size is set for variable datatypes.
783 - Added code for GetSqlBinary ()
784 - Fixed GetFieldCount ()
785 - Added more checks and exceptions.
787 2006-01-17 Senganal T <tsenganal@novell.com>
789 * SqlCommandBuilder.cs
790 - Modified CreateNewCommand () : Clean up any existing parameter list
791 before reusing the command.Fixes #77225
793 2005-11-24 Senganal T <tsenganal@novell.com>
796 - Modifications to get the correct Packet Size
798 2005-11-21 Senganal T <tsenganal@novell.com>
800 * SqlClientFactory.cs
801 * SqlCommandBuilder.cs
802 * SqlParameterCollection.cs
808 Added stubs and other changes for ADO.NET 2.0 compatibility
810 2005-11-12 Gonzalo Paniagua Javier <gonzalo@ximian.com>
812 * SqlConnection.cs: don't throw NotImplementedException when using
813 'PERSIST SECUTIRY INFO'. Just do nothing.
815 2005-10-27 Senganal T <tsenganal@novell.com>
820 Made changes so that the number of rows affected can be got directly from
821 Tds regardsless of the type of query.Fixes bug #75698
823 2005-10-19 Senganal T <tsenganal@novell.com>
825 * SqlConnection.cs (SetProperties) :
826 - Added support for AttachDBFileName
828 2005-10-19 Senganal T <tsenganal@novell.com>
830 * SqlException.cs (Constructor)
831 - Modified the constructor, so that the message parameter
832 of base class is not the same as that of the Exception message.
835 2005-09-24 Sureshkumar T <tsureshkumar@novell.com>
837 * SqlParameterCollection.cs (AddWithValue): added method. patch
838 from awaddell@fnfr.com (Andy Waddell).
840 2005-09-21 Senganal T <tsenganal@novell.com>
844 - Set the correct Default Values for Parameters.
845 - Added Argument Checks (where missing) for the Properties and
846 throw the correct exception on error.
847 - Modified SetDefaultParameters() to make sure that the parameters
848 are all reset to default values everytime it is called.
849 - Modified SetProperties() to take into account the order of the
850 keywords in the ConnectionString.
852 SqlConnection Fixes for the failing sqlserver connected-mode testcases
853 in ProviderTest/System.Data.SqlClient/SqlConnectionTest.cs
855 2005-09-21 Senganal T <tsenganal@novell.com>
857 * SqlTransaction.cs : Modifed the Rollback() method, so that
858 connection can be used for another transaction after the previous
859 transaction is rolled back. fixes bug 75904
861 2005-09-02 Umadevi S <sumadevi@novell.com>
863 * Removed SqlResultSet.cs file
865 2005-08-26 Sureshkumar T <tsureshkumar@novell.com>
867 * SqlConnection.cs (Open): enable sp_reset_connection.
869 2005-08-25 Sureshkumar T <tsureshkumar@novell.com>
871 * SqlCommandBuilder.cs: BuildInformation (): continue on columns
872 who don't have basetablename.
874 2005-08-12 Daniel Morgan <danielmorgan@verizon.net>
876 * SqlCommandBuilder.cs: update command builder based on
877 OdbcCommandBuilder latest changes to fix regression
880 2005-08-05 Sureshkumar T <tsureshkumar@novell.com>
882 * SqlCommandBuilder.cs: Set SourceVersion property to the created
883 parameters as it is used by the Adapter's Update method.
885 2005-07-22 Sureshkumar T <tsureshkumar@novell.com>
887 * SqlCommandBuilder.cs, SqlParameterCollection.cs,
888 SqlConnection.cs, SqlParameter.cs:
889 - updated attributes & attribute descriptions to match with
892 2005-07-16 Daniel Morgan <danielmorgan@verizon.net>
894 * SqlCommandBuilder.cs: CreateUpdateCommand should get the current value, not
895 the orginal value when setting one of the SET variables
897 2005-07-15 Sureshkumar T <tsureshkumar@novell.com>
899 * SqlCommandBuilder.cs:
900 - set_DataAdapter: unsubscribe event if DataAdapter is reset.
901 - CreateInsertCommand, CreateUpdateCommand, CreateDeleteCommand:
902 if column mapping is missing, use the source column name. use
903 proper version to get the data.
904 - RowUpdatingHandler: set status to continue to actually process
907 2005-07-04 Ben Maurer <bmaurer@ximian.com>
909 * SqlError.cs: Patch from dezelin@gmail.com to fix serialization.
911 2005-06-29 Sureshkumar T <tsureshkumar@novell.com>
913 * SqlConnection.cs: Open (): catch TdsInternalException and throw
915 * SqlException.cs: code re-organised to pass message as well with
918 2005-06-23 Sureshkumar T <tsureshkumar@novell.com>
920 * SqlConnectionStringBuilder.cs: simplified multiple keyword
921 mappings and allowed-key checking. fixed Item, Remove,
922 ContainsKey, ShoudSerialize, TryGetValue implementations.
924 2005-06-21 Sureshkumar T <tsureshkumar@novell.com>
926 * SqlConnectionStringBuilder.cs: Connection String Builder class
927 for SqlClient Data Provider.
929 2005-06-01 Gonzalo Paniagua Javier <gonzalo@ximian.com>
931 * SqlParameter.cs: moved the 'using S.D.SqlTypes' out of NET_2_0. Fixes
934 2005-06-01 Sureshkumar T <tsureshkumar@novell.com>
936 * SqlParameter.cs: Parameter's value can be SqlTypes. Convert to
937 framework type to pass to TDS layer. Fixes bug #75044.
939 2005-05-24 Umadevi S <sumadevi@novell.com>
940 * fixed some 2.0 and 1.0 specific fields/attributes for various classes.
941 * Added SqlClientMetaDataCollectionNames.cs, Implemented some 2.0
942 properties for SqlParameterCollection for the bulkcopy feature.
945 2005-05-20 Kornél Pál <http://www.kornelpal.hu/>
947 * Fixed Bug #53169 - SqlDataReader incorrectly returns bigint as decimal
948 Note: The fix works around the limitations of TDS 7.0 to avoid this
949 difference between Mono and .NET Framework TDS 8.0 should be used instead.
951 2005-05-20 Umadevi S <sumadevi@novell.com>
953 * Fixed Bug 74948 - SqlParameter also takes DBNull Value.
954 Correct some attributes stuff of 1.1 and 2.0 for SqlParameter.cs
956 2005-05-20 Umadevi S <sumadevi@novell.com>
958 * Continuing on implementation for bulkcopy and notification
959 Added files SqlNotificationEventArgs.cs, OnChangeEventHandler.cs
960 Modified SqlRowUpdatingEventArgs.cs
962 2005-05-19 Umadevi S <sumadevi@novell.com>
964 * For implementation of bulkcopy and notifications added files
965 SqlBulkCopyOptions.cs,SqlBulkCopyColumnMapping.cs,SqlNotificationAuthType.cs
966 SqlNotificationTransports.cs,SqlRowsCopiedEventArgs.cs, SqlRowsCopiedEventHandler.cs
968 2005-05-19 Umadevi S <sumadevi@novell.com>
970 * Corrected types,enum values of SqlNotificationType,SqlNotificationSource,
971 SqlNotificationInfo and added new method in SqlRowUpdatingEventArgs.cs
972 (For implementation of bulkcopy/notifications)
974 2005-04-19 Sureshkumar T <tsureshkumar@novell.com>
976 * SqlDataReader.cs: NextResult (): Re-create schema table for each
977 result set. don't re-use, as it may be referenced from somewhere.
979 2005-04-07 Sureshkumar T <tsureshkumar@novell.com>
980 Ankit Jain <radical@corewars.org>
982 * SqlConnection.cs: Implemented additional connection string
983 property "Asynchronous Processing".
985 * SqlCommand.cs: Implemented Asynchronous command execution API.
987 * SqlAsyncState.cs: A internal state object for asynchronous
990 * SqlAsyncResult.cs: Added. Class to hold result for asynchronous
993 2005-03-28 Sureshkumar T <tsureshkumar@novell.com>
995 * SqlCommand.cs: Execute: Add a semicolon at the end of
996 CommandText. Multiple semicolon's are not being complained.
1000 2005-03-11 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1002 * SqlConnection.cs: added a finalizer for correct implementation of the
1003 IDisposable pattern.
1005 2005-03-11 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1007 * SqlException.cs: make it serialization-compatible with MS. Patch by
1008 Aleksandar Dezelin. Closes bug #73596.
1010 2005-03-08 Sureshkumar T <tsureshkumar@novell.com>
1012 * SqlDataReader.cs: Call base constructor with CommandBehavior
1013 parameter instead of passing DbCommand object. The internal base
1014 class with DbCommand Parameter is removed.
1016 2005-03-07 Sureshkumar T <tsureshkumar@novell.com>
1018 * SqlCommand.cs : Set CommandBehavior on
1019 ExecuteReader,ExecuteScalar,ExecuteNonQuery. This is used in
1022 This fixes bug #73252.
1024 2005-03-03 Sureshkumar T <tsureshkumar@novell.com>
1026 * SqlClientFactory.cs: While creating command, create using
1027 DbConnectionFactory as DbConnectionBase.CreateDbCommand needs to
1028 have a connection factory.
1030 * SqlConnection.cs: Added an internal constructor which takes
1031 DbConnectionFactory.
1033 * SqlConnectionFactory.cs: Added. Concrete class for abstract
1034 factory DbConnectionFactory.
1036 2005-02-22 Sureshkumar T <tsureshkumar@novell.com>
1038 * SqlDataReader.cs: GetBytes: return the length of the data if
1039 output buffer is null. if not, copy the values to buffer and
1040 return the bytes actually read.
1042 2005-02-02 Sureshkumar T <tsureshkumar@novell.com>
1045 - Database: return db name from database if connection open,
1046 otherwise take from connection string.
1047 - Set default values for parameters in the constructor itself.
1048 - Dangling else problem with Close method.
1049 - reset values of parms (TdsConnectionParameters) rather setting
1051 - set disposed to false in Open method
1052 - finally call base.Dispose in Dispose (bool)
1054 Fixes nunit regressions SqlConnectionTest:DefaultConnectionValues
1055 and SqlConnectionTest:DatabaseSynonyms.
1057 2005-01-27 Sureshkumar T <tsureshkumar@novell.com>
1059 * SqlCommand.cs (DeriveParameters): Change parameter name to
1061 * SqlParameter.cs (SqlParameter (object [])) : call default
1062 constructor to create Tds.Metaparameter.
1066 2005-01-03 Sureshkumar T <tsureshkumar@novell.com>
1068 * SqlCommand.cs: Fixed bug #68973. Reset Tds.RecordsAffected to 0
1069 for each execute statement.
1071 2004-11-25 Sureshkumar T <tsureshkumar@novell.com>
1073 These changes are for 2.0 profile only. These changes implement
1074 the generic data base access technique using Provider Factory
1075 Implementation. These classes need to be dervided from abstract
1076 base classes so that the corresponding factory classes are
1077 created when calling CreateCommand, CreateParameter, etc.
1079 * SqlClientFactory.cs: Provider Factory class Implementaion for SqlServer
1080 * SqlParameter.cs: Change base classes and override methods.
1081 * SqlParameterCollection.cs: Change base classes and override methods.
1082 * SqlTransaction.cs: Change base classes and override methods.
1083 * SqlDataSourceEnumerator.cs: DataSource Enumerator stubs.
1084 * SqlDataReader.cs: Change base classes and override methods.
1085 * SqlConnection.cs: Change base classes and override methods.
1086 * SqlCommandBuilder.cs: Change base classes and override methods.
1087 * SqlCommand.cs: Change base classes and override necessary methods.
1089 2004-10-14 Umadevi S <sumadevi@novell.com>
1090 * SqlCommand.cs - Implemented the clone method correctly.
1093 2004-10-06 Umadevi S <sumadevi@novell.com>
1094 * ISqlNoticationReceiver.cs - changed namespace
1095 * Added files SqlNotificationType.cs, SqlNotificationInfo.cs, SqlNotificationSource.cs
1097 2004-09-24 Umadevi S <sumadevi@novell.com>
1098 * SqlTransaction.cs - Dispose will not call rollback incase the transaction is not open.
1100 2004-09-14 Sebastien Pouliot <sebastien@ximian.com>
1102 * SqlClientPermission.cs: Added internal constructor accepting an Sql
1103 ClientPermissionAttribute parameter (using base class protected ctor).
1104 * SqlClientPermissionAttribute.cs: Copy now use the new SqlClient
1105 Permission constructor.
1107 2004-09-13 Sebastien Pouliot <sebastien@ximian.com>
1109 * SqlClientPermission.cs: Mostly completed (needs tests).
1110 * SqlClientPermissionAttribute.cs: Completed.
1112 2004-09-02 Umadevi S <sumadevi@novell.com>
1113 * SqlCommand.cs - ExecuteNonQuery to return -1 incase of executing a storedprocedure
1115 2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
1117 * SqlConnection.cs: added TODO on ConnectionString for keywords
1118 that are not yet implemented. check value of Integrated Security
1119 keyword, check value of bool keywords, improve error reporting
1120 for int keywords, added support for the following keyword
1121 synonyms : APP, TIMEOUT, NETWORK, PERSISTSECURITYINFO, WSID,
1122 LANGUAGE, USER. Throw NotImplementedException when encrypt keyword
1123 is set to true, enlist keyword is set to false or attachdbfilename
1124 keyword (or one of its synonyms) is set. Added FIXME for PERSIST
1125 SECURITY INFO keyword, throwing a NotImplementedException here
1126 would break lots of apps
1128 2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
1130 * SqlConnection.cs - spaces to tabs
1132 2004-08-12 Sureshkumar T <tsureshkumar@novell.com>
1133 * SqlDataReader.cs - In Close method, the remaining resultsets are drained
1134 out, to read output parameters & to avoid stream overlap
1136 2004-06-30 Umadevi S <sumadevi@novell.com>
1137 * SqlCommand.cs : In the Execute Method the commandbehavior parameters were ignored correct
1140 2004-06-22 Atsushi Enomoto <atsushi@ximian.com>
1142 * SqlCommandBuilder.cs : Avoid cast exception caused by DbNull.
1144 2004-06-18 Umadevi S <sumadevi@novell.com>
1145 * SqlCommand.cs - ExecuteNonQuery returns -1 in all cases except
1146 insert,update or delete.
1148 2004-06-18 Umadevi S <sumadevi@novell.com>
1149 * SqlConnection.cs - handled null being passed as a connectionstring
1150 - checked for minimal set of parameters in connectionstring.
1151 - handled unrecogonized keywords similar to MS.NET
1153 2004-06-17 Umadevi S <sumadevi@novell.com>
1154 * SqlTransaction.cs - fixed multiple rollbacks being called causes invalidoperationexception
1156 2004-06-04 Gert Driesen <drieseng@users.sourceforge.net>
1158 * SqlClientPermission.cs: removed extra CreateInstance
1161 2004-06-02 Gert Driesen <drieseng@users.sourceforge.net>
1163 * SQLDebugging.cs: added missing attributes, marked ctor
1164 public to match MS.NET
1166 2004-05-22 Atsushi Enomoto <atsushi@ximian.com>
1168 * SqlClientPermission.cs : don't use chained obsolete .ctor.
1170 2004-05-20 Gert Driesen (drieseng@users.sourceforge.net)
1172 * SqlClientPermissionAttribute.cs: change AllowMultiple and
1173 Inherited to match .NET
1175 2004-05-20 Umadevi S <sumadevi@novell.com>
1177 * Fixed bug 58406- implemented the hasrow method, test program used
1178 to test with the bug report
1180 2004-05-13 Umadevi S <sumadevi@novell.com>
1182 * SqlClientPermission.cs, SqlDataReader.cs - added missing methods with TODO tags
1183 * SqlCommand.cs, SqlDataAdapter.cs - implemented ToolboxItemAttribute
1184 * SQLDebugging.cs - Added new file with a TODO tag
1186 2004-04-05 Lluis Sanchez Gual <lluis@ximian.com>
1188 * SqlConnection.cs: Use connection pool implemented in Mono.Data.Tds.
1190 2004-04-01 Lluis Sanchez Gual <lluis@ximian.com>
1192 * SqlDataReader.cs: Null values are now represented with DBNull instances.
1195 2004-03-14 Tim Coleman <tim@timcoleman.com>
1196 * SqlCommand.cs SqlConnection.cs:
1197 Changes from two patches by Andres Taylor
1198 <andres@rotselleri.com>
1200 2004-03-12 Andreas Nahr <ClassDevelopment@A-SoftTech.com>
1202 * SqlParameter.cs: DO NOT USE the consts scheme if types can be referenced directly!
1204 2004-01-10 Atsushi Enomoto <atsushi@ximian.com>
1206 * SqlClientPermission.cs : Fixed NET_2_0 build related to
1207 obsolete attribute problem (see DbDataPermission.cs)
1209 2003-12-28 Tim Coleman <tim@timcoleman.com>
1211 Stubbed out this class.
1213 2003-12-23 Tim Coleman <tim@timcoleman.com>
1215 Improved connection string parsing. See
1216 System.Data.Common.DbConnectionString for source.
1218 2003-12-21 Tim Coleman <tim@timcoleman.com>
1220 Enable Integrated Security
1222 2003-12-19 Tim Coleman <tim@timcoleman.com>
1223 * ISqlNotificationReceiver.cs SqlResultSet.cs:
1225 * SqlClientPermission.cs:
1226 Fix constructor for 1.2
1228 2003-12-04 John Luke <jluke@cfl.rr.com>
1230 * SqlXmlTextReader.cs: applied patch from Chris Masters <neeeeeep@bigpond.com>
1231 fix peek so it checks if it is at the end and also to make sure that if Read()
1232 advances the position past the end of the localBuffer array, it makes
1233 a call to GetNextBuffer(). fixes bug #40253 System.IndexOutOfRangeException when
1234 using SqlCommand.ExecuteXmlReader()
1236 2003-11-20 Joerg Rosenkranz <JoergR@voelcker.com>
1238 * SqlConnection (SetDefaultConnectionParameters):
1239 Changed default value of WORKSTATION ID to reflect real
1240 host name instead of "localhost".
1242 2003-11-16 Ben Maurer <bmaurer@users.sourceforge.net>
1244 * SqlParameterCollection.cs (Clear): Clear needs to take
1245 the parameter out of the collection so that it can be used
1250 2003-10-03 Diego Caravana <diego@toth.it>
1252 * SqlCommand.cs: no change.
1254 * SqlConnection.cs (Close): Added checks for null instance
1257 * SqlParameter.cs (Direction): Now handles parameters of type
1258 ReturnValue and InputOutput.
1260 * SqlParameterCollection.cs (IndexOf(string)): Search for
1261 SqlParameter object in list is done by obtaining ParameterName
1262 attribute, not directly through list.IndexOf().
1264 2003-08-22 Duncan Mak <duncan@ximian.com>
1266 * SqlCommand.cs (ExecuteNonQuery): Return
1267 Connection.Tds.RecordsAffected if it is successful. Patch from
1268 Jörg Rosenkranz <joergr@voelcker.com>.
1270 This is part of a fix to bug #40315.
1272 2003-08-20 Duncan Mak <duncan@ximian.com>
1274 * SqlConnectionPool.cs (ReleaseConnection): A patch from Joerg
1275 Rosenkranz <JoergR@voelcker.com>. Currently, if a connection is
1276 closed by an external event (network problem, etc.) it is pushed
1277 back into the connection pool. The next Open call retrieves this
1278 invalid connection which leads to exceptions when executing
1281 This patch fixes this problem. This closes bug #47429.
1283 2003-07-04 Miguel de Icaza <miguel@ximian.com>
1285 * SqlDataReader.cs: Added extra information to the exceptions
1286 thrown by all the GetXXXX methods.
1288 2003-03-15 Daniel Morgan <danmorg@sc.rr.com>
1290 * SqlConnection.cs: if Server in the ConnectionString
1291 is set to "(local", use "localhost" as the hostname
1294 2003-03-04 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1296 * SqlException.cs: implemented GetObjectData ().
1298 2003-02-16 Daniel Morgan <danmorg@sc.rr.com>
1300 * ChangeLog: added this file
1302 * SqlConnection.cs: - parse data source for 3 possible uses:
1304 "Server=hostname\\instancename",
1305 "Server=hostname,port" and open the connection based on the
1306 resulting server name and port.
1307 - Added support for named instances
1308 by discovery of the sql server tcp port via the sql monitor (udp port 1434)
1309 thanks to Phillip Jerkins (Phillip.Jerkins@morgankeegan.com) contribution.
1310 Also, thanks to Gonzalo and Tim for their help with timeouts.