Sometime we want to make user defined function and use it in our query to the database. In Ms. SQL Server and Oracle DBMS support user defined function, stored procedure and transactional. Since SQLite is zero configuration, serverless and single database file, SQLite doesn't support user defined function (If you don't know what is SQLite and how to use SQLite ADO.Net with C# please refer to this post). User defined function can be made outside of the SQLite that means you make custom function … Read more...
[HowTo] Use SqLite ADO.NET with C#
September 26, 2009 • 35 Comments
SQLite is software library written in C that implement self-contained (very minimal support from external libraries), serverless (read/write process directly to database file), cross-platform (run in any Operating System), zero-configuration (no setup/installation needed), transactional (implement serializeable transaction) SQL database engine. SQLite is relatively small, approx 275 KB in size and single database file.For me SQLite is better solution rather than use MS.Access for medium to … Read more...
