How to create asp.net web application using sqlite [closed]

Question

I want to develop small application in asp.net using sqlite, actually I don't know how to use sqlite in application. Can anybody provide a link for step by step process to create a application in asp.net code behind c#.

Answer 1

You create it the same way you would any regular asp.net web application - You probably want to use a provider for it, such as this: http://system.data.sqlite.org/

Here is how to make the connection: http://www.fryan0911.com/2009/10/c-how-to-connect-to-sqlite-database.html

More information about sqlite functionality here: http://www.aspfree.com/c/a/Database/Using-SQLite-for-Simple-Database-Storage/

There are certain subtleties that is different than regular sql server - you can read about it on that site. Here is another question that has some information on these subtle differences: https://stackoverflow.com/questions/822548/c-sqlite-syntax-in-asp-net