Entity Framework Plus extends your DbContext with must-haves features: Include Filter, Auditing, Caching, Query Future, Batch Delete, Batch Update, and more
Hello.
The problem with PostgreSQL. For him the qualifier name is the '"' symbol, not '[]'. In Sql Server qualifier name server can also act as the '"' symbol.
You can fix this?
The problem arose in the syntax of the query after an UPDATE statement to the instruction INNER JOIN
This DELETE statement is formed correctly, with USAGE, etc.
UPDATE A SET A.[custom_attributes] = $1, A.[modified_user_id] = $2, A.[modified_date] = $3 FROM [public].[service] AS A INNER JOIN ( SELECT "Extent1"."service_id", "Extent1"."service_number", "Extent1"."service_type_code", "Extent1"."department_type_code_create", "Extent1"."department_type_code_assigned", "Extent1"."department_type_code_reestr", "Extent1"."prepare_target_date", "Extent1"."created_user_id", "Extent1"."created_date", "Extent1"."modified_user_id", "Extent1"."modified_date", "Extent1"."reg_date", "Extent1"."reg_num", "Extent1"."custom_attributes", "Extent1"."output_target_date", "Extent1"."prepare_fact_date", "Extent1"."output_fact_date" FROM "public"."service" AS "Extent1" WHERE "Extent1"."service_id" = $4 ) AS B ON A.[service_id] = B.[service_id]
Hello. The problem with PostgreSQL. For him the qualifier name is the '"' symbol, not '[]'. In Sql Server qualifier name server can also act as the '"' symbol. You can fix this? The problem arose in the syntax of the query after an UPDATE statement to the instruction INNER JOIN This DELETE statement is formed correctly, with USAGE, etc.
UPDATE A SET A.[custom_attributes] = $1, A.[modified_user_id] = $2, A.[modified_date] = $3 FROM [public].[service] AS A INNER JOIN ( SELECT "Extent1"."service_id", "Extent1"."service_number", "Extent1"."service_type_code", "Extent1"."department_type_code_create", "Extent1"."department_type_code_assigned", "Extent1"."department_type_code_reestr", "Extent1"."prepare_target_date", "Extent1"."created_user_id", "Extent1"."created_date", "Extent1"."modified_user_id", "Extent1"."modified_date", "Extent1"."reg_date", "Extent1"."reg_num", "Extent1"."custom_attributes", "Extent1"."output_target_date", "Extent1"."prepare_fact_date", "Extent1"."output_fact_date" FROM "public"."service" AS "Extent1" WHERE "Extent1"."service_id" = $4 ) AS B ON A.[service_id] = B.[service_id]