System.Data.SQLite

Yes you can, by executing the statement 'PRAGMA journal_mode=WAL;'

http://www.sqlite.org/draft/wal.html (Activating And Configuring WAL Mode)

Ok, but how would we then specify the Connection String ? Do we just leave out the journal specification ? And when using the Designer and creating a Connection, would it not be an issue when chosing a mode from the list that is not WAL, but the DB is WAL ?

 I tried invoking objectcontext constructor with my own connectionstring at run time and it failed.

It finally worked by providing the journal mode=WAL in app.config file.

 

 

What must be do to deploy a solution using SqLite.dll without running Setup ?

actually, i get an exception if i run my app on machine where setup is not installed.

Thanks for help.

In my project, I have added the SQLite.Interop.066.DLL and set the [Build Action] = [Content] and set the [Copy to Output Directory] = [Copy if newer]. Still, *after* I open my my connection, I receive the unhandled Missing Method Exception message "Can't find PInvoke DLL 'SQLite.Interop.DLL" whenever I attempt to execute the reader on the SQLiteCommand. What is wrong?

 

ion123, Could you give us setup source code to see what is done to make sqlite working on client configuration, or can you explain what to do ?

Is it necessary to update registry or to copy files in windows directory ?

thanks for your great work

This forum is still up and running, but I do not believe anyone from SQLite comes here anymore. Their current website is www.sqlite.org, where you will see that they are up to Version 3.7.9.

When you are not using the entity framework, you will only need the "System.Data.SQLite.dll" (for the correct platform [x86 or x64]).

When your application is targeting "Any CPU" the "System.Data.SQLite.dll" (x86 and x64) will need to be installed to the GAC to let it pick the right version.

When using the entity framework, you will need "System.Data.SQLite.dll" and "System.Data.SQLite.Linq.dll". Also the provider needs to be registered:

In app.config or globally in machine.config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<system.data>
		<DbProviderFactories>
			<remove invariant="System.Data.SQLite"/>
			<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite"/>
		</DbProviderFactories>
	</system.data>
</configuration>

The source is available here:

https://bitbucket.org/ionkiwi/sqlite.net4

 thanks ion123