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
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.
SharpDevelop is a free IDE for C# and VB.NET projects on Microsoft's .NET platform, you can download it at http://www.sharpdevelop.net.You can then paste the C# code into an empty project and under Tools -> Convert Code to -> VB.NET let the IDE convert the code for you, VB.NET -> C# is also possible. Your sample is converted to:
Using mytransaction As SQLiteTransaction = myconnection.BeginTransaction() Using mycommand As New SQLiteCommand(myconnection) Dim myparam As New SQLiteParameter() Dim n As Integer mycommand.CommandText = "INSERT INTO [MyTable] ([MyId]) VALUES(?)" mycommand.Parameters.Add(myparam) For n = 0 To 99999 myparam.Value = n + 1 mycommand.ExecuteNonQuery() Next End Using mytransaction.Commit() End Using
SEE i.e. the SQLite Encryption Extension which allows an application to read and write encrypted database files. This aapplication use the 'Attach' command of SQLite talk to two or more encrypted and unencrypted database files. Every database file have its own encryption key.