ContinuousProcessing参数不再受支持.NPGSQL

Question

我刚刚将我的npgsql从2.5.5升级到3.1.1，我收到了这个运行时错误。

我的DbConnection类

public static string ServerConnectionString()
{
var connectionStringBuilder = new NpgsqlConnectionStringBuilder
{
Host = ConfigurationManager.AppSettings["Server"],
Username = ConfigurationManager.AppSettings["UserId"],
Database = "postgres",
Password = ConfigurationManager.AppSettings["Password"],
CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeout"]),
ApplicationName = EverestEnums.ConnectionApplicationName.EverestServerChecker.ToString(),
//  MaxPoolSize = 200,
//   SyncNotification = true,
KeepAlive = 1,
ConnectionLifeTime = 1,
//  MinPoolSize = 1,
Pooling = false
};
return connectionStringBuilder.ConnectionString;
}

堆栈跟踪

[NotSupportedException: The ContinuousProcessing parameter is no longer supported. Please see http://www.npgsql.org/doc/3.1/migration.html]

Npgsql.NpgsqlConnectionStringBuilder.set_ConnectionLifeTime(Int32值)+62E:\Everest_PES\Everest.Net.DatabaseLayer\DBFactory.DbConnection.ServerConnectionString()E:\Everest_PES\Everest.Net.DatabaseLayer\DBFactory\DBCOperations.IsServerAvailable()E:\Everest_PES\Everest.Net.DatabaseLayer\DBFactory.ServerConnectivity.IsDbServerAvailable()E:\Everest_PES\Everest.Net.BusinessLayer\DBFactory.ServerConnectivity.IsDbServerAvailable()e:\Everest_PES\Everest.Net.Web\Global.asax.cs:15 中的Everest.Net.Web.Global.Application_Start(对象发送器，EventArgs e)

[HttpException(0x80004005)：不再支持ContinuousProcessing参数。请参阅http://www.npgsql.org/doc/3.1/migration.html]System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext上下文，HttpApplication应用程序)+544System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext、HttpContext上下文、MethodInfo[]处理程序)+186System.Web.HttpApplication.InitSpecial(HttpApplicationState状态，MethodInfo[]处理程序，IntPtr appContext，HttpContext上下文)+172System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext，HttpContext context)+402System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext)+343

[HttpException(0x80004005)：不再支持ContinuousProcessing参数。请参阅http://www.npgsql.org/doc/3.1/migration.html]System.Web.HttpRuntime.FirstRequestInit(HttpContext上下文)+579System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext上下文)+112System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr，HttpContext上下文)+712

因为它以前工作得很好。但是连接池存在一些问题。然后我升级了npgsql和这个rumtime错误。任何帮助。

Answer 1

当您在NpgsqlConnectionStringBuilder上获取或设置ConnectionLifeTime属性时，似乎抛出了异常。该属性已过时，现在由Connection Idle Lifetime属性替换(请参阅http://www.npgsql.org/doc/migration.html)。尝试使用这个替代：

public static string ServerConnectionString()
{
var connectionStringBuilder = new NpgsqlConnectionStringBuilder
{
Host = ConfigurationManager.AppSettings["Server"],
Username = ConfigurationManager.AppSettings["UserId"],
Database = "postgres",
Password = ConfigurationManager.AppSettings["Password"],
CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeout"]),
ApplicationName = EverestEnums.ConnectionApplicationName.EverestServerChecker.ToString(),
//  MaxPoolSize = 200,
//   SyncNotification = true,
KeepAlive = 1,
ConnectionIdleLifetime = 1,
//  MinPoolSize = 1,
Pooling = false
};
return connectionStringBuilder.ConnectionString;
}