针对查询记录数较多的情况,我遇到了超时问题。如何改变查询超时时间?
我尝试过以下方式修改连接超时时间,但是并没有生效:
connection.ConnectionTimeout = 60; // 不起作用(已就绪)
类:
public abstract class RepositoryBase<TEntity> : IRepositoryBase<TEntity>, IDisposable where TEntity : class
{
protected SqlConnection _connection;
protected string _connectionString;
public RepositoryBase(string connectionString)
{
_connectionString = connectionString;
SqlConnection connection = new SqlConnection(connectionString);
if (connection.State == ConnectionState.Closed)
connection.ConnectionTimeout = 60; // not working (ready)
connection.Open();
_connection = connection;
}
public List<T> GetEntitiesByQuery<T>(string Query)
{
using (var connection = _connection)
{
try
{
var entities = connection.Query<T>(Query);
return entities.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
}
}
entity-framework
标签?看起来你在使用不同的(微型)ORM? - Ivan Stoev