Can we use Sqlite database in asp.net?

Try
Using SQLite Embedded Database with Entity Framework and Linq-to-SQL[^]

Did you add the assembly to your assemblies section of web.config?

<add assembly="System.Data.SQLite,Version=1.0.60.0, Culture=neutral,PublicKeyToken=db937bc2d44ff139"/>

yes we can use

see the code below

<connectionstrings>
      <remove name="LocalSqlServer" />
      <add name="ConnectionStringName" connectionstring="data source=actual path to db" providername="System.Data.SQLite" />
</connectionstrings>

IMO you can use SQLLite in Asp.Net.
I have not used in Asp.Net but in WPF application and their website[^] can give you more insights on configuration etc.

Also go through these links

http://sqlite.phxsoftware.com/[^]

http://sqlite.phxsoftware.com/forums/p/1636/7005.aspx[^]