Hi, You can read this basic article :
http://www.supinfo-projects.com/fr/2005/ibatisneten/ an example of stored procedure call : public IEntityList<Adresse> GetEntityList() { try { AdresseList list = (AdresseList)DataAccess.Mapper.QueryForList<Adresse>("SelectAdresse", new Adresse()); return (list); } catch(System.Exception exception) { throw exception; } } Regards, Guilhem Berthalon AROBAN 28 rue des teinturiers 84 000 AVIGNON tel : 04 32 76 23 60 Hotline : 04 90 85 89 29 _____ De : Prosper [mailto:[EMAIL PROTECTED] Envoyé : lundi 26 février 2007 10:04 À : [email protected] Objet : Re: SQL Serer 2005 Stored Procedures (calling) 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! <http://us.rd.yahoo.com/evt=43909/*http:/mobile.yahoo.com/mail> Mail for Mobile and always <http://us.rd.yahoo.com/evt=43909/*http:/mobile.yahoo.com/mail> stay connected to friends.
image001.gif
Description: GIF image
