Sqlite

The next hurdle in my Windows Azure project was the missing support for Sqlite. I needed to add these lines to the configuration to get it:

<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, Version=1.0.65.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
 </DbProviderFactories>
</system.data>

But what about the type? Azure needs the fullname. I used reflector to get it. http://reflector.red-gate.com/download.aspx 
Note: Azure needs the x64 assembly, so package it for deployment.

About erictummers

My work as a recruited developer changes almost every month. I like challenges and sharing the solutions with others. On my blog I’ll mostly post about my work, but expect an occasional home project, productivity tip and tooling review.
This entry was posted in Development. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s