SqlJobExtension.SqlJob.SetConnection C# (CSharp) Method

        private void SetConnection()
        {
            if (Connection == null)
            {
                if (JobConfiguration.AppSettings == null)
                    throw new Exception("Cannot retrieve SQL connection string. Set 'JobConfiguration.AppSettings = Settings.Default' and provide your SQL connection string under application property 'ConnectionString'.");

                var connectionString = JobConfiguration.AppSettings[ConnectionStringKey].ToString();
                Connection = new SqlConnection(connectionString);
            }
        }