Thank you so much sir, but it didn't work for me as the database function in PostgreSQL and
EntityFramework6.Npgsql is used as provider for entity framework.
Thanks!
Vikram
On Thu, Feb 6, 2020 at 9:23 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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.klaver@xxxxxxxxxxx
