Change DB to SQL Server

Jun 3, 2011 at 2:33 PM

Hi Tim,

I have read your book and want to develop some software that pattern like in your book. But, I want to use SQL Server as DB, especially SQL Server 2008. Do you have any suggestion how to connect it to SQL Server 2008 instead SQL Server CE 3.5?

Coordinator
Jun 3, 2011 at 10:54 PM

Hi Andreas, you should be able to just change the connectionString and providerName (should be changed to System.Data.SqlClient) in the app.config file.  After that, you'll probably want to change the code in the repository implementations to use stored procedures instead of dynamic SQL strings.  By the way, I actually have a related DDD project here on CodePlex that does just that, it even targets SharePoint!  Here's the link:

http://ncipna.codeplex.com/

Thanks,

Tim