Using Table Value Functions

Posts   
 
    
Posts: 28
Joined: 27-Mar-2007
# Posted on: 21-Feb-2008 13:54:51   

Hi, I am a little lost as to how to use LLBLGen to call a table value function. The function takes a single int value and returns a table of strings. I need to treat this as a dataset and apply a FieldLikePredicate to match a specific string. I'm looking at the DbFunctionCall stuff in the Call Database Function section of the manual. Any pointers would be appreciated.

Version: 2.5 DB: SQL 2000 Visual Studio : 2005 sp1 OS: Vista

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 21-Feb-2008 14:21:33   

You should wrap the function in a stored procedure, then LLBLGenPro can generate calls to the SP.

Please check the following thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=10619