title: Does SingleOrDefault() query remotely?
body: <p>Consider an environment with various computers at different locations. These computers have a Windows application running and a timer checking for new data to sync every 5 minutes. Information is synced to a centralised location over an internet connection. The database on both the client computers and the centralised server is an SQL Server database.</p>
  
  <p>Before writing into the remote (centralised) server, the SingleOrDefault() method is used to check whether a record with the same ID exists remotely or not. The client has reported a surge in internet data used. I am wondering whether the centralised database has grown too large and the SingleOrDefault returns the whole queryable data over the connection and does the querying client side. Could this be the case? And what would be an alternate solution that does not do the same thing?</p>