Update of /cvsroot/springnet/Spring.Net/test/Spring/Spring.Data.Integration.Tests/Data
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv28705
Modified Files:
StoredProcedureTests.cs
Log Message:
clean up imports, add additional integraiton style test.
Index: StoredProcedureTests.cs
===================================================================
RCS file: /cvsroot/springnet/Spring.Net/test/Spring/Spring.Data.Integration.Tests/Data/StoredProcedureTests.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** StoredProcedureTests.cs 3 Aug 2007 19:51:22 -0000 1.3
--- StoredProcedureTests.cs 11 Oct 2007 06:03:26 -0000 1.4
***************
*** 23,26 ****
--- 23,27 ----
using System;
using System.Collections;
+ using System.Data;
using NUnit.Framework;
using Spring.Context;
***************
*** 87,90 ****
--- 88,120 ----
}
}
+
+ [Test]
+ public void OutReturnValueTestWithAdoTemplate()
+ {
+ IDbParameters parameters = adoOperations.CreateDbParameters();
+ parameters.AddOut("Count", DbType.Int32);
+ parameters.AddReturn("RETURN_VALUE", DbType.Int32);
+ parameters.AddWithValue("Name", "George");
+ IList queryResults = adoOperations.QueryWithRowMapper(CommandType.StoredProcedure, "SelectByNameWithReturnAndOutValue",
+ new SimpleRowMapper(),
+ parameters);
+ for (int i = 0; i < parameters.Count;i++ )
+ {
+ Console.WriteLine("parameter " + i
+ + " name = " + parameters[i].ParameterName
+ + " value = " + parameters[i].Value);
+ }
+ // Console.WriteLine("out parameter 'count' = " + parameters["count"]);
+ //Console.WriteLine("RETURN_VALE = " + parameters["RETURN_VALUE"]);
+
+ }
}
+
+ internal class SimpleRowMapper : IRowMapper
+ {
+ public object MapRow(IDataReader reader, int rowNum)
+ {
+ return "hello";
+ }
+ }
}
|