Print Page | Close Window

Can I pass User Defined Tables-Type to StoreProcedure with ideablade?

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=3536
Printed Date: 13-May-2026 at 4:40am


Topic: Can I pass User Defined Tables-Type to StoreProcedure with ideablade?
Posted By: pponzano
Subject: Can I pass User Defined Tables-Type to StoreProcedure with ideablade?
Date Posted: 13-Jul-2012 at 3:30am
Hello,
I've to call a store procedure on some different items....... for now I'm doing ths calling for each item a storedprocedure... I was wondering if it's possible to pass at a SQL Server SP a custom user defined datatype (with ado It's possible I've done it more then one time.... )

Thanks


Replies:
Posted By: sbelini
Date Posted: 13-Jul-2012 at 2:58pm
Hi Paolo,
 
Unfortunatelly, in DevForce ( and EF, for that matter) the type passed to a stored proc must be present in the model.
 
The alternative in this case would be using raw ADO.
 
Regards,
   Silvio.


Print Page | Close Window