System.Data.SQLite

Hi folk, I'm using Visual Studio 2008 express (.Net V3.5 SP1) with the designer components installed (version of SQLite-1.0.65.0). When I try to add a connection, I get an error after entering my connection string and clicking OK: "Object reference not set to an instance of an object" . is someone has encountered this issue ? Thx for your help in advance, Cedric

 I have exactly the same problem. I described it in this topic, but I don't have any solution. I hope Robert will look at it soon.

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

The designers are missing functionality in the Express Editions.  There's nothing I can do about it unfortunately.

It fixable through patch against Visual Studio Express config file to redirect assembly binding. For example to get SQLite designer working in VS C# 2008 Express, you need to add following lines to C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\VCSExpress.exe.config on same level with other <dependentAssembly> entries.

<dependentAssembly>  
   <assemblyIdentity name="Microsoft.VisualStudio.Data" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />  
   <bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="9.0.0.0" /> 
</dependentAssembly> 

For VS C# 2010 you need to add following lines to C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VCSExpress.exe.config

<dependentAssembly>   
  <assemblyIdentity name="Microsoft.VisualStudio.Data" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />   
  <bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="10.0.0.0" />   
</dependentAssembly> 

For fix SQLite Designer in Visual Basic Express, change VBExpress.exe.config, for Visual C++ change VCExpress.exe.config respectively. Although i not recommend it, cause it is against VS Express EULA ("You may not work around any technical limitations").
However seems SQLite design mode works in Visual Studio Web Developer Express 2008 without any modifications.

Do you solve your problem? I have the same problem too.