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

Question

I am doing this to connect the 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 that Entities can be used.

Answer 1

There are third-party providers that support EF today. Personally, I used Devart dotConnect for Oracle for a while. Another such option is Datadirect.

Oracle has a beta version of ODP.Net provider that supports EF , I have not tried to use it yet.