Hi All,
For those that know composite fairly well can I pick your brains? Any advice would be appreciated...
Currently; I have a data set returned by a SQL proc and exposed by a smart object. I want to extend this dataset with an additional item of information that's the result of a .NET library call in a similar manner to how an inline SQL function evaluates for each row returned. I have the .NET library exposed as a via the custom assembly endpoint.
Can a composite smart object provide this inline evaluation functionality?
To test this, I've added the additional output property via the smart objects' method bindings, set the services object to the correct function and bound the inputs properties of the function to the relevant smart object properties, however, when debugging via the SOTT the assembly is receiving null input values. I'm presuming this is because the additional method binding does not have access to the row level properties that have been returned by the main SQL procedure.
Can anybody confirm if this is as expected?
I understand I could bring the SP data back to the smart form first, then push it through the .NET function but this seems a little inefficient when the smart form doesn't need access to the parameters used in the call and the data is fairly sizeable.
Cheers,
Paul.