1 2009-01-03 Gert Driesen <drieseng@users.sourceforge.net>
3 * SqlCommandBuilder.cs: Only set SourceColumn for null check
4 parameters on the 2.0 profile, and set SourceVersion to
5 Current on 1.0 profile. Changed accessibility of RefreshSchema
6 to public, and do not immediately create commands. Removed
9 2009-01-03 Gert Driesen <drieseng@users.sourceforge.net>
11 * SqlParameter.cs: When setting ParameterName or sourceName to
12 null, use a zero-length string instead. On 1.0 profile, only
13 infer type from value if value is not null or DBNull. Store
14 raw value in TdsMetadataParameter, and use delegate to convert
15 it to framework type (when necessary). Improve implementation
16 of SqlValue (still needs lots of work).
18 2009-01-03 Gert Driesen <drieseng@users.sourceforge.net>
20 * SqlCommandBuilder.cs: Added missing checks for QuotePrefix and
21 QuoteSuffix on 2.0 profile, and return a zero-length string if
22 not set (or set to null) on 1.0 profile. Do not allow the value
23 of CatalogSeparator and SchemaSeparator to be changed from '.'.
24 Modified generated SQL to match MS. Added implementation for
25 QuoteIdenfifier. Modified parameters to match MS.
26 * SqlParameter.cs (SqlValue): Keep Value in sync.
28 2008-12-20 Gonzalo Paniagua Javier <gonzalo@novell.com>
30 * SqlParameter.cs: I removed these 2 lines I added 2 patches ago in
33 2008-12-20 Gonzalo Paniagua Javier <gonzalo@novell.com>
35 * SqlConnection.cs: close the connection on error.
37 2008-12-16 Gonzalo Paniagua Javier <gonzalo@novell.com>
39 * SqlParameter.cs: don't allocate error strings until the error
40 actually happens. Compare types instead of strings. Use a Hashtable
43 2008-12-12 Gonzalo Paniagua Javier <gonzalo@novell.com>
45 * SqlParameter.cs: use the underlying type when inferring the type for
48 2008-11-13 Veerapuram Varadhan <vvaradhan@novell.com>
50 * SqlCommand.cs: When a timeout exception occurs, reset the
51 connection before re-using it. Fixes connection corrupted errors
54 2008-11-09 Gert Driesen <drieseng@users.sourceforge.net>
56 * SqlConnection.cs (ClearPool): Added null check.
58 2008-11-09 Gert Driesen <drieseng@users.sourceforge.net>
60 * SqlConnection.cs: In Close, also remove reference to pool. In Open,
61 set TdsConnection.Pooling to false for a non-pooled connection.
62 Fixed ClearAllPools to no longer create a new connection for each
63 pool. In ClearPool, perform a lookup of the pool to clear using
64 the connectionstring as the pool field may refer to another pool
65 (as the connectionstring may have changed).
67 2008-09-30 Veerapuram Varadhan <vvaradhan@novell.com>
69 * SqlDataReader.cs (GetSqlXml): Handle the scenario when Sql
70 Server 2005 returns Xml column type as NTEXT when called from
71 clients that use < TDS 8.0 protocol.
73 2008-09-20 Veerapuram Varadhan <vvaradhan@novell.com>
75 * SqlCommand.cs (DeriveParameters): Simplification of the if-else loop.
77 2008-09-20 Veerapuram Varadhan <vvaradhan@novell.com>
79 * SqlCommand.cs (DeriveParameters): Handle no square brackets
80 case in schema/procedure names.
82 2008-09-17 Veerapuram Varadhan <vvaradhan@novell.com>
84 * SqlCommand.cs (DeriveParameters): Escape/trim both
85 schema/procedure names before passing as parameter values.
87 2008-09-13 Atsushi Enomoto <atsushi@ximian.com>
89 * SqlDependency.cs : wrong namespace.
91 2008-08-14 Gert Driesen <drieseng@users.sourceforge.net>
93 * SqlConnection.cs: Use constants for min/max values. When value is
94 zero-length string, then fallback to default value for boolean and
95 integer backed properties. Throw ArgumentException when min pool size
96 exceeds max pool size. Check whether value for 'MARS' is a bool.
97 The 'user instance' property is 2.0 only.
99 2008-08-14 Gert Driesen <drieseng@users.sourceforge.net>
101 * SqlConnection.cs: Convert keywords to lowercase instead of uppercase
102 to avoid further case changes in exception messages.
104 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
106 * SqlCommand.cs (ExecuteReader): When behavior includes SingleRow,
107 then only return a single result. Fixes bug #412569.
109 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
111 * SqlCommand.cs: Fixed order of arguments for ArgumentException in
113 * SqlConnection.cs (ChangePassword): Do not allow empty connection
114 string. Updated exception messages.
116 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
118 * SqlCommand.cs: Fixed param name in ArgumentException for negative
119 CommandTimeout to match MS. On 2.0 profile, throw NRE in Prepare
120 when connection is NULL. In Prepare, return immediately after
121 connection check (2.0 only) for stored procedures, or when no
122 parameters are added. Added check to see if transaction is
123 associated with same connection as the command and updated
126 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
128 * SqlCommand.cs: Added bool argument to ValidateCommand to specify
129 whether an async method is being executed. Minor changes to exception
130 messages to match MS.
132 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
134 * SqlCommand.cs: Avoid NRE in CloseDataReader when connection is NULL.
135 Fixes bug #412584. Removed unused moreResults eargument from
136 CloseDataReader. Removed behavior argument from Execute, and have it
137 use the behavior field instead. In ValidateCommand, throw
138 InvalidOperationException instead of NRE when Connection is NULL.
139 * SqlDataReader.cs: Sync with SqlCommand's CloseDataReader signature
142 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
144 * SqlCommand.cs: (Transaction): On the 1.0 profile, do not allow
145 Transaction to be set when a reader is open for the current connection.
148 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
150 * SqlCommand.cs (Connection): Do not throw InvalidOperationException
151 if transaction is in progress. Fixes bug #412576. On 1.0 profile, throw
152 InvalidOperationException when a reader is open for the current
153 connection. Do not set transaction to NULL when changing connection,
154 instead set it to null in Transaction when transaction is no longer
157 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
159 * SqlConnection.cs: Use null as default value for connectionString
160 field. Remove Init method, as initialization is done in
161 SetDefaultConnectionParameters. Initialize parms in
162 SetDefaultConnectionParameters to avoid calling Reset on newly
163 initialized collection. In Dispose (bool), also invoke base.Dispose if
164 SqlConnection was already disposed. Fixes bug #412571.
166 2008-07-28 Gert Driesen <drieseng@users.sourceforge.net>
168 * SqlConnection.cs (ChangeState): Return immediately when new state
169 equals original state. Fixes bug #412574. Removed extra whitespace.
171 2008-07-23 Veerapuram Varadhan <vvaradhan@novell.com>
173 * SqlDataReader.cs (NextResult): Memleak fix - mark datatypeNames
174 array to be GCed along with schemaTable.
176 2008-07-23 Veerapuram Varadhan <vvaradhan@novell.com>
178 * SqlDataReader.cs: Do not generate schemaTable unless otherwise
179 asked for; use command.Tds.Columns instead. Improves performance
182 2008-07-10 Veerapuram Varadhan <vvaradhan@novell.com>
185 * SqlCommand.cs (GetOutputParameters): Update parameter values iff
186 parameter direction is InputOutput or Output.
188 2008-07-06 Gert Driesen <drieseng@users.sourceforge.net>
190 * SqlException.cs: Modified HResult/ErrorCode to match MS. Removed
191 unused FromTdsInternalException overload. Removed unnecessary check
192 for Errors.Count. Minor code formatting.
194 2008-07-03 Rodrigo Kumpera <rkumpera@novell.com>
196 * SqlConnection.cs: Remove connStringParameters as nobody uses it.
198 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
200 * SqlDataReader.cs: Do all column accesses with int indexes.
202 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
204 * SqlDataReader.cs (GetSchemaTable): All column index are constants,
207 2008-07-01 Rodrigo Kumpera <rkumpera@novell.com>
209 * SqlDataReader.cs (GetSchemaTable): Calculate column indexes
210 outside of the row loop.
212 2008-07-01 Marek Habersack <mhabersack@novell.com>
214 * SqlDataReader.cs: use named properties in TdsDataColumn for the
217 2008-06-30 Zoltan Varga <vargaz@gmail.com>
219 * SqlDataReader.cs: Allocate 'schemaTable' lazily.
220 (GetSchemaValue): Avoid some hash table lookups
222 2008-06-27 Zoltan Varga <vargaz@gmail.com>
224 * SqlDataReader.cs (ConstructSchemaTable): Avoid unneccessary reflection calls.
226 2008-06-23 Veerapuram Varadhan <vvaradhan@novell.com>
228 * SqlDependency.cs: New
230 2008-06-12 Veerapuram Varadhan <vvaradhan@novell.com>
232 Patch by Christian Hergert <christian.hergert@gmail.com>
233 * SqlConnection.cs (Open): Do not reset the connection as it is already
234 done in the TdsConnectionPool itself.
236 2008-06-12 Marek Habersack <mhabersack@novell.com>
238 * SqlParameterCollection.cs: this [int] must check the range and
239 throw an exception if necessary.
241 * SqlCommand.cs: throw IOEX when stored procedure is not found in
242 DeriveParameters. All procedures in MS SQL will report at least
243 one parameter - the return value.
245 2008-06-10 Veerapuram Varadhan <vvaradhan@novell.com>
247 * SqlConnection.cs: TdsConnectionPool.GetConnectionPool() now returns
248 IDictionary<TKey, TValue>.
250 2008-06-09 Ankit Jain <jankit@novell.com>
252 * SqlCommand.cs: Use Tds instead of ITds now.
253 * SqlConnection.cs: Likewise.
255 2008-05-27 Gert Driesen <drieseng@users.sourceforge.net>
257 * SqlConnection.cs: Added support for '.' as alias for localhost.
258 Improve exception message when TCP/IP protocol is not enabled.
260 2008-05-17 Gert Driesen <drieseng@users.sourceforge.net>
262 * SqlDataReader.cs (GetInt64): Removed workaround for TDS 7.0 handling
263 of bigint column type as this is handled in Mono.Data.Tds.
265 2008-05-14 Marek Habersack <mhabersack@novell.com>
267 * SqlConnection.cs: added support for USER INSTANCE keyword in the
270 2008-04-22 Veerapuram Varadhan <vvaradhan@novell.com>
273 * SqlCommand.cs: Handle exceptions sanely and do not close
274 connection on TdsTimeoutException.
276 2008-04-21 Gert Driesen <drieseng@users.sourceforge.net>
278 * SqlBulkCopyColumnMappingCollection.cs: Changed argument names to
279 match MS. Code formatting.
280 * SqlCommand.cs: Changed argument names to match MS. Code formatting.
281 Do not include explicit IDbCommand implementation on 2.0 profile.
282 * SqlCommandBuilder.cs: Changed argument names to match MS. Code
284 * SqlDataReader.cs: Changed argument names to match MS. Code
286 * SqlParameterCollection.cs: Do not include IList, ICollection and
287 IDataParameterCollection explicit interface implementation on 2.0
288 profile. Code formatting.
289 * SqlConnection.cs: Changed argument names to match MS.
290 * SqlDataAdapter.cs: Changed argument names to match MS.
291 * SqlTransaction.cs: Do not include explicit interface implementation
292 of IDbTransaction.Connection on 2.0 profile. Code formatting.
294 2008-04-19 Robert Jordan <robertj@gmx.net>
296 * SqlParameterCollection.cs (AddRange(SqlParameter[])):
297 Fix endless recursion.
299 2008-04-08 Marek Habersack <mhabersack@novell.com>
301 * SqlConnection.cs: TCP port discovery via UDP port 1434 should
302 honor the timeout specified in the connection string (or the
303 default one). In some environments 100 microseconds might not be
304 enough to discover the port.
306 2008-04-01 Marek Habersack <mhabersack@novell.com>
308 * SqlParameter.cs: ConvertToFrameworkType must handle empty
309 strings gracefully - a DBNull.Value must be returned in this
312 * SqlCommand.cs: DeriveParameters should split the stored
313 procedure name into the schema name and procedure name before
314 querying its parameters.
316 2008-03-03 Ankit Jain <jankit@novell.com>
318 * SqlClientMetaDataCollectionNames.cs: Set the field values.
320 2007-10-21 Gert Driesen <drieseng@users.sourceforge.net>
322 * SqlCommand.cs: Use ExceptionHelper.CheckEnumValue for enum checks.
324 2007-10-20 Gert Driesen <drieseng@users.sourceforge.net>
326 * SqlCommand.cs: Added constant for default CommandTimeout, instead
327 of using a magic number. Avoid unnecessary initialization. Fixed
328 default value for DesignTimeVisible. Return zero-length string if
329 CommandText is null. Use ExceptionHelper.InvalidEnumValueException
330 to avoid code duplication. Spaces to tabs and code formatting.
331 * SqlConnection.cs: Use different default package size on 2.0 profile.
332 Added constants for default values, instead of using magic numbers.
333 Avoid unnecessary initialization. In PacketSize, return default or
334 configured packet size when connection is not open. Use
335 ExceptionHelper.ConnectionClosed instead of local method. Removed
336 use of some hardcoded values in SetDefaultConnectionParameters, and
337 use Environment.MachineName as default WorkstationId instead of
338 DNS host name. Code formatting.
339 * SqlDataAdapter.cs: In default ctor, set SelectCommand to null.
340 Avoid unnecessary initializations. Use direct assignment in
341 IDbDataAdapter implementation. Fixed exception message for negative
342 UpdateBatchSize. In Dispose override, make sure to invoke base
345 2007-10-19 Gert Driesen <drieseng@users.sourceforge.net>
347 * SqlTransaction.cs: Clear connection in commit. In IsolationLevel,
348 throw IOE if transaction is no longer open.
350 2007-10-19 Gert Driesen <drieseng@users.sourceforge.net>
352 * SqlTransaction.cs: Avoid unnecessary initialization. Remove
353 isRolledBack since its essentially the same as isOpen. Use
354 ExceptionHelper.TransactionNotUsable instead of duplicating code.
355 On 2.0 profile, ignore call to Rollback when transaction was already
358 2007-10-18 Gert Driesen <drieseng@users.sourceforge.net>
360 * SqlConnection.cs: Avoid unnecessary initialization. Use string.Empty
361 for assigning zero-length string, and use String.Length to check for
362 zero-length string. Added support for IsolationLevel.Snapshot.
363 Added StructuredTypeMembers schema collection and restrictions. Fixed
364 table name for MetaDataCollections collection. Implemented
365 DataSourceInformation collection. Added missing data types (probably
366 introduced in 2.0 SP1). In GetSchema, throw InvalidOperationException
367 if connection is closed and throw NotImplementedException for
368 StructuredTypeMembers collection.
370 2007-10-18 Gert Driesen <drieseng@users.sourceforge.net>
372 * SqlConnection.cs: On 1.0 profile, IsolationLevel.Unspecified is
373 not valid. On 2.0 profile, when IsolationLevel.Unspecified is passed
374 make sure to also set SqlTransaction.IsolationLevel to
375 ReadCommitted. Modified exceptions to match MS.
377 2007-10-17 Nagappan <anagappan@novell.com>
379 * SqlParameter.cs (ConvertToFrameworkType): Added SqlDbType.Image.
381 2007-10-17 Nagappan <anagappan@novell.com>
383 * SqlConnection.cs: BeginTransaction does not handle
384 IsolationLevel.Unspecified, so the default is set as ReadCommited.
385 Thanks to Jerome Haltom <wasabi@larvalstage.net> for this patch. Fixes
387 * SqlTransaction.cs: If transaction count is greater then 0 then roll back.
388 Thanks to Jerome Haltom <wasabi@larvalstage.net> for this patch. Fixes
391 2007-10-15 Gert Driesen <drieseng@users.sourceforge.net>
393 * SqlException.cs: Do not hide Message on 2.0 profile. Fixes bug
396 2007-10-08 Marek Safar <marek.safar@gmail.com>
398 * SqlParameterCollection.cs (SetParameter): Fixed missing cast.
400 2007-09-27 Nagappan A <anagappan@novell.com>
402 * SqlConnection.cs: Added MonoTODO appropriately.
404 2007-09-26 Nagappan A <anagappan@novell.com>
406 * SqlCommandBuilder.cs: Code alignment.
408 2007-09-25 Nagappan A <anagappan@novell.com>
410 * SqlInitialCatalogConverter.cs, SqlDataSourceConverter.cs:
411 NetworkLibraryConverter.cs: Added new files.
413 * SqlParameter.cs: 2.0 attribute changes.
415 * SqlDataAdapter.cs: 2.0 attribute changes.
417 * SqlConnectionStringBuilder.cs: 2.0 attribute changes.
419 * SqlConnection.cs (ClearAllPools, ClearPool): Implemented 2.0
420 APIs, other 2.0 attribute changes.
422 * SqlCommandBuilder.cs (GetSchemaTable, InitializeCommand):
423 Implemented 2.0 APIs, other 2.0 attribute changes.
425 * SqlBulkCopyColumnMappingCollection.cs: Added constructor, 2.0
426 API compatibility changes.
428 * SqlException.cs: 2.0 attribute changes.
430 2007-08-13 Nagappan A <anagappan@novell.com>
432 * SqlConnection.cs (ConnectionString): 2.0 compatibility changes.
434 * SqlDataReader.cs (IsCommandBehavior): Fixed spelling mistake of
436 (Dispose): 2.0 compatibility changes.
438 * SqlBulkCopy.cs (SqlRowsCopied): Fixed spelling mistake of the
440 (RowsCopied): Generates event when NotifyAfter is set.
442 * SqlCommandBuilder.cs (Dispose, RefreshSchema): 2.0 compatibility
445 * SqlClientFactory.cs (CreateDataSourceEnumerator): Removed bogus
448 * SqlException.cs (Message): 2.0 compatibility changes.
450 2007-08-06 Nagappan A <anagappan@novell.com>
452 * SqlCommand.cs, SqlDataReader.cs, SqlConnection.cs: When the
453 server resets the connection, now the client code also disconnects
454 the session and remove the instance from pool. Fixes bug # 81933.
456 2007-07-31 Nagappan A <anagappan@novell.com>
458 * SqlCommand.cs (Transaction, Connection): IDbCommand Transaction
459 and Connection can be set to null. Fixes bug 82189.
461 2007-07-23 Nagappan A <anagappan@novell.com>
463 * SqlCommandBuilder.cs (ApplyParameterInfo, GetParameterName):
464 (GetParameterPlaceholder): Implemented 2.0 missing APIs.
466 2007-07-22 Nagappan A <anagappan@novell.com>
468 * SqlBulkCopy.cs (NotifyAfter): Implemented 2.0 property.
469 (GetColumnMetaData, GenerateColumnMetaData):
470 (ValidateColumnMapping): Implemented private method's to generate
471 and validate SqlBulkCopy headers.
472 (BulkCopyToServer): Private method to actually do the bulk copy
474 (WriteToServer): Implemented 2.0 missing overloaded methods.
475 (IDisposable.Dispose): Implemented 2.0 missing method.
477 * SqlBulkCopyColumnMappingCollection.cs (Add, CopyTo): Implemented
479 (Item): Implemented missing property.
481 * SqlBulkCopyColumnMapping.cs: Modified the implementation of
482 Constructors to use property.
484 * SqlDataReader.cs (GetSqlXml, IsCommandBehaviour): Added 2.0
486 (Connection): Added missing property.
488 * SqlParameter.cs (SetSqlDbType, ConvertToFrameworkType): Modified
489 method as internal from private.
491 * SqlConnection.cs: Fixed 2.0 missing feature.
493 * SqlException.cs: Fixed 2.0 missing feature.
495 * SqlClientPermission.cs: Fixed 2.0 missing feature.
497 2007-07-01 Gert Driesen <drieseng@users.sourceforge.net>
499 * ISqlNotificationReceiver.cs: Removed.
500 * SqlClientFactory.cs: Use SqlDataSourceEnumerator from S.D.Sql and
501 marked method todo. Avoid unnessary casts. Code formatting.
502 * SqlCommand.cs: Explicit interface implementation of IDbCommand not
503 necessary on 2.0 profile. Fixes API mismatches. Avoid unnecessary
504 casts. Code formatting.
505 * SqlConnection.cs: Also use RecommendAsConfigurable instead of
506 SettingBindableAttribute on 2.0. Use StateChange event from base class
507 on 2.0. Only explicitly implement IDbConnection methods on 1.0, since
508 these are implemented by base class on 2.0 profile. Removed extra
509 explicit implementation of IDisposable since the base class implements
510 this. Code formatting.
511 * SqlDataAdapter.cs: Dispose (bool) override not necessary on 2.0
512 profile. Stubbed ICloneable.Clone. Fixes API mismatches.
513 * SqlDataReader.cs: On 2.0, IDisposable.Dispose is implemented by
514 DbDataReader. Only 1.0 profile, explicitly implemented IEnumerable
515 GetEnumerator. Code formatting.
516 * SqlDataSourceEnumerator.cs: Removed.
517 * SQLDebugging.cs: Marked sealed on 2.0. Code formatting.
518 * SqlNotificationAuthType.cs: Removed.
519 * SqlNotificationInfo.cs: Added missing fields. Code formatting.
520 * SqlNotificationSource.cs: Added missing fields. Code formatting.
521 * SqlNotificationTransports.cs: Removed.
522 * SqlNotificationType.cs: Added missing Unknown field. Code formatting.
523 * SqlParameter.cs: Removed Browsable and EditorBrowsable attributes
524 from Precision and Scale. Fixes API mismatches. Code formatting fixes.
525 * SqlTransaction.cs: On 2.0 profile, Dispose method is exposed by
526 base class. Fixes API mismatches. Code formatting fixes.
528 2007-06-21 Nagappan A <anagappan@novell.com>
530 * SqlConnection.cs: Fixed compiler warning.
532 2007-06-11 Nagappan A <anagappan@novell.com>
534 * SqlConnection.cs (ParseDataSource): Adds tcp support in
535 connection string. Fixes bug # 80975.
537 * SqlCommand.cs (Dispose): On disposing the command object, don't
538 dispose connection and transaction.
540 2007-06-06 Nagappan A <anagappan@novell.com>
542 * SqlCommand.cs, SqlConnectionStringBuilder.cs, SqlConnection.cs:
543 Fixed 1.0 and 2.0 extras, errors as stated in class status page.
545 * SqlDataAdapter.cs, SqlParameter.cs:Fixed 1.0 and 2.0 extras,
546 errors as stated in class status page.
548 * SqlBulkCopyColumnMappingCollection.cs: Fixed 1.0 and 2.0 extras,
549 errors as stated in class status page.
551 2007-05-30 Nagappan A <anagappan@novell.com>
553 * SqlParameter.cs (SqlParameter): Updated constructor to use the
554 new TDS RPC implementation.
555 Fixed missing attributes.
556 (SetDbType): Added new case for sql_variant type.
557 (ConvertToFrameworkType): Implemented new private method to
558 convert the data type to framework type.
560 * SqlParameterCollection.cs: Fixed missing attributes and
561 implemented missing methods.
563 * SqlConnection.cs: Fixed missing attributes.
565 * SqlConnectionStringBuilder.cs: Certain attributes are missing or
566 its value or they are not appropriate. Fixed them.
568 * SqlDataReader.cs (GetData): Method is available only under 1.0
571 * SqlCommandBuilder.cs: Certain attributes are available only
572 under 2.0 profile, so moved them inside ifdef.
574 * SqlCommand.cs: Certain attributes are available only under 2.0
575 profile, so moved them inside ifdef.
577 * SqlBulkCopy.cs: Added new stubs.
579 * SqlBulkCopyColumnMappingCollection.cs: Added new stubs.
581 2007-05-29 Nagappan A <anagappan@novell.com>
583 * SqlCommand.cs (Dispose): Command.Dispose closing
584 connection. Fixes bug # 81710. Thanks to AMC <amc1999@gmail.com>
587 2007-05-10 Nagappan A <anagappan@novell.com>
589 * SqlClientMetaDataCollectionNames.cs: Fixed incorrect constructor
592 * SqlConnectionStringBuilder.cs: Fixed missing attributes.
594 2007-05-09 Igor Zelmanovich <igorz@mainsoft.com>
596 * SqlConnectionStringBuilder.cs: added MonoNotSupported attribute.
598 2007-04-03 Amit Biswas <amit@amitbiswas.com>
600 * SqlDataReader.cs (GetSqlBytes, GetProviderSpecificFieldType)
601 (GetProviderSpecificValue, GetProviderSpecificValues): Implemented
604 * SqlParameter.cs (XmlSchemaCollectionDatabase): Implemented missing property
605 (XmlSchemaCollectionName): Implemented missing property
606 (XmlSchemaCollectionOwningSchema): Implemented missing property
607 (SourceColumnNullMapping): Existing implementation was not correct, Replaced the implementation
608 (.ctor): Implemented mising constructor new in .net 2.0
610 * SqlErrorCollection.cs (CopyTo): Implemented missing API
612 * SqlParameter.cs (InferSqlType): Corrected bug related to default values of
614 (ResetSqlDbType): Implemented missing API
615 (ResetDbType): Implemented missing API
617 2007-03-09 Amit Biswas <amit@amitbiswas.com>
619 * SqlParameterCollection.cs (CopyTo): Implemented missing API
621 2007-04-02 Nagappan A <anagappan@novell.com>
623 * SqlParameter.cs: Variable name fix.
625 2007-03-20 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
627 * SqlClientFactory.cs: Added two using directives.
628 (CreateConnectionStringBuilder): Implemented the method.
629 (CreatePermission): Implemented the property.
631 * SqlCommand.cs: Added one using directive.
632 (Clone): Implemented the method.
633 (Dispose): Implemented the method.
634 (BeginExecuteXmlReader): Implemented the method.
636 * SqlCommandBuilder.cs (QuoteIdentifier): Implemented the method.
637 (UnquoteIdentifier): Implemented the method.
639 * SqlConnection.cs (ChangePassword): Implemented the method.
641 2007-03-19 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
643 * SqlClientFactory.cs (CanCreateDataSourceEnumerator): Implemented
646 * SqlCommand.cs (Notification): Implemented the property.
647 (NotificationAutoEnlist): Implemented the property.
649 * SqlDataReader.cs (VisibleFieldCount): Implemented the property.
651 * SqlConnectionStringBuilder.cs (TrustServerCertificate): Implemented
653 (TypeSystemVersion): Implemented the property.
654 (UserInstance): Implemented the property.
655 (ContextConnection): Implemented the property.
657 * SqlConnection.cs (FireInfoMessageEventOnUserErrors): Implemented
659 (StatisticsEnabled): Implemented the property.
661 * SqlDataAdapter.cs (UpdateBatchSize): Implemented the property.
663 * SqlParameter.cs: Implemented one attribute.
665 2007-03-16 Andreia Gaita <avidigal@novell.com>
667 * SqlParameter.cs: Move isVariableSizeType flag to TdsMetaParameter
668 so that the TdsMetaParameter can validate itself for valid size / values.
669 * SqlCommand.cs (Execute): Call Validate on TdsMetaParameter.
671 2007-03-14 Nagappan A <anagappan@novell.com>
673 * SqlCommand.cs (CommandType): Exception type thrown in 2.0
674 profile is different than 1.0, ArgumentOutOfRangeException.
675 (Connection): Exception type thrown in 2.0 profile is different
676 than 1.0, ArgumentOutOfRangeException.
677 (Execute): If Size property is 0 for String and Binary type, then
678 throw InvalidOperationException.
679 (ValidateCommand): Exception type thrown in 2.0 profile is
680 different than 1.0, NullReferenceException.
682 2007-03-09 Nagappan A <anagappan@novell.com>
684 * SqlDataReader.cs: Fixed syntax erros reported in class status
687 2007-03-09 Andreia Gaita <avidigal@novell.com>
689 * SqlCommand.cs (ExecuteScalar): Fix returned value for
690 stored procedure calls to return the first column of the
691 first row produced by the proc.
693 2007-03-08 Nagappan A <anagappan@novell.com>
695 * SqlCommand.cs (CloseDataReader): Checks whether the SQL
696 connection is created or not.
698 2007-03-07 Andreia Gaita <avidigal@novell.com>
700 * SqlCommand.cs (ExecuteScalar): when calling stored procedures,
701 implement support for return of output values in the parameter
704 2007-02-16 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
706 * SqlParameter.cs (CompareInfo): Implemented the property
708 (LocaleId): Written the property LocaleId.
709 (SqlValue): Written the propert SqlValue.
711 2007-02-15 Nidhi Rawal <rawalnidhi_rawal@yahoo.com>
713 * SqlCommand.cs: Added some attributes which were not implemented
714 for .NET 2.0 and removed extra attribute which are not there in
717 * SqlCommandBuilder.cs: Added some attributes that were not
718 implemented for .NET 2.0.
720 * SqlParameterCollection.cs: Added some attributes that were
721 not implemented for .NET 2.0.
723 * SqlConnectionStringBuilder.cs: Added some attributes that
724 were not implemented for .NET 2.0.
726 * SqlConnection.cs: Added attribute that was not implemented
729 * SqlParameter.cs: Added some attributes which were not
730 implemented for .NET 2.0 and removed some extra attributes which
731 are not there in .NET 2.0
733 2007-02-09 Nagappan A <anagappan@novell.com>
735 * SqlConnection.cs (SetConnectionString): Fixes bug # 80712. A
738 2007-01-08 Nagappan A <anagappan@novell.com>
740 * SqlTransaction.cs (Dispose): Fixed compliation warning.
742 * SqlDataReader.cs (GetValues): Length of elements to be copied was
743 decided based on the argument array passed, which caused a bug, if
744 the length of given array is more than actual column values.
746 * SqlCommandBuilder.cs (CatalogSeparator, SchemaSeparator)
747 (CatalogLocation): Implemented missing properties.
748 (CreateDeleteCommand, CreateInsertCommand, CreateUpdateCommand):
749 Modified private methods to take bool flag. If true, add actual
750 parameter name instead of p1, p2 etc.
751 (CreateParameter): Added overloaded private method to create
752 parameter with the actual column name.
753 (GetUpdateCommand, GetDeleteCommand, GetInsertCommand):
754 Implemented missing overloaded methods.
755 (SetRowUpdatingHandler): Implemented missing protected method.
757 * SqlCommand.cs: Fixed compilation warning. Removed bogus
760 2006-12-05 Nagappan A <anagappan@novell.com>
762 * SqlCommand.cs (Execute): If sql2 length is greater than 0, then
763 add ';' and the respective sql2 string and then execute the
764 string. Fixes bug # 79880.
766 2006-08-30 Nagappan A <anagappan@novell.com>
768 * SqlConnection.cs: Implemented SqlConnection.GetSchema ().
770 2006-09-08 Konstantin Triger <kostat@mainsoft.com>
772 * SqlClientFactory.cs: implemented SqlClientFactory.CreateConnection ().
774 2006-07-13 Senganal T <tsenganal@novell.com>
776 * SqlClientFactory.cs SqlCommand.cs SqlConnectionFactory.cs
777 SqlClientPermission.cs SqlParameterCollection.cs SqlDataReader.cs
778 SqlConnection.cs SqlParameter.cs SqlTransaction.cs :
781 2006-05-31 Gert Driesen <drieseng@users.sourceforge.net>
783 * SqlConnection.cs: Removed extra destructor, as destructor on
784 System.ComponentModel.Component already calls Dispose.
785 * SqlParameter.cs: Removed explicit interface implementation of
786 IDataParameter.ParameterName.
788 2006-05-26 Senganal T <tsenganal@novell.com>
791 - InferSqlType : if value is null or DBNull.Value, retain the
792 current parameter type.
794 2006-04-18 Senganal T <tsenganal@novell.com>
797 - SetConnectionString : set the pareameter to default values
798 if connection string is empty or null
799 - Open : Raise InvalidOperationException if Connection String
801 - Dispose : Test exception not raised if dispose called on a
802 connection with empty connection string
804 slight modification of the patch by Jonel Rienton
806 2006-04-07 Senganal T <tsenganal@novell.com>
808 * SqlCommandBuilder.cs :
809 * CreateDeleteCommand ()
810 * CreateUpdateCommand ()
811 * CreateInsertCommand ()
812 - Changed the signature. Do not need DataRow parameter
813 as the Query generated is parametric.
814 - Correct the null-check term in the WhereClause, set the
815 correct properties for null-check parameter
817 - Modified the generated query to match the query as
818 generated by 2.0. We now ignore null-check in the
819 whereclause if the Column does not allow nulls.
820 * ctor () : Set QuotePrefix and QuoteSuffix for 2.0 profile
821 * GetUpdateCommand ()
822 * GetInsertCommand ()
823 * GetDeleteCommand ()
824 - Do not create new command everytime. Create only if
826 * RefreshSchema : Reset the commands.
828 2006-02-17 Chris Toshok <toshok@ximian.com>
830 * SqlCommand.cs, SqlCommandBuilder.cs, SqlConnection.cs,
831 SqlDataAdapter.cs: remove DataSysDescription attributes for >= 2.0
833 2006-02-17 Chris Toshok <toshok@ximian.com>
835 * SqlDataReader.cs: remove VisibleFieldCount property.
837 2006-02-10 Senganal T <tsenganal@novell.com>
839 - GetBytes : Read binary/blob/clob data sequentially when
840 CommandBehavior is set to SequentialAcccess
841 - GetChars : Read String/clob data sequentially when CommandBehavior
842 is set to SequentialAccess
844 - ExecuteReader : set SequentialAccess property on TDS
845 - CloseDataReader : Reset the command behavior
847 2006-01-27 Senganal T <tsenganal@novell.com>
849 * SqlCommandBuilder.cs :
850 - Modified CreateUpdateCommand,CreateDeleteCommand , to not include
851 column name in the query if its a expression col.
852 Also, modified the queries to match the generated queries in ms.net
854 - Modifed Prepare, to check if Parameter is explicitly initialized
856 - Added CheckIfInitialized : Checks if datatype is explicitly set and
857 non-zero size is set for variable datatypes.
859 - Added code for GetSqlBinary ()
860 - Fixed GetFieldCount ()
861 - Added more checks and exceptions.
863 2006-01-17 Senganal T <tsenganal@novell.com>
865 * SqlCommandBuilder.cs
866 - Modified CreateNewCommand () : Clean up any existing parameter list
867 before reusing the command.Fixes #77225
869 2005-11-24 Senganal T <tsenganal@novell.com>
872 - Modifications to get the correct Packet Size
874 2005-11-21 Senganal T <tsenganal@novell.com>
876 * SqlClientFactory.cs
877 * SqlCommandBuilder.cs
878 * SqlParameterCollection.cs
884 Added stubs and other changes for ADO.NET 2.0 compatibility
886 2005-11-12 Gonzalo Paniagua Javier <gonzalo@ximian.com>
888 * SqlConnection.cs: don't throw NotImplementedException when using
889 'PERSIST SECUTIRY INFO'. Just do nothing.
891 2005-10-27 Senganal T <tsenganal@novell.com>
896 Made changes so that the number of rows affected can be got directly from
897 Tds regardsless of the type of query.Fixes bug #75698
899 2005-10-19 Senganal T <tsenganal@novell.com>
901 * SqlConnection.cs (SetProperties) :
902 - Added support for AttachDBFileName
904 2005-10-19 Senganal T <tsenganal@novell.com>
906 * SqlException.cs (Constructor)
907 - Modified the constructor, so that the message parameter
908 of base class is not the same as that of the Exception message.
911 2005-09-24 Sureshkumar T <tsureshkumar@novell.com>
913 * SqlParameterCollection.cs (AddWithValue): added method. patch
914 from awaddell@fnfr.com (Andy Waddell).
916 2005-09-21 Senganal T <tsenganal@novell.com>
920 - Set the correct Default Values for Parameters.
921 - Added Argument Checks (where missing) for the Properties and
922 throw the correct exception on error.
923 - Modified SetDefaultParameters() to make sure that the parameters
924 are all reset to default values everytime it is called.
925 - Modified SetProperties() to take into account the order of the
926 keywords in the ConnectionString.
928 SqlConnection Fixes for the failing sqlserver connected-mode testcases
929 in ProviderTest/System.Data.SqlClient/SqlConnectionTest.cs
931 2005-09-21 Senganal T <tsenganal@novell.com>
933 * SqlTransaction.cs : Modifed the Rollback() method, so that
934 connection can be used for another transaction after the previous
935 transaction is rolled back. fixes bug 75904
937 2005-09-02 Umadevi S <sumadevi@novell.com>
939 * Removed SqlResultSet.cs file
941 2005-08-26 Sureshkumar T <tsureshkumar@novell.com>
943 * SqlConnection.cs (Open): enable sp_reset_connection.
945 2005-08-25 Sureshkumar T <tsureshkumar@novell.com>
947 * SqlCommandBuilder.cs: BuildInformation (): continue on columns
948 who don't have basetablename.
950 2005-08-12 Daniel Morgan <danielmorgan@verizon.net>
952 * SqlCommandBuilder.cs: update command builder based on
953 OdbcCommandBuilder latest changes to fix regression
956 2005-08-05 Sureshkumar T <tsureshkumar@novell.com>
958 * SqlCommandBuilder.cs: Set SourceVersion property to the created
959 parameters as it is used by the Adapter's Update method.
961 2005-07-22 Sureshkumar T <tsureshkumar@novell.com>
963 * SqlCommandBuilder.cs, SqlParameterCollection.cs,
964 SqlConnection.cs, SqlParameter.cs:
965 - updated attributes & attribute descriptions to match with
968 2005-07-16 Daniel Morgan <danielmorgan@verizon.net>
970 * SqlCommandBuilder.cs: CreateUpdateCommand should get the current value, not
971 the orginal value when setting one of the SET variables
973 2005-07-15 Sureshkumar T <tsureshkumar@novell.com>
975 * SqlCommandBuilder.cs:
976 - set_DataAdapter: unsubscribe event if DataAdapter is reset.
977 - CreateInsertCommand, CreateUpdateCommand, CreateDeleteCommand:
978 if column mapping is missing, use the source column name. use
979 proper version to get the data.
980 - RowUpdatingHandler: set status to continue to actually process
983 2005-07-04 Ben Maurer <bmaurer@ximian.com>
985 * SqlError.cs: Patch from dezelin@gmail.com to fix serialization.
987 2005-06-29 Sureshkumar T <tsureshkumar@novell.com>
989 * SqlConnection.cs: Open (): catch TdsInternalException and throw
991 * SqlException.cs: code re-organised to pass message as well with
994 2005-06-23 Sureshkumar T <tsureshkumar@novell.com>
996 * SqlConnectionStringBuilder.cs: simplified multiple keyword
997 mappings and allowed-key checking. fixed Item, Remove,
998 ContainsKey, ShoudSerialize, TryGetValue implementations.
1000 2005-06-21 Sureshkumar T <tsureshkumar@novell.com>
1002 * SqlConnectionStringBuilder.cs: Connection String Builder class
1003 for SqlClient Data Provider.
1005 2005-06-01 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1007 * SqlParameter.cs: moved the 'using S.D.SqlTypes' out of NET_2_0. Fixes
1010 2005-06-01 Sureshkumar T <tsureshkumar@novell.com>
1012 * SqlParameter.cs: Parameter's value can be SqlTypes. Convert to
1013 framework type to pass to TDS layer. Fixes bug #75044.
1015 2005-05-24 Umadevi S <sumadevi@novell.com>
1016 * fixed some 2.0 and 1.0 specific fields/attributes for various classes.
1017 * Added SqlClientMetaDataCollectionNames.cs, Implemented some 2.0
1018 properties for SqlParameterCollection for the bulkcopy feature.
1021 2005-05-20 Kornél Pál <http://www.kornelpal.hu/>
1023 * Fixed Bug #53169 - SqlDataReader incorrectly returns bigint as decimal
1024 Note: The fix works around the limitations of TDS 7.0 to avoid this
1025 difference between Mono and .NET Framework TDS 8.0 should be used instead.
1027 2005-05-20 Umadevi S <sumadevi@novell.com>
1029 * Fixed Bug 74948 - SqlParameter also takes DBNull Value.
1030 Correct some attributes stuff of 1.1 and 2.0 for SqlParameter.cs
1032 2005-05-20 Umadevi S <sumadevi@novell.com>
1034 * Continuing on implementation for bulkcopy and notification
1035 Added files SqlNotificationEventArgs.cs, OnChangeEventHandler.cs
1036 Modified SqlRowUpdatingEventArgs.cs
1038 2005-05-19 Umadevi S <sumadevi@novell.com>
1040 * For implementation of bulkcopy and notifications added files
1041 SqlBulkCopyOptions.cs,SqlBulkCopyColumnMapping.cs,SqlNotificationAuthType.cs
1042 SqlNotificationTransports.cs,SqlRowsCopiedEventArgs.cs, SqlRowsCopiedEventHandler.cs
1044 2005-05-19 Umadevi S <sumadevi@novell.com>
1046 * Corrected types,enum values of SqlNotificationType,SqlNotificationSource,
1047 SqlNotificationInfo and added new method in SqlRowUpdatingEventArgs.cs
1048 (For implementation of bulkcopy/notifications)
1050 2005-04-19 Sureshkumar T <tsureshkumar@novell.com>
1052 * SqlDataReader.cs: NextResult (): Re-create schema table for each
1053 result set. don't re-use, as it may be referenced from somewhere.
1055 2005-04-07 Sureshkumar T <tsureshkumar@novell.com>
1056 Ankit Jain <radical@corewars.org>
1058 * SqlConnection.cs: Implemented additional connection string
1059 property "Asynchronous Processing".
1061 * SqlCommand.cs: Implemented Asynchronous command execution API.
1063 * SqlAsyncState.cs: A internal state object for asynchronous
1066 * SqlAsyncResult.cs: Added. Class to hold result for asynchronous
1069 2005-03-28 Sureshkumar T <tsureshkumar@novell.com>
1071 * SqlCommand.cs: Execute: Add a semicolon at the end of
1072 CommandText. Multiple semicolon's are not being complained.
1076 2005-03-11 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1078 * SqlConnection.cs: added a finalizer for correct implementation of the
1079 IDisposable pattern.
1081 2005-03-11 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1083 * SqlException.cs: make it serialization-compatible with MS. Patch by
1084 Aleksandar Dezelin. Closes bug #73596.
1086 2005-03-08 Sureshkumar T <tsureshkumar@novell.com>
1088 * SqlDataReader.cs: Call base constructor with CommandBehavior
1089 parameter instead of passing DbCommand object. The internal base
1090 class with DbCommand Parameter is removed.
1092 2005-03-07 Sureshkumar T <tsureshkumar@novell.com>
1094 * SqlCommand.cs : Set CommandBehavior on
1095 ExecuteReader,ExecuteScalar,ExecuteNonQuery. This is used in
1098 This fixes bug #73252.
1100 2005-03-03 Sureshkumar T <tsureshkumar@novell.com>
1102 * SqlClientFactory.cs: While creating command, create using
1103 DbConnectionFactory as DbConnectionBase.CreateDbCommand needs to
1104 have a connection factory.
1106 * SqlConnection.cs: Added an internal constructor which takes
1107 DbConnectionFactory.
1109 * SqlConnectionFactory.cs: Added. Concrete class for abstract
1110 factory DbConnectionFactory.
1112 2005-02-22 Sureshkumar T <tsureshkumar@novell.com>
1114 * SqlDataReader.cs: GetBytes: return the length of the data if
1115 output buffer is null. if not, copy the values to buffer and
1116 return the bytes actually read.
1118 2005-02-02 Sureshkumar T <tsureshkumar@novell.com>
1121 - Database: return db name from database if connection open,
1122 otherwise take from connection string.
1123 - Set default values for parameters in the constructor itself.
1124 - Dangling else problem with Close method.
1125 - reset values of parms (TdsConnectionParameters) rather setting
1127 - set disposed to false in Open method
1128 - finally call base.Dispose in Dispose (bool)
1130 Fixes nunit regressions SqlConnectionTest:DefaultConnectionValues
1131 and SqlConnectionTest:DatabaseSynonyms.
1133 2005-01-27 Sureshkumar T <tsureshkumar@novell.com>
1135 * SqlCommand.cs (DeriveParameters): Change parameter name to
1137 * SqlParameter.cs (SqlParameter (object [])) : call default
1138 constructor to create Tds.Metaparameter.
1142 2005-01-03 Sureshkumar T <tsureshkumar@novell.com>
1144 * SqlCommand.cs: Fixed bug #68973. Reset Tds.RecordsAffected to 0
1145 for each execute statement.
1147 2004-11-25 Sureshkumar T <tsureshkumar@novell.com>
1149 These changes are for 2.0 profile only. These changes implement
1150 the generic data base access technique using Provider Factory
1151 Implementation. These classes need to be dervided from abstract
1152 base classes so that the corresponding factory classes are
1153 created when calling CreateCommand, CreateParameter, etc.
1155 * SqlClientFactory.cs: Provider Factory class Implementaion for SqlServer
1156 * SqlParameter.cs: Change base classes and override methods.
1157 * SqlParameterCollection.cs: Change base classes and override methods.
1158 * SqlTransaction.cs: Change base classes and override methods.
1159 * SqlDataSourceEnumerator.cs: DataSource Enumerator stubs.
1160 * SqlDataReader.cs: Change base classes and override methods.
1161 * SqlConnection.cs: Change base classes and override methods.
1162 * SqlCommandBuilder.cs: Change base classes and override methods.
1163 * SqlCommand.cs: Change base classes and override necessary methods.
1165 2004-10-14 Umadevi S <sumadevi@novell.com>
1166 * SqlCommand.cs - Implemented the clone method correctly.
1169 2004-10-06 Umadevi S <sumadevi@novell.com>
1170 * ISqlNoticationReceiver.cs - changed namespace
1171 * Added files SqlNotificationType.cs, SqlNotificationInfo.cs, SqlNotificationSource.cs
1173 2004-09-24 Umadevi S <sumadevi@novell.com>
1174 * SqlTransaction.cs - Dispose will not call rollback incase the transaction is not open.
1176 2004-09-14 Sebastien Pouliot <sebastien@ximian.com>
1178 * SqlClientPermission.cs: Added internal constructor accepting an Sql
1179 ClientPermissionAttribute parameter (using base class protected ctor).
1180 * SqlClientPermissionAttribute.cs: Copy now use the new SqlClient
1181 Permission constructor.
1183 2004-09-13 Sebastien Pouliot <sebastien@ximian.com>
1185 * SqlClientPermission.cs: Mostly completed (needs tests).
1186 * SqlClientPermissionAttribute.cs: Completed.
1188 2004-09-02 Umadevi S <sumadevi@novell.com>
1189 * SqlCommand.cs - ExecuteNonQuery to return -1 incase of executing a storedprocedure
1191 2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
1193 * SqlConnection.cs: added TODO on ConnectionString for keywords
1194 that are not yet implemented. check value of Integrated Security
1195 keyword, check value of bool keywords, improve error reporting
1196 for int keywords, added support for the following keyword
1197 synonyms : APP, TIMEOUT, NETWORK, PERSISTSECURITYINFO, WSID,
1198 LANGUAGE, USER. Throw NotImplementedException when encrypt keyword
1199 is set to true, enlist keyword is set to false or attachdbfilename
1200 keyword (or one of its synonyms) is set. Added FIXME for PERSIST
1201 SECURITY INFO keyword, throwing a NotImplementedException here
1202 would break lots of apps
1204 2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
1206 * SqlConnection.cs - spaces to tabs
1208 2004-08-12 Sureshkumar T <tsureshkumar@novell.com>
1209 * SqlDataReader.cs - In Close method, the remaining resultsets are drained
1210 out, to read output parameters & to avoid stream overlap
1212 2004-06-30 Umadevi S <sumadevi@novell.com>
1213 * SqlCommand.cs : In the Execute Method the commandbehavior parameters were ignored correct
1216 2004-06-22 Atsushi Enomoto <atsushi@ximian.com>
1218 * SqlCommandBuilder.cs : Avoid cast exception caused by DbNull.
1220 2004-06-18 Umadevi S <sumadevi@novell.com>
1221 * SqlCommand.cs - ExecuteNonQuery returns -1 in all cases except
1222 insert,update or delete.
1224 2004-06-18 Umadevi S <sumadevi@novell.com>
1225 * SqlConnection.cs - handled null being passed as a connectionstring
1226 - checked for minimal set of parameters in connectionstring.
1227 - handled unrecogonized keywords similar to MS.NET
1229 2004-06-17 Umadevi S <sumadevi@novell.com>
1230 * SqlTransaction.cs - fixed multiple rollbacks being called causes invalidoperationexception
1232 2004-06-04 Gert Driesen <drieseng@users.sourceforge.net>
1234 * SqlClientPermission.cs: removed extra CreateInstance
1237 2004-06-02 Gert Driesen <drieseng@users.sourceforge.net>
1239 * SQLDebugging.cs: added missing attributes, marked ctor
1240 public to match MS.NET
1242 2004-05-22 Atsushi Enomoto <atsushi@ximian.com>
1244 * SqlClientPermission.cs : don't use chained obsolete .ctor.
1246 2004-05-20 Gert Driesen (drieseng@users.sourceforge.net)
1248 * SqlClientPermissionAttribute.cs: change AllowMultiple and
1249 Inherited to match .NET
1251 2004-05-20 Umadevi S <sumadevi@novell.com>
1253 * Fixed bug 58406- implemented the hasrow method, test program used
1254 to test with the bug report
1256 2004-05-13 Umadevi S <sumadevi@novell.com>
1258 * SqlClientPermission.cs, SqlDataReader.cs - added missing methods with TODO tags
1259 * SqlCommand.cs, SqlDataAdapter.cs - implemented ToolboxItemAttribute
1260 * SQLDebugging.cs - Added new file with a TODO tag
1262 2004-04-05 Lluis Sanchez Gual <lluis@ximian.com>
1264 * SqlConnection.cs: Use connection pool implemented in Mono.Data.Tds.
1266 2004-04-01 Lluis Sanchez Gual <lluis@ximian.com>
1268 * SqlDataReader.cs: Null values are now represented with DBNull instances.
1271 2004-03-14 Tim Coleman <tim@timcoleman.com>
1272 * SqlCommand.cs SqlConnection.cs:
1273 Changes from two patches by Andres Taylor
1274 <andres@rotselleri.com>
1276 2004-03-12 Andreas Nahr <ClassDevelopment@A-SoftTech.com>
1278 * SqlParameter.cs: DO NOT USE the consts scheme if types can be referenced directly!
1280 2004-01-10 Atsushi Enomoto <atsushi@ximian.com>
1282 * SqlClientPermission.cs : Fixed NET_2_0 build related to
1283 obsolete attribute problem (see DbDataPermission.cs)
1285 2003-12-28 Tim Coleman <tim@timcoleman.com>
1287 Stubbed out this class.
1289 2003-12-23 Tim Coleman <tim@timcoleman.com>
1291 Improved connection string parsing. See
1292 System.Data.Common.DbConnectionString for source.
1294 2003-12-21 Tim Coleman <tim@timcoleman.com>
1296 Enable Integrated Security
1298 2003-12-19 Tim Coleman <tim@timcoleman.com>
1299 * ISqlNotificationReceiver.cs SqlResultSet.cs:
1301 * SqlClientPermission.cs:
1302 Fix constructor for 1.2
1304 2003-12-04 John Luke <jluke@cfl.rr.com>
1306 * SqlXmlTextReader.cs: applied patch from Chris Masters <neeeeeep@bigpond.com>
1307 fix peek so it checks if it is at the end and also to make sure that if Read()
1308 advances the position past the end of the localBuffer array, it makes
1309 a call to GetNextBuffer(). fixes bug #40253 System.IndexOutOfRangeException when
1310 using SqlCommand.ExecuteXmlReader()
1312 2003-11-20 Joerg Rosenkranz <JoergR@voelcker.com>
1314 * SqlConnection (SetDefaultConnectionParameters):
1315 Changed default value of WORKSTATION ID to reflect real
1316 host name instead of "localhost".
1318 2003-11-16 Ben Maurer <bmaurer@users.sourceforge.net>
1320 * SqlParameterCollection.cs (Clear): Clear needs to take
1321 the parameter out of the collection so that it can be used
1326 2003-10-03 Diego Caravana <diego@toth.it>
1328 * SqlCommand.cs: no change.
1330 * SqlConnection.cs (Close): Added checks for null instance
1333 * SqlParameter.cs (Direction): Now handles parameters of type
1334 ReturnValue and InputOutput.
1336 * SqlParameterCollection.cs (IndexOf(string)): Search for
1337 SqlParameter object in list is done by obtaining ParameterName
1338 attribute, not directly through list.IndexOf().
1340 2003-08-22 Duncan Mak <duncan@ximian.com>
1342 * SqlCommand.cs (ExecuteNonQuery): Return
1343 Connection.Tds.RecordsAffected if it is successful. Patch from
1344 Jörg Rosenkranz <joergr@voelcker.com>.
1346 This is part of a fix to bug #40315.
1348 2003-08-20 Duncan Mak <duncan@ximian.com>
1350 * SqlConnectionPool.cs (ReleaseConnection): A patch from Joerg
1351 Rosenkranz <JoergR@voelcker.com>. Currently, if a connection is
1352 closed by an external event (network problem, etc.) it is pushed
1353 back into the connection pool. The next Open call retrieves this
1354 invalid connection which leads to exceptions when executing
1357 This patch fixes this problem. This closes bug #47429.
1359 2003-07-04 Miguel de Icaza <miguel@ximian.com>
1361 * SqlDataReader.cs: Added extra information to the exceptions
1362 thrown by all the GetXXXX methods.
1364 2003-03-15 Daniel Morgan <danmorg@sc.rr.com>
1366 * SqlConnection.cs: if Server in the ConnectionString
1367 is set to "(local", use "localhost" as the hostname
1370 2003-03-04 Gonzalo Paniagua Javier <gonzalo@ximian.com>
1372 * SqlException.cs: implemented GetObjectData ().
1374 2003-02-16 Daniel Morgan <danmorg@sc.rr.com>
1376 * ChangeLog: added this file
1378 * SqlConnection.cs: - parse data source for 3 possible uses:
1380 "Server=hostname\\instancename",
1381 "Server=hostname,port" and open the connection based on the
1382 resulting server name and port.
1383 - Added support for named instances
1384 by discovery of the sql server tcp port via the sql monitor (udp port 1434)
1385 thanks to Phillip Jerkins (Phillip.Jerkins@morgankeegan.com) contribution.
1386 Also, thanks to Gonzalo and Tim for their help with timeouts.