SQLite Asp.net Path Problem

Question

when using data source=|DataDirectory|\mydb.sqlite in visual studio 2008 i can not see the tables in query builder and in dataset designer. How can i fix this? it is a web application for .net 3.5 thanks a lot

Answer 1

i found this

This would be the proper method, except that it doesnt support designtime, as in, your program will work in debug and in release modes, but when trying to edit the dataset definitions, it crashes out with "unable to connect to the DB". it is a known bug in SQLITe. – Karl Feb 3 '09 at 18:44

http://stackoverflow.com/questions/314853/with-system-data-sqlite-how-do-you-specify-a-database-file-in-the-connect-string

Answer 2

i have used relative path for local and |DataDirectory|\mydb.sqlite for web server. it works in this way