Hi Garth
<procedure id="IsValidSVN" parameterMap="SVNParams">
fnIsValidSVN --Name of your sp.
</procedure>
<parameterMap id="SVNParams" class="">
<parameter property="Name of your property/param from c# code" column
="Name of the corresponding param in the sp body" direction="Output"
dbType="Int" type="int"/>
</parameterMap>
Garth Keesler <[EMAIL PROTECTED]> wrote:
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.
--not sure what would go here--
direction="Output" dbType="Int" type="int"/>
type="string" direction="Input"/>
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
---------------------------------
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.
