-
Using Linq to Sqlite Providers: Updated
Posted on February 9th, 2009 4 commentsSo, 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.
Uncategorized .net, ado, ado.net, linq, Mono, sqlite, visualstudio, vs20084 responses to “Using Linq to Sqlite Providers: Updated”
-
[...] This post is obsolete, please see this post on Sqlite Linq Providers. Kubasik csharp, Hacking, linq, Mono, sql, sqlite [...]
-
Mono support would be great
-
Thanks
I was lost, this is simple and right to the point
-
I guess it won’t work with Visual Studio Express Editions, or does it?
Leave a reply
Recent Comments