System.Data.SQLite

After some thought, I decided that rather than do some really rudimentary tutorial code that demonstrates the simplest of SQL, my time would be better spent hitting on some of the more advanced topics and features of SQLite.  Here are some of the samples I hope to complete in the coming days: 

1. Creating a new SQLite database file
2. Enabling NTFS file compression on a database file
3. Enabling NTFS encrypted file system support on a database file (obsolete, see #5)
4. Writing parameterized queries
5. Encrypting, decrypting and attaching to encrypted databases
6. Writing high performance inserts/updates
7. User-defined scalar, aggregate and collation functions
8. Attaching multiple databases to a connection (aka "how to read and write simultaneously")
9. Reclaiming unused space in a database file (vacuum)
10. Retrieving and interpreting schema information

 

I'll be finishing those up next week if I'm able.  Things are getting a little crazy with the holidays coming up!

Robert

 

Robert,

great job! it works wery nice and i love the performance.

I think other people will also agree that it would be great if you can make PDF manual which will come together with installation of ado.net sqlite.

grtz

Perica

So its been 1 year so far, and I still dont see an example of user defined functions.  This would be extremely helpful for me.  Could you show us a quick example of this?  Whenever I try it I get a no such function.

It was easy to find anexample of user function. Here is link to thread about adding regex function to sqlite:
http://sqlite.phxsoftware.com/forums/thread/1457.aspx

In the source code distribution is a project called Test.  Inside that project is TestCases.cs which contains several examples of user-defined scalar and aggregate functions and collating sequences.

Robert