Installing SQL Express / Creating a database during deployment

[Ekjon]

I need to deploy a .NET 2.0 windows application so if no SQL Server found on the network, it will allow them to install SQL Express. If there is SQL Server, then it will allow them to create a database with some baseline data. Really need help on this, Thanks, Ekjon

[Ekjon]

Basically, my concern is - to create a database with 30/40 tables with some data in some of them - the sql statements would be large. What would be the best approach to deal with it?