Azure的Web作业 - 如何连接到Azure的MS SQL数据库？

我有一个MVC网站，发布到Azure的地方使用了Azure的SQL数据库。

I have a MVC website that gets published to Azure where it uses an Azure SQL Database.

现在是时候了，我们需要运行计划任务发送短信提醒。我是IM pression了Azure的网上工作是一个很好的适合这种下但我有一些问题得到它运行起来。

The time has come where we need to run a scheduled task to send SMS reminders. I was under the impression that Azure Web Jobs was a good fit for this but am having some issues getting it up and running.

我添加了一个控制台应用程序到我的网站的解决方案，并通过从控制台应用程序（我想发布为Web作业）EF数据模型引用。

I have added a console app to my website solution and referenced by EF data model from the console app (which I would like to publish as a web job).

目前的控制台应用程序，如下所示：

The current console app looks as follows:

 class Program
{
    static void Main(string[] args)
    {
        JobHost host = new JobHost();
        host.RunAndBlock();
    }

    public static void ProcessNotifications()
    {
        var uow = new KirkleesDatabase.DAL.UnitOfWork();
        uow.CommunicationRepository.SendPALSAppointmentReminders();
    }

}

然后运行控制台应用程序会抛出异常：

Running the console app will then throw the exception:

更多信息：用户帐户连接字符串缺失。这可以通过AzureJobsData连接字符串或通过构造函数来设置。

Additional information: User account connection string is missing. This can be set via the 'AzureJobsData' connection string or via the constructor.

这表明，网络招聘是专门找一个指向存储帐户的连接字符串。不过，我想在网上工作来查询Azure数据库，而不是存储工作。

This suggests that the Web Job is specifically looking for a connection string that points at a storage account. However, I would like the web job to query an Azure database rather than work with storage.

这是可行的？

谢谢，