SQL Query to DataTable in C# Statement

blickfangQ2

Hello everyone,
I have very complex SQL querys which cannot be translated to LinQ very easily with my knowledge.
Right now I use the following code to get my job done:

DataTable Table = new DataTable();

const string Server = "Server=XXXX; User ID=XXXXXXX; Password=XXXXXX";
const string sqlQuery = "SELECT * FROM XXXX";

using (OracleConnection connection = new OracleConnection(Server))
using (OracleCommand cmd = new OracleCommand(sqlQuery, connection))
using (OracleDataAdapter results = new OracleDataAdapter(cmd))
{
	connection.Open();
	results.Fill(Table);
	connection.Close();
}
Table.Dump();

Unfortunately OracleConnection is obsolete and won’t be supported in the future. I know I could use the Oracle Data Provider to be a bit more up to date… but:

My Question is:
Is it possible to use the direct Oracle Plugin in LinQPad? If so, how do I have to connect?
Thanks in advance!
Best regards,
Sebastian

blickfangQ2

Anyone?

JoeAlbahari

What type of connection are you using? Entity Framework or the IQ Driver?

blickfangQ2

I'm using the IQ Connection with the Connection Mode = Direct (Oracle Client not required). Can I use this Direct Connection "manually" and open it like I posted above to run a Query in a C#-Statement. If Yes, how would I connect in C# language?

Thanks

blickfangQ2

Is this possible?

JoeAlbahari

I don't see why not. Just instantiate the ADO.NET objects that the IQ driver uses yourself.

You can figure this out by running the following query:

this.Connection

The result is Devart.Data.Oracle.OracleConnection.

So just substitute OracleConnection with Devart.Data.Oracle.OracleConnection (or add Devart.Data.Oracle to your namespace imports).

And you don't need to create a new connection - just use this.Connection and call Open on it.

blickfangQ2

Thank you, I'll try that!