Visual Studio 2010 complaints about ELMAH on a 64-bit machine - fixed

  • August 23, 2010
  • James Skemp
My laptop has quickly become my development machine for smaller projects, especially after I purchased a low-end desktop to host the Subversion repositories. I recently added ELMAH support to one of my sites, but since I run 64-bit, and have been using the built-in Cassini for quick development, I started getting a message in Visual Studio 2010 saying "ASP.NET runtime error: Could not load file or assembly 'System.Data.SQLite' or one of its dependencies.

Read More

Using SQLite as a membership, profile, and role provider in ASP.NET MVC

  • October 25, 2009
  • James Skemp
I'd really like to implement membership providers in my Web applications, but just don't have the user-base that requires SQL Server (Express), nor the memory on my production server. Having looked at SQLite before, I figured it would be exactly what I'd need, without going to the alternative of XML. After some research I found Roger Martin's SQLite Membership, Role, and Profile Providers, and finally decided yesterday to implement these on a dummy MVC site.

Read More

iTunes Music to SQLite - version 0.1 beta released

  • September 24, 2009
  • James Skemp
While it was at the same stage as it is now back on the 19th, I'm finally releasing the beta version of iTunes Music to SQLite. This console application finds all Music playlists in iTunes and imports them into a SQLite database (called iTunesMusic.s3db). You can change this by passing the database and source names as parameters. For example: iTunesMusicToSQLite.exe "datum.db" "James Skemp's 80 gig" You can run the executable and it will prompt for a key press before exiting, in case you want to view any messages.

Read More

IIS Logs to SQLite - version 0.1 beta released

  • September 24, 2009
  • James Skemp
Unfortunately, Microsoft Log Parser is unable to convert logs into SQLite. To work around this limitation I've created IIS Logs to SQLite, which will parse IIS logs and import them into the SQLite database and table of your choice. The first beta version of this application is now available. Download IIS Logs to SQLite version 0.1. This application requires the .NET Framework version 3.5 (check your version of .NET Framework).

Read More