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.

Have you considered Entity Framework Code First as an option? — websch01ar
– websch01ar, Commented Jan 23, 2014 at 16:37
It sounds like you want to use a Visual Studio database project (instead of SQL Server Management Studio) and you want the developer to work against a local development database when debugging (which he should be doing anyway). In the latter case, if the database project is set to deploy to the database as part of running the project then it would update the stored procedure(s) (and other database objects) when the solution is built/deployed as part of invoking the debugger. — David
– David, Commented Jan 23, 2014 at 16:38
Look at CLR Object in SQL Server. I've never done it, though — Luis Filipe
– Luis Filipe, Commented Jan 23, 2014 at 16:39
@websch01ar: Entity Framework Code First looks very promising but, unfortunately can not be used in my case. Thanks — Jeppen
– Jeppen, Commented Jan 24, 2014 at 8:21

cdev · Accepted Answer · 2014-02-06 22:11:41Z

2

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/

answered Feb 6, 2014 at 22:11

cdev

1665 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kevin Cunnane Over a year ago

For Visual Studio 2010 you can download SSDT from the links you posted. It also supports database unit testing and using local/test databases during development so it definitely sounds like it would meet Jeppen's needs.

Collectives™ on Stack Overflow

Development methods C# and SQL Database in Visual Studio

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related