开发者

Can a database function be called in the predicate of a llblgen query?

开发者 https://www.devze.com 2023-02-01 07:10 出处:网络
I want to 开发者_如何学Cuse a table-valued database function in the where clause of a query I am building using LLBLGen Pro 2.6 (self-servicing).

I want to 开发者_如何学Cuse a table-valued database function in the where clause of a query I am building using LLBLGen Pro 2.6 (self-servicing).

SELECT * FROM [dbo].[Users]
WHERE [dbo].[Users].[UserID] IN (
SELECT UserID FROM [dbo].[GetScopedUsers] (@ScopedUserID)
)

I am looking into the FieldCompareSetPredicate class, but can't for the life of me figure out what the exact signature would be. Any help would be greatly appreciated.

ADDITION - A better question would be "How do can you interact with a table-valued function via LLBLGen Pro?" I do not see how to generate files/classes for it.


Yes. Use DbFunctioncallExpression, to formulate an expression with a DbFunctionCall and then use a FieldCompareExpression predicate to use it. See 'Calling a Database Function' in ... the manual! :) http://www.llblgen.com/documentation/3.0/LLBLGen%20Pro%20RTF/hh_goto.htm#Using%20the%20generated%20code/gencode_dbfunctioncall.htm

Please post questions on our forums, it's easier to track them down :)

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号