System.Data.SQLite

I just upgraded from version 1.0.28.0 to 1.0.36.1.  Now, I get compile errors when I reference SQLiteConnectionStringBuilder.  Is this no longer supported?

Regards - V

Can you paste the errors?  SQLiteConnectionStringBuilder hasn't gone anywhere, I assure you.

Robert

The error is the following:

Error 1 The type or namespace name 'SQLiteConnectionStringBuilder' could not be found (are you missing a using directive or an assembly reference?) C:\Perforce\vbecker_esd\ESD\Source\Master\Client\DataAccess\Specific\SQLiteClientPersistenceHelper.cs 32 13 DataAccess (Client\DataAccess)

I've downloaded the SQLite-1.0.36.1-source.zip, extracted the System.Data.SQLite.dll dated 10/25/2006 2:45pm, and added a reference to my project.  References to 'SQLiteConnection', 'SQLiteTransaction', 'SQLiteCommand', 'SQLiteException', 'SQLiteErrorCode' still work.

thanks & regards -V

Robert,

Just a heads up - the System.Data.SQLite.dll that comes from the msi works.  The one in the source.zip doesn't.  Just out of curiosity what's the reason for System.Data.SQLite.dll to be included in the source.zip?

thanks & regards - V

There is one special build of the DLL in the tools\install\resources folder that is used strictly to support Compact Framework development on the desktop.  You definitely should not be referencing that one!

Robert

so, does it mean the CF version of system.data.sqlite DOES NOT have the SQLiteConnectionStringBuilder?

i am currently developing a device application which uses the CF version of the system.data.sqlite, and i got it from SQLite-1.0.63.0-setup, after installation.

 thanks in advance!