0

I installed Visual Studio 2010 and SQL Server Express 2012. Then I created a new database in SQL Server Management Studio.

Can someone tell me how to connect to this database from Visual Studio (the type of project is not relevant) and start working.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Amer A.
  • 1,025
  • 2
  • 16
  • 22
  • How would you like to use the data? Entity Framework, ADO .NET, ETc? – JSK NS Oct 10 '12 at 13:20
  • Welcome to StackOverflow! Questions such as these tend to get closed for being too general. There are tons of tutorials on the web to get you started, then if you have a problem with code you have written you can come back and ask specific questions. Good luck! – Dave Swersky Oct 10 '12 at 13:20

3 Answers3

0

Take a look at your Server Explorer. You will be able to create data connections, and use them, from there.

On the other hand, if you asking how to create a C# program and connect to your database, that's an entirely different question, with a far more complex answer. But a little research on Google should get you started. This article might help if this is what you want to do.

Randy Minder
  • 47,200
  • 49
  • 204
  • 358
  • Yes, I see my database in "Database Connections". So I would like to know how to use the database in my program with ADO.NET. – Amer A. Oct 10 '12 at 13:24
  • @AmerA. That is an entirely different and far more complex question. I suggest you start with the link I provided in my response. – Randy Minder Oct 10 '12 at 13:31
0

There are options like if you want to add and Entity Framework to your project or you want the simple to the point connection to the database. Well, in the second case you can follow the steps:

Go to the server Explorer>>Options to add a conection to the database>> Choose the Server Name>> and you will be guided.

For using an Entity Framework, you can go through the Entity Framework Tutorial

Incredible
  • 3,495
  • 8
  • 49
  • 77
0

I don't think you would be able to connect to SQLSERVER2012 database files from VS2010 server explorer due to the version incompatibility of the database files and the VS2010..

techBeginner
  • 3,792
  • 11
  • 43
  • 59