Hi, I'm new to Visual Studio, C#, and SQL Server, so wanted to ask what might be a rather basic question: I'm using Visual Studio 2013 Express to develop a desktop Windows Forms application which which uses and will be deployed with a SQL Server localDB database. The database will need to be updated periodically, so I'd like to make that as easy as possible.
When I started I wasn't sure I would end up sticking with C#/SQL Server (or revert back to VBA/Access), but I'm making decent progress now and want to reorganize/optimize the projects within my application (I'll have more questions about that in a different thread).
My question is what is the best way to add the localDB database to the application? The MSDN documentation says to add a localDB in a new Windows Forms project, but from what I've seen it looks like an SQL Server project might be better because my understanding is that it is easier to update databases created as SQL Server projects. What are the pluses and minuses of doing it both ways?
My inclination is to follow the guidance in the MSDN documentation, but I'd at least like to understand why they suggest a Windows Forms project. Thanks in advance for any advice.