Hi! Other simple question:

I have complex sql-function GetAllowedUserIdList that has one parameter (Guid) and returns multiple rows with single column of Guid (uniqueidentifier) type. How I can correctly read this data?

I do not want to wrap this function into stored procedure. Are there other ways?

1. I've found the thread http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=11573&StartAtMessage=0&#64617. In some cases it is the way.

2. I can realize function code generation task in custom task performer (like RetrievalProcedures behaviour)

But question is the same...

Are there other ways? More convenient and simple

idsn11 wrote:

Are there other ways? More convenient and simple

I'm afraid not. As I see your options are: A. Use a stored procedure, then you can call the SP from LLBLGen code, or project it to an entity or a custom class. B. Use a view that joins to your UDF, then you can map that view in LLBLGen. C. Use the workaround mentioned in your above link (modify a bit the way sql is generated). Did you try that code? (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=11573&StartAtMessage=0&#64617)

Understood.

Choise C is not suitable for me.

I'll realize two classes (ActionFunctions/RetrievalFunctions) generation (like ActionProcedures/RetrievalProcedures) with TaskPerformers (useful in the future).

Thanks for the answer.