I've googled and searched the PDF file but still have not figured out
how to invoke a simple stored procedure in c# using iBatisNet. The
stored procedure could be as follows:
create procedure fnIsValidSVN @svn varchar(128) as
set nocount on
declare @cnt int;
select @cnt = count(*) from tblVendors
where (ShortVN = @svn);
return @cnt
Pretty straight forward stuff. Following is the xml I think I need
except for the actual call which I'm not sure of.
<procedure id="IsValidSVN" parameterMap="SVNParams">
--not sure what would go here--
</procedure>
<parameterMap id="SVNParams">
<parameter property="--not sure what goes here--"
direction="Output" dbType="Int" type="int"/>
<parameter property="@svn" dbType="VarChar" size="128"
type="string" direction="Input"/>
</parameterMap>
As to how to actually use the above in c# I've not a clue. Somehow I
need to invoke IsValidSVN and pass it at least one string param and then
access the return value of the stored procedure. Can someone add a bit
of c# in reply?
Thanx much,
Garth
