Click here to Skip to main content
11,583,865 members (44,385 online)
Rate this: bad
good
Please Sign up or sign in to vote.
Hai....
Can we use Sqlite database in asp.net? If we can, how to install the sqlite? And how to connect to the database?

Thanks......
Posted 19-Dec-11 21:46pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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[^]
  Permalink  
Comments
RaviRanjankr at 20-Dec-11 5:05am
   
5+
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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>
  Permalink  
Comments
Member 11082705 at 15-Apr-15 6:09am
   
how to decrypt sqlite database to display in gridview
Member 11082705 at 15-Apr-15 6:09am
   
in asp.net
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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"/>
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

  Permalink  
Comments
Suresh Suthar at 20-Dec-11 5:13am
   
Very informative. 5!
RaviRanjankr at 20-Dec-11 5:15am
   
Thanks :)
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 5

  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 430
1 Sergey Alexandrovich Kryukov 314
2 virusstorm 268
3 Richard Deeming 220
4 Dave Kreskowiak 200
0 OriginalGriff 1,623
1 Sergey Alexandrovich Kryukov 1,135
2 Abhinav S 701
3 Dave Kreskowiak 627
4 Suvendu Shekhar Giri 568


Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 17 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100