Upgrade from 4.5.6 to 4.5.8

ServiceStack.OrmLite
1

In ServiceStatck.OrmLite 4.5.6, It works fine. the project is based on Sqlserver 2008 R2, .net framework 4.6.2,

After Upgrade to 4.5.8, It Doesn’t work. the connection state is open ,

Pasted image1624×309 68.1 KB

but want to get data , It will occur a error, System.InvalidOperationException, the connection is closed
Pasted image1578×383 82.3 KB

is there anything I write wrong?

2

Can you provide a stand-alone example we can run locally to see the issue?

3

I’m sorry , I think my code is also not works in 4.5.6.

if I wirte the code like the under, I found the Db will dispose before getdata, So will get errors.

    public class TestService1 : Service
    {
        static readonly NLog.Logger logger = NLog.LogManager.GetCurrentClassLogger();
        public async Task<List<WX_RSGL_ZGDA>> GetData()
        {
            var testUserList = await Db.SelectAsync<WX_RSGL_ZGDA>();
            logger.Info($"testUserList: {testUserList.SerializeToString()}");
            return testUserList;
        }
    }

If I write the code like the under , It works fine.

  public class TestService2 : Service
    {
        static readonly NLog.Logger logger = NLog.LogManager.GetCurrentClassLogger();
        public async Task<List<WX_RSGL_ZGDA>> GetData()
        {
            using (var Db = HostContext.Resolve<AppService>().Db)
            {
                var testUserList = await Db.SelectAsync<WX_RSGL_ZGDA>();
                logger.Info($"testUserList: {testUserList.SerializeToString()}");
                return testUserList;
            }
        }
    }

If I want to used the code like TestService1 , how to set will getdata before the Db Dispose?

4

Can you show how do you call GetData () in the first case?

5

I’m sorry, I have found the wrong and had to fixed it . thanks .