C# SqliteConnection problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MichaelHooker
    New Member
    • Sep 2007
    • 5

    C# SqliteConnection problem

    I am fairly new at C#, but I already have two similar programs working, retrieving data from a SQLite file. Now I am working on a third, but despite the fact that I am following the same path, Visual Studio 2015 Community Edition won't accept my code.
    In all cases I have used the Nuget manager to install System.Data.SQL ite, and added "using System.Data.SQL ite;".

    But in the latest program, when I get to the point of setting the connection as follows:

    Code:
    SQLiteConnection sqlCon = new SQLiteConnection("Data Source=c:/Users/Public/Dropbox/Log/AvData.sqb; Version=3;");
    sqlCon.Open();
    The first line reports "'SQLiteConnect ion' does not contain a constructor that takes 1 arguments" and the second "'SQLiteConnect ion' does not contain a definition for 'Open' and no extension method 'Open' accepting a first argument of type 'SQLiteConnecti on' could be found (are you missing a using directive or an assembly reference?)"

    Solution Explorer confirms that the SQLite package is installed.

    Those two lines are as far as I have got and now I am stuck. Why is SqliteConnectio n not behaving the same way as it did before ?

    Many thanks in advance for any help provided.
    Michael
Working...