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
