Can't use a table-valued function

[KenD3]

I have a table-valued function in my database, which has been added to Entity Developer. However, I don't have the ability to set this as a table-valued function as shown in the documentation. The docs show the "Method Editor" having a checkbox marked "Table-Value function" - however, this doesn't appear in my version of Entity Developer (v6.10.1145); it has options for Name, Source, Access, Inheritance Modifier and Return Type.

When I tried to use the generate code, I can get the exception

Code: Select all

SqlException: The request for procedure 'CallHistory' failed because 'CallHistory' is a table valued function object.

What am I doing wrong, and how can I call the table-valued function from LinqConnect?

[Shalex]

Try setting Pipelined=True in the properties of the method in Entity Developer.

If this doesn't help, specify the DDL script of your table-valued function and related database objects.

[KenD3]

Thank you, that appears to work.