Hello Everyone,
I'm creating a Windows Application in Visual Studio 2008. I've got experience developing business applications using SQL Database and Access Databases as well. But, I've seen "Service-based Database" in Visual Studio 2008 and I've made my whole application working with that Service-based Database. and It works pretty fine with Tables and SPROCS.
I'm using connectionstring like "AttachDatabase=|Data Directory|MISData.mdf" and also setting "User Instance=true" but, the error is, I want to create Setup Project of this application with this DB. And it installs on the client system very well and works fine.
But, When making some changes to an application, and installing that application back on that client's computer, it shows an error.. that DB is already there, instance have already database attached something like that you know.
Reason behind using "Service-based Database" was simple that it contains single file of the database, which client can use as mobility, sometimes in laptop and sometimes updated file of laptop in Desktop PC. But, dont really know how to make it possible with this great feature "Service-based Database".
Please help me out guys, How to solve this issue? that client can use this database file like Access Database (.mdb) file.