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.
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:
> > 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! > > >
