Modified: ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/providers.config URL: http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/providers.config?rev=384614&r1=384613&r2=384614&view=diff ============================================================================== --- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/providers.config (original) +++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/providers.config Thu Mar 9 12:57:36 2006 @@ -18,6 +18,7 @@ usePositionalParameters="false" useParameterPrefixInSql="true" useParameterPrefixInParameter="true" + allowPreparingCommands="true" parameterPrefix="@" /> <provider @@ -36,6 +37,7 @@ usePositionalParameters="false" useParameterPrefixInSql="true" useParameterPrefixInParameter="true" + allowPreparingCommands="true" parameterPrefix="@" /> <provider @@ -52,9 +54,10 @@ commandBuilderClass=" System.Data.SqlClient.SqlCommandBuilder" usePositionalParameters = "false" useParameterPrefixInSql = "true" - useParameterPrefixInParameter = "true" + useParameterPrefixInParameter = "true" + allowPreparingCommands="true" parameterPrefix="@" - /> + /> <provider name="OleDb1.1" description="OleDb, provider V1.0.5000.0 in framework .NET V1.1" enabled="true" @@ -69,6 +72,7 @@ usePositionalParameters="true" useParameterPrefixInSql="false" useParameterPrefixInParameter="false" + allowPreparingCommands="true" parameterPrefix="" /> <provider name="OleDb2.0" @@ -85,24 +89,27 @@ usePositionalParameters="true" useParameterPrefixInSql="false" useParameterPrefixInParameter="false" + allowPreparingCommands="true" parameterPrefix="" /> -<provider - name="Odbc1.1" - description="Odbc, provider V1.0.5000.0 in framework .NET V1.1" - enabled="true" - assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" - connectionClass="System.Data.Odbc.OdbcConnection" - commandClass="System.Data.Odbc.OdbcCommand" - parameterClass="System.Data.Odbc.OdbcParameter" - parameterDbTypeClass="System.Data.Odbc.OdbcType" - parameterDbTypeProperty="OdbcType" - dataAdapterClass="System.Data.Odbc.OdbcDataAdapter" - commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder" - usePositionalParameters="true" - useParameterPrefixInSql="false" - useParameterPrefixInParameter="false" - parameterPrefix="@"/> + <provider + name="Odbc1.1" + description="Odbc, provider V1.0.5000.0 in framework .NET V1.1" + enabled="true" + assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" + connectionClass="System.Data.Odbc.OdbcConnection" + commandClass="System.Data.Odbc.OdbcCommand" + parameterClass="System.Data.Odbc.OdbcParameter" + parameterDbTypeClass="System.Data.Odbc.OdbcType" + parameterDbTypeProperty="OdbcType" + dataAdapterClass="System.Data.Odbc.OdbcDataAdapter" + commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder" + usePositionalParameters="true" + useParameterPrefixInSql="false" + useParameterPrefixInParameter="false" + allowPreparingCommands="true" + parameterPrefix="@" + /> <provider name="Odbc2.0" description="Odbc, provider V2.0.0.0 in framework .NET V2" @@ -118,178 +125,201 @@ usePositionalParameters="true" useParameterPrefixInSql="false" useParameterPrefixInParameter="false" - parameterPrefix="@"/> -<provider - name="oracle9.2" - description="Oracle, Oracle provider V9.2.0.401" - enabled="false" - assemblyName="Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionClass="Oracle.DataAccess.Client.OracleConnection" - commandClass="Oracle.DataAccess.Client.OracleCommand" - parameterClass="Oracle.DataAccess.Client.OracleParameter" - parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType" - parameterDbTypeProperty="OracleDbType" - dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter" - commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder" - usePositionalParameters="false" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="false" - parameterPrefix=":" - useDeriveParameters="false"/> -<provider - name="oracle10.1" - description="Oracle, oracle provider V10.1.0.301" - enabled="false" - assemblyName="Oracle.DataAccess, Version=10.1.0.301, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionClass="Oracle.DataAccess.Client.OracleConnection" - commandClass="Oracle.DataAccess.Client.OracleCommand" - parameterClass="Oracle.DataAccess.Client.OracleParameter" - parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType" - parameterDbTypeProperty="OracleDbType" - dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter" - commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder" - usePositionalParameters="true" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="true" - parameterPrefix=":" - useDeriveParameters="false"/> -<provider - name="oracleClient1.0" - description="Oracle, Microsoft provider V1.0.5000.0" - enabled="false" - assemblyName="System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.OracleClient.OracleConnection" - commandClass="System.Data.OracleClient.OracleCommand" - parameterClass="System.Data.OracleClient.OracleParameter" - parameterDbTypeClass="System.Data.OracleClient.OracleType" - parameterDbTypeProperty="OracleType" - dataAdapterClass="System.Data.OracleClient.OracleDataAdapter" - commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder" - usePositionalParameters="false" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="false" - parameterPrefix=":"/> -<provider - name="ByteFx" - description="MySQL, ByteFx provider V0.7.6.15073" - enabled="false" - assemblyName="ByteFX.MySqlClient, Version=0.7.6.15073, Culture=neutral, PublicKeyToken=f2fef6fed1732fc1" connectionClass="ByteFX.Data.MySqlClient.MySqlConnection" - commandClass="ByteFX.Data.MySqlClient.MySqlCommand" - parameterClass="ByteFX.Data.MySqlClient.MySqlParameter" - parameterDbTypeClass="ByteFX.Data.MySqlClient.MySqlDbType" - parameterDbTypeProperty="MySqlDbType" - dataAdapterClass="ByteFX.Data.MySqlClient.MySqlDataAdapter" - commandBuilderClass="ByteFX.Data.MySqlClient.MySqlCommandBuilder" - usePositionalParameters="false" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="true" - parameterPrefix="@"/> -<provider - name="MySql" - description="MySQL, MySQL provider V1.0.5.13785" - enabled="false" - assemblyName="MySql.Data, Version=1.0.5.13785, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionClass="MySql.Data.MySqlClient.MySqlConnection" - commandClass="MySql.Data.MySqlClient.MySqlCommand" - parameterClass="MySql.Data.MySqlClient.MySqlParameter" - parameterDbTypeClass="MySql.Data.MySqlClient.MySqlDbType" - parameterDbTypeProperty="MySqlDbType" - dataAdapterClass="MySql.Data.MySqlClient.MySqlDataAdapter" - commandBuilderClass="MySql.Data.MySqlClient.MySqlCommandBuilder" - usePositionalParameters="false" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="true" - parameterPrefix="?"/> -<provider name="SQLite3" - description="SQLite, SQLite.NET provider V0.21.1869.3794" - enabled="false" - assemblyName="SQLite.NET, Version=0.21.1869.3794, Culture=neutral, PublicKeyToken=c273bd375e695f9c" - connectionClass="Finisar.SQLite.SQLiteConnection" - commandClass="Finisar.SQLite.SQLiteCommand" - parameterClass="Finisar.SQLite.SQLiteParameter" - parameterDbTypeClass="System.Data.DbType, System.Data" - parameterDbTypeProperty="DbType" - dataAdapterClass="Finisar.SQLite.SQLiteDataAdapter" - commandBuilderClass="Finisar.SQLite.SQLiteCommandBuilder" - usePositionalParameters="false" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="true" - parameterPrefix="@" - setDbParameterPrecision="false" - setDbParameterScale="false"/> -<provider - name="Firebird1.7" - description="Firebird, Firebird SQL .NET provider V1.7.0.33200" - enabled="false" - assemblyName="FirebirdSql.Data.Firebird, Version=1.7.0.33200, Culture=neutral, PublicKeyToken=fa843d180294369d" connectionClass="FirebirdSql.Data.Firebird.FbConnection" - commandClass="FirebirdSql.Data.Firebird.FbCommand" - parameterClass="FirebirdSql.Data.Firebird.FbParameter" - parameterDbTypeClass="FirebirdSql.Data.Firebird.FbDbType" - parameterDbTypeProperty="FbDbType" - dataAdapterClass="FirebirdSql.Data.Firebird.FbDataAdapter" - commandBuilderClass="FirebirdSql.Data.Firebird.FbCommandBuilder" - usePositionalParameters="false" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="true" - parameterPrefix="@"/> -<provider - name="PostgreSql0.7" - description="PostgreSql, Npgsql provider V0.7.0.0" - enabled="false" - assemblyName="Npgsql, Version=0.7.0.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" - connectionClass="Npgsql.NpgsqlConnection" - commandClass="Npgsql.NpgsqlCommand" - parameterClass="Npgsql.NpgsqlParameter" - parameterDbTypeClass="NpgsqlTypes.NpgsqlDbType" - parameterDbTypeProperty="NpgsqlDbType" - dataAdapterClass="Npgsql.NpgsqlDataAdapter" - commandBuilderClass="Npgsql.NpgsqlCommandBuilder" - usePositionalParameters="false" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="true" - parameterPrefix=":"/> -<provider - name="PostgreSql0.7.1" - description="PostgreSql, Npgsql provider V0.7.1.0" - enabled="false" - assemblyName="Npgsql, Version=0.7.1.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" - connectionClass="Npgsql.NpgsqlConnection" - commandClass="Npgsql.NpgsqlCommand" - parameterClass="Npgsql.NpgsqlParameter" - parameterDbTypeClass="NpgsqlTypes.NpgsqlDbType" - parameterDbTypeProperty="NpgsqlDbType" - dataAdapterClass="Npgsql.NpgsqlDataAdapter" - commandBuilderClass="Npgsql.NpgsqlCommandBuilder" - usePositionalParameters="false" - useParameterPrefixInSql="true" - useParameterPrefixInParameter="true" - parameterPrefix=":"/> -<provider - name="iDb2.10" - description="IBM DB2 Provider, V 10.0" - enabled="false" - assemblyName="IBM.Data.DB2.iSeries, Version=10.0.0.0,Culture=neutral, PublicKeyToken=9cdb2ebfb1f93a26, Custom=null" connectionClass="IBM.Data.DB2.iSeries.iDB2Connection" - commandClass="IBM.Data.DB2.iSeries.iDB2Command" - parameterClass="IBM.Data.DB2.iSeries.iDB2Parameter" - parameterDbTypeClass="IBM.Data.DB2.iSeries.iDB2DbType" - parameterDbTypeProperty="iDB2DbType" - dataAdapterClass="IBM.Data.DB2.iSeries.iDB2DataAdapter" - commandBuilderClass="IBM.Data.DB2.iSeries.iDB2CommandBuilder" - usePositionalParameters="true" - useParameterPrefixInSql="false" - useParameterPrefixInParameter="false" - parameterPrefix=""/> -<provider - name="Informix" - description="Informix NET Provider, 2.81.0.0" - enabled="false" - assemblyName="IBM.Data.Informix, Version=2.81.0.0, Culture=neutral, PublicKeyToken=7c307b91aa13d208" - connectionClass="IBM.Data.Informix.IfxConnection" - commandClass="IBM.Data.Informix.IfxCommand" - parameterClass="IBM.Data.Informix.IfxParameter" - parameterDbTypeClass="IBM.Data.Informix.IfxType" - parameterDbTypeProperty="IfxType" - dataAdapterClass="IBM.Data.Informix.IfxDataAdapter" - commandBuilderClass="IBM.Data.Informix.IfxCommandBuilder" - usePositionalParameters = "true" - useParameterPrefixInSql = "false" - useParameterPrefixInParameter = "false" - useDeriveParameters="false" + allowPreparingCommands="true" + parameterPrefix="@" + /> + <provider + name="oracle9.2" + description="Oracle, Oracle provider V9.2.0.401" + enabled="false" + assemblyName="Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionClass="Oracle.DataAccess.Client.OracleConnection" + commandClass="Oracle.DataAccess.Client.OracleCommand" + parameterClass="Oracle.DataAccess.Client.OracleParameter" + parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType" + parameterDbTypeProperty="OracleDbType" + dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter" + commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder" + usePositionalParameters="false" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="false" + parameterPrefix=":" + allowPreparingCommands="true" + useDeriveParameters="false" + /> + <provider + name="oracle10.1" + description="Oracle, oracle provider V10.1.0.301" + enabled="false" + assemblyName="Oracle.DataAccess, Version=10.1.0.301, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionClass="Oracle.DataAccess.Client.OracleConnection" + commandClass="Oracle.DataAccess.Client.OracleCommand" + parameterClass="Oracle.DataAccess.Client.OracleParameter" + parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType" + parameterDbTypeProperty="OracleDbType" + dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter" + commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder" + usePositionalParameters="true" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="true" + parameterPrefix=":" + allowPreparingCommands="true" + useDeriveParameters="false" + /> + <provider + name="oracleClient1.0" + description="Oracle, Microsoft provider V1.0.5000.0" + enabled="false" + assemblyName="System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.OracleClient.OracleConnection" + commandClass="System.Data.OracleClient.OracleCommand" + parameterClass="System.Data.OracleClient.OracleParameter" + parameterDbTypeClass="System.Data.OracleClient.OracleType" + parameterDbTypeProperty="OracleType" + dataAdapterClass="System.Data.OracleClient.OracleDataAdapter" + commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder" + usePositionalParameters="false" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="false" + allowPreparingCommands="true" + parameterPrefix=":" + /> + <provider + name="ByteFx" + description="MySQL, ByteFx provider V0.7.6.15073" + enabled="false" + assemblyName="ByteFX.MySqlClient, Version=0.7.6.15073, Culture=neutral, PublicKeyToken=f2fef6fed1732fc1" connectionClass="ByteFX.Data.MySqlClient.MySqlConnection" + commandClass="ByteFX.Data.MySqlClient.MySqlCommand" + parameterClass="ByteFX.Data.MySqlClient.MySqlParameter" + parameterDbTypeClass="ByteFX.Data.MySqlClient.MySqlDbType" + parameterDbTypeProperty="MySqlDbType" + dataAdapterClass="ByteFX.Data.MySqlClient.MySqlDataAdapter" + commandBuilderClass="ByteFX.Data.MySqlClient.MySqlCommandBuilder" + usePositionalParameters="false" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="true" + allowPreparingCommands="false" + parameterPrefix="@" + /> + <provider + name="MySql" + description="MySQL, MySQL provider V1.0.5.13785" + enabled="false" + assemblyName="MySql.Data, Version=1.0.5.13785, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionClass="MySql.Data.MySqlClient.MySqlConnection" + commandClass="MySql.Data.MySqlClient.MySqlCommand" + parameterClass="MySql.Data.MySqlClient.MySqlParameter" + parameterDbTypeClass="MySql.Data.MySqlClient.MySqlDbType" + parameterDbTypeProperty="MySqlDbType" + dataAdapterClass="MySql.Data.MySqlClient.MySqlDataAdapter" + commandBuilderClass="MySql.Data.MySqlClient.MySqlCommandBuilder" + usePositionalParameters="false" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="true" + allowPreparingCommands="false" + parameterPrefix="?" + /> + <provider name="SQLite3" + description="SQLite, SQLite.NET provider V0.21.1869.3794" + enabled="false" + assemblyName="SQLite.NET, Version=0.21.1869.3794, Culture=neutral, PublicKeyToken=c273bd375e695f9c" + connectionClass="Finisar.SQLite.SQLiteConnection" + commandClass="Finisar.SQLite.SQLiteCommand" + parameterClass="Finisar.SQLite.SQLiteParameter" + parameterDbTypeClass="System.Data.DbType, System.Data" + parameterDbTypeProperty="DbType" + dataAdapterClass="Finisar.SQLite.SQLiteDataAdapter" + commandBuilderClass="Finisar.SQLite.SQLiteCommandBuilder" + usePositionalParameters="false" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="true" + parameterPrefix="@" + setDbParameterPrecision="false" + setDbParameterScale="false" + allowPreparingCommands="false" + /> + <provider + name="Firebird1.7" + description="Firebird, Firebird SQL .NET provider V1.7.0.33200" + enabled="false" + assemblyName="FirebirdSql.Data.Firebird, Version=1.7.0.33200, Culture=neutral, PublicKeyToken=fa843d180294369d" connectionClass="FirebirdSql.Data.Firebird.FbConnection" + commandClass="FirebirdSql.Data.Firebird.FbCommand" + parameterClass="FirebirdSql.Data.Firebird.FbParameter" + parameterDbTypeClass="FirebirdSql.Data.Firebird.FbDbType" + parameterDbTypeProperty="FbDbType" + dataAdapterClass="FirebirdSql.Data.Firebird.FbDataAdapter" + commandBuilderClass="FirebirdSql.Data.Firebird.FbCommandBuilder" + usePositionalParameters="false" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="true" + allowPreparingCommands="false" + parameterPrefix="@" + /> + <provider + name="PostgreSql0.7" + description="PostgreSql, Npgsql provider V0.7.0.0" + enabled="false" + assemblyName="Npgsql, Version=0.7.0.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" + connectionClass="Npgsql.NpgsqlConnection" + commandClass="Npgsql.NpgsqlCommand" + parameterClass="Npgsql.NpgsqlParameter" + parameterDbTypeClass="NpgsqlTypes.NpgsqlDbType" + parameterDbTypeProperty="NpgsqlDbType" + dataAdapterClass="Npgsql.NpgsqlDataAdapter" + commandBuilderClass="Npgsql.NpgsqlCommandBuilder" + usePositionalParameters="false" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="true" + allowPreparingCommands="false" + parameterPrefix=":" + /> + <provider + name="PostgreSql0.7.1" + description="PostgreSql, Npgsql provider V0.7.1.0" + enabled="false" + assemblyName="Npgsql, Version=0.7.1.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" + connectionClass="Npgsql.NpgsqlConnection" + commandClass="Npgsql.NpgsqlCommand" + parameterClass="Npgsql.NpgsqlParameter" + parameterDbTypeClass="NpgsqlTypes.NpgsqlDbType" + parameterDbTypeProperty="NpgsqlDbType" + dataAdapterClass="Npgsql.NpgsqlDataAdapter" + commandBuilderClass="Npgsql.NpgsqlCommandBuilder" + usePositionalParameters="false" + useParameterPrefixInSql="true" + useParameterPrefixInParameter="true" + allowPreparingCommands="false" + parameterPrefix=":" + /> + <provider + name="iDb2.10" + description="IBM DB2 Provider, V 10.0" + enabled="false" + assemblyName="IBM.Data.DB2.iSeries, Version=10.0.0.0,Culture=neutral, PublicKeyToken=9cdb2ebfb1f93a26, Custom=null" connectionClass="IBM.Data.DB2.iSeries.iDB2Connection" + commandClass="IBM.Data.DB2.iSeries.iDB2Command" + parameterClass="IBM.Data.DB2.iSeries.iDB2Parameter" + parameterDbTypeClass="IBM.Data.DB2.iSeries.iDB2DbType" + parameterDbTypeProperty="iDB2DbType" + dataAdapterClass="IBM.Data.DB2.iSeries.iDB2DataAdapter" + commandBuilderClass="IBM.Data.DB2.iSeries.iDB2CommandBuilder" + usePositionalParameters="true" + useParameterPrefixInSql="false" + useParameterPrefixInParameter="false" + allowPreparingCommands="false" + parameterPrefix="" + /> + <provider + name="Informix" + description="Informix NET Provider, 2.81.0.0" + enabled="false" + assemblyName="IBM.Data.Informix, Version=2.81.0.0, Culture=neutral, PublicKeyToken=7c307b91aa13d208" + connectionClass="IBM.Data.Informix.IfxConnection" + commandClass="IBM.Data.Informix.IfxCommand" + parameterClass="IBM.Data.Informix.IfxParameter" + parameterDbTypeClass="IBM.Data.Informix.IfxType" + parameterDbTypeProperty="IfxType" + dataAdapterClass="IBM.Data.Informix.IfxDataAdapter" + commandBuilderClass="IBM.Data.Informix.IfxCommandBuilder" + usePositionalParameters = "true" + useParameterPrefixInSql = "false" + useParameterPrefixInParameter = "false" + useDeriveParameters="false" + allowPreparingCommands="false" /> </providers>
Modified: ibatis/trunk/cs/mapper/IBatisNet.DataMapper/Commands/DefaultPreparedCommand.cs URL: http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper/Commands/DefaultPreparedCommand.cs?rev=384614&r1=384613&r2=384614&view=diff ============================================================================== --- ibatis/trunk/cs/mapper/IBatisNet.DataMapper/Commands/DefaultPreparedCommand.cs (original) +++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper/Commands/DefaultPreparedCommand.cs Thu Mar 9 12:57:36 2006 @@ -2,7 +2,7 @@ #region Apache Notice /***************************************************************************** * $Header: $ - * $Revision: $ + * $Revision$ * $Date$ * * iBATIS.NET Data Mapper @@ -49,7 +49,10 @@ #region Fields private static readonly ILog _logger = LogManager.GetLogger( System.Reflection.MethodBase.GetCurrentMethod().DeclaringType ); - #endregion + private StringBuilder _paramLogList = new StringBuilder(); // Log info + private StringBuilder _typeLogList = new StringBuilder(); // Log info + + #endregion #region IPreparedCommand Members @@ -68,6 +71,10 @@ { // the IDbConnection & the IDbTransaction are assign in the CreateCommand request.IDbCommand = session.CreateCommand(statement.CommandType); + if (session.DataSource.DbProvider.SupportsPreparingCommands) + { + request.IDbCommand.Prepare(); + } request.IDbCommand.CommandText = request.PreparedStatement.PreparedSql; @@ -94,10 +101,8 @@ { ArrayList properties = request.PreparedStatement.DbParametersName; ArrayList parameters = request.PreparedStatement.DbParameters; - StringBuilder paramLogList = new StringBuilder(); // Log info - StringBuilder typeLogList = new StringBuilder(); // Log info - for ( int i = 0; i < properties.Count; ++i ) + for ( int i = 0; i < properties.Count; ++i ) { IDataParameter sqlParameter = (IDataParameter)parameters[i]; IDataParameter parameterCopy = command.CreateParameter(); @@ -106,10 +111,13 @@ #region Logging if (_logger.IsDebugEnabled) { - paramLogList.Append(sqlParameter.ParameterName); - paramLogList.Append("=["); - typeLogList.Append(sqlParameter.ParameterName); - typeLogList.Append("=["); + _paramLogList.Remove(0, _paramLogList.Length); + _typeLogList.Remove(0, _paramLogList.Length); + + _paramLogList.Append(sqlParameter.ParameterName); + _paramLogList.Append("=["); + _typeLogList.Append(sqlParameter.ParameterName); + _typeLogList.Append("=["); } #endregion @@ -143,8 +151,8 @@ #region Logging if (_logger.IsDebugEnabled) { - paramLogList.Append( property.PropertyName ); - paramLogList.Append( "," ); + _paramLogList.Append(property.PropertyName); + _paramLogList.Append(","); } #endregion @@ -178,16 +186,16 @@ { if (parameterCopy.Value == System.DBNull.Value) { - paramLogList.Append("null"); - paramLogList.Append( "], " ); - typeLogList.Append("System.DBNull, null"); - typeLogList.Append( "], " ); + _paramLogList.Append("null"); + _paramLogList.Append("], "); + _typeLogList.Append("System.DBNull, null"); + _typeLogList.Append("], "); } else - { + { - paramLogList.Append( parameterCopy.Value.ToString() ); - paramLogList.Append( "], " ); + _paramLogList.Append(parameterCopy.Value.ToString()); + _paramLogList.Append("], "); // sqlParameter.DbType could be null (as with Npgsql) // if PreparedStatementFactory did not find a dbType for the parameter in: @@ -195,10 +203,10 @@ // Use parameterCopy.DbType //typeLogList.Append( sqlParameter.DbType.ToString() ); - typeLogList.Append( parameterCopy.DbType.ToString() ); - typeLogList.Append( ", " ); - typeLogList.Append( parameterCopy.Value.GetType().ToString() ); - typeLogList.Append( "], " ); + _typeLogList.Append(parameterCopy.DbType.ToString()); + _typeLogList.Append(", "); + _typeLogList.Append(parameterCopy.Value.GetType().ToString()); + _typeLogList.Append("], "); } } #endregion @@ -231,8 +239,8 @@ if (_logger.IsDebugEnabled && properties.Count>0) { - _logger.Debug("Statement Id: [" + statement.Id + "] Parameters: [" + paramLogList.ToString(0, paramLogList.Length - 2) + "]"); - _logger.Debug("Statement Id: [" + statement.Id + "] Types: [" + typeLogList.ToString(0, typeLogList.Length - 2) + "]"); + _logger.Debug("Statement Id: [" + statement.Id + "] Parameters: [" + _paramLogList.ToString(0, _paramLogList.Length - 2) + "]"); + _logger.Debug("Statement Id: [" + statement.Id + "] Types: [" + _typeLogList.ToString(0, _typeLogList.Length - 2) + "]"); } #endregion } Modified: ibatis/trunk/cs/mapper/IBatisNet.sln URL: http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.sln?rev=384614&r1=384613&r2=384614&view=diff ============================================================================== --- ibatis/trunk/cs/mapper/IBatisNet.sln (original) +++ ibatis/trunk/cs/mapper/IBatisNet.sln Thu Mar 9 12:57:36 2006 @@ -11,10 +11,6 @@ ProjectSection(ProjectDependencies) = postProject EndProjectSection EndProject -Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "IBatisNet.DataAccess.Extensions", "IBatisNet.DataAccess.Extensions\IBatisNet.DataAccess.Extensions.csproj", "{342C92B4-2742-4C55-9374-A504FE3B6972}" - ProjectSection(ProjectDependencies) = postProject - EndProjectSection -EndProject Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "IBatisNet.Common.Test", "IBatisNet.Common.Test\IBatisNet.Common.Test.csproj", "{5961F3DE-CB5E-40FE-AE89-D00D6E453907}" ProjectSection(ProjectDependencies) = postProject EndProjectSection @@ -56,12 +52,6 @@ {72F70057-B2E1-4DAD-BA6C-E2962745EEA5}.Debug Test.Build.0 = Debug|.NET {72F70057-B2E1-4DAD-BA6C-E2962745EEA5}.Release.ActiveCfg = Release|.NET {72F70057-B2E1-4DAD-BA6C-E2962745EEA5}.Release.Build.0 = Release|.NET - {342C92B4-2742-4C55-9374-A504FE3B6972}.Debug.ActiveCfg = Debug|.NET - {342C92B4-2742-4C55-9374-A504FE3B6972}.Debug.Build.0 = Debug|.NET - {342C92B4-2742-4C55-9374-A504FE3B6972}.Debug Test.ActiveCfg = Debug|.NET - {342C92B4-2742-4C55-9374-A504FE3B6972}.Debug Test.Build.0 = Debug|.NET - {342C92B4-2742-4C55-9374-A504FE3B6972}.Release.ActiveCfg = Release|.NET - {342C92B4-2742-4C55-9374-A504FE3B6972}.Release.Build.0 = Release|.NET {5961F3DE-CB5E-40FE-AE89-D00D6E453907}.Debug.ActiveCfg = Debug|.NET {5961F3DE-CB5E-40FE-AE89-D00D6E453907}.Debug.Build.0 = Debug|.NET {5961F3DE-CB5E-40FE-AE89-D00D6E453907}.Debug Test.ActiveCfg = Debug|.NET
