SQLite Data Source Connection String?

Hello,

Trying to connect my C# project to a SQLite DB.

I can get the connection to work with the old assembly “URI” connection string.

string Path = "C:\Blah\Blah\BlahBase.db";
IDbConnection Base = new SqliteConnection (@"URI=File:" + Path);

But, I cant get the connection to work with “Data Source”.

string Path = "C:\Blah\Blah\BlahBase.db";
IDbConnection Base = new SqliteConnection ("Data Source=" + Path);

I get “Invalid Connection String: No URI” Error.

Any thoughts?

Sean

Was missing a plugin for the latest SQL which does not exclusively use a “URI” once I added that it worked fine.

Tutorial SQLite Unity3d 2018 or higher( Android , Windows Phone , Windows , IOS, WINRT )
How to Connection Database Sqlite how to Create Table , Select , Insert , Update , Delete , Search

How to read data from on unity Solving all error in unity for assembly reference:
1- error “The type or namespace name Data’ does not exist in the namespace ‘Mono’. Are you missing an assembly reference?”
2- and error “The type or namespace name MONO’ does not exist in the namespace Data’. Are you missing an assembly reference?”

  • using Mono.Data.Sqlite;
  • using System;
  • using System.Data;
  • using System.IO;
  • using UnityEngine.UI;

learning how:

  • SQLite Admin to create database and tables …
  • SQLite DLL to support unity .s3db extension and compile on unity for windows 32bit or 64bit.

Github example : walidabazo (Walid Abd El Azeem) · GitHub

Video