如何使用ASP.NET配置hangfire以从配置文件获取连接字符串？ [英] How to configure hangfire with ASP.NET to obtain connection string from config file?

问题描述

请原谅我这个可能很愚蠢的问题，总体上我还是不太熟悉ASP.NET架构。

Please forgive me this probably stupid question, I am still not too familiar with the ASP.NET architecture in general.

我继承了一个大项目，我打算到设置hangfire.io 。我知道我必须以某种方式初始化数据库上下文，但是我不想按照hangfire-docu的建议对其进行硬编码。

I inherited a large project, and I intend to setup hangfire.io. I understand that I have to somehow initialize the DB context, but I do not want to hardcode it as suggested by the hangfire-docu.

我的 API\Global.asax.cs 当前看起来如下，有趣的东西在<$ c之后开始$ c> // Hangfire的东西：

My API\Global.asax.cs currently looks as follows, the interesting stuff begins after // Hangfire stuff:

using System.Web.Http;
using System.Web.Http.ExceptionHandling;
using System.Web.Mvc;
using System.Web.Optimization;
using System.Web.Routing;
using Hangfire;

namespace API
{
   public class WebApiApplication : System.Web.HttpApplication
   {
       protected void Application_Start()
       {
          log4net.Config.XmlConfigurator.Configure();
          GlobalConfiguration.Configuration.Services.Add(typeof(IExceptionLogger), new GlobalExceptionLogger());
          GlobalConfiguration.Configuration.Services.Replace(typeof(IExceptionHandler), new GlobalExceptionHandler());
          MvcHandler.DisableMvcResponseHeader = true;
          AreaRegistration.RegisterAllAreas();
          GlobalConfiguration.Configure(WebApiConfig.Register);
          FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
          RouteConfig.RegisterRoutes(RouteTable.Routes);
          MapperConfig.RegisterMapper();

          // Hangfire stuff  
          GlobalConfiguration.Configuration.UseSqlServerStorage("HardcodedContextString");
          RecurringJob.AddOrUpdate("some-id", () => Console.WriteLine("My hangfire test."), "*/2 * * * 1-5"); 
       }
   }
}

我的数据库上下文 myContext 似乎在 API\connections.config 内定义，其中包含以下几行：

My database context myContext seems to defined inside API\connections.config which contains the following lines:

<?xml version="1.0"?>
  <connectionStrings>
    <add name="myContext" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=myContext;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />
  </connectionStrings>

我应该输入什么而不是 HardcodedContextString 使ASP.NET从相应的配置文件中读取连接字符串？

What shall I put instead of HardcodedContextString to make ASP.NET read the connection string from the respective configuration file?

PS：有趣的是， /下的两行/ Hangfire内容用红色下划线。我想念什么？

PS: Interestingly, both lines underneath // Hangfire stuff is underlined in red. What do I miss?

• 如何为Hangfire的mySQL数据库设置 connectionString？

• How do I set up 'connectionString' for a mySQL database for Hangfire?

推荐答案

1. 确保<$ c实际上已经安装了$ c> Hangfire （另请参见《 Hangfire安装指南》 ）。对于Visual Studio Professional 2017，您可以执行以下操作：
   
   

1. Make sure that Hangfire is actually installed (see also Hangfire Installation Guide). For Visual Studio Professional 2017, you can do the following:

1. 右键单击项目，然后单击管理NuGet包。


2. 选择数据包来源： nuget.org ，在右侧搜索 Hangfire 使用左上方的搜索栏。


3. 选择 Hangfire 并单击安装。出现弹出窗口时，您可能必须单击接受。

1. Right-click on your project and click Manage NuGet Packages.
2. Select Packet source: nuget.org on the right, search for Hangfire using the search bar on the top left.
3. Select Hangfire and click Install. You might have to click on Accept when a popup-window appears.

添加使用System.Configuration； 在 Global.asax.cs 的标题中。以下所有步骤将在该文件中进行。

定义一个变量，该变量从 connections.config 获取数据库上下文定义：

Add using System.Configuration; in the header of Global.asax.cs. All following steps will happen within that file.

Define a variable which obtains the data base context definition from connections.config:

string connString = ConfigurationManager.ConnectionStrings["ConStringName"].ToString();

1. 如果您使用的是 System.Web.Http 像我一样，您必须用 System.Web替换 GlobalConfiguration.xxx 的所有外观。 Http.GlobalConfiguration.xxx 。这是避免冲突所必需的，因为两个软件包都具有（不同的） GlobalConfiguration 属性。


2. 我们还必须指定完整的名称空间进行Hangfire。我们现在还将使用 connString ：而不是 GlobalConfiguration.Configuration.UseSqlServerStorage（ HardcodedContextString）; 我们
   必须写

1. If you are using System.Web.Http like me, you have to replace all appearances of GlobalConfiguration.xxx with System.Web.Http.GlobalConfiguration.xxx. This is necessary to avoid a conflict since both packages have a (different) GlobalConfiguration property.
2. We also have to specify the full namespace for Hangfire. We will also use connString now: Instead of GlobalConfiguration.Configuration.UseSqlServerStorage("HardcodedContextString"); we have to write

Hangfire.GlobalConfiguration.Configuration.UseSqlServerStorage(connString);

1. 现在所有内容都应正确编译。

PS：来自 https://stackoverflow.com/a/6134384/1236044 我了解了如何从配置文件中获取连接字符串-感谢@ jbl 指出了这一点。 JBL还给了我有关名称空间冲突的提示。

PS: From https://stackoverflow.com/a/6134384/1236044 I learned how to obtain the connection string from the config file-- thanks @jbl for pointing me to that. JBL also gave me the hint about the name space conflict.

这篇关于如何使用ASP.NET配置hangfire以从配置文件获取连接字符串？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！