* Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds.cs :
- GetSequentialColumn,BeginLoad, EndLoad,
LoadData, SkipRow, SkipToColumnIndex
New Methods to Support sequential loading of row data
* Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs :
- Skip : Changed arugment type from int to long.
* System.Data/Test/ProviderTests/System.Data.SqlClient/SqlDataReaderTest.cs :
Added more tests to verify Sequential reading of row data.
* System.Data/Test/ProviderTests/ProviderIndependant/DataReaderTest : Corrected a failing testcase.
* System.Data/System.Data.SqlClient/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
* System.Data/System.Data.SqlClient/SqlCommand.cs :
- ExecuteReader : set SequentialAccess property on TDS
- CloseDataReader : Reset the command behavior
svn path=/trunk/mcs/; revision=56757
* Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds.cs :
- Modified GetSqlMoney () , to set the precision and Scale correctly.
- Modified ProcessColumnDetails , to set the schema values correctly.
* Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsDataColumn.cs : Added some default values for the column schema
* System.Data/Test/ProviderTests/ProviderIndependant/DataReaderTest : Corrected a failing testcase.
* System.Data/Test/ProviderTests/System.Data.SqlClient/SqlCommandBuilderTest.cs : corrected a failing testcase
* System.Data/System.Data.SqlTypes/SqlDateTime : Corrected the MaxValue for SqlDateTime
* System.Data/System.Data.Common/DbDataAdapter.cs :
- Modified schema population to follow MissingSchemaAction and MissingMappingAction
- Add a column to the Primary Key only if its not a hidden key
- Added some argument checks
- Removed some redundant code
* System.Data/System.Data.Common/DataAdapter :
- Added argument checks
* System.Data/System.Data.Common/ExceptionHelper :
- Added InvalidEnumException , a helper function to print error msg
* System.Data/System.Data.SqlClient/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
* System.Data/System.Data.SqlClient/SqlCommand.cs :
- Modifed Prepare, to check if Parameter is explicitly initialized
* System.Data/System.Data.SqlClient/SqlParameter.cs :
- Added CheckIfInitialized : Checks if datatype is explicitly set and
non-zero size is set for variable datatypes.
* System.Data/System.Data.SqlClient/SqlDataReader.cs :
- Added code for GetSqlBinary ()
- Fixed GetFieldCount ()
- Added more checks and exceptions.
Fixes most of the failing SqlClient Provider Tests .
svn path=/trunk/mcs/; revision=56167
* Test/ProviderTests/sqlserver.config : Modified the default login and password to 'monotester'
* Test/ProviderTests/System.Data.SqlClient/SqlCommandBuilderTest.cs : Added testcase for bug #77225
* System.Data.SqlClient/SqlCommandBuilder.cs
- Modified CreateNewCommand () : Clean up any existing parameter list
before reusing the command.Fixes #77225
svn path=/trunk/mcs/; revision=55668
* Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds.cs
* Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds70.cs :
- Modifications to set the desired packetsize info when connecting
to database
* System.Data/System.Data.SqlClient/SqlConnection.cs
- Modifications to get the correct Packet Size
svn path=/trunk/mcs/; revision=53443
* Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds.cs :
- Added a virtual method IsValidRowCount ()
- Modified the way RecordsAffected is being counted
* Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds70.cs :
- Overrode IsValidRowCount(), to check if the rowcount
returned by sqlserver is valid.
* System.Data/Test/ProviderTests/System.Data.SqlClient/SqlCommandTest.cs :
- Added Testcase for bug #75698
* System.Data/System.Data.SqlClient/SqlCommand.cs
* System.Data/System.Data.SqlClient/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
svn path=/trunk/mcs/; revision=52268
* Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsConnectionParameter.cs :
- Added a class variable 'AttachDBFileName' to store the location
of the DB file.
* Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds70.cs (Connect) :
- Modified to append the bytes corresponding to AttachDBFileName
into the Tds Packets.
* System.Data/System.Data.SqlClient/SqlConnection.cs (SetProperties) :
- Added support for AttachDBFileName
svn path=/trunk/mcs/; revision=51909
* 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
svn path=/trunk/mcs/; revision=51908
* Mono.Data.Tds.Protocol/Tds.cs:
- Modified the way Server Version number is calculated
- Added a new varaible to remember the original database
connected to and to reset the Database property when the
connection to database is closed.
* Mono.Data.Tds.Protocol/Tds70.cs:
modified Reset() to Call the Reset() of base class which
in turn resets the database name.
In System.Data/Test/ProviderTests/System.Data.SqlClient:
* SqlConnectionTest.cs: removed some hardcoded database names
in DatabasePropertyTest ().
In System.Data/System.Data.SqlClient:
* 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.
svn path=/trunk/mcs/; revision=50377
2005-08-26 Sureshkumar T <[email protected]>
* SqlConnection.cs (Open): enable sp_reset_connection.
In Mono.Data.Tds/Mono.Data.Tds.Protocol:
2005-08-26 Sureshkumar T <[email protected]>
* Tds70.cs (ExecProc): if no parameters, execute via RPC. parameter
support has to be added.
* Tds.cs (ExecRPC): added virtual method to execute via RPC.
This fixes bug #68978 by enabling execution of sp_reset_connection.
svn path=/trunk/mcs/; revision=48881
* SqlCommandBuilder.cs: update command builder based on
OdbcCommandBuilder latest changes to fix regression
of bug 75552
svn path=/trunk/mcs/; revision=48347
2005-08-05 Sureshkumar T <[email protected]>
* DbDataAdapter.cs:
- Update (): set parameter values only after getting the
appropriate command from command builder. Close reader only if it
is not closed before. Use parameter's SourceVersion. Whitespace
corrections to comply with standard.
In System.Data.SqlClient:
2005-08-05 Sureshkumar T <[email protected]>
* SqlCommandBuilder.cs: Set SourceVersion property to the created
parameters as it is used by the Adapter's Update method.
In System.Data.Odbc:
2005-08-05 Sureshkumar T <[email protected]>
* OdbcDataReader.cs: RecordsAffected: get value from command.
GetSchemaTable (): set IsExpression based on BaseTableName. set
AllowDBNull to false if the column is PK.
* OdbcCommand.cs: correct UpdatedRowSource is returned. whitespace
changes to conform to standard.
* OdbcCommandBuilder.cs: Implemented.
* OdbcParameter.cs: Direction is set to Input by default.
svn path=/trunk/mcs/; revision=48043
2005-07-22 Sureshkumar T <[email protected]>
* DataColumnMappingCollection.cs: updated attributes & attribute
descriptions to match with masterinfos.
In System.Data.SqlClient:
2005-07-22 Sureshkumar T <[email protected]>
* SqlCommandBuilder.cs, SqlParameterCollection.cs,
SqlConnection.cs, SqlParameter.cs:
- updated attributes & attribute descriptions to match with
masterinfos.
In System.Data:
* DataViewSettingCollection.cs, DataTableCollection.cs,
DataSet.cs, DataView.cs, DataColumn.cs, ForeignKeyConstraint.cs,
DataRelationCollection.cs, UniqueConstraint.cs, DataTable.cs,
DataColumnCollection.cs, DataRelation.cs, DataSet.cs:
- updated attributes & attribute descriptions to match with
masterinfos.
In System.Data.Odbc:
* OdbcParameter.cs: updated attributes & attribute descriptions to
match with masterinfos.
svn path=/trunk/mcs/; revision=47554
* SqlCommandBuilder.cs: CreateUpdateCommand should get the current value, not
the orginal value when setting one of the SET variables
svn path=/trunk/mcs/; revision=47357
2005-07-15 Sureshkumar T <[email protected]>
* DataTableMappingCollection.cs: GetTableMappingBySchemaAction:
meaningful error message if mapping is missing.
* DbDataAdapter.cs: Update: meaningful message if table is missing.
In System.Data.SqlClient:
2005-07-15 Sureshkumar T <[email protected]>
* 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.
svn path=/trunk/mcs/; revision=47340
* Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsInternalException.cs: Add ctor for InnerException.
* Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs: Throw TdsInternalException rather than
SocketException.
* System.Data/System.Data.SqlClient/SqlConnection.cs: Open (): catch TdsInternalException and throw
SqlException.
* System.Data/System.Data.SqlClient/SqlException.cs: code re-organised to pass message as well with
the exception.
svn path=/trunk/mcs/; revision=46722
* System.Data.Common/DbConnectionStringBuilder.cs: Implemented method for parsing
connection string through "ConnectionString" property.
* System.Data.Common/DbConnectionStringBuilderHelper.cs: Helper class to provide
conversion between string=>.net type mapping for connection string
builders. The idea is to use between other providers (odbc) as well.
* System.Data.SqlClient/SqlConnectionStringBuilder.cs: Connection String Builder class
for SqlClient Data Provider.
* Test/System.Data.SqlClient/SqlConnectionStringBuilderTest.cs: Added some preliminary tests.
* System.Data.dll.sources: Added SqlConnectionStringBuilder.cs and DbConnectionStringBuilderHelper.cs
* System.Data_test.dll.sources: Added SqlConnectionStringBuilderTest.cs
svn path=/trunk/mcs/; revision=46289
* SqlParameter.cs: Parameter's value can be SqlTypes. Convert to
framework type to pass to TDS layer. Fixes bug #75044.
svn path=/trunk/mcs/; revision=45289
* Added SqlClientMetaDataCollectionNames.cs, Implemented some 2.0
properties for SqlParameterCollection for the bulkcopy feature.
svn path=/trunk/mcs/; revision=44964
SqlNotificationInfo and added new method in SqlRowUpdatingEventArgs.cs
(For implementation of bulkcopy/notifications)
svn path=/trunk/mcs/; revision=44738
* SqlDataReader.cs: NextResult (): Re-create schema table for each
result set. don't re-use, as it may be referenced from somewhere.
svn path=/trunk/mcs/; revision=43240
* SqlCommand.cs: Execute: Add a semicolon at the end of
CommandText. Multiple semicolon's are not being complained.
fixes bug #74134.
svn path=/trunk/mcs/; revision=42305
2005-03-08 Sureshkumar T <[email protected]>
* DbParameterBase.cs: Implemented most of get set methods.
* DbConnectionBase.cs: Commented ConnectionOptions creation,
because it is not yet implemented.
* DbCommandBase.cs: Implemented ExecuteScalar method.
* DbParameterCollectionBase.cs: Implemented Add method.
* DbDataReaderBase.cs: removed internal constructor DbDataReader
(DbCommand).
In System.Data.SqlClient:
2005-03-08 Sureshkumar T <[email protected]>
* SqlDataReader.cs: Call base constructor with CommandBehavior
parameter instead of passing DbCommand object. The internal base
class with DbCommand Parameter is removed.
svn path=/trunk/mcs/; revision=41552
* SqlCommand.cs : Set CommandBehavior on
ExecuteReader,ExecuteScalar,ExecuteNonQuery. This is used in
CloseDataReader.
This fixes bug #73252.
svn path=/trunk/mcs/; revision=41519
2005-03-02 Sureshkumar T <[email protected]>
* DbConnectionBase.cs: CreateDbCommand: assign connection to the
created command.
In .:
2005-03-02 Sureshkumar T <[email protected]>
* System.Data.dll.sources: Added
System.Data.SqlClient/SqlConnectionFactory.cs.
In System.Data.SqlClient:
2005-03-03 Sureshkumar T <[email protected]>
* 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.
svn path=/trunk/mcs/; revision=41382
* 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.
svn path=/trunk/mcs/; revision=41026
* 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.
svn path=/trunk/mcs/; revision=39974
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.
svn path=/trunk/mcs/; revision=36527