Oracle & EF: Varchar2 is not qualified with a namespace or alias

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
J4N
Posts: 11
Joined: Thu 09 Aug 2012 12:49

Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by J4N » Thu 09 Aug 2012 12:55

Hi,

I just created an edmx, with the latest version of devart oracle connector. I then added a dbContext template generator.

When I'm trying to get some data, I got a "MetadataException", with the following content:

The last week I did the same, but with a POCO template, and it worked. Any idea about how to resolve this problem?

I'm using Entity Framework 4.3.1. I found some things about putting some "IgnoreSchemaName",in a config object, but I don't have a config file, and I don't want any database-specific code in the application. If there something special to use, ok, but it has to be in the app.config file.
System.Data.MetadataException was unhandled
Message=Schema specified is not valid. Errors:
Law.ssdl(55,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(56,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(58,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(59,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(60,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(61,6) : error 0040: The Type CHAR is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(62,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(63,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(64,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(72,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(73,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(76,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(77,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(79,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(80,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(81,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(82,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(83,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(84,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(85,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(86,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(87,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(88,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(89,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(90,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(91,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(92,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(93,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(94,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(95,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(96,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(97,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(98,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(99,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(100,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(101,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(102,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(112,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(113,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(114,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(115,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(116,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(117,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(118,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(127,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(128,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(129,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(130,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(131,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(132,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(133,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(134,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(135,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(136,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(138,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(139,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(140,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(152,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(153,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(154,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(155,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(156,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(157,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(158,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(159,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(160,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(161,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(162,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(163,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(164,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(165,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(166,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(167,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(168,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(169,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(171,6) : error 0040: The Type CHAR is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(172,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(179,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(180,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(181,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(182,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(183,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(184,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(185,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(186,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(187,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(196,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(198,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(200,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(201,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(202,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(203,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(204,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(205,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(206,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(207,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(208,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(209,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(210,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(211,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(212,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(213,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(214,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(215,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(216,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(217,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(218,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(219,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(220,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(221,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(222,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(223,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(224,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(225,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(226,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(227,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(228,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(229,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(230,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(231,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(232,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(233,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(235,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(236,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(237,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(239,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(241,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(242,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(243,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(244,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(245,6) : error 0040: The Type CHAR is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(246,6) : error 0040: The Type CHAR is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(253,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(254,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(255,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(262,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(263,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(264,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(271,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(272,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(273,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(281,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(282,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(283,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(284,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(285,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(286,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(293,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(294,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(295,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(298,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(299,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(300,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(308,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(310,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(311,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(312,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(313,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(314,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(315,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(316,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(319,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(320,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(330,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(332,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(333,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(334,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(335,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(336,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(337,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(338,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(341,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(342,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(352,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(354,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(355,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(356,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(357,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(358,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(359,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(360,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(363,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(364,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(373,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(374,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(375,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(376,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(377,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(379,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(380,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(388,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(390,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(391,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(392,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(393,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(394,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(405,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(406,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(407,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(408,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Law.ssdl(409,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
Source=System.Data.Entity
StackTrace:
at System.Data.Metadata.Edm.StoreItemCollection.Loader.LoadItems(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths)
at System.Data.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths, Boolean throwOnError, DbProviderManifest& providerManifest, DbProviderFactory& providerFactory, String& providerManifestToken, Memoizer`2& cachedCTypeFunction)
at System.Data.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths)
at System.Data.Metadata.Edm.MetadataCache.StoreMetadataEntry.LoadStoreCollection(EdmItemCollection edmItemCollection, MetadataArtifactLoader loader)
at System.Data.Metadata.Edm.MetadataCache.LoadItemCollection[T](IItemCollectionLoader`1 itemCollectionLoader, T entry)
at System.Data.Metadata.Edm.MetadataCache.GetOrCreateStoreAndMappingItemCollections(String cacheKey, MetadataArtifactLoader loader, EdmItemCollection edmItemCollection, Object& entryToken)
at System.Data.EntityClient.EntityConnection.LoadStoreItemCollections(MetadataWorkspace workspace, DbConnection storeConnection, DbProviderFactory factory, DbConnectionOptions connectionOptions, EdmItemCollection edmItemCollection, MetadataArtifactLoader artifactLoader)
at System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections)
at System.Data.EntityClient.EntityConnection.InitializeMetadata(DbConnection newConnection, DbConnection originalConnection, Boolean closeOriginalConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator()
at System.Data.Entity.Internal.Linq.InternalSet`1.GetEnumerator()
at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator()

logesg
Posts: 2
Joined: Fri 10 Aug 2012 06:37

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by logesg » Fri 10 Aug 2012 07:19

Same here. Investigating a day, I dind't find a Solution for this Error so I use the previous Version.

Gregor

logesg
Posts: 2
Joined: Fri 10 Aug 2012 06:37

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by logesg » Fri 10 Aug 2012 09:05

Hello,
I just installed the new Version 7.1.58. The Problem seemed to be resolved there :) .

Gregor

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by Shalex » Fri 10 Aug 2012 14:03

As a temporary workaround, please specify this option in the code:

Code: Select all

config=Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance;
config.CodeFirstOptions.ColumnTypeCasingConventionCompatibility = false;
We will fix the issue with possibility of setting configuration options via the application config file and notify you.

guilford
Posts: 7
Joined: Wed 29 Aug 2012 17:47

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by guilford » Wed 29 Aug 2012 17:52

You say to specify the option in "the code", but what code do you mean? In the .cs file generated from the template? Somewhere in the project before the model is called for the first time? Could you specify where exactly these two lines of code need to go?

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by Shalex » Fri 31 Aug 2012 16:39

guilford wrote:Somewhere in the project before the model is called for the first time?
This is correct.

maneshwar
Posts: 2
Joined: Tue 04 Sep 2012 12:08

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by maneshwar » Tue 04 Sep 2012 12:15

I am still getting the following exception

A service exception occurred:
System.Data.MetadataException: Schema specified is not valid. Errors:
QHealthModel.ssdl(545,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(546,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(547,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(548,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(549,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(550,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(551,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(552,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(553,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(554,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(555,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1673,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1679,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1685,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1686,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1692,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1693,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1694,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1695,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1696,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(1697,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3032,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3033,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3038,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3041,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3042,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3043,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3044,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3047,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3048,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3051,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3052,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
QHealthModel.ssdl(3054,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
at QHealth.Framework.Data.Repository`1.Wrap[T](Func`1 method, Object[] parameters) in D:\Work\trunk\Components\Framework\QHealth.Framework.Data\Repository.cs:line 223
at QHealth.Framework.Data.Repository`1.GetSingle(ISpecification`1 specification, IEnumerable`1 includes) in D:\Work\trunk\Components\Framework\QHealth.Framework.Data\Repository.cs:line 77
at QHealth.Platform.Processing.UserAclProcessor.<>c__DisplayClass14.<ResolveUser>b__d() in D:\Work\trunk\Components\Platform\QHealth.Platform.Processing\UserAclProcessor.cs:line 118
at QHealth.Framework.Processing.ProcessorBase.Wrap[T](Func`1 method, Object[] parameters) in D:\Work\trunk\Components\Framework\QHealth.Framework.Processing\ProcessorBase.cs:line 181
at QHealth.Platform.Processing.UserAclProcessor.ResolveUser(ClaimsData data) in D:\Work\trunk\Components\Platform\QHealth.Platform.Processing\UserAclProcessor.cs:line 113
at QHealth.Platform.Services.UserAclService.<>c__DisplayClass1.<ResolveUser>b__0() in D:\Work\trunk\Components\Platform\QHealth.Platform.Services\UserAclService.cs:line 41
at QHealth.Framework.Services.ServiceBase.Wrap[T](Func`1 method, Object[] parameters) in D:\Work\trunk\Components\Framework\QHealth.Framework.Services\ServiceBase.cs:line 112


Oracle Data Provider DLL reference versions

Devart.Data Version 5.0.517.0
Devart.Data.Oracle Version 7.1.58.0

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by Shalex » Thu 06 Sep 2012 15:01

maneshwar,
Have you set the following option in your code before the first usage of the context (e.g., in a static constructor of the context or in the Main method of your program, etc)?

Code: Select all

config=Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance;
config.CodeFirstOptions.ColumnTypeCasingConventionCompatibility = false;
This setting will be available during all life of your application.

maneshwar
Posts: 2
Joined: Tue 04 Sep 2012 12:08

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by maneshwar » Thu 06 Sep 2012 15:08

Thanks for your reply; i have uninstalled latest connector and now using older version 7.0.25.0 and it's working fine.

Now receiving another unexpected exception

"OUTER APPLY is not supported by Oracle"

System.Data.EntityCommandCompilationException: An error occurred while preparing the command definition. See the inner exception for details. ---> System.NotSupportedException: OUTER APPLY is not supported by Oracle.

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by Shalex » Fri 07 Sep 2012 10:32

Shalex wrote:We will fix the issue with possibility of setting configuration options via the application config file and notify you.
The bug with setting configuration options via the application config file is fixed in the latest (7.2) version of dotConnect for Oracle. It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
maneshwar wrote:Now receiving another unexpected exception
"OUTER APPLY is not supported by Oracle"
This is a limitation of Entity Framework which does not take into account the peculiarities of other databases which differ from SQL Server: http://social.msdn.microsoft.com/Forums ... 82a2177346.
Scenarios which lead to CROSS APPLY/OUTER APPLY are listed at http://forums.devart.com/viewtopic.php?t=23362.

mcinnes01
Posts: 19
Joined: Wed 27 Jun 2012 13:55

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by mcinnes01 » Thu 01 Nov 2012 09:12

Hi,

I have upgraded and started a new project, added a Devart Entity Model, Database First, selected the tables I wanted and used the UnitOfWork/Repositiory template, enabled mapping sync and I still get the VARCHAR2 errors?
Error 1 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 2 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 3 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 4 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 5 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 6 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 7 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 8 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 9 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 10 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 11 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 12 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 13 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 14 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1
Error 15 Custom tool error: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification. C:\Users\AMcInnes\documents\visual studio 2010\Projects\OrgChart2\OrgChart2\C21Model.edml 1 1

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by Shalex » Thu 01 Nov 2012 17:46

mcinnes01 wrote:I still get the VARCHAR2 errors?
1. Which template (ObjectContext/DbContext) do you use along with Repository and Unit of Work?
2. Which value (true/false) have you set in the ColumnTypeCasingConventionCompatibility option?

For example:
a) ObjectContext and DbContext (fluent mapping=false) should be used with ColumnTypeCasingConventionCompatibility=false;
b) DbContext (fluent mapping=true) should be applied with ColumnTypeCasingConventionCompatibility=true.

mcinnes01
Posts: 19
Joined: Wed 27 Jun 2012 13:55

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by mcinnes01 » Fri 02 Nov 2012 10:18

I have tried with all templates, but I was interested in the use of the new template "UnitOfWork and Repository Pattern".

I have just tried again with dbContext, which is something I have managed to get working previously and it has this issue from the outset. Initially I had issues where the conceptual mapping wasn't the same as the actual mappings, but what I am finding now is that there are errors as soon as the wizard creates the model.

I have followed all the steps I previously used but this error is not going away, also I am still quite new to programming and I find the documentation or tutorials somewhat lacking. Where would I put ColumnTypeCasingConventionCompatibility=false? I have added a Devart Entity Model and followed the wizard. I don't understand why this produces an model in whatever template you select with errors?

All I want to do is map to some existing Oracle database tables, I use UnitOfWork and Repository pattern, so now there is a template option for that it makes sense to use it right? So I would like to use that and then be able to get on with using generated model and repositiory pattern methods as usual. Instead I am finding it frustrating that I keep getting an error that I can't get rid of and there seems to be no clear documentation or step by step guide of how to achieve this.

Please can you tell me exactly what I need to do, something has clearly changed with the product as I had this error previously and simply enabling the auto sync mapping fixed the issue. Also I now observe that changes I make on the conceptual part are automatically mimiced on the physical side.

I hope you can help,

Andy

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by Shalex » Thu 08 Nov 2012 12:13

mcinnes01 wrote:Where would I put ColumnTypeCasingConventionCompatibility=false?
You should specify this option in your code before the first usage of the context. We recommend you to put it in a static constructor of the context.
mcinnes01 wrote:I keep getting an error that I can't get rid of and there seems to be no clear documentation or step by step guide of how to achieve this.
Here is a simple walkhrough (it works in our environment using VS2010):
1. Add a Devart Entity Model to your project, follow the wizard and select the Repository And Unit of Work template.
2. The "Repository ..." template generates an intermediate code which works like an interface between you and the model but it doesn't generate the context itself. For this, you should add the "main" template to the model (via Tools > Entity Developer > Model Explorer): choose any from ObjectContext/POCO/DbContext. Let's add the DbContext template.
3. Select Repository And Unit of Work in Model Explorer > press F4 (navigate to Properties) > set its Use Db Context property to True. Save the model.
4. Open Tools > Library Package Manager > Package Manager Console and type "install-package entityframework" (without quotes) to download EntityFramework.dll 4.4.0.0 and add reference to it in the project.
5. Open DataModel1.Designer.cs to find out the names of the used namespace and context (e.g.: SHALEXModel and SHALEXEntities). Now we will add the ColumnTypeCasingConventionCompatibility setting in a static constructor: right click on the project in Solution Explorer > Add > New Item > Code > Class (Class1.cs) and put the following code into it:

Code: Select all

namespace SHALEXModel {
    public partial class SHALEXEntities {
        static SHALEXEntities() {
            Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig config = Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance;
            config.CodeFirstOptions.ColumnTypeCasingConventionCompatibility = false;
        }
    }
}
Also add the reference to %ProgramFiles%\Devart\dotConnect\Oracle\Entity\EF4\Devart.Data.Oracle.Entity.dll in the project.
6. Save All, rebuild the application and retrieve data from the database using created repository. Does it work?

mcinnes01
Posts: 19
Joined: Wed 27 Jun 2012 13:55

Re: Oracle & EF: Varchar2 is not qualified with a namespace or alias

Post by mcinnes01 » Thu 08 Nov 2012 14:12

Thanks that is really helpful I will give it a go and post back.

Andy

Post Reply