Visual C# Express and Oracle database Express using entity framework

I'm trying to access my Oracle XE database using Visual C# Express and entity framework.

I've tried installing oracleef (http://oracleef.codeplex.com/) but I'm not getting Oracle EF provider inside Visual C# Express add EF connection wizard, although machine.config contains

<DbProviderFactories>
  <add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
  <add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=开发者_如何学编程89845dcd8080cc91" />
</DbProviderFactories>

I've tried using EdmGen2.exe to manually generate EF classes from database, but I had little success.

How can I use Oracle database, Visual C# Express and Entity Framework together?

VS Express doesn't support third party components such as DB connection wizards. You will have to configure the connection manually (and create the entity model manually, too... so I suggest you use EF Code First)

You could install the oracle Instant Client with ODP.Net and add Oracle.DataAccess as reference to your project. After that you could connect to your database, like this:

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;

private OracleConnection Connect = new OracleConnection();

public int OracleConnect(string hostname, string username, string password, string servicename)
{
    Connect.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" + hostname + ") (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=" + servicename + ")));" + "User Id=" + username + ";Password=" + password + ";";
    try
    {
        Connect.Open();
        return 0;

    }
    catch (OracleException OracleExeption)
    {
        return -1;
    }
}