try
        {
            // Create and open a connection object
            conn = new SqlConnection(configurationConnString);
            conn.Open();

            // Set Stored Proc 
            SqlCommand cmd = new SqlCommand("spGetConfigSettingsByApplication", conn);
            cmd.CommandType = CommandType.StoredProcedure;

            // Set Parameters
            cmd.Parameters.Add(new SqlParameter("@applicationName", SqlDbType.NVarChar, 50));
            cmd.Parameters["@applicationName"].Value = "FTU";

            // execute the command
            rdr = cmd.ExecuteReader();

            // iterate through results, printing each to console
            while (rdr.Read())
            {
                configSettings.Add(rdr["AppKey"], rdr["AppValue"]);
            }
        }
        finally
        {
            if (conn != null) conn.Close();
            if (rdr != null) rdr.Close();
        }

Database Retrieve

database, sql

C#