none
Query Related to ADO.NET Entity Data Model With Oracle Data Source RRS feed

  • Question

  • Hi friends
    I have a small query
    How can we configure Oracle datasource with edmx ?
    Without using any 3rd Party Solution which Devart.com (very cool api has been provided by them to configure oracle with edmx thats really great since it solves my purpose)has provided us.
    The only issue with it is ,its not the freeware.
    Now if I am taking MS VS2008  spending some bugs on that,And again if I need to use Oracle or any other DataSource except for MS SQL Server,For doing that I need to use some 3rd party api.

    i think MS alredy has a  solution .Since if I am using Server Explorer And creating new connection ther,In the lisiting of Data Sources ther I could find Oracle Database and can configure Database smoothly .Definately the same thing could be possible while setting up the DataSource with edmx. Hope MS would be working on the same,
    Or maybe I need to do some configuration which I am not aware of .
    I wished if someone would help me with this patch or configuration which i am expecting 
     

    I have alredy gone through this post
    http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/a71b6814-4ae3-4a71-9fc4-431eaace6d60/


    S/W Developer
    Wednesday, March 4, 2009 2:26 AM

Answers

  • Finally the Only cool solution i could find out is "Devart for oracle"
    S/W Developer
    • Marked as answer by SamsonJohn Monday, April 6, 2009 10:58 AM
    Monday, April 6, 2009 10:55 AM

All replies

  • Hi *,

    the stuff you see in Server Explorer is functionality from DDEX. EF itself doesn't need DDEX to run, only couple of classes in provider to be able to translate queries and query the database.


    Jiri {x2} Cincura
    Thursday, March 5, 2009 10:59 AM
  • Hi  Jiri {x2} Cincura,
    Thanks a lot for knowledge transfer.It was good to know about DDEX .
    You told that entity framework requires only few classes,thats also fine,but how can i get the Oracle database Option in the data Source listing in ef.what can be done to achieve that ?

    regards
    Sam


    S/W Developer
    Thursday, March 5, 2009 11:47 AM
  • Hi *,

    if you wanna to use it in wizard in VS, you need DDEX provider installed and working. But you can easily generate model using EdmGen/EdmGen2 or you own program (API is accessible).


    Jiri {x2} Cincura
    Friday, March 6, 2009 8:26 AM
  • Hi

    OpenLink Software provide a suite of ADO.Net 3.5 Entity Framework Providers for Oracle and other Databases (Informix, Ingres, DB2, Sybase, Progress, MySQL , Postgres, FireBird and others).

    Details on the OpenLink ADO.Net 3.5 Providers can be obtained from:

    http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAdoNet35Provider

    With specific usage for Oracle at:

    http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtOracleEntityFrameworkUsage

    Best Regards
    Hugh Williams
    Professional Services
    OpenLink Software
    http://www.openlinksw.com

    Friday, March 6, 2009 9:53 AM
  • Sam -

    In order to use the Entity Framework with a certain database type, you need an Entity Framework enabled Ado.Net Provider for that database.  In .net framework 3.5, microsoft ships a SQL Server provider for that works with the entity framework.  SQL Compact Edition 3.5 also ships an entity framework provider.

    To use Oracle, you will need to obtain and install an EF-enabled Oracle Provider.    As Hugh mentions, you can get one from open line. There's also one from DevArt (as you know), and there's a "sample" oracle provider available through microsoft code plex.

    Once you have the provider, you'll be able to run the command line tools (edmgen.exe).

    To use your provider at design-time, you'll need to have an appropriate DDEX provider configured to use your Ado.Net provider.  For information on configuring DDEX, see this link:  http://msdn.microsoft.com/en-us/library/ms379576.aspx.

    Perhaps Hugh Williams from OpenLink can comment on how to get their providers to work in a Visual Studio tooling environment.

    Hope this helps,

    Mike Kaufman,

    Microsoft Corp.
    This posting is provided "AS IS" with no warranties, and confers no rights
    • Marked as answer by SamsonJohn Monday, April 6, 2009 10:54 AM
    • Unmarked as answer by SamsonJohn Monday, April 6, 2009 10:54 AM
    Friday, March 6, 2009 11:14 PM
    Moderator
  • Finally the Only cool solution i could find out is "Devart for oracle"
    S/W Developer
    • Marked as answer by SamsonJohn Monday, April 6, 2009 10:58 AM
    Monday, April 6, 2009 10:55 AM