Tuesday, January 15, 2008

Your Three Minute Guide to SQLite and .Net

mikeduncan.com - SQLite on .NET - Get up and running in 3 minutes.

"You found it! The quick and dirty guide to setting up SQLite with .Net in 3 minutes. Small, fast, and ass-kicking like a transactional Jackie Chan. At least that’s what this campy image created just for this post says. (Shout out to righteous graphics dude Brian Cook for the sweet photoshoppery)

...

SQLite is great for that small-mediumish application we already spec-ed out so lets get into the quick and dirty setup to get this hog rockin’ on .NET.

..."

Mike [Not related, but us Duncan's have to stick together...  ;)  ] has put together a very cool three minute guide to downloading and using SQLite with .Net.

While if I need a local DB I'd probably start with SQL CE, it's still good having this information as there have been some SQLite DB's I've wanted to access.

In looking for LINQ to SQLite information, I came across this site, System.Data.SQLite, which looks pretty cool too.

"System.Data.SQLite is an enhanced version of the original SQLite database engine.  It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll).  It has no linker dependency on the .NET runtime so it can be distributed independently of .NET, yet embedded in the binary is a complete ADO.NET 2.0 provider for full managed development.

..."

And there's forum chat that LINQ to SQLite may be coming...

No comments: