Light Speed - How to force refresh from database

Hallo, I'd like to force refreshing table content from db. How to acomplish such task?

Let's asssume I have the following method implemented.

    public IEnumerable<TbCUser> GetUsers()
    {
        IEnumerable<TbCUser> users = null;
        try
        {
            using (var context = _contextSecurity.CreateUnitOfWork())
            {
                users = context.TbCUsers.AsEnumerable();
            }
        }
        catch (Exception ex)
        {
            _log.Error(ex.Message);
            throw;
        }

        return users;
    }

Thanks in advance for you help, Aleksandra

Hi Aleksandra,

In the code above you are performing the fetch of your TbCUser instances within the scope of a new UnitOfWork so these will be loaded from the database and not from a cache unless you are using a second level cache and they are already being stored.

Or are you wanting to to do something subsequent to this method call in regards to refreshing the entities?

Jeremy

Hallo Jeremy,

my solution uses distributed scenario where WPF client application connects to WCF host. And unfortunatelly I have to restart IIS & restart my client application to force refreshing directly from database :-(

Do you have any idea about the reason?

Best regards, Aleksandra

You definitely should not need to restart IIS. Are you applying any caching?

Also can you post some code showing how you are setting up your DistributedUnitOfWork and what the server side components look like (again just focused on how you are managing the ServiceHost for the DistributedUnitOfWork).

Jeremy

Hallo, we decided to resign from WCF in our architecture - it's not necessary in our solution - so the problem has been solved. Thanks for your time.

Aleksandra