ChangeLog 34 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007
  1. 2007-10-17 Nagappan <[email protected]>
  2. * SqlConnection.cs: BeginTransaction does not handle
  3. IsolationLevel.Unspecified, so the default is set as ReadCommited.
  4. Thanks to Jerome Haltom <[email protected]> for this patch. Fixes
  5. bug # 333082.
  6. * SqlTransaction.cs: If transaction count is greater then 0 then roll back.
  7. Thanks to Jerome Haltom <[email protected]> for this patch. Fixes
  8. bug # 331953.
  9. 2007-10-15 Gert Driesen <[email protected]>
  10. * SqlException.cs: Do not hide Message on 2.0 profile. Fixes bug
  11. #333901.
  12. 2007-10-08 Marek Safar <[email protected]>
  13. * SqlParameterCollection.cs (SetParameter): Fixed missing cast.
  14. 2007-09-27 Nagappan A <[email protected]>
  15. * SqlConnection.cs: Added MonoTODO appropriately.
  16. 2007-09-26 Nagappan A <[email protected]>
  17. * SqlCommandBuilder.cs: Code alignment.
  18. 2007-09-25 Nagappan A <[email protected]>
  19. * SqlInitialCatalogConverter.cs, SqlDataSourceConverter.cs:
  20. NetworkLibraryConverter.cs: Added new files.
  21. * SqlParameter.cs: 2.0 attribute changes.
  22. * SqlDataAdapter.cs: 2.0 attribute changes.
  23. * SqlConnectionStringBuilder.cs: 2.0 attribute changes.
  24. * SqlConnection.cs (ClearAllPools, ClearPool): Implemented 2.0
  25. APIs, other 2.0 attribute changes.
  26. * SqlCommandBuilder.cs (GetSchemaTable, InitializeCommand):
  27. Implemented 2.0 APIs, other 2.0 attribute changes.
  28. * SqlBulkCopyColumnMappingCollection.cs: Added constructor, 2.0
  29. API compatibility changes.
  30. * SqlException.cs: 2.0 attribute changes.
  31. 2007-08-13 Nagappan A <[email protected]>
  32. * SqlConnection.cs (ConnectionString): 2.0 compatibility changes.
  33. * SqlDataReader.cs (IsCommandBehavior): Fixed spelling mistake of
  34. the method name.
  35. (Dispose): 2.0 compatibility changes.
  36. * SqlBulkCopy.cs (SqlRowsCopied): Fixed spelling mistake of the
  37. event name.
  38. (RowsCopied): Generates event when NotifyAfter is set.
  39. * SqlCommandBuilder.cs (Dispose, RefreshSchema): 2.0 compatibility
  40. changes.
  41. * SqlClientFactory.cs (CreateDataSourceEnumerator): Removed bogus
  42. TODO.
  43. * SqlException.cs (Message): 2.0 compatibility changes.
  44. 2007-08-06 Nagappan A <[email protected]>
  45. * SqlCommand.cs, SqlDataReader.cs, SqlConnection.cs: When the
  46. server resets the connection, now the client code also disconnects
  47. the session and remove the instance from pool. Fixes bug # 81933.
  48. 2007-07-31 Nagappan A <[email protected]>
  49. * SqlCommand.cs (Transaction, Connection): IDbCommand Transaction
  50. and Connection can be set to null. Fixes bug 82189.
  51. 2007-07-23 Nagappan A <[email protected]>
  52. * SqlCommandBuilder.cs (ApplyParameterInfo, GetParameterName):
  53. (GetParameterPlaceholder): Implemented 2.0 missing APIs.
  54. 2007-07-22 Nagappan A <[email protected]>
  55. * SqlBulkCopy.cs (NotifyAfter): Implemented 2.0 property.
  56. (GetColumnMetaData, GenerateColumnMetaData):
  57. (ValidateColumnMapping): Implemented private method's to generate
  58. and validate SqlBulkCopy headers.
  59. (BulkCopyToServer): Private method to actually do the bulk copy
  60. processing.
  61. (WriteToServer): Implemented 2.0 missing overloaded methods.
  62. (IDisposable.Dispose): Implemented 2.0 missing method.
  63. * SqlBulkCopyColumnMappingCollection.cs (Add, CopyTo): Implemented
  64. missing API.
  65. (Item): Implemented missing property.
  66. * SqlBulkCopyColumnMapping.cs: Modified the implementation of
  67. Constructors to use property.
  68. * SqlDataReader.cs (GetSqlXml, IsCommandBehaviour): Added 2.0
  69. missing method.
  70. (Connection): Added missing property.
  71. * SqlParameter.cs (SetSqlDbType, ConvertToFrameworkType): Modified
  72. method as internal from private.
  73. * SqlConnection.cs: Fixed 2.0 missing feature.
  74. * SqlException.cs: Fixed 2.0 missing feature.
  75. * SqlClientPermission.cs: Fixed 2.0 missing feature.
  76. 2007-07-01 Gert Driesen <[email protected]>
  77. * ISqlNotificationReceiver.cs: Removed.
  78. * SqlClientFactory.cs: Use SqlDataSourceEnumerator from S.D.Sql and
  79. marked method todo. Avoid unnessary casts. Code formatting.
  80. * SqlCommand.cs: Explicit interface implementation of IDbCommand not
  81. necessary on 2.0 profile. Fixes API mismatches. Avoid unnecessary
  82. casts. Code formatting.
  83. * SqlConnection.cs: Also use RecommendAsConfigurable instead of
  84. SettingBindableAttribute on 2.0. Use StateChange event from base class
  85. on 2.0. Only explicitly implement IDbConnection methods on 1.0, since
  86. these are implemented by base class on 2.0 profile. Removed extra
  87. explicit implementation of IDisposable since the base class implements
  88. this. Code formatting.
  89. * SqlDataAdapter.cs: Dispose (bool) override not necessary on 2.0
  90. profile. Stubbed ICloneable.Clone. Fixes API mismatches.
  91. * SqlDataReader.cs: On 2.0, IDisposable.Dispose is implemented by
  92. DbDataReader. Only 1.0 profile, explicitly implemented IEnumerable
  93. GetEnumerator. Code formatting.
  94. * SqlDataSourceEnumerator.cs: Removed.
  95. * SQLDebugging.cs: Marked sealed on 2.0. Code formatting.
  96. * SqlNotificationAuthType.cs: Removed.
  97. * SqlNotificationInfo.cs: Added missing fields. Code formatting.
  98. * SqlNotificationSource.cs: Added missing fields. Code formatting.
  99. * SqlNotificationTransports.cs: Removed.
  100. * SqlNotificationType.cs: Added missing Unknown field. Code formatting.
  101. * SqlParameter.cs: Removed Browsable and EditorBrowsable attributes
  102. from Precision and Scale. Fixes API mismatches. Code formatting fixes.
  103. * SqlTransaction.cs: On 2.0 profile, Dispose method is exposed by
  104. base class. Fixes API mismatches. Code formatting fixes.
  105. 2007-06-21 Nagappan A <[email protected]>
  106. * SqlConnection.cs: Fixed compiler warning.
  107. 2007-06-11 Nagappan A <[email protected]>
  108. * SqlConnection.cs (ParseDataSource): Adds tcp support in
  109. connection string. Fixes bug # 80975.
  110. * SqlCommand.cs (Dispose): On disposing the command object, don't
  111. dispose connection and transaction.
  112. 2007-06-06 Nagappan A <[email protected]>
  113. * SqlCommand.cs, SqlConnectionStringBuilder.cs, SqlConnection.cs:
  114. Fixed 1.0 and 2.0 extras, errors as stated in class status page.
  115. * SqlDataAdapter.cs, SqlParameter.cs:Fixed 1.0 and 2.0 extras,
  116. errors as stated in class status page.
  117. * SqlBulkCopyColumnMappingCollection.cs: Fixed 1.0 and 2.0 extras,
  118. errors as stated in class status page.
  119. 2007-05-30 Nagappan A <[email protected]>
  120. * SqlParameter.cs (SqlParameter): Updated constructor to use the
  121. new TDS RPC implementation.
  122. Fixed missing attributes.
  123. (SetDbType): Added new case for sql_variant type.
  124. (ConvertToFrameworkType): Implemented new private method to
  125. convert the data type to framework type.
  126. * SqlParameterCollection.cs: Fixed missing attributes and
  127. implemented missing methods.
  128. * SqlConnection.cs: Fixed missing attributes.
  129. * SqlConnectionStringBuilder.cs: Certain attributes are missing or
  130. its value or they are not appropriate. Fixed them.
  131. * SqlDataReader.cs (GetData): Method is available only under 1.0
  132. profile.
  133. * SqlCommandBuilder.cs: Certain attributes are available only
  134. under 2.0 profile, so moved them inside ifdef.
  135. * SqlCommand.cs: Certain attributes are available only under 2.0
  136. profile, so moved them inside ifdef.
  137. * SqlBulkCopy.cs: Added new stubs.
  138. * SqlBulkCopyColumnMappingCollection.cs: Added new stubs.
  139. 2007-05-29 Nagappan A <[email protected]>
  140. * SqlCommand.cs (Dispose): Command.Dispose closing
  141. connection. Fixes bug # 81710. Thanks to AMC <[email protected]>
  142. for the fix.
  143. 2007-05-10 Nagappan A <[email protected]>
  144. * SqlClientMetaDataCollectionNames.cs: Fixed incorrect constructor
  145. type.
  146. * SqlConnectionStringBuilder.cs: Fixed missing attributes.
  147. 2007-05-09 Igor Zelmanovich <[email protected]>
  148. * SqlConnectionStringBuilder.cs: added MonoNotSupported attribute.
  149. 2007-04-03 Amit Biswas <[email protected]>
  150. * SqlDataReader.cs (GetSqlBytes, GetProviderSpecificFieldType)
  151. (GetProviderSpecificValue, GetProviderSpecificValues): Implemented
  152. missing API.
  153. * SqlParameter.cs (XmlSchemaCollectionDatabase): Implemented missing property
  154. (XmlSchemaCollectionName): Implemented missing property
  155. (XmlSchemaCollectionOwningSchema): Implemented missing property
  156. (SourceColumnNullMapping): Existing implementation was not correct, Replaced the implementation
  157. (.ctor): Implemented mising constructor new in .net 2.0
  158. * SqlErrorCollection.cs (CopyTo): Implemented missing API
  159. * SqlParameter.cs (InferSqlType): Corrected bug related to default values of
  160. SqlDbType and DbType
  161. (ResetSqlDbType): Implemented missing API
  162. (ResetDbType): Implemented missing API
  163. 2007-03-09 Amit Biswas <[email protected]>
  164. * SqlParameterCollection.cs (CopyTo): Implemented missing API
  165. 2007-04-02 Nagappan A <[email protected]>
  166. * SqlParameter.cs: Variable name fix.
  167. 2007-03-20 Nidhi Rawal <[email protected]>
  168. * SqlClientFactory.cs: Added two using directives.
  169. (CreateConnectionStringBuilder): Implemented the method.
  170. (CreatePermission): Implemented the property.
  171. * SqlCommand.cs: Added one using directive.
  172. (Clone): Implemented the method.
  173. (Dispose): Implemented the method.
  174. (BeginExecuteXmlReader): Implemented the method.
  175. * SqlCommandBuilder.cs (QuoteIdentifier): Implemented the method.
  176. (UnquoteIdentifier): Implemented the method.
  177. * SqlConnection.cs (ChangePassword): Implemented the method.
  178. 2007-03-19 Nidhi Rawal <[email protected]>
  179. * SqlClientFactory.cs (CanCreateDataSourceEnumerator): Implemented
  180. the property.
  181. * SqlCommand.cs (Notification): Implemented the property.
  182. (NotificationAutoEnlist): Implemented the property.
  183. * SqlDataReader.cs (VisibleFieldCount): Implemented the property.
  184. * SqlConnectionStringBuilder.cs (TrustServerCertificate): Implemented
  185. the property.
  186. (TypeSystemVersion): Implemented the property.
  187. (UserInstance): Implemented the property.
  188. (ContextConnection): Implemented the property.
  189. * SqlConnection.cs (FireInfoMessageEventOnUserErrors): Implemented
  190. the property.
  191. (StatisticsEnabled): Implemented the property.
  192. * SqlDataAdapter.cs (UpdateBatchSize): Implemented the property.
  193. * SqlParameter.cs: Implemented one attribute.
  194. 2007-03-16 Andreia Gaita <[email protected]>
  195. * SqlParameter.cs: Move isVariableSizeType flag to TdsMetaParameter
  196. so that the TdsMetaParameter can validate itself for valid size / values.
  197. * SqlCommand.cs (Execute): Call Validate on TdsMetaParameter.
  198. 2007-03-14 Nagappan A <[email protected]>
  199. * SqlCommand.cs (CommandType): Exception type thrown in 2.0
  200. profile is different than 1.0, ArgumentOutOfRangeException.
  201. (Connection): Exception type thrown in 2.0 profile is different
  202. than 1.0, ArgumentOutOfRangeException.
  203. (Execute): If Size property is 0 for String and Binary type, then
  204. throw InvalidOperationException.
  205. (ValidateCommand): Exception type thrown in 2.0 profile is
  206. different than 1.0, NullReferenceException.
  207. 2007-03-09 Nagappan A <[email protected]>
  208. * SqlDataReader.cs: Fixed syntax erros reported in class status
  209. page.
  210. 2007-03-09 Andreia Gaita <[email protected]>
  211. * SqlCommand.cs (ExecuteScalar): Fix returned value for
  212. stored procedure calls to return the first column of the
  213. first row produced by the proc.
  214. 2007-03-08 Nagappan A <[email protected]>
  215. * SqlCommand.cs (CloseDataReader): Checks whether the SQL
  216. connection is created or not.
  217. 2007-03-07 Andreia Gaita <[email protected]>
  218. * SqlCommand.cs (ExecuteScalar): when calling stored procedures,
  219. implement support for return of output values in the parameter
  220. collection.
  221. 2007-02-16 Nidhi Rawal <[email protected]>
  222. * SqlParameter.cs (CompareInfo): Implemented the property
  223. CompareInfo.
  224. (LocaleId): Written the property LocaleId.
  225. (SqlValue): Written the propert SqlValue.
  226. 2007-02-15 Nidhi Rawal <[email protected]>
  227. * SqlCommand.cs: Added some attributes which were not implemented
  228. for .NET 2.0 and removed extra attribute which are not there in
  229. .NET 2.0.
  230. * SqlCommandBuilder.cs: Added some attributes that were not
  231. implemented for .NET 2.0.
  232. * SqlParameterCollection.cs: Added some attributes that were
  233. not implemented for .NET 2.0.
  234. * SqlConnectionStringBuilder.cs: Added some attributes that
  235. were not implemented for .NET 2.0.
  236. * SqlConnection.cs: Added attribute that was not implemented
  237. for .NET 2.0.
  238. * SqlParameter.cs: Added some attributes which were not
  239. implemented for .NET 2.0 and removed some extra attributes which
  240. are not there in .NET 2.0
  241. 2007-02-09 Nagappan A <[email protected]>
  242. * SqlConnection.cs (SetConnectionString): Fixes bug # 80712. A
  243. small typo.
  244. 2007-01-08 Nagappan A <[email protected]>
  245. * SqlTransaction.cs (Dispose): Fixed compliation warning.
  246. * SqlDataReader.cs (GetValues): Length of elements to be copied was
  247. decided based on the argument array passed, which caused a bug, if
  248. the length of given array is more than actual column values.
  249. * SqlCommandBuilder.cs (CatalogSeparator, SchemaSeparator)
  250. (CatalogLocation): Implemented missing properties.
  251. (CreateDeleteCommand, CreateInsertCommand, CreateUpdateCommand):
  252. Modified private methods to take bool flag. If true, add actual
  253. parameter name instead of p1, p2 etc.
  254. (CreateParameter): Added overloaded private method to create
  255. parameter with the actual column name.
  256. (GetUpdateCommand, GetDeleteCommand, GetInsertCommand):
  257. Implemented missing overloaded methods.
  258. (SetRowUpdatingHandler): Implemented missing protected method.
  259. * SqlCommand.cs: Fixed compilation warning. Removed bogus
  260. MonoTODO's.
  261. 2006-12-05 Nagappan A <[email protected]>
  262. * SqlCommand.cs (Execute): If sql2 length is greater than 0, then
  263. add ';' and the respective sql2 string and then execute the
  264. string. Fixes bug # 79880.
  265. 2006-08-30 Nagappan A <[email protected]>
  266. * SqlConnection.cs: Implemented SqlConnection.GetSchema ().
  267. 2006-09-08 Konstantin Triger <[email protected]>
  268. * SqlClientFactory.cs: implemented SqlClientFactory.CreateConnection ().
  269. 2006-07-13 Senganal T <[email protected]>
  270. * SqlClientFactory.cs SqlCommand.cs SqlConnectionFactory.cs
  271. SqlClientPermission.cs SqlParameterCollection.cs SqlDataReader.cs
  272. SqlConnection.cs SqlParameter.cs SqlTransaction.cs :
  273. 2.0 Api fixes
  274. 2006-05-31 Gert Driesen <[email protected]>
  275. * SqlConnection.cs: Removed extra destructor, as destructor on
  276. System.ComponentModel.Component already calls Dispose.
  277. * SqlParameter.cs: Removed explicit interface implementation of
  278. IDataParameter.ParameterName.
  279. 2006-05-26 Senganal T <[email protected]>
  280. * SqlParameter.cs :
  281. - InferSqlType : if value is null or DBNull.Value, retain the
  282. current parameter type.
  283. 2006-04-18 Senganal T <[email protected]>
  284. * SqlConnection.cs :
  285. - SetConnectionString : set the pareameter to default values
  286. if connection string is empty or null
  287. - Open : Raise InvalidOperationException if Connection String
  288. is empty or null
  289. - Dispose : Test exception not raised if dispose called on a
  290. connection with empty connection string
  291. slight modification of the patch by Jonel Rienton
  292. 2006-04-07 Senganal T <[email protected]>
  293. * SqlCommandBuilder.cs :
  294. * CreateDeleteCommand ()
  295. * CreateUpdateCommand ()
  296. * CreateInsertCommand ()
  297. - Changed the signature. Do not need DataRow parameter
  298. as the Query generated is parametric.
  299. - Correct the null-check term in the WhereClause, set the
  300. correct properties for null-check parameter
  301. fixes #78027
  302. - Modified the generated query to match the query as
  303. generated by 2.0. We now ignore null-check in the
  304. whereclause if the Column does not allow nulls.
  305. * ctor () : Set QuotePrefix and QuoteSuffix for 2.0 profile
  306. * GetUpdateCommand ()
  307. * GetInsertCommand ()
  308. * GetDeleteCommand ()
  309. - Do not create new command everytime. Create only if
  310. not already created.
  311. * RefreshSchema : Reset the commands.
  312. 2006-02-17 Chris Toshok <[email protected]>
  313. * SqlCommand.cs, SqlCommandBuilder.cs, SqlConnection.cs,
  314. SqlDataAdapter.cs: remove DataSysDescription attributes for >= 2.0
  315. 2006-02-17 Chris Toshok <[email protected]>
  316. * SqlDataReader.cs: remove VisibleFieldCount property.
  317. 2006-02-10 Senganal T <[email protected]>
  318. * SqlDataReader.cs :
  319. - GetBytes : Read binary/blob/clob data sequentially when
  320. CommandBehavior is set to SequentialAcccess
  321. - GetChars : Read String/clob data sequentially when CommandBehavior
  322. is set to SequentialAccess
  323. * SqlCommand.cs :
  324. - ExecuteReader : set SequentialAccess property on TDS
  325. - CloseDataReader : Reset the command behavior
  326. 2006-01-27 Senganal T <[email protected]>
  327. * SqlCommandBuilder.cs :
  328. - Modified CreateUpdateCommand,CreateDeleteCommand , to not include
  329. column name in the query if its a expression col.
  330. Also, modified the queries to match the generated queries in ms.net
  331. * SqlCommand.cs :
  332. - Modifed Prepare, to check if Parameter is explicitly initialized
  333. * SqlParameter.cs :
  334. - Added CheckIfInitialized : Checks if datatype is explicitly set and
  335. non-zero size is set for variable datatypes.
  336. * SqlDataReader.cs :
  337. - Added code for GetSqlBinary ()
  338. - Fixed GetFieldCount ()
  339. - Added more checks and exceptions.
  340. 2006-01-17 Senganal T <[email protected]>
  341. * SqlCommandBuilder.cs
  342. - Modified CreateNewCommand () : Clean up any existing parameter list
  343. before reusing the command.Fixes #77225
  344. 2005-11-24 Senganal T <[email protected]>
  345. * SqlConnection.cs
  346. - Modifications to get the correct Packet Size
  347. 2005-11-21 Senganal T <[email protected]>
  348. * SqlClientFactory.cs
  349. * SqlCommandBuilder.cs
  350. * SqlParameterCollection.cs
  351. * SqlDataReader.cs
  352. * SqlDataAdapter.cs
  353. * SqlParameter.cs
  354. * SqlTransaction.cs
  355. Added stubs and other changes for ADO.NET 2.0 compatibility
  356. 2005-11-12 Gonzalo Paniagua Javier <[email protected]>
  357. * SqlConnection.cs: don't throw NotImplementedException when using
  358. 'PERSIST SECUTIRY INFO'. Just do nothing.
  359. 2005-10-27 Senganal T <[email protected]>
  360. * SqlCommand.cs
  361. * SqlDataReader.cs
  362. Made changes so that the number of rows affected can be got directly from
  363. Tds regardsless of the type of query.Fixes bug #75698
  364. 2005-10-19 Senganal T <[email protected]>
  365. * SqlConnection.cs (SetProperties) :
  366. - Added support for AttachDBFileName
  367. 2005-10-19 Senganal T <[email protected]>
  368. * SqlException.cs (Constructor)
  369. - Modified the constructor, so that the message parameter
  370. of base class is not the same as that of the Exception message.
  371. fixes bug #76468
  372. 2005-09-24 Sureshkumar T <[email protected]>
  373. * SqlParameterCollection.cs (AddWithValue): added method. patch
  374. from [email protected] (Andy Waddell).
  375. 2005-09-21 Senganal T <[email protected]>
  376. * SqlConnection.cs :
  377. - Set the correct Default Values for Parameters.
  378. - Added Argument Checks (where missing) for the Properties and
  379. throw the correct exception on error.
  380. - Modified SetDefaultParameters() to make sure that the parameters
  381. are all reset to default values everytime it is called.
  382. - Modified SetProperties() to take into account the order of the
  383. keywords in the ConnectionString.
  384. SqlConnection Fixes for the failing sqlserver connected-mode testcases
  385. in ProviderTest/System.Data.SqlClient/SqlConnectionTest.cs
  386. 2005-09-21 Senganal T <[email protected]>
  387. * SqlTransaction.cs : Modifed the Rollback() method, so that
  388. connection can be used for another transaction after the previous
  389. transaction is rolled back. fixes bug 75904
  390. 2005-09-02 Umadevi S <[email protected]>
  391. * Removed SqlResultSet.cs file
  392. 2005-08-26 Sureshkumar T <[email protected]>
  393. * SqlConnection.cs (Open): enable sp_reset_connection.
  394. 2005-08-25 Sureshkumar T <[email protected]>
  395. * SqlCommandBuilder.cs: BuildInformation (): continue on columns
  396. who don't have basetablename.
  397. 2005-08-12 Daniel Morgan <[email protected]>
  398. * SqlCommandBuilder.cs: update command builder based on
  399. OdbcCommandBuilder latest changes to fix regression
  400. of bug 75552
  401. 2005-08-05 Sureshkumar T <[email protected]>
  402. * SqlCommandBuilder.cs: Set SourceVersion property to the created
  403. parameters as it is used by the Adapter's Update method.
  404. 2005-07-22 Sureshkumar T <[email protected]>
  405. * SqlCommandBuilder.cs, SqlParameterCollection.cs,
  406. SqlConnection.cs, SqlParameter.cs:
  407. - updated attributes & attribute descriptions to match with
  408. masterinfos.
  409. 2005-07-16 Daniel Morgan <[email protected]>
  410. * SqlCommandBuilder.cs: CreateUpdateCommand should get the current value, not
  411. the orginal value when setting one of the SET variables
  412. 2005-07-15 Sureshkumar T <[email protected]>
  413. * SqlCommandBuilder.cs:
  414. - set_DataAdapter: unsubscribe event if DataAdapter is reset.
  415. - CreateInsertCommand, CreateUpdateCommand, CreateDeleteCommand:
  416. if column mapping is missing, use the source column name. use
  417. proper version to get the data.
  418. - RowUpdatingHandler: set status to continue to actually process
  419. the query.
  420. 2005-07-04 Ben Maurer <[email protected]>
  421. * SqlError.cs: Patch from [email protected] to fix serialization.
  422. 2005-06-29 Sureshkumar T <[email protected]>
  423. * SqlConnection.cs: Open (): catch TdsInternalException and throw
  424. SqlException.
  425. * SqlException.cs: code re-organised to pass message as well with
  426. the exception.
  427. 2005-06-23 Sureshkumar T <[email protected]>
  428. * SqlConnectionStringBuilder.cs: simplified multiple keyword
  429. mappings and allowed-key checking. fixed Item, Remove,
  430. ContainsKey, ShoudSerialize, TryGetValue implementations.
  431. 2005-06-21 Sureshkumar T <[email protected]>
  432. * SqlConnectionStringBuilder.cs: Connection String Builder class
  433. for SqlClient Data Provider.
  434. 2005-06-01 Gonzalo Paniagua Javier <[email protected]>
  435. * SqlParameter.cs: moved the 'using S.D.SqlTypes' out of NET_2_0. Fixes
  436. the build.
  437. 2005-06-01 Sureshkumar T <[email protected]>
  438. * SqlParameter.cs: Parameter's value can be SqlTypes. Convert to
  439. framework type to pass to TDS layer. Fixes bug #75044.
  440. 2005-05-24 Umadevi S <[email protected]>
  441. * fixed some 2.0 and 1.0 specific fields/attributes for various classes.
  442. * Added SqlClientMetaDataCollectionNames.cs, Implemented some 2.0
  443. properties for SqlParameterCollection for the bulkcopy feature.
  444. 2005-05-20 Kornél Pál <http://www.kornelpal.hu/>
  445. * Fixed Bug #53169 - SqlDataReader incorrectly returns bigint as decimal
  446. Note: The fix works around the limitations of TDS 7.0 to avoid this
  447. difference between Mono and .NET Framework TDS 8.0 should be used instead.
  448. 2005-05-20 Umadevi S <[email protected]>
  449. * Fixed Bug 74948 - SqlParameter also takes DBNull Value.
  450. Correct some attributes stuff of 1.1 and 2.0 for SqlParameter.cs
  451. 2005-05-20 Umadevi S <[email protected]>
  452. * Continuing on implementation for bulkcopy and notification
  453. Added files SqlNotificationEventArgs.cs, OnChangeEventHandler.cs
  454. Modified SqlRowUpdatingEventArgs.cs
  455. 2005-05-19 Umadevi S <[email protected]>
  456. * For implementation of bulkcopy and notifications added files
  457. SqlBulkCopyOptions.cs,SqlBulkCopyColumnMapping.cs,SqlNotificationAuthType.cs
  458. SqlNotificationTransports.cs,SqlRowsCopiedEventArgs.cs, SqlRowsCopiedEventHandler.cs
  459. 2005-05-19 Umadevi S <[email protected]>
  460. * Corrected types,enum values of SqlNotificationType,SqlNotificationSource,
  461. SqlNotificationInfo and added new method in SqlRowUpdatingEventArgs.cs
  462. (For implementation of bulkcopy/notifications)
  463. 2005-04-19 Sureshkumar T <[email protected]>
  464. * SqlDataReader.cs: NextResult (): Re-create schema table for each
  465. result set. don't re-use, as it may be referenced from somewhere.
  466. 2005-04-07 Sureshkumar T <[email protected]>
  467. Ankit Jain <[email protected]>
  468. * SqlConnection.cs: Implemented additional connection string
  469. property "Asynchronous Processing".
  470. * SqlCommand.cs: Implemented Asynchronous command execution API.
  471. * SqlAsyncState.cs: A internal state object for asynchronous
  472. operations.
  473. * SqlAsyncResult.cs: Added. Class to hold result for asynchronous
  474. queries.
  475. 2005-03-28 Sureshkumar T <[email protected]>
  476. * SqlCommand.cs: Execute: Add a semicolon at the end of
  477. CommandText. Multiple semicolon's are not being complained.
  478. fixes bug #74134.
  479. 2005-03-11 Gonzalo Paniagua Javier <[email protected]>
  480. * SqlConnection.cs: added a finalizer for correct implementation of the
  481. IDisposable pattern.
  482. 2005-03-11 Gonzalo Paniagua Javier <[email protected]>
  483. * SqlException.cs: make it serialization-compatible with MS. Patch by
  484. Aleksandar Dezelin. Closes bug #73596.
  485. 2005-03-08 Sureshkumar T <[email protected]>
  486. * SqlDataReader.cs: Call base constructor with CommandBehavior
  487. parameter instead of passing DbCommand object. The internal base
  488. class with DbCommand Parameter is removed.
  489. 2005-03-07 Sureshkumar T <[email protected]>
  490. * SqlCommand.cs : Set CommandBehavior on
  491. ExecuteReader,ExecuteScalar,ExecuteNonQuery. This is used in
  492. CloseDataReader.
  493. This fixes bug #73252.
  494. 2005-03-03 Sureshkumar T <[email protected]>
  495. * SqlClientFactory.cs: While creating command, create using
  496. DbConnectionFactory as DbConnectionBase.CreateDbCommand needs to
  497. have a connection factory.
  498. * SqlConnection.cs: Added an internal constructor which takes
  499. DbConnectionFactory.
  500. * SqlConnectionFactory.cs: Added. Concrete class for abstract
  501. factory DbConnectionFactory.
  502. 2005-02-22 Sureshkumar T <[email protected]>
  503. * SqlDataReader.cs: GetBytes: return the length of the data if
  504. output buffer is null. if not, copy the values to buffer and
  505. return the bytes actually read.
  506. 2005-02-02 Sureshkumar T <[email protected]>
  507. * SqlConnection.cs:
  508. - Database: return db name from database if connection open,
  509. otherwise take from connection string.
  510. - Set default values for parameters in the constructor itself.
  511. - Dangling else problem with Close method.
  512. - reset values of parms (TdsConnectionParameters) rather setting
  513. to null.
  514. - set disposed to false in Open method
  515. - finally call base.Dispose in Dispose (bool)
  516. Fixes nunit regressions SqlConnectionTest:DefaultConnectionValues
  517. and SqlConnectionTest:DatabaseSynonyms.
  518. 2005-01-27 Sureshkumar T <[email protected]>
  519. * SqlCommand.cs (DeriveParameters): Change parameter name to
  520. "procedure_name".
  521. * SqlParameter.cs (SqlParameter (object [])) : call default
  522. constructor to create Tds.Metaparameter.
  523. fixes bug #63122.
  524. 2005-01-03 Sureshkumar T <[email protected]>
  525. * SqlCommand.cs: Fixed bug #68973. Reset Tds.RecordsAffected to 0
  526. for each execute statement.
  527. 2004-11-25 Sureshkumar T <[email protected]>
  528. These changes are for 2.0 profile only. These changes implement
  529. the generic data base access technique using Provider Factory
  530. Implementation. These classes need to be dervided from abstract
  531. base classes so that the corresponding factory classes are
  532. created when calling CreateCommand, CreateParameter, etc.
  533. * SqlClientFactory.cs: Provider Factory class Implementaion for SqlServer
  534. * SqlParameter.cs: Change base classes and override methods.
  535. * SqlParameterCollection.cs: Change base classes and override methods.
  536. * SqlTransaction.cs: Change base classes and override methods.
  537. * SqlDataSourceEnumerator.cs: DataSource Enumerator stubs.
  538. * SqlDataReader.cs: Change base classes and override methods.
  539. * SqlConnection.cs: Change base classes and override methods.
  540. * SqlCommandBuilder.cs: Change base classes and override methods.
  541. * SqlCommand.cs: Change base classes and override necessary methods.
  542. 2004-10-14 Umadevi S <[email protected]>
  543. * SqlCommand.cs - Implemented the clone method correctly.
  544. (fixed bug 67301)
  545. 2004-10-06 Umadevi S <[email protected]>
  546. * ISqlNoticationReceiver.cs - changed namespace
  547. * Added files SqlNotificationType.cs, SqlNotificationInfo.cs, SqlNotificationSource.cs
  548. 2004-09-24 Umadevi S <[email protected]>
  549. * SqlTransaction.cs - Dispose will not call rollback incase the transaction is not open.
  550. 2004-09-14 Sebastien Pouliot <[email protected]>
  551. * SqlClientPermission.cs: Added internal constructor accepting an Sql
  552. ClientPermissionAttribute parameter (using base class protected ctor).
  553. * SqlClientPermissionAttribute.cs: Copy now use the new SqlClient
  554. Permission constructor.
  555. 2004-09-13 Sebastien Pouliot <[email protected]>
  556. * SqlClientPermission.cs: Mostly completed (needs tests).
  557. * SqlClientPermissionAttribute.cs: Completed.
  558. 2004-09-02 Umadevi S <[email protected]>
  559. * SqlCommand.cs - ExecuteNonQuery to return -1 incase of executing a storedprocedure
  560. 2004-08-16 Gert Driesen <[email protected]>
  561. * SqlConnection.cs: added TODO on ConnectionString for keywords
  562. that are not yet implemented. check value of Integrated Security
  563. keyword, check value of bool keywords, improve error reporting
  564. for int keywords, added support for the following keyword
  565. synonyms : APP, TIMEOUT, NETWORK, PERSISTSECURITYINFO, WSID,
  566. LANGUAGE, USER. Throw NotImplementedException when encrypt keyword
  567. is set to true, enlist keyword is set to false or attachdbfilename
  568. keyword (or one of its synonyms) is set. Added FIXME for PERSIST
  569. SECURITY INFO keyword, throwing a NotImplementedException here
  570. would break lots of apps
  571. 2004-08-16 Gert Driesen <[email protected]>
  572. * SqlConnection.cs - spaces to tabs
  573. 2004-08-12 Sureshkumar T <[email protected]>
  574. * SqlDataReader.cs - In Close method, the remaining resultsets are drained
  575. out, to read output parameters & to avoid stream overlap
  576. 2004-06-30 Umadevi S <[email protected]>
  577. * SqlCommand.cs : In the Execute Method the commandbehavior parameters were ignored correct
  578. these
  579. 2004-06-22 Atsushi Enomoto <[email protected]>
  580. * SqlCommandBuilder.cs : Avoid cast exception caused by DbNull.
  581. 2004-06-18 Umadevi S <[email protected]>
  582. * SqlCommand.cs - ExecuteNonQuery returns -1 in all cases except
  583. insert,update or delete.
  584. 2004-06-18 Umadevi S <[email protected]>
  585. * SqlConnection.cs - handled null being passed as a connectionstring
  586. - checked for minimal set of parameters in connectionstring.
  587. - handled unrecogonized keywords similar to MS.NET
  588. 2004-06-17 Umadevi S <[email protected]>
  589. * SqlTransaction.cs - fixed multiple rollbacks being called causes invalidoperationexception
  590. 2004-06-04 Gert Driesen <[email protected]>
  591. * SqlClientPermission.cs: removed extra CreateInstance
  592. method
  593. 2004-06-02 Gert Driesen <[email protected]>
  594. * SQLDebugging.cs: added missing attributes, marked ctor
  595. public to match MS.NET
  596. 2004-05-22 Atsushi Enomoto <[email protected]>
  597. * SqlClientPermission.cs : don't use chained obsolete .ctor.
  598. 2004-05-20 Gert Driesen ([email protected])
  599. * SqlClientPermissionAttribute.cs: change AllowMultiple and
  600. Inherited to match .NET
  601. 2004-05-20 Umadevi S <[email protected]>
  602. * Fixed bug 58406- implemented the hasrow method, test program used
  603. to test with the bug report
  604. 2004-05-13 Umadevi S <[email protected]>
  605. * SqlClientPermission.cs, SqlDataReader.cs - added missing methods with TODO tags
  606. * SqlCommand.cs, SqlDataAdapter.cs - implemented ToolboxItemAttribute
  607. * SQLDebugging.cs - Added new file with a TODO tag
  608. 2004-04-05 Lluis Sanchez Gual <[email protected]>
  609. * SqlConnection.cs: Use connection pool implemented in Mono.Data.Tds.
  610. 2004-04-01 Lluis Sanchez Gual <[email protected]>
  611. * SqlDataReader.cs: Null values are now represented with DBNull instances.
  612. Deal with this.
  613. 2004-03-14 Tim Coleman <[email protected]>
  614. * SqlCommand.cs SqlConnection.cs:
  615. Changes from two patches by Andres Taylor
  616. <[email protected]>
  617. 2004-03-12 Andreas Nahr <[email protected]>
  618. * SqlParameter.cs: DO NOT USE the consts scheme if types can be referenced directly!
  619. 2004-01-10 Atsushi Enomoto <[email protected]>
  620. * SqlClientPermission.cs : Fixed NET_2_0 build related to
  621. obsolete attribute problem (see DbDataPermission.cs)
  622. 2003-12-28 Tim Coleman <[email protected]>
  623. * SqlResultSet.cs:
  624. Stubbed out this class.
  625. 2003-12-23 Tim Coleman <[email protected]>
  626. * SqlConnection.cs:
  627. Improved connection string parsing. See
  628. System.Data.Common.DbConnectionString for source.
  629. 2003-12-21 Tim Coleman <[email protected]>
  630. * SqlConnection.cs:
  631. Enable Integrated Security
  632. 2003-12-19 Tim Coleman <[email protected]>
  633. * ISqlNotificationReceiver.cs SqlResultSet.cs:
  634. New stubs added
  635. * SqlClientPermission.cs:
  636. Fix constructor for 1.2
  637. 2003-12-04 John Luke <[email protected]>
  638. * SqlXmlTextReader.cs: applied patch from Chris Masters <[email protected]>
  639. fix peek so it checks if it is at the end and also to make sure that if Read()
  640. advances the position past the end of the localBuffer array, it makes
  641. a call to GetNextBuffer(). fixes bug #40253 System.IndexOutOfRangeException when
  642. using SqlCommand.ExecuteXmlReader()
  643. 2003-11-20 Joerg Rosenkranz <[email protected]>
  644. * SqlConnection (SetDefaultConnectionParameters):
  645. Changed default value of WORKSTATION ID to reflect real
  646. host name instead of "localhost".
  647. 2003-11-16 Ben Maurer <[email protected]>
  648. * SqlParameterCollection.cs (Clear): Clear needs to take
  649. the parameter out of the collection so that it can be used
  650. again.
  651. (Remove):
  652. (RemoveAt): Ditto.
  653. 2003-10-03 Diego Caravana <[email protected]>
  654. * SqlCommand.cs: no change.
  655. * SqlConnection.cs (Close): Added checks for null instance
  656. variables.
  657. * SqlParameter.cs (Direction): Now handles parameters of type
  658. ReturnValue and InputOutput.
  659. * SqlParameterCollection.cs (IndexOf(string)): Search for
  660. SqlParameter object in list is done by obtaining ParameterName
  661. attribute, not directly through list.IndexOf().
  662. 2003-08-22 Duncan Mak <[email protected]>
  663. * SqlCommand.cs (ExecuteNonQuery): Return
  664. Connection.Tds.RecordsAffected if it is successful. Patch from
  665. Jörg Rosenkranz <[email protected]>.
  666. This is part of a fix to bug #40315.
  667. 2003-08-20 Duncan Mak <[email protected]>
  668. * SqlConnectionPool.cs (ReleaseConnection): A patch from Joerg
  669. Rosenkranz <[email protected]>. Currently, if a connection is
  670. closed by an external event (network problem, etc.) it is pushed
  671. back into the connection pool. The next Open call retrieves this
  672. invalid connection which leads to exceptions when executing
  673. statements.
  674. This patch fixes this problem. This closes bug #47429.
  675. 2003-07-04 Miguel de Icaza <[email protected]>
  676. * SqlDataReader.cs: Added extra information to the exceptions
  677. thrown by all the GetXXXX methods.
  678. 2003-03-15 Daniel Morgan <[email protected]>
  679. * SqlConnection.cs: if Server in the ConnectionString
  680. is set to "(local", use "localhost" as the hostname
  681. to connect
  682. 2003-03-04 Gonzalo Paniagua Javier <[email protected]>
  683. * SqlException.cs: implemented GetObjectData ().
  684. 2003-02-16 Daniel Morgan <[email protected]>
  685. * ChangeLog: added this file
  686. * SqlConnection.cs: - parse data source for 3 possible uses:
  687. "Server=hostname",
  688. "Server=hostname\\instancename",
  689. "Server=hostname,port" and open the connection based on the
  690. resulting server name and port.
  691. - Added support for named instances
  692. by discovery of the sql server tcp port via the sql monitor (udp port 1434)
  693. thanks to Phillip Jerkins ([email protected]) contribution.
  694. Also, thanks to Gonzalo and Tim for their help with timeouts.