title: How can I support both a local SQL Server CE and remote SQL Server in my desktop C#/WPF application?
body: <p>I am developing a Windows .NET 4 C#/WPF desktop application for a client. Originally, they wanted only a standalone desktop app, so I was planning on using SQL Server CE for the database. Now, they want the app to also support an environment where the application is run by multiple users on the local network.</p>
  
  <p>I'm not sure what I need to do to support both environments in my application. This seems like a pretty common scenario. What is the best approach to handle this requirement?</p>