Hi guys,

I use LLBL v2.6 in self servicing mode (with 2 classes) and I want a add a new read only property to an entity and return the result of a stored procedure. Can you post a example how to do this in the best way? I was thinking to use an SqlCommand object but didn't seem like the LLBL style...

Thanks

You can map this SP to LLBLGen funtction call, and perform the call in the get of the property.

Is it possible to do in LLBL something like:

select field1, field2, func1(f3) from entity1.....

and get the entity with field f3 mapped as a function in one query or you will end up with 2 queries, one for entity and on to get the result of the function for field f3 like:

select field1, field2, f3 from entity1 and then select func1(f3)

thanks

You can't get it added to the main select if you are fetching entities, you will always end up with 2 SQL calls.

If you are using a DynamicList, you can use a DBFunctionCall to get the call to the function included in the SQL select statement.

Matt

Thanks guys.