Search code examples
ironpythonsystem.data.sqliteassembly-reference-path

Referencing an Assembly in the Application Path


I am trying to reference System.Data.SQLite which is located in the application path so that I can package it with the application. I have tried several different ways including:

#1
clr.AddReferenceToFile("System.Data.SQLite.DLL")

#2
clr.AddReferenceToFileAndPath("C:\\Path\\To\\System.Data.SQLite.DLL")

#3
sys.path.append(os.getcwd())
clr.AddReferenceToFile("System.Data.SQLite.DLL")

Each time it will either give me an error: "Could not load assembly System.Data.SQLite" or that it can't find the specified file.


Solution

  • The way we generally add references at work is the following:

    import sys
    import clr
    # forward slashes work fine here and don't need to be escaped
    sys.path.append('c:/path/to/directory/containing/dll')
    clr.AddReference('System.Data.SQLite') # note lack of .dll