jeudi 18 février 2016

what is the exact sytax to open sqlite "Temporary" database using vb.net

below will create in memory db

Dim cn As SQLiteConnection = New SQLiteConnection("Data Source=:memory:")

below will create disk file db with name abc in C:\Temp\

Dim cn As SQLiteConnection = New SQLiteConnection("Data Source=C:\Temp\abc")

or below will creates disk file db with name abc at default location ..\SqliteProject\bin\Debug

Dim cn As SQLiteConnection = New SQLiteConnection("Data Source=abc")

but.. how to create temporary db?? documentation Link1 Link2 Link3 Link4 says "to create temporary db use empty filename". but no one tells the exact code. I tried various combinations

Dim cn As SQLiteConnection = New SQLiteConnection("") 
Dim cn As SQLiteConnection = New SQLiteConnection("Data Source=") 
Dim cn As SQLiteConnection = New SQLiteConnection("Data Source=C:\Temp\")

but all throws exception/error

Aucun commentaire:

Enregistrer un commentaire