Connection to SQLite db that has a custom function

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
mmedic
Posts: 1
Joined: Wed 02 Mar 2011 03:48
Location: Charlotte

Connection to SQLite db that has a custom function

Post by mmedic » Wed 02 Mar 2011 03:59

Connector fails to connect to SQLite db that has a custom function defined. It throws an erro stating that the function does not exist and then skips showing any tables. Any ideas?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 02 Mar 2011 10:23

SQLite doesn’t support user defined functions natively. But you can write a user defined function yourself in your favorite .NET language, and later that function can be binded to SQLite core functions. Please refer to our blog: http://www.devart.com/blogs/dotconnect/ ... tions.html. If the examples from the blog article doesn't help, please send us a small test project with the corresponding SQLite database file to reproduce the issue in our environment. Also tell us the exact text of the error, your call stack, and the version (x.xx.xxx) of your dotConnect for SQLite (the Tools > SQLite > About menu of Visual Studio).

Post Reply