System.Data.SQLite

 I'm using system.data.sqlite in a C# and XNA project and it's working very well, but I still have a problem with the designer interface.

I used the tips described in this topic to access the designer on Visual Web Developer 2008 SP1 and Visual C# 2008 Express SP1. It's working fine on VWD but I still have some problems on VCS. When I open a database with the Database Explorer, I receive an 'object reference not set to an instance of an object' error message the first time I click the OK button. The second time I click on the button it opens the database ! Then I can see and modifie the tables, views, etc., but when I try to see the data (right click on table and Extract Data) I have a 'Unspecified error' message. It displays the data window empty and below there's a message saying it's waiting for response from data source.

This problem appears only on VC# 2008 Express, not in VWD 2008, so I can use VWD to view, add or modifie data but it's not very user-friendly. I don't know if I'm the lone to have this problem but it's look like a bug. I reproduced it on different computers and OS (Vista and Win7RC) and from version 1.0.62 of system.data.sqlite. I didn't try previous versions. I have the XNA Game Studio (3.0 or 3.1) installed on both systems but I don't think it could impact the database designer.

Mahrak

(I'm not sure about the exact error message in english. I translated them from my french version.)

 To be sure it's not a problem with the french version I try on an english version of Visual C# Express 2008 SP1 and OS. I have exactly the same problems. I also try on Visual Basic and Visual C++ and the problems are the same on the both editors.I used the version 1.0.65 of system.data.sqlite for my tests

http://sqlite.phxsoftware.com/forums/p/987/5198.aspx#5198

That thread may answer your question(s).  Some of the designer functionality is missing in the Express Editions.

 Thanks for your answer. I looked some topic before to post but I missed this one.