How to access oracle data using Linq through ADO.net?

Question

I am doing this to connect database using sql.

    OracleConnection conn = new OracleConnection();
    conn.ConnectionString = "Data Source=XE;uid=HR;pwd=fusion;";
    conn.Open();
    OracleCommand command = new OracleCommand("Select * from Students", conn);
    DataSet ds = new DataSet();
    OracleDataAdapter oraDa = new OracleDataAdapter(command);
    oraDa.Fill(ds, "Students");
    return ds.Tables["Students"];

But I want to use Linq instead of SQL. I heard it is possible using Entities.

Answer 1

There are some third party providers that support EF today. Personally I have been using Devart dotConnect for Oracle for some time. Datadirect is another such option.

Oracle has a beta version of it's ODP.Net provider supporting EF, I haven't tried to use it yet.