title: confusion between service based database and local database
body: <p>hi i am new to c# and i am a student learning c# from last 3 month and when starting my small project i created a service based database and use to store the values in the tables. in my app i am only dealing with the tables. and queries which will be working on a single machine. i am generating a project which only will be working on a single machine. so i now realised diffrence between service based database and local database
  **A service-based database is a database that is only accessed through a server. It uses an MDF data file, which is SQL Server format. To be able to connect to a SQL Server database the SQL Server service must be running, because it's that that processes your requests and access the data file.</p>
  
  <p>A local database is one that is local to your application only. It uses an SDF data file, which is SQL Server CE (Compact Edition) format. There is no need to install a server to access an SDF database**
  but i formed the whole project with the service based database and used all queries which is select and update. and i used this code</p>
  
  <pre><code>connectionString = @"Data Source=.\
      SQLEXPRESS;AttachDbFilename=E:\project\Database1.mdf;Integrated 
      Security=True;User Instance=True";
  sqlConnection = new SqlConnection(connectionString);
  </code></pre>
  
  <p>but when shifting to .sdf file means to local database i just have to replace the new connection string? does it reflects to any of the functioning?</p>