Winform App creates database in MSSQL LocalDB & creates tables. Data is imported & analysed then report is created. At any point in the process the user can start a new project & tables are removed to be re-created later as the user progresses through the steps in the application.
The app works perfectly the first time, however when the user starts a new project (second project) the SQL tables are dropped (as planned) however when the app attempts to re-create the tables an error occurs stating that the database is offline. However it is online & accessible through the MSSQL Management Studio.
Not sure which code would be useful to post as it all works the first time round - any ideas on what's happening as everything works fine the first time & through MSSQL management Studio........