var query = _customerRepository.Table

hi all,

I am trying to retrieve all customer table using var query = _customerRepository.Table;

in my local database it will retrieve all customers, but in my live database it does not work. What is the missing here.

same database structure in both local and live.

Thanks

some obvious things:
1. var query = _customerRepository.Table only returns an IQueryable. call ToList() will get the actual data
2. Do you have customers in your live database?

yah, there are customers in live database. when i debug it for the query there aren't any data. But in local db it has.