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.

codeandcloud · Accepted Answer · 2015-06-13 06:51:07Z

4

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.

edited Jun 13, 2015 at 6:51

codeandcloud

55.5k47 gold badges169 silver badges259 bronze badges

answered Nov 14, 2011 at 17:12

GTG

4,9542 gold badges25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related