System.Data.SQLite

Is there any possibility to have relative path to database file in connectionstring that it would work in designer ? Cause if i make connectionstring to "DataSource=|DataDirectory|database.db3" then cannot use that file in designer, i must use full path to db file to use wizards during designing app. When i'm deploying or copy compiled app to the destination place i must edit connectionstring before compiling to have proper working application. Is there any solution to work with database file during design and compiled app without editing connectionstring?

Not at the moment there isn't.  There are a few things in VS2005 dealing with databases and designers that are hard-coded, and I think this is one of them.  If I can figure out a workaround, I'll fix it.

Robert

 

I was wondering the same thing, glad I found this post.