Using SemWeb with SQLite

As mentioned in the previous post I've had a few problems getting SemWeb, the C# RDF library, to persist data to a database. Here I describe the steps I've had to follow to get things working.

I've been using Visual Studio on Windows - I suspect that these problems may not exist when using Mono on Linux.

I'm using the following versions:

• Visual Studio 2005
• SemWeb 1.0
• MySQL Server 5.0
• MySQL ADO.Net Data Provider 5.0.7
• Mono 1.2.4
• SQLite 3.4.0

SQLite

Following the approach described in the SemWeb documentation, I first tried to set up a database connection to a SQLite database.

Following the SemWeb documentation I performed the following steps:

• Placed the "sqlite3.dll" (from the SQLite download) into my windows System32 directory
• Added the "Mono.Data.SqliteClient.dll" from the the Mono install directory "Mono-1.2.4\lib\mono\2.0" into my SemWeb\bin directory
• Downloaded the sample RDF file from http://www.mozilla.org/news.rdf
• Entered the specified command line at a DOS prompt in the SemWeb\bin directory:
  rdfstorage.exe news.rdf --out "sqlite:rdf:Uri=file:news.sqlite;version=3"
• Pressed return and stood well back.

I was greeted with the following:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: The located assembly's manifest definition with the name 'Mono.Data.SqliteClient' does not match the assembly reference.

Basically my Mono SQLite adapter was newer than the version that the SemWeb.SqliteStore.dll had been built with.

Unfortunately the SemWeb Visual Studio solution doesn't come with a SemWeb.SqliteStore project, so the following steps are required:

• Open the SemWeb solution in Visual Studio
• Add a new project of type "Class Library" and called "SemWeb.SqliteStore"
• Delete the default "Class1.cs" that gets added to the project
• Choose to add an existing item to the project and pick "SQLiteStore.cs" from the SemWeb\src directory
• Add a reference to the "Mono.Data.SqliteClient.dll" that should already be in the SemWeb\bin directory
• Add a reference to the SemWeb project
• In the project properties, set the output path to the SemWeb\bin directory

I also rebuilt the SemWeb and RDFStorage projects (after setting their output directories to the bin directory). Once built I re-ran the command line and this time obtained the expected result:

news.rdf 0m0s, 81 statements, 1036 st/sec
Total Time: 0m1s, 81 statements, 42 st/sec


Next time I'll describe the steps I've had to follow to get SemWeb up and running with MySQL.