Can a database function be called in the predicate of a llblgen query?
Posted
by
Dan Appleyard
on Stack Overflow
See other posts from Stack Overflow
or by Dan Appleyard
Published on 2010-12-22T16:51:04Z
Indexed on
2010/12/22
16:54 UTC
Read the original article
Hit count: 295
I want to use 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.
© Stack Overflow or respective owner
