con.Open() get the error Object reference not set to an instance of an object. c#

Asked Dec 16 '18 at 13:58

Active Dec 16 '18 at 14:46

Viewed 23 times

I Have connectionString OracleConnection when I try to do : ConnectionString.Open(); I get the error: Object reference not set to an instance of an object. the code:

  private static OracleConnection _connectionString;
  private static OracleConnection ConnectionString
    {
        get
        {
            if (_connectionString == null)
            {
                _connectionString = new OracleConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString);
            }

            return _connectionString;
        }
    }
ConnectionString.Open();

in the webConfig:

<add name="DB" providerName="System.Data.OracleClient" connectionString="data source=test;Persist Security Info=true;user id=db;password=db"/>

edited Dec 16 '18 at 14:46

asked Dec 16 '18 at 13:58

rikush

Do you have another `ConnectionString` variable where you use `Open()`? – Guy Dec 16 '18 at 14:00
I dont know.. can I close all the connectionstring before? – rikush Dec 16 '18 at 14:02
It is bad practice to use a static property for a database connection. You should be using it as a local variable inside a `using` statement whenever you need it. – Zohar Peled Dec 16 '18 at 14:03
The property is `private`, it can be used only in this class, what is the problem to check? and closing the connection won't solve this problem, it will just shift the exception to another place. – Guy Dec 16 '18 at 14:04
can you share stack Trace with us? – Derviş Kayımbaşıoğlu Dec 16 '18 at 14:10
Try this. – Rehan Shah Dec 16 '18 at 14:12

con.Open() get the error Object reference not set to an instance of an object. c#

0 Answers0