none
LINQing to older versions of Oracle RRS feed

  • Question

  • We need to build a data model from tables originating in Oracle 7.3.2 and SQL 2005.  The problem we have is how to define the Oracle data source.

    If we create an Oracle data connector (in the code) we use a connection string similar to the following:

    Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCP.global)(PROTOCOL=TCP)(HOST=111.111.1.1)(PORT=9999)))(CONNECT_DATA=(SID=XYZ)(GLOBAL_NAME=XYZ.global)));User Id=XXX;Password=YYY;

    But we have had no luck in replicating the connection within the Server Explorer and so have not been able to (graphically) identify the tables therein and build the data model.

    I guess the questions I'm asking are:

    1. Is anyone using this version of Oracle as LINQ and/or Entity Data Class source?
    2. Can anyone offer any advice on how to set up the data connection?
    3. From a connectivity viewpoint is there any difference/benefit between using LINQ or the ADO.NET Entity Data Classes (we've used SQL derived LINQ but have not, as yet, worked the the EDM)?
    Thanks, any help advice would be much appreciated.
    Friday, March 6, 2009 4:09 PM

All replies