I need more information so that I can assist you further.

• are you using Web API?
• are you using Intersoft Entity Data Model template?
• could you please inform us about the GetAll() method? for example: how do you implement this method?

Yes I try to access the Web API with intersoft Entity Data Model.

I have registered the repository and resolve it within the ViewModel.

Count will always be 0. But the table contains record.

var secondRepository = Container.Current.Resolve<ISecondRepository>();
var entires = secondRepository.GetAll().Count;

What steps do I have do proceed to register and use the repositories?

secondRepository.GetAllAsync() is working.

Why does only the async version return the correct result?

You are using LocalEntityRepository. To query data, you can use one of the available methods as follows:

• Task<TEntity> GetSingleAsync(TKey key)
  Create and execute RestRequest that returns a single entity using the specified key.
• Task<ISelectResult<TEntity>> GetAllAsync()
  Create and execute RestRequest that returns all entities
• Task<ISelectResult<TEntity>> GetAllAsync(ISelectParameter selectParameter)
  Create and execute RestRequest based on the specified select parameter. The select parameter has a QueryDescriptor object that is used to perform data manipulation using OData query.

Note that whenever you retrieve data, the entity will be stored in an EntityContainer in the repository. This allows the EntityContainer to track any changes that happens to your entity so that you can easily send the changes back to the enterprise data service.

For more detail, please check Repository Pattern article in Crosslight documentation.

What GetAll() do is:

public virtual ICollection<TEntity> GetAll()
{
    return this.EntityContainer.FindEntities<TEntity>(FindEntityState.All)
        .Where(o => o.EntityAspect.EntityState != EntityState.Deleted).ToList();
}

It gets all items using default select parameter from EntityContainer.

The source can be obtained from the git repository.

Hope this help.