You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by gb...@apache.org on 2005/03/31 07:05:47 UTC
svn commit: r159561 - in
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test:
Maps/MSSQL/SqlClient/EmbedParameter.xml
NUnit/SqlMapTests/MSSQL/EmbedParameterTest.cs
Author: gbayon
Date: Wed Mar 30 21:05:45 2005
New Revision: 159561
URL: http://svn.apache.org/viewcvs?view=rev&rev=159561
Log:
- Added NUnit [Category("EmbedParameter")]
Modified:
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/SqlClient/EmbedParameter.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/NUnit/SqlMapTests/MSSQL/EmbedParameterTest.cs
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/SqlClient/EmbedParameter.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/SqlClient/EmbedParameter.xml?view=diff&r1=159560&r2=159561
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/SqlClient/EmbedParameter.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/SqlClient/EmbedParameter.xml Wed Mar 30 21:05:45 2005
@@ -23,7 +23,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_SequenceID] = #value#
-->
@@ -42,7 +42,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_SequenceID] = #value#
</select>
@@ -62,7 +62,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest] WITH(INDEX([IDX_ManyRecordsTest_Seq]))
+ [ManyRecordsTest] WITH(INDEX([IDX_ManyRecordsTest_Seq]))
WHERE
[Many_SequenceID] = 91
-->
@@ -81,7 +81,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest] WITH(INDEX([IDX_ManyRecordsTest_Seq]))
+ [ManyRecordsTest] WITH(INDEX([IDX_ManyRecordsTest_Seq]))
WHERE
[Many_SequenceID] = #value#
</select>
@@ -101,7 +101,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_DistributedID] = 91
-->
@@ -120,7 +120,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_DistributedID] = #value#
</select>
@@ -140,7 +140,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest] WITH(INDEX([IDX_ManyRecordsTest_Dist]))
+ [ManyRecordsTest] WITH(INDEX([IDX_ManyRecordsTest_Dist]))
WHERE
[Many_DistributedID] = 91
-->
@@ -159,7 +159,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest] WITH(INDEX([IDX_ManyRecordsTest_Dist]))
+ [ManyRecordsTest] WITH(INDEX([IDX_ManyRecordsTest_Dist]))
WHERE
[Many_DistributedID] = #value#
</select>
@@ -179,7 +179,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_FifthID] = 30000
-->
@@ -198,7 +198,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_FifthID] = #value#
</select>
@@ -218,7 +218,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_FifthID] = 30000 OR
[Many_SequenceID] = 91
@@ -238,7 +238,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_FifthID] = #FifthID# OR
[Many_SequenceID] = #SequenceID#
@@ -259,7 +259,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_SampleDate] BETWEEN '1999-01-01' AND '1999-01-02'
-->
@@ -278,7 +278,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_SampleDate] BETWEEN #StartDate# AND #EndDate#
</select>
@@ -298,7 +298,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_SampleCharValue] = 'AAA'
-->
@@ -317,7 +317,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_SampleCharValue] = #value#
</select>
@@ -337,7 +337,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_SampleCharValue] LIKE '%AAA%'
-->
@@ -356,7 +356,7 @@
[Many_SampleDate] AS SampleDate,
[Many_SequenceDate] AS SequenceDate
FROM
- [dbo].[ManyRecordsTest]
+ [ManyRecordsTest]
WHERE
[Many_SampleCharValue] LIKE '%$value$%'
</select>
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/NUnit/SqlMapTests/MSSQL/EmbedParameterTest.cs
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/NUnit/SqlMapTests/MSSQL/EmbedParameterTest.cs?view=diff&r1=159560&r2=159561
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/NUnit/SqlMapTests/MSSQL/EmbedParameterTest.cs (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/NUnit/SqlMapTests/MSSQL/EmbedParameterTest.cs Wed Mar 30 21:05:45 2005
@@ -1,4 +1,7 @@
using System;
+using System.Data;
+using System.Data.SqlClient;
+
using System.Collections;
using NUnit.Framework;
@@ -17,6 +20,7 @@
/// </summary>
[TestFixture]
[Category("MSSQL")]
+ [Category("EmbedParameter")]
public class EmbedParameterTest : BaseTest
{
@@ -155,7 +159,21 @@
}
#endregion
+
+ public void TestAdoPerformanceWithParameter()
+ {
+ IDbConnection connection = new SqlConnection();
+ connection.ConnectionString = sqlMap.DataSource.ConnectionString;
+ IDbCommand command = new SqlCommand();
+// command.CommandType = CommandType.Text;
+// command.CommandText = "";
+// command.Parameters.Add ( "@id", id) ;
+// command.Parameters.Add ( "@desc", desc) ;
+// command.Prepare() ; // Calling Prepare after having set the Commandtext and parameters.
+// command.ExecuteNonQuery();
+
+ }
}
}