How do i set connection to oracle db to get data from Dual?

Question

I would like to get temporary data so i created this query SELECT 'BMW' as Car, 'Peter' as Owner FROM DUAL UNION ALL SELECT 'Mustang' as Car, 'Joe' as Owner FROM DUAL;

I do not know how to set connection to the Data base to execute this query in DB from my program.

Nepethya Rana · Answer

I figured out I forgot to pass connection string in command obj. Thank you for reaching and helping out.

Nepethya Rana · Answer

CS : class Program{ static string myCS = ConfigurationManager.ConnectionStrings[MYCS_ORA].ConnectionString; static void Main(string[] args) { SomeMethod(); } Public static void SomeMethod(){ OleDbConnection ora_conn = new OleDbConnection(); OleDbCommand ora_cmd = new OleDbCommand(); OleDbDataReader ora_reader = null; try { ora_conn = new OleDbConnection(myCS ); ora_conn.Open(); if (ConfigurationManager.AppSettings[Test_Environment].ToUpper() == TRUE) { ora_cmd = new OleDbCommand(ConfigurationManager.AppSettings[Test_VW_Table_Query]); } else { ora_cmd = new OleDbCommand(SELECT Car Owner FROM Real_VW_Table ora_conn); } ora_reader = ora_cmd.ExecuteReader(); } catch (Exception e) { WriteToLog(e.StackTrace); } } } Error: 3/27/2017 9:06:29 AM: System.InvalidOperationException: ExecuteReader: Connection property has not been initialized. at System.Data.OleDb.OleDbCommand.ValidateConnection(String method) at System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String method) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteReader() at Program.SomeMethod()

Ramesh Palanivel · Answer

Are u using ASP MVC application

Nepethya Rana · Answer

My situation is data is not in view table but for the program to run and test i need data. I do not have access to insert test data on view table also. So i am trying to get these data from dual and pass them to my program to get into next step. If there is alternate way to do this. I have never worked with Oracle also.

Ramesh Palanivel · Answer

Hi Gaurav Which means kindly send Ur error code.. I will help u...

Ramesh Palanivel · Answer

Hi Gaurav Can u share Ur code....

Nepethya Rana · Answer

I am getting error.

Ramesh Palanivel · Answer

Hi Gaurav Your question is not clear. DO you want to fetch this record from Oracle DB or You are getting any error for this query? Or Do you want get connection for your oracle DB?