> If I try to query database existence using Linq's "DatabaseExists" I get > a NotImplemented exception in the sqlite ChangeDatabase function - which > doesn't make sense to me.
SQLite doesn't have a notion of server containing several databases. That's why it makes perfect sense that SQLite doesn't implement DatabaseExists or ChangeDatabase methods. If you want to check database existence just check if file exists in the file system. If you want to use new database just open new connection to it. Also if you want to create a new database just open connection to it, it will be created automatically. Sorry I can't say what syntax for all those things it is in Linq. Pavel On Tue, May 24, 2011 at 10:28 AM, Ruth Ivimey-Cook <[email protected]> wrote: > Folks, > > Has anyone successfully used system.data.linq and system.data.sqlite > together with the linq CreateDatabase function? > > When I try, I get an exception "syntax error near "DATABASE"". > > If I try to query database existence using Linq's "DatabaseExists" I get > a NotImplemented exception in the sqlite ChangeDatabase function - which > doesn't make sense to me. > > Regards, > Ruth > > -- > Software Manager& Engineer > Tel: 01223 414180 > Blog: http://www.ivimey.org/blog > LinkedIn: http://uk.linkedin.com/in/ruthivimeycook/ > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
