I am trying to open a connection to my SQLite Database in WPF

Question

I am using SQLite.Net-PCL (trying to) in my WPF application.

I am stuck trying to make a connection.

I have this:

var connector = new SQLiteConnection(S, "My_DB_Path");

where 'S' is of type:

SQLite.Net.Interop.ISQLitePlatform

But how do I make this setting - confused...

well, give me an example line of code for this? What value do I pass in? — Andrew Simpson, Jan 14 '16 at 12:25
[SQLite connection strings](https://www.connectionstrings.com/sqlite/) — Izzy, Jan 14 '16 at 12:36
@Izzy thank you but I am using this framework : I am using SQLite.Net-PCL — Andrew Simpson, Jan 14 '16 at 12:37

score 1 · Answer 1 · answered Jan 14 '16 at 12:32

1

Googling around, it seems that the SQLiteConnection class has a constructor that just accepts a string. Can you use that one instead?

Something like:

new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;")

answered Jan 14 '16 at 12:32

Drew Noakes

Hi, the sqlite framework I am using does not expect just the connection string. :( – Andrew Simpson Jan 14 '16 at 12:36

score 0 · Answer 2 · answered Jan 14 '16 at 12:33

0

You can use the SQLiteConnection as follows

string dbPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "db_Name.db");

        db = new SQLiteConnection(dbPath);

        if (db != null)
            db.CreateTable<Table_Name>();

answered Jan 14 '16 at 12:33

Nishanth Bhat

Hi, the sqlite framework I am using does not expect just the connection string. :( – Andrew Simpson Jan 14 '16 at 12:36
Which versioon of sqlite are you using? – Nishanth Bhat Jan 14 '16 at 12:39
Hi, it is not a matter of version it is a matter of framework. I am using the SQLite.net PCL framework at : https://github.com/oysteinkrog/SQLite.Net-PCL – Andrew Simpson Jan 14 '16 at 12:41
var connection = new SQLiteConnection(new SQLitePlatformWinRT(), Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, DATABASE_NAME)); //Try to use this. – Nishanth Bhat Jan 14 '16 at 12:43
Thanks, but when I put that in I get: The type or namespace name 'SQLitePlatformWinRT' could not be found (are you missing a using directive or an assembly reference? – Andrew Simpson Jan 14 '16 at 12:45
Please check this link https://developer.xamarin.com/guides/xamarin-forms/working-with/databases/ – Nishanth Bhat Jan 14 '16 at 13:01
thanks but there does not seem to be any sample code for a wpf c# desktop application to make a connection – Andrew Simpson Jan 14 '16 at 13:03

score 0 · Answer 3 · edited May 23 '17 at 10:29

0

In Android, I'm using new SQLiteConnection(new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(), path);

For WPF maybe you can use a generec platform. See this topic

edited May 23 '17 at 10:29

Community

answered Sep 05 '16 at 12:11

Luiz

3 Answers3