I have a pipelined function who is returning an array of a custom type (for example addresses of a client). This function take one argument (clientId, for example). My idea is to see this pipelined function as an entity in an EF model, linked to a 'Client' entity (table based). And of course, the link is supposed to be on ClientId and it has to be used as the argument of the function.
Possible or not ???
I can use a view, but the performances are very poor (due to the complexity of the function).