Page 1 of 1

Can't use a table-valued function

Posted: Thu 07 Jan 2021 12:32
by 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?

Re: Can't use a table-valued function

Posted: Sat 09 Jan 2021 18:53
by 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.

Re: Can't use a table-valued function

Posted: Tue 12 Jan 2021 15:13
by KenD3
Thank you, that appears to work.