Framework EFv6 LLBLGenPro 4.2 Final 2014-11-19 PostgreSQL 9.3 VS2013 C#

L.S., I'm using the above environment to make use of stored procedures in a Postgres database database lis, schema exprop,

CREATE OR REPLACE FUNCTION load_municipalities() RETURNS character varying

In the DbContext class code is generated as below, which does not compile

var cmd = CreateStoredProcCallCommand(""expro"."load_municipalities"");

which i can trace back to template contextClassInclude.lpt (folder LLBLGen Pro v4.2\Frameworks\Entity Framework\Templates\Shared\C#)

string storedProcedureToCall = SD_EF_GeneralUtils.ProduceTargetFullName(targetProc, _executingGenerator);

Any ideas on how to fix this?

tnx

Could you please attach a repro solution?

see attached.

Npgsql version = 2.2.3

Selected preset = SD.EntityFramework.v6(Code First); Target Platform 4.5

Attached the generated code where PostgreSQL stored functions expro.load_municipalities() and public.load_temp_municipalities(varchar p_data_table)

are translated into GetLoadMunicipalitiesResults() and GetLoadTempMunicipalitiesResults(System.String pDataTable)

We'll look into it.

The \" escaping gets lost during string building for the name. Will fix.

Fixed. Copy the attached template into the following folder as administrator: <llblgen pro installation folder>\Frameworks\Entity Framework\Templates\Shared\C#

Thanks a lot, generated code is fine now.

        public DataTable GetLoadMunicipalitiesResults()
        {
            var cmd = CreateStoredProcCallCommand("\"expro\".\"load_municipalities\"");
            var toReturn = new DataTable();
            CreateAndSetupAdapter(cmd).Fill(toReturn);
            return toReturn;
        }