1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
|
2006-02-17 Chris Toshok <toshok@ximian.com>
* SqlCommand.cs, SqlCommandBuilder.cs, SqlConnection.cs,
SqlDataAdapter.cs: remove DataSysDescription attributes for >= 2.0
2006-02-17 Chris Toshok <toshok@ximian.com>
* SqlDataReader.cs: remove VisibleFieldCount property.
2006-02-10 Senganal T <tsenganal@novell.com>
* SqlDataReader.cs :
- GetBytes : Read binary/blob/clob data sequentially when
CommandBehavior is set to SequentialAcccess
- GetChars : Read String/clob data sequentially when CommandBehavior
is set to SequentialAccess
* SqlCommand.cs :
- ExecuteReader : set SequentialAccess property on TDS
- CloseDataReader : Reset the command behavior
2006-01-27 Senganal T <tsenganal@novell.com>
* SqlCommandBuilder.cs :
- Modified CreateUpdateCommand,CreateDeleteCommand , to not include
column name in the query if its a expression col.
Also, modified the queries to match the generated queries in ms.net
* SqlCommand.cs :
- Modifed Prepare, to check if Parameter is explicitly initialized
* SqlParameter.cs :
- Added CheckIfInitialized : Checks if datatype is explicitly set and
non-zero size is set for variable datatypes.
* SqlDataReader.cs :
- Added code for GetSqlBinary ()
- Fixed GetFieldCount ()
- Added more checks and exceptions.
2006-01-17 Senganal T <tsenganal@novell.com>
* SqlCommandBuilder.cs
- Modified CreateNewCommand () : Clean up any existing parameter list
before reusing the command.Fixes #77225
2005-11-24 Senganal T <tsenganal@novell.com>
* SqlConnection.cs
- Modifications to get the correct Packet Size
2005-11-21 Senganal T <tsenganal@novell.com>
* SqlClientFactory.cs
* SqlCommandBuilder.cs
* SqlParameterCollection.cs
* SqlDataReader.cs
* SqlDataAdapter.cs
* SqlParameter.cs
* SqlTransaction.cs
Added stubs and other changes for ADO.NET 2.0 compatibility
2005-11-12 Gonzalo Paniagua Javier <gonzalo@ximian.com>
* SqlConnection.cs: don't throw NotImplementedException when using
'PERSIST SECUTIRY INFO'. Just do nothing.
2005-10-27 Senganal T <tsenganal@novell.com>
* SqlCommand.cs
* SqlDataReader.cs
Made changes so that the number of rows affected can be got directly from
Tds regardsless of the type of query.Fixes bug #75698
2005-10-19 Senganal T <tsenganal@novell.com>
* SqlConnection.cs (SetProperties) :
- Added support for AttachDBFileName
2005-10-19 Senganal T <tsenganal@novell.com>
* SqlException.cs (Constructor)
- Modified the constructor, so that the message parameter
of base class is not the same as that of the Exception message.
fixes bug #76468
2005-09-24 Sureshkumar T <tsureshkumar@novell.com>
* SqlParameterCollection.cs (AddWithValue): added method. patch
from awaddell@fnfr.com (Andy Waddell).
2005-09-21 Senganal T <tsenganal@novell.com>
* SqlConnection.cs :
- Set the correct Default Values for Parameters.
- Added Argument Checks (where missing) for the Properties and
throw the correct exception on error.
- Modified SetDefaultParameters() to make sure that the parameters
are all reset to default values everytime it is called.
- Modified SetProperties() to take into account the order of the
keywords in the ConnectionString.
SqlConnection Fixes for the failing sqlserver connected-mode testcases
in ProviderTest/System.Data.SqlClient/SqlConnectionTest.cs
2005-09-21 Senganal T <tsenganal@novell.com>
* SqlTransaction.cs : Modifed the Rollback() method, so that
connection can be used for another transaction after the previous
transaction is rolled back. fixes bug 75904
2005-09-02 Umadevi S <sumadevi@novell.com>
* Removed SqlResultSet.cs file
2005-08-26 Sureshkumar T <tsureshkumar@novell.com>
* SqlConnection.cs (Open): enable sp_reset_connection.
2005-08-25 Sureshkumar T <tsureshkumar@novell.com>
* SqlCommandBuilder.cs: BuildInformation (): continue on columns
who don't have basetablename.
2005-08-12 Daniel Morgan <danielmorgan@verizon.net>
* SqlCommandBuilder.cs: update command builder based on
OdbcCommandBuilder latest changes to fix regression
of bug 75552
2005-08-05 Sureshkumar T <tsureshkumar@novell.com>
* SqlCommandBuilder.cs: Set SourceVersion property to the created
parameters as it is used by the Adapter's Update method.
2005-07-22 Sureshkumar T <tsureshkumar@novell.com>
* SqlCommandBuilder.cs, SqlParameterCollection.cs,
SqlConnection.cs, SqlParameter.cs:
- updated attributes & attribute descriptions to match with
masterinfos.
2005-07-16 Daniel Morgan <danielmorgan@verizon.net>
* SqlCommandBuilder.cs: CreateUpdateCommand should get the current value, not
the orginal value when setting one of the SET variables
2005-07-15 Sureshkumar T <tsureshkumar@novell.com>
* SqlCommandBuilder.cs:
- set_DataAdapter: unsubscribe event if DataAdapter is reset.
- CreateInsertCommand, CreateUpdateCommand, CreateDeleteCommand:
if column mapping is missing, use the source column name. use
proper version to get the data.
- RowUpdatingHandler: set status to continue to actually process
the query.
2005-07-04 Ben Maurer <bmaurer@ximian.com>
* SqlError.cs: Patch from dezelin@gmail.com to fix serialization.
2005-06-29 Sureshkumar T <tsureshkumar@novell.com>
* SqlConnection.cs: Open (): catch TdsInternalException and throw
SqlException.
* SqlException.cs: code re-organised to pass message as well with
the exception.
2005-06-23 Sureshkumar T <tsureshkumar@novell.com>
* SqlConnectionStringBuilder.cs: simplified multiple keyword
mappings and allowed-key checking. fixed Item, Remove,
ContainsKey, ShoudSerialize, TryGetValue implementations.
2005-06-21 Sureshkumar T <tsureshkumar@novell.com>
* SqlConnectionStringBuilder.cs: Connection String Builder class
for SqlClient Data Provider.
2005-06-01 Gonzalo Paniagua Javier <gonzalo@ximian.com>
* SqlParameter.cs: moved the 'using S.D.SqlTypes' out of NET_2_0. Fixes
the build.
2005-06-01 Sureshkumar T <tsureshkumar@novell.com>
* SqlParameter.cs: Parameter's value can be SqlTypes. Convert to
framework type to pass to TDS layer. Fixes bug #75044.
2005-05-24 Umadevi S <sumadevi@novell.com>
* fixed some 2.0 and 1.0 specific fields/attributes for various classes.
* Added SqlClientMetaDataCollectionNames.cs, Implemented some 2.0
properties for SqlParameterCollection for the bulkcopy feature.
2005-05-20 Kornél Pál <http://www.kornelpal.hu/>
* Fixed Bug #53169 - SqlDataReader incorrectly returns bigint as decimal
Note: The fix works around the limitations of TDS 7.0 to avoid this
difference between Mono and .NET Framework TDS 8.0 should be used instead.
2005-05-20 Umadevi S <sumadevi@novell.com>
* Fixed Bug 74948 - SqlParameter also takes DBNull Value.
Correct some attributes stuff of 1.1 and 2.0 for SqlParameter.cs
2005-05-20 Umadevi S <sumadevi@novell.com>
* Continuing on implementation for bulkcopy and notification
Added files SqlNotificationEventArgs.cs, OnChangeEventHandler.cs
Modified SqlRowUpdatingEventArgs.cs
2005-05-19 Umadevi S <sumadevi@novell.com>
* For implementation of bulkcopy and notifications added files
SqlBulkCopyOptions.cs,SqlBulkCopyColumnMapping.cs,SqlNotificationAuthType.cs
SqlNotificationTransports.cs,SqlRowsCopiedEventArgs.cs, SqlRowsCopiedEventHandler.cs
2005-05-19 Umadevi S <sumadevi@novell.com>
* Corrected types,enum values of SqlNotificationType,SqlNotificationSource,
SqlNotificationInfo and added new method in SqlRowUpdatingEventArgs.cs
(For implementation of bulkcopy/notifications)
2005-04-19 Sureshkumar T <tsureshkumar@novell.com>
* SqlDataReader.cs: NextResult (): Re-create schema table for each
result set. don't re-use, as it may be referenced from somewhere.
2005-04-07 Sureshkumar T <tsureshkumar@novell.com>
Ankit Jain <radical@corewars.org>
* SqlConnection.cs: Implemented additional connection string
property "Asynchronous Processing".
* SqlCommand.cs: Implemented Asynchronous command execution API.
* SqlAsyncState.cs: A internal state object for asynchronous
operations.
* SqlAsyncResult.cs: Added. Class to hold result for asynchronous
queries.
2005-03-28 Sureshkumar T <tsureshkumar@novell.com>
* SqlCommand.cs: Execute: Add a semicolon at the end of
CommandText. Multiple semicolon's are not being complained.
fixes bug #74134.
2005-03-11 Gonzalo Paniagua Javier <gonzalo@ximian.com>
* SqlConnection.cs: added a finalizer for correct implementation of the
IDisposable pattern.
2005-03-11 Gonzalo Paniagua Javier <gonzalo@ximian.com>
* SqlException.cs: make it serialization-compatible with MS. Patch by
Aleksandar Dezelin. Closes bug #73596.
2005-03-08 Sureshkumar T <tsureshkumar@novell.com>
* SqlDataReader.cs: Call base constructor with CommandBehavior
parameter instead of passing DbCommand object. The internal base
class with DbCommand Parameter is removed.
2005-03-07 Sureshkumar T <tsureshkumar@novell.com>
* SqlCommand.cs : Set CommandBehavior on
ExecuteReader,ExecuteScalar,ExecuteNonQuery. This is used in
CloseDataReader.
This fixes bug #73252.
2005-03-03 Sureshkumar T <tsureshkumar@novell.com>
* SqlClientFactory.cs: While creating command, create using
DbConnectionFactory as DbConnectionBase.CreateDbCommand needs to
have a connection factory.
* SqlConnection.cs: Added an internal constructor which takes
DbConnectionFactory.
* SqlConnectionFactory.cs: Added. Concrete class for abstract
factory DbConnectionFactory.
2005-02-22 Sureshkumar T <tsureshkumar@novell.com>
* SqlDataReader.cs: GetBytes: return the length of the data if
output buffer is null. if not, copy the values to buffer and
return the bytes actually read.
2005-02-02 Sureshkumar T <tsureshkumar@novell.com>
* SqlConnection.cs:
- Database: return db name from database if connection open,
otherwise take from connection string.
- Set default values for parameters in the constructor itself.
- Dangling else problem with Close method.
- reset values of parms (TdsConnectionParameters) rather setting
to null.
- set disposed to false in Open method
- finally call base.Dispose in Dispose (bool)
Fixes nunit regressions SqlConnectionTest:DefaultConnectionValues
and SqlConnectionTest:DatabaseSynonyms.
2005-01-27 Sureshkumar T <tsureshkumar@novell.com>
* SqlCommand.cs (DeriveParameters): Change parameter name to
"procedure_name".
* SqlParameter.cs (SqlParameter (object [])) : call default
constructor to create Tds.Metaparameter.
fixes bug #63122.
2005-01-03 Sureshkumar T <tsureshkumar@novell.com>
* SqlCommand.cs: Fixed bug #68973. Reset Tds.RecordsAffected to 0
for each execute statement.
2004-11-25 Sureshkumar T <tsureshkumar@novell.com>
These changes are for 2.0 profile only. These changes implement
the generic data base access technique using Provider Factory
Implementation. These classes need to be dervided from abstract
base classes so that the corresponding factory classes are
created when calling CreateCommand, CreateParameter, etc.
* SqlClientFactory.cs: Provider Factory class Implementaion for SqlServer
* SqlParameter.cs: Change base classes and override methods.
* SqlParameterCollection.cs: Change base classes and override methods.
* SqlTransaction.cs: Change base classes and override methods.
* SqlDataSourceEnumerator.cs: DataSource Enumerator stubs.
* SqlDataReader.cs: Change base classes and override methods.
* SqlConnection.cs: Change base classes and override methods.
* SqlCommandBuilder.cs: Change base classes and override methods.
* SqlCommand.cs: Change base classes and override necessary methods.
2004-10-14 Umadevi S <sumadevi@novell.com>
* SqlCommand.cs - Implemented the clone method correctly.
(fixed bug 67301)
2004-10-06 Umadevi S <sumadevi@novell.com>
* ISqlNoticationReceiver.cs - changed namespace
* Added files SqlNotificationType.cs, SqlNotificationInfo.cs, SqlNotificationSource.cs
2004-09-24 Umadevi S <sumadevi@novell.com>
* SqlTransaction.cs - Dispose will not call rollback incase the transaction is not open.
2004-09-14 Sebastien Pouliot <sebastien@ximian.com>
* SqlClientPermission.cs: Added internal constructor accepting an Sql
ClientPermissionAttribute parameter (using base class protected ctor).
* SqlClientPermissionAttribute.cs: Copy now use the new SqlClient
Permission constructor.
2004-09-13 Sebastien Pouliot <sebastien@ximian.com>
* SqlClientPermission.cs: Mostly completed (needs tests).
* SqlClientPermissionAttribute.cs: Completed.
2004-09-02 Umadevi S <sumadevi@novell.com>
* SqlCommand.cs - ExecuteNonQuery to return -1 incase of executing a storedprocedure
2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
* SqlConnection.cs: added TODO on ConnectionString for keywords
that are not yet implemented. check value of Integrated Security
keyword, check value of bool keywords, improve error reporting
for int keywords, added support for the following keyword
synonyms : APP, TIMEOUT, NETWORK, PERSISTSECURITYINFO, WSID,
LANGUAGE, USER. Throw NotImplementedException when encrypt keyword
is set to true, enlist keyword is set to false or attachdbfilename
keyword (or one of its synonyms) is set. Added FIXME for PERSIST
SECURITY INFO keyword, throwing a NotImplementedException here
would break lots of apps
2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
* SqlConnection.cs - spaces to tabs
2004-08-12 Sureshkumar T <tsureshkumar@novell.com>
* SqlDataReader.cs - In Close method, the remaining resultsets are drained
out, to read output parameters & to avoid stream overlap
2004-06-30 Umadevi S <sumadevi@novell.com>
* SqlCommand.cs : In the Execute Method the commandbehavior parameters were ignored correct
these
2004-06-22 Atsushi Enomoto <atsushi@ximian.com>
* SqlCommandBuilder.cs : Avoid cast exception caused by DbNull.
2004-06-18 Umadevi S <sumadevi@novell.com>
* SqlCommand.cs - ExecuteNonQuery returns -1 in all cases except
insert,update or delete.
2004-06-18 Umadevi S <sumadevi@novell.com>
* SqlConnection.cs - handled null being passed as a connectionstring
- checked for minimal set of parameters in connectionstring.
- handled unrecogonized keywords similar to MS.NET
2004-06-17 Umadevi S <sumadevi@novell.com>
* SqlTransaction.cs - fixed multiple rollbacks being called causes invalidoperationexception
2004-06-04 Gert Driesen <drieseng@users.sourceforge.net>
* SqlClientPermission.cs: removed extra CreateInstance
method
2004-06-02 Gert Driesen <drieseng@users.sourceforge.net>
* SQLDebugging.cs: added missing attributes, marked ctor
public to match MS.NET
2004-05-22 Atsushi Enomoto <atsushi@ximian.com>
* SqlClientPermission.cs : don't use chained obsolete .ctor.
2004-05-20 Gert Driesen (drieseng@users.sourceforge.net)
* SqlClientPermissionAttribute.cs: change AllowMultiple and
Inherited to match .NET
2004-05-20 Umadevi S <sumadevi@novell.com>
* Fixed bug 58406- implemented the hasrow method, test program used
to test with the bug report
2004-05-13 Umadevi S <sumadevi@novell.com>
* SqlClientPermission.cs, SqlDataReader.cs - added missing methods with TODO tags
* SqlCommand.cs, SqlDataAdapter.cs - implemented ToolboxItemAttribute
* SQLDebugging.cs - Added new file with a TODO tag
2004-04-05 Lluis Sanchez Gual <lluis@ximian.com>
* SqlConnection.cs: Use connection pool implemented in Mono.Data.Tds.
2004-04-01 Lluis Sanchez Gual <lluis@ximian.com>
* SqlDataReader.cs: Null values are now represented with DBNull instances.
Deal with this.
2004-03-14 Tim Coleman <tim@timcoleman.com>
* SqlCommand.cs SqlConnection.cs:
Changes from two patches by Andres Taylor
<andres@rotselleri.com>
2004-03-12 Andreas Nahr <ClassDevelopment@A-SoftTech.com>
* SqlParameter.cs: DO NOT USE the consts scheme if types can be referenced directly!
2004-01-10 Atsushi Enomoto <atsushi@ximian.com>
* SqlClientPermission.cs : Fixed NET_2_0 build related to
obsolete attribute problem (see DbDataPermission.cs)
2003-12-28 Tim Coleman <tim@timcoleman.com>
* SqlResultSet.cs:
Stubbed out this class.
2003-12-23 Tim Coleman <tim@timcoleman.com>
* SqlConnection.cs:
Improved connection string parsing. See
System.Data.Common.DbConnectionString for source.
2003-12-21 Tim Coleman <tim@timcoleman.com>
* SqlConnection.cs:
Enable Integrated Security
2003-12-19 Tim Coleman <tim@timcoleman.com>
* ISqlNotificationReceiver.cs SqlResultSet.cs:
New stubs added
* SqlClientPermission.cs:
Fix constructor for 1.2
2003-12-04 John Luke <jluke@cfl.rr.com>
* SqlXmlTextReader.cs: applied patch from Chris Masters <neeeeeep@bigpond.com>
fix peek so it checks if it is at the end and also to make sure that if Read()
advances the position past the end of the localBuffer array, it makes
a call to GetNextBuffer(). fixes bug #40253 System.IndexOutOfRangeException when
using SqlCommand.ExecuteXmlReader()
2003-11-20 Joerg Rosenkranz <JoergR@voelcker.com>
* SqlConnection (SetDefaultConnectionParameters):
Changed default value of WORKSTATION ID to reflect real
host name instead of "localhost".
2003-11-16 Ben Maurer <bmaurer@users.sourceforge.net>
* SqlParameterCollection.cs (Clear): Clear needs to take
the parameter out of the collection so that it can be used
again.
(Remove):
(RemoveAt): Ditto.
2003-10-03 Diego Caravana <diego@toth.it>
* SqlCommand.cs: no change.
* SqlConnection.cs (Close): Added checks for null instance
variables.
* SqlParameter.cs (Direction): Now handles parameters of type
ReturnValue and InputOutput.
* SqlParameterCollection.cs (IndexOf(string)): Search for
SqlParameter object in list is done by obtaining ParameterName
attribute, not directly through list.IndexOf().
2003-08-22 Duncan Mak <duncan@ximian.com>
* SqlCommand.cs (ExecuteNonQuery): Return
Connection.Tds.RecordsAffected if it is successful. Patch from
Jörg Rosenkranz <joergr@voelcker.com>.
This is part of a fix to bug #40315.
2003-08-20 Duncan Mak <duncan@ximian.com>
* SqlConnectionPool.cs (ReleaseConnection): A patch from Joerg
Rosenkranz <JoergR@voelcker.com>. Currently, if a connection is
closed by an external event (network problem, etc.) it is pushed
back into the connection pool. The next Open call retrieves this
invalid connection which leads to exceptions when executing
statements.
This patch fixes this problem. This closes bug #47429.
2003-07-04 Miguel de Icaza <miguel@ximian.com>
* SqlDataReader.cs: Added extra information to the exceptions
thrown by all the GetXXXX methods.
2003-03-15 Daniel Morgan <danmorg@sc.rr.com>
* SqlConnection.cs: if Server in the ConnectionString
is set to "(local", use "localhost" as the hostname
to connect
2003-03-04 Gonzalo Paniagua Javier <gonzalo@ximian.com>
* SqlException.cs: implemented GetObjectData ().
2003-02-16 Daniel Morgan <danmorg@sc.rr.com>
* ChangeLog: added this file
* SqlConnection.cs: - parse data source for 3 possible uses:
"Server=hostname",
"Server=hostname\\instancename",
"Server=hostname,port" and open the connection based on the
resulting server name and port.
- Added support for named instances
by discovery of the sql server tcp port via the sql monitor (udp port 1434)
thanks to Phillip Jerkins (Phillip.Jerkins@morgankeegan.com) contribution.
Also, thanks to Gonzalo and Tim for their help with timeouts.
|