Can't use a table-valued function

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
KenD3
Posts: 3
Joined: Mon 17 Aug 2020 19:18

Can't use a table-valued function

Post by KenD3 » Thu 07 Jan 2021 12:32

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
Site Admin
Posts: 9164
Joined: Thu 14 Aug 2008 12:44

Re: Can't use a table-valued function

Post by Shalex » Sat 09 Jan 2021 18:53

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
Posts: 3
Joined: Mon 17 Aug 2020 19:18

Re: Can't use a table-valued function

Post by KenD3 » Tue 12 Jan 2021 15:13

Thank you, that appears to work.

Post Reply