Error when Adding View from Oracle DB

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
nssidhu
Posts: 11
Joined: Tue 23 Feb 2010 18:35

Error when Adding View from Oracle DB

Post by nssidhu » Tue 19 Oct 2010 16:07

I am getting Error when Adding View From Oracle DB.
The view is defined in Oracle and is using Oracle Link to connect to the sybase Server and query is running against sybase server.
SELECT P.C_LLW_CODE P_LLW_CODE,
C.M_AWARD_AMOUNT AWARD_AMOUNT,
V.C_NAME GC_CONTRACTOR,
BW.C_ELECTRICAL ELECTRICAL,
BW.C_PLUMBING PLUMBING,
BW.C_HVAC HVAC,
C.VC_COMMENT
FROM PROJ_LLW@XXXX_LINK_CMS P,
CONTRACT@XXXX_LINK_CMS C,
VENDOR@XXXX_LINK_CMS V,
BIDDER_WICKS@XXXX_LINK_CMS BW
WHERE P.C_SOLICIT = C.C_SOLICIT
AND V.C_VENDOR_ID = C.C_VENDOR_ID
AND BW.N_SOLICIT_SEQ = C.N_SOLICIT_SEQ
AND BW.C_VENDOR_ID = C.C_VENDOR_ID

Query runs fine against DB.

Unable to generate the model because of the following exception: 'The item with identity 'LLW_CODE' already exists in the metadata collection.
Parameter name: item
'.
Loading metadata from the database took 00:00:04.6467538.
Generating the model took 00:00:36.7599838.
Unable to update the Web.Config file because of the following exception: 'The 'server' keyword is not supported.'
Successfully registered the assembly 'System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' in the Web.Config file.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 27 Oct 2010 12:50

Please try to add a Devart Entity model to your project. Its functionality is the same as the functionality of Microsoft Entity model, and it has a bit more convenient designer and some other features like flexible code generation and editable Storage model.
Please let us know if the error persists.

Post Reply