How can we connect SQLite in ASP.Net?

Question

How can we connect SQLite in ASP.Net? Please provide me some sample code snippets.

Sri Rama Phani Bhushan · Answer

It same as sqlserver you need to add sqlLite.dll reference your Project. and the code follows like this SQLiteConnection sqlCon = new SQLiteConnection(connection string); string Cmdtext =Insert Query; SQLiteCommand cmd =new SQLiteCommand(cmdtextsqlCon); if(sqlCon.state == system.Data.Connectionstate.Closed) { sqlCon.Open(); cmd.ExecuteNonQuery(); }

Sri Rama Phani Bhushan · Answer

It same as sqlserver you need to add sqlLite.dll reference your Project. and the code follows like this SQLiteConnection sqlCon = new SQLiteConnection(connection string); string Cmdtext =Insert Query; SQLiteCommand cmd =new SQLiteCommand(cmdtextsqlCon); if(sqlCon.state == system.Data.Connectionstate.Closed) { sqlCon.Open(); cmd.ExecuteNonQuery(); }

Maram Kiran · Answer

Thanks friends finally i got the solution.