title: How to deploy and attach SQL Server Management Studio 2012 Database with Winform Application?
body: <p>I am using Visual Studio 2012 with SQL Server Management Studio 2012, 
  At very first I created a database named salesystem in SQL Server Management Studio 2012, I created views and tables also in SQL Server Management Studio 2012 ... Then </p>
  
  <ol>
  <li><p>I created a new Winform Project,</p></li>
  <li><p>Then I created a new Data connection in Server Explorer (Visually > Not by Coding) in Visual Studio 2012.  Server Explorer > Add Connection > (In Server Name I gave . and selected my database from the combo box given there , I clicked TEST CONNECTION (It gave me Connection Successful !) then I clicked OK ).</p></li>
  <li><p>Then I created a NEW DATA SET by clicking on Solution Explorer > Add > New Item > Dataset.</p></li>
  <li><p>Then In Data Set I Dragged Tables from my Database. And started working with my Database.</p></li>
  </ol>
  
  <p>Now the problem is that when i wish to publish my project, my database is not attached with it! What to Do Now??? </p>
  
  <ol>
  <li><p>How can I publish this Application with my Database created in SQL Server Management Studio 2012??</p></li>
  <li><p>How can i reference my Database to my Winform Application?</p></li>
  <li><p>Do i have to reference it before publishing? If YES, then HOW????</p></li>
  <li><p>IF ... someone in one of you helped and solved my problem, then when I install this 
  Application with database on my client PC, and install SQL Server 2008 Express OR SQL Server Management Studio 2012, will I have to give server name. In his PC?? After installing and running SQL Server Management Studio 2012???? If yes then, how can I configure database reference settings after my application is published?</p></li>
  </ol>
  
  <p>I know this is a very long question but I am stuck very badly!!! Any Help Will Be Appreciated....</p>
  
  <p>NOTE : I don't know any other method on how to make a database app in winforms in visual studio 2012 , so please try to help me in my way , Not by telling me to use SQL Compact or LOCAL Database in my app !!! I know it’s a tricky question!</p>