Development methods C# and SQL Database in Visual Studio

Question

I've been googeling and testing this issue now for a while. Here is my question:

We develop in Visual Studio 2010 the C# part and Microsoft SQL Server Management Studio for the Views/Stored Procedures/... part.

What I want to do is combine both systems so that:

• The developer writes the C# code in the C# project
• The developer writes the stored procedure in the SQL project
  • He can test the stored procedure against the test environment database from VS
• When he wants to test the C# code, the stored procedure is beeing created runtime ONLY. When The application stops (break) the object is beeing destroyed.

Maybe you can help me.

Answer 1

If you are using Visual Studio 2010 you may need to install the sql server data tools (used to create database projects). It's installed with VS 2012 but I'm not sure about VS2010.

Here are some links for more information: Site: http://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx Blog: http://blogs.msdn.com/b/ssdt/