title: trouble with initial setup and connection to microsoft sql server from Visual Studio
body: <p>I am on a Windows 10 machine, which has Visual Studio 2015. I am now trying to do projects with a database on the same machine. I seem to have SQL server ( I am really new to Databases ) Here is why I think I have a Database, which I can use: </p>
  
  <pre><code>C:\Users\zohal&gt;wmic product get name,version | findstr "SQL"
  Microsoft SQL Server Compact 4.0 SP1 x64 ENU                                                                    4.0.8876.1
  </code></pre>
  
  <p>When I try to connect to a database from Visual Studio I do the following: 
  click on Project > Add New Data Source new Window Comes up
  select Database  new Window Comes up
  select Dataset   the only option available, new Window Comes up
  select NewConnection new Window Comes up There are six options 
  select Micorsoft SQL Server new Window Comes up but the pulldown is blank. I looked in the services section of Computer Management application, and do not see a SQL service running. I want to know how do I connect to this SQL server and does it work for what I want to do, which is to run .Net C# code with SQL statements? </p>
  
  <p>Update...........
  Guys, thank you for the content and advice. I have tried both SQL compact and SQL Express, and ran into the following problems. I wonder if you can help, or perhaps I'll create a new post. I have tried everything I could think of. 1) I tried to use the SQL compact. Got as far as "Creating a SQL server Compact Database". When I right click on the "App_Data", I just don't see an option of "SQL Server Compact 4.0 Local Database" as it stated in the procedures. Here is an <a href="https://i.stack.imgur.com/vcgwb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vcgwb.png" alt="image"></a> of what I see. I did a search online for this type of issue, and the solution was to install a tools package. I did that. In fact I ran the Visual Studio install file, and chose the modify option and added all the tools, and support packages I could think of. I rebooted the machine also; no change. 
  I also ended up installing SQLExpress, and followed <a href="https://www.dotnetperls.com/sqlclient" rel="nofollow noreferrer">this</a> link to set it up, but when I click on a new connection option I do not see the SQL Express option in the server name pull down as it states in the procedure. I basically get as far as creating the project and three steps into the procedure. I can put the projects on Git if that helps. My immediate goal is to create a table and query it. Here the code in my project: </p>
  
  <pre><code>var query = from c in db.Customers
                          where c.City == "Nantes"
                          select new { c.City, c.CompanyName };
  </code></pre>
  
  <p>Right now, I get an error under "c" and "db" as I have not created a connection. While I don't know how to do that yet, I do know that is not a huge task. But if I can not connect to a Database, this does not help me much. I did find the right assemblies and added them to the beginning of my project. I am talking about </p>
  
  <pre><code>using System.Linq.Expressions;
  using System.Data.SqlServerCe;
  </code></pre>
  
  <p>Just tell me what to do. Should post again or can help me?</p>
  
  <p>Update: Thank you. The <a href="https://docs.microsoft.com/en-us/aspnet/core/data/ef-mvc/intro" rel="nofollow noreferrer">MVC .Net Core MVC</a> procedures worked. Thank you so much.</p>