Re: Function not imported in Entity Framework

On 2/6/20 1:36 AM, Vikram Sah wrote:
> Dear sir/mam,
>
> I want to integrate PostgreSQL database to entity framework in asp.net
> <http://asp.net> using database first approach. but when try to add
> function then error occurred:
>
> *Error 6046: Unable to generate function import return type of the store
> function.*

This really a question for the EntityFramework maintainers/users. Still
I did find this:

https://stackoverflow.com/questions/24161005/error-6046-unable-to-generate-function-import-return-type-of-the-store-function

>
> I have following configuration:
>
> PostgreSQL 11.6,
> npgsql v.4.0.9.0,
> EntityFramework6.Npgsql 3.2.1.1,
> in .net framework 4.5.2
>
> *My function in postgresql database is :*
>
> CREATE OR REPLACE FUNCTION dbo.EmployeeDetail ()
> RETURNS TABLE (
> emp_name VARCHAR,
> emp_Id UUID
> )
> AS $$
> BEGIN
> RETURN QUERY SELECT
> "EmployeName",
> "EmployeeID"
> FROM
> dbo.Employee;
> END; $$
>
> LANGUAGE 'plpgsql';
>
>
> Can you pls help! I did more researches but no luck.
>
>
> Thanks!
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com