Connection open error (为什么dapper连接没问题呢?) 返回

求助
2 207

开发环境:使用的sqlSugar5.0.0.15。用的core3.1。疑问,是不是只能用sqlsugarcore版本的


English Message : Connection open error . Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=47; handshake=14952; 

Chinese Message :  连接数据库过程中发生错误,检查服务器是否正常连接字符串是否正确,实在找不到原因请先Google错误信息:Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=47; handshake=14952; .


Exception:

   at SqlSugar.AdoProvider.<GetDataReaderAsync>d__102.MoveNext()

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

   at SqlSugar.QueryableProvider`1.<GetDataAsync>d__189`1.MoveNext()

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

   at SqlSugar.QueryableProvider`1.<_ToListAsync>d__181`1.MoveNext()

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

   at Exam.DataFactory.Repository.Imp.DataBaseRepository`1.<Query>d__13.MoveNext() in D:\project\Exam.DataFactory\Repository\Imp\DataBaseRepository.cs:line 285



ConnString:Data Source=xxx;Initial Catalog=project;User Id=sa;Password=123456;

热忱回答2

  •      /// <summary>

            /// 主库连接

            /// </summary>

            /// <returns></returns>

            public SqlSugarClient CreateExamConnection()

            {

                var dataConfig = ConnectionFactory.MutiConnectionString.FirstOrDefault(x => x.Name.Equals(EnumDataType.Exam.ToString()));

                var connString = dataConfig.Enabled ? dataConfig.ConnectionTest : dataConfig.Connection;

                return new SqlSugarClient(new ConnectionConfig()

                {

                    ConnectionString = connString, //cfg["connectionString"],

                    DbType = DbType.SqlServer,

                    IsAutoCloseConnection = true, // 查询完之后自动释放数据库

                    IsShardSameThread = true,//相同线程是同一个sqlsugarclient

                    InitKeyType = InitKeyType.Attribute,

                    ConfigureExternalServices = new ConfigureExternalServices()

                    {

                        // DataInfoCacheService = new RedisCache()

                    }

                });

            }


    0 回复
  • 升级到最新版本解决。

    0 回复

版块

学习文档

最新会员

发布达人

回贴达人