Click here to Skip to main content
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 22: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  
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 Maciej Los 295
1 OriginalGriff 273
2 Aajmot Sk 234
3 Marcin Kozub 205
4 Richard MacCutchan 200
0 OriginalGriff 7,903
1 Sergey Alexandrovich Kryukov 7,127
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,820


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 17 Nov 2012
Copyright © CodeProject, 1999-2014
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