Code: Select all
modelBuilder.Entity<Cliente>()
.HasMany(u => u.Cargadores)
.WithMany(c => c.Clientes).Map(f => f.MapLeftKey("ID_CLIENTE").MapRightKey("ID_CARGADOR").ToTable("DEGNET.CLIENTE_CARGADOR"));
Code: Select all
SELECT
'1X0X' AS C1,
"Join1".ID_ENTIDAD_LEGAL,
"Join1".NEMONICO,
"Join1".RAZON_SOCIAL,
"Join1".CUIT,
"Join1".FAX1 AS FAX,
"Join1".TELEFONO1 AS TELEFONO,
"Join1".MEGID,
"Join1".NOMBRE_PARA_TGN,
"Join1".RECIBE_FAX,
"Join1".FAX2 AS FAX1,
"Join1".TELEFONO2 AS TELEFONO1,
"Join1".EMAIL,
"Join1".RESPONSABLE,
"Join1".ID_CARGADOR_TGN
FROM "DEGNET.CLIENTE_CARGADOR" "Extent1" <----ERROR should be "DEGNET"."CLIENTE_CARGADOR"
INNER JOIN (SELECT
"Extent2".ID_ENTIDAD_LEGAL,
"Extent2".NEMONICO,
"Extent2".RAZON_SOCIAL,
"Extent2".CUIT,
"Extent2".FAX AS FAX1,
"Extent2".TELEFONO AS TELEFONO1,
"Extent2".MEGID,
"Extent3".ID_CARGADOR,
"Extent3".NOMBRE_PARA_TGN,
"Extent3".RECIBE_FAX,
"Extent3".FAX AS FAX2,
"Extent3".TELEFONO AS TELEFONO2,
"Extent3".EMAIL,
"Extent3".RESPONSABLE,
"Extent3".ID_CARGADOR_TGN
FROM RED.ENTIDAD_LEGAL "Extent2"
INNER JOIN RED.CARGADOR "Extent3" ON "Extent2".ID_ENTIDAD_LEGAL = "Extent3".ID_CARGADOR ) "Join1" ON "Extent1".ID_CARGADOR = "Join1".ID_ENTIDAD_LEGAL
WHERE "Extent1".ID_CLIENTE = :EntityKeyValue1
in order to fix this temporaly i have change the mapping to
Code: Select all
modelBuilder.Entity<Cliente>()
.HasMany(u => u.Cargadores)
.WithMany(c => c.Clientes).Map(f => f.MapLeftKey("ID_CLIENTE").MapRightKey("ID_CARGADOR").ToTable("DEGNET\".\"CLIENTE_CARGADOR"));