Defining Connection String in Console Application

Question

I am trying to create a connection but, it is always taking null. Below I am mentioning a way, how i am doing it :

Program.cs :

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CreateConnection"].ConnectionString);

App.config :

<configuration>

   <connectionStrings>
    <add name="CreateConnection" connectionString="data source=MyDatabase;initial catalog=TestDatabase;integrated security=True;MultipleActiveResultSets=True;user id=ABC;password=Admin@123;App=EntityFramework;" providerName="System.Data.EntityClient" />
   </connectionStrings>

</configuration>

Possible duplicate of [ConfigurationManager.ConnectionStrings\["XXX"\] is returning null](https://stackoverflow.com/questions/16565275/configurationmanager-connectionstringsxxx-is-returning-null) — Mikhail Tulubaev, Jul 18 '17 at 06:56

score 4 · Accepted Answer · answered Jul 18 '17 at 07:00

I used following way. Check if this helps Used for MySQL

In App.config file

<appSettings>
  <add key="DBConnectionString" 
   value="server=localhost;userid=root;database=databasename"/>
  </appSettings>

In Program.cs

public static string m_strMySQLConnectionString;
static MySqlConnection m_mySqlConnection;

static void Main(string[] args)
{
  m_strMySQLConnectionString = ConfigurationManager.AppSettings["DBConnectionString"].ToString();
  m_mySqlConnection = null;
 }

In DB Helper Function

public string GetValueFromDB(string strQuery)
    {
        string strData = "";

        try
        {
            if (m_mySqlConnection == null)
                OpenDatabase();

            if (string.IsNullOrEmpty(strQuery) == true)
                return string.Empty;

            MySqlCommand cmd = new MySqlCommand(strQuery, m_mySqlConnection);
            object objValue = cmd.ExecuteScalar();
            if (objValue == null)
            {
                cmd.Dispose();
                return string.Empty;
            }
            else
            {
                strData = (string)cmd.ExecuteScalar();
                cmd.Dispose();
            }

            if (strData == null)
                return string.Empty;
            else
                return strData;
        }
        catch (MySqlException ex)
        {
            LogException(ex);
            return string.Empty;
        }
        catch (Exception ex)
        {
            LogException(ex);
            return string.Empty;
        }
        finally
        {
            CloseDatabase();
        }
    }

Defining Connection String in Console Application

1 Answers1

Linked