1 2005-03-03 Sureshkumar T <tsureshkumar@novell.com>
3 * SqlClientFactory.cs: While creating command, create using
4 DbConnectionFactory as DbConnectionBase.CreateDbCommand needs to
5 have a connection factory.
7 * SqlConnection.cs: Added an internal constructor which takes
10 * SqlConnectionFactory.cs: Added. Concrete class for abstract
11 factory DbConnectionFactory.
13 2005-02-22 Sureshkumar T <tsureshkumar@novell.com>
15 * SqlDataReader.cs: GetBytes: return the length of the data if
16 output buffer is null. if not, copy the values to buffer and
17 return the bytes actually read.
19 2005-02-02 Sureshkumar T <tsureshkumar@novell.com>
22 - Database: return db name from database if connection open,
23 otherwise take from connection string.
24 - Set default values for parameters in the constructor itself.
25 - Dangling else problem with Close method.
26 - reset values of parms (TdsConnectionParameters) rather setting
28 - set disposed to false in Open method
29 - finally call base.Dispose in Dispose (bool)
31 Fixes nunit regressions SqlConnectionTest:DefaultConnectionValues
32 and SqlConnectionTest:DatabaseSynonyms.
34 2005-01-27 Sureshkumar T <tsureshkumar@novell.com>
36 * SqlCommand.cs (DeriveParameters): Change parameter name to
38 * SqlParameter.cs (SqlParameter (object [])) : call default
39 constructor to create Tds.Metaparameter.
43 2005-01-03 Sureshkumar T <tsureshkumar@novell.com>
45 * SqlCommand.cs: Fixed bug #68973. Reset Tds.RecordsAffected to 0
46 for each execute statement.
48 2004-11-25 Sureshkumar T <tsureshkumar@novell.com>
50 These changes are for 2.0 profile only. These changes implement
51 the generic data base access technique using Provider Factory
52 Implementation. These classes need to be dervided from abstract
53 base classes so that the corresponding factory classes are
54 created when calling CreateCommand, CreateParameter, etc.
56 * SqlClientFactory.cs: Provider Factory class Implementaion for SqlServer
57 * SqlParameter.cs: Change base classes and override methods.
58 * SqlParameterCollection.cs: Change base classes and override methods.
59 * SqlTransaction.cs: Change base classes and override methods.
60 * SqlDataSourceEnumerator.cs: DataSource Enumerator stubs.
61 * SqlDataReader.cs: Change base classes and override methods.
62 * SqlConnection.cs: Change base classes and override methods.
63 * SqlCommandBuilder.cs: Change base classes and override methods.
64 * SqlCommand.cs: Change base classes and override necessary methods.
66 2004-10-14 Umadevi S <sumadevi@novell.com>
67 * SqlCommand.cs - Implemented the clone method correctly.
70 2004-10-06 Umadevi S <sumadevi@novell.com>
71 * ISqlNoticationReceiver.cs - changed namespace
72 * Added files SqlNotificationType.cs, SqlNotificationInfo.cs, SqlNotificationSource.cs
74 2004-09-24 Umadevi S <sumadevi@novell.com>
75 * SqlTransaction.cs - Dispose will not call rollback incase the transaction is not open.
77 2004-09-14 Sebastien Pouliot <sebastien@ximian.com>
79 * SqlClientPermission.cs: Added internal constructor accepting an Sql
80 ClientPermissionAttribute parameter (using base class protected ctor).
81 * SqlClientPermissionAttribute.cs: Copy now use the new SqlClient
82 Permission constructor.
84 2004-09-13 Sebastien Pouliot <sebastien@ximian.com>
86 * SqlClientPermission.cs: Mostly completed (needs tests).
87 * SqlClientPermissionAttribute.cs: Completed.
89 2004-09-02 Umadevi S <sumadevi@novell.com>
90 * SqlCommand.cs - ExecuteNonQuery to return -1 incase of executing a storedprocedure
92 2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
94 * SqlConnection.cs: added TODO on ConnectionString for keywords
95 that are not yet implemented. check value of Integrated Security
96 keyword, check value of bool keywords, improve error reporting
97 for int keywords, added support for the following keyword
98 synonyms : APP, TIMEOUT, NETWORK, PERSISTSECURITYINFO, WSID,
99 LANGUAGE, USER. Throw NotImplementedException when encrypt keyword
100 is set to true, enlist keyword is set to false or attachdbfilename
101 keyword (or one of its synonyms) is set. Added FIXME for PERSIST
102 SECURITY INFO keyword, throwing a NotImplementedException here
103 would break lots of apps
105 2004-08-16 Gert Driesen <drieseng@users.sourceforge.net>
107 * SqlConnection.cs - spaces to tabs
109 2004-08-12 Sureshkumar T <tsureshkumar@novell.com>
110 * SqlDataReader.cs - In Close method, the remaining resultsets are drained
111 out, to read output parameters & to avoid stream overlap
113 2004-06-30 Umadevi S <sumadevi@novell.com>
114 * SqlCommand.cs : In the Execute Method the commandbehavior parameters were ignored correct
117 2004-06-22 Atsushi Enomoto <atsushi@ximian.com>
119 * SqlCommandBuilder.cs : Avoid cast exception caused by DbNull.
121 2004-06-18 Umadevi S <sumadevi@novell.com>
122 * SqlCommand.cs - ExecuteNonQuery returns -1 in all cases except
123 insert,update or delete.
125 2004-06-18 Umadevi S <sumadevi@novell.com>
126 * SqlConnection.cs - handled null being passed as a connectionstring
127 - checked for minimal set of parameters in connectionstring.
128 - handled unrecogonized keywords similar to MS.NET
130 2004-06-17 Umadevi S <sumadevi@novell.com>
131 * SqlTransaction.cs - fixed multiple rollbacks being called causes invalidoperationexception
133 2004-06-04 Gert Driesen <drieseng@users.sourceforge.net>
135 * SqlClientPermission.cs: removed extra CreateInstance
138 2004-06-02 Gert Driesen <drieseng@users.sourceforge.net>
140 * SQLDebugging.cs: added missing attributes, marked ctor
141 public to match MS.NET
143 2004-05-22 Atsushi Enomoto <atsushi@ximian.com>
145 * SqlClientPermission.cs : don't use chained obsolete .ctor.
147 2004-05-20 Gert Driesen (drieseng@users.sourceforge.net)
149 * SqlClientPermissionAttribute.cs: change AllowMultiple and
150 Inherited to match .NET
152 2004-05-20 Umadevi S <sumadevi@novell.com>
154 * Fixed bug 58406- implemented the hasrow method, test program used
155 to test with the bug report
157 2004-05-13 Umadevi S <sumadevi@novell.com>
159 * SqlClientPermission.cs, SqlDataReader.cs - added missing methods with TODO tags
160 * SqlCommand.cs, SqlDataAdapter.cs - implemented ToolboxItemAttribute
161 * SQLDebugging.cs - Added new file with a TODO tag
163 2004-04-05 Lluis Sanchez Gual <lluis@ximian.com>
165 * SqlConnection.cs: Use connection pool implemented in Mono.Data.Tds.
167 2004-04-01 Lluis Sanchez Gual <lluis@ximian.com>
169 * SqlDataReader.cs: Null values are now represented with DBNull instances.
172 2004-03-14 Tim Coleman <tim@timcoleman.com>
173 * SqlCommand.cs SqlConnection.cs:
174 Changes from two patches by Andres Taylor
175 <andres@rotselleri.com>
177 2004-03-12 Andreas Nahr <ClassDevelopment@A-SoftTech.com>
179 * SqlParameter.cs: DO NOT USE the consts scheme if types can be referenced directly!
181 2004-01-10 Atsushi Enomoto <atsushi@ximian.com>
183 * SqlClientPermission.cs : Fixed NET_2_0 build related to
184 obsolete attribute problem (see DbDataPermission.cs)
186 2003-12-28 Tim Coleman <tim@timcoleman.com>
188 Stubbed out this class.
190 2003-12-23 Tim Coleman <tim@timcoleman.com>
192 Improved connection string parsing. See
193 System.Data.Common.DbConnectionString for source.
195 2003-12-21 Tim Coleman <tim@timcoleman.com>
197 Enable Integrated Security
199 2003-12-19 Tim Coleman <tim@timcoleman.com>
200 * ISqlNotificationReceiver.cs SqlResultSet.cs:
202 * SqlClientPermission.cs:
203 Fix constructor for 1.2
205 2003-12-04 John Luke <jluke@cfl.rr.com>
207 * SqlXmlTextReader.cs: applied patch from Chris Masters <neeeeeep@bigpond.com>
208 fix peek so it checks if it is at the end and also to make sure that if Read()
209 advances the position past the end of the localBuffer array, it makes
210 a call to GetNextBuffer(). fixes bug #40253 System.IndexOutOfRangeException when
211 using SqlCommand.ExecuteXmlReader()
213 2003-11-20 Joerg Rosenkranz <JoergR@voelcker.com>
215 * SqlConnection (SetDefaultConnectionParameters):
216 Changed default value of WORKSTATION ID to reflect real
217 host name instead of "localhost".
219 2003-11-16 Ben Maurer <bmaurer@users.sourceforge.net>
221 * SqlParameterCollection.cs (Clear): Clear needs to take
222 the parameter out of the collection so that it can be used
227 2003-10-03 Diego Caravana <diego@toth.it>
229 * SqlCommand.cs: no change.
231 * SqlConnection.cs (Close): Added checks for null instance
234 * SqlParameter.cs (Direction): Now handles parameters of type
235 ReturnValue and InputOutput.
237 * SqlParameterCollection.cs (IndexOf(string)): Search for
238 SqlParameter object in list is done by obtaining ParameterName
239 attribute, not directly through list.IndexOf().
241 2003-08-22 Duncan Mak <duncan@ximian.com>
243 * SqlCommand.cs (ExecuteNonQuery): Return
244 Connection.Tds.RecordsAffected if it is successful. Patch from
245 Jörg Rosenkranz <joergr@voelcker.com>.
247 This is part of a fix to bug #40315.
249 2003-08-20 Duncan Mak <duncan@ximian.com>
251 * SqlConnectionPool.cs (ReleaseConnection): A patch from Joerg
252 Rosenkranz <JoergR@voelcker.com>. Currently, if a connection is
253 closed by an external event (network problem, etc.) it is pushed
254 back into the connection pool. The next Open call retrieves this
255 invalid connection which leads to exceptions when executing
258 This patch fixes this problem. This closes bug #47429.
260 2003-07-04 Miguel de Icaza <miguel@ximian.com>
262 * SqlDataReader.cs: Added extra information to the exceptions
263 thrown by all the GetXXXX methods.
265 2003-03-15 Daniel Morgan <danmorg@sc.rr.com>
267 * SqlConnection.cs: if Server in the ConnectionString
268 is set to "(local", use "localhost" as the hostname
271 2003-03-04 Gonzalo Paniagua Javier <gonzalo@ximian.com>
273 * SqlException.cs: implemented GetObjectData ().
275 2003-02-16 Daniel Morgan <danmorg@sc.rr.com>
277 * ChangeLog: added this file
279 * SqlConnection.cs: - parse data source for 3 possible uses:
281 "Server=hostname\\instancename",
282 "Server=hostname,port" and open the connection based on the
283 resulting server name and port.
284 - Added support for named instances
285 by discovery of the sql server tcp port via the sql monitor (udp port 1434)
286 thanks to Phillip Jerkins (Phillip.Jerkins@morgankeegan.com) contribution.
287 Also, thanks to Gonzalo and Tim for their help with timeouts.