Using Linq to Sqlite Providers: Updated

So, I still get hundreds of hits each day looking for my linq to sqlite provider, which is quite outdated. To prevent anyone else from falling prey to bitrotten code, I have taken down the link, and created this brief walkthrough. 

For starters, you need to download sqlite for ADO.Net here: http://sqlite.phxsoftware.com/

You will also need the ADO.Net Entities Framework and Visual Studio 2008.

• First, install the Sqlite Provider that you downloaded, and when prompted, choose to install DesignTime support for Visual Studio 2008. 
• Now, open Visual Studio and create a new project.
• Expand the Server Explorer on the left and add a new connection. 
• Select the Sqlite provider.
• Once you have a Sqlite Connection, create your schema.
• Next, Create a new ADO.Net Entities Model, and choose to generate models from a database. Select your Sqlite Connection.
• Viola! We now have objects representing our SQLite database that can be queried and modified!

I’ll upload a screencast in a few days when I can get my hands on a screencast recorder for Windows. I’m also working on the means to generate those ADO.Net entities under Mono, but I am still researching what is out there.