等待操作超时mvc

本文关键字:mvc 超时 操作 等待 | 更新日期: 2023-09-27 18:21:10

我有一个问题:如何处理asp.net MVC页面中的操作超时。在加载查询数据库SQL Server的页面时,它会加载产品。有时它会说等待操作超时。如何处理。

等待操作超时mvc

为了避免在运行超长查询时出现等待操作超时异常,请更改SQL命令属性,并允许命令在调用超时之前等待更长时间。

using System;
using System.Data.SqlClient;
/// 
public class A {
  /// 
  public static void Main() {
     string connectionString = "";
     // Wait for 5 second delay in the command
     string queryString = "waitfor delay '00:00:05'";
     using (SqlConnection connection = new SqlConnection(connectionString)) {
       connection.Open();
       SqlCommand command = new SqlCommand(queryString, connection);
       // Setting command timeout to 1 second
        command.CommandTimeout = 1;
          try {
              command.ExecuteNonQuery();
              }
           catch (SqlException e) {
              Console.WriteLine("Got expected SqlException due to command timeout ");
              Console.WriteLine(e);
      }
   }
}

}

执行Linq到sql查询可能需要更长的时间&超过DataContext类的CommandTimeout属性的默认值。默认值为30秒。我们可以在每次创建并调用LINQ to SQL DataContext对象之前设置CommandTimeout的值。

 #region Constructors
    /// <summary>
    /// Initializes a new FrameworkEntities object using the connection string found in the 'FrameworkEntities' section of the application configuration file.
    /// </summary>
    public FrameworkEntities() : base("name=FrameworkEntities", "FrameworkEntities")
    {
        this.ContextOptions.LazyLoadingEnabled = true;
        this.CommandTimeout = 300;
        OnContextCreated();
    }
    /// <summary>
    /// Initialize a new FrameworkEntities object.
    /// </summary>
    public FrameworkEntities(string connectionString) : base(connectionString, "FrameworkEntities")
    {
        this.ContextOptions.LazyLoadingEnabled = true;
        this.CommandTimeout = 300;
        OnContextCreated();
    }
    /// <summary>
    /// Initialize a new FrameworkEntities object.
    /// </summary>
    public FrameworkEntities(EntityConnection connection) : base(connection, "FrameworkEntities")
    {
        this.ContextOptions.LazyLoadingEnabled = true;
        this.CommandTimeout = 300;
        OnContextCreated();
    }
    #endregion