However, one small limitation is that in some cases, SQLite supports only a subset of standard SQL commands. IMHO SQLite is a great product even supporting full text searching. However, this solution did not offer any way of automatically keeping the database updated with schema changes and so I created a simple initialization framework which is what this article is about. SQLite was my choice for an in-process database. I had previously used PetaPoco as a lightweight ORM when working with Umbraco and subsequently found NPoco which had added some nice features including async versions of many methods. This article came about when I was creating a small blog styled web application where EF and SQL Server was just too much overhead, I needed a smaller, lighter, in-process database which I could use with the Microsoft AspNet Identity framework.
0 Comments
Leave a Reply. |