[2008] How does this work (installing app with SQL Database?)

[Icyculyr]

Ok, I want to know how this works, I have a database in VS (several), now what happens when I build, and install my application via a project installer, do those databases get installed? or do I have to actually manually create the database in code, so it is created when my app is installed to someone's computer.

Thanks

[jmcilhinney]

If you've added an MDF file to your project and you're attaching that to SQL Server Express at run time then you just distribute the MDF.

If you have actually created a database in SQL Server then it's up to you to build that database when you install.

[Icyculyr]

So, I need to create the database via code...

How would one check if a database exists, I saw nothing about that in my SQL tutorial.

Cheers