I'm creating an application with MS Visual C# 2010 Express that requires a database.
I've learned that there seem to be two ways to create/use a SQL database with this application.
The first seems to be where from within C#, I can create a "local database" by right-clicking on my application in the Solution Explorer and clicking "Add"->"New Item"->"Local Database". Then it's shown in the Database Explorer and I can use it.
The other way is where I create a database with SQL Server Management Studio and then from within the C# code, I open a connection to it (SQLConnection... yada yada yada) and use it.
I'm having a hard time understanding what technical reasons there are between choosing one way or the other way to do this...
Can someone describe the differences and what criteria would be used to choose one way vs. the other? (or point to a website reference...)
Thanks!
-Adeena
Additional Info... Right now, this is really a hobby project as I get a few things worked out.
- I'm the only developer and working on a single machine
- The application is intended to be one that runs standalone - not in a browser or over the web in any way. I know that that's not the direction the universe is heading, but as mentioned above, this is a hobby project that I need to complete to work out a few other issues.
- I don't believe I have any need or intent for multiple applications to work on this database.