topic Re: My Revit app can't find SQLite. dll in Revit API Forum

My Revit app can't find SQLite. dll

Anonymous — Thu, 19 Apr 2018 09:32:54 GMT

I am trying to use SQLite in my c# app to store data but I got file not find althought I refenced in the app, put it in all possible folders.

What to do? See the image.

Re: My Revit app can't find SQLite. dll

MarryTookMyCoffe — Thu, 19 Apr 2018 10:37:38 GMT

look at this https://forums.autodesk.com/t5/revit-api-forum/3rd-party-dll-in-revit-addin/m-p/7746443#M28372 and if you start from RevitManager it can not load it with referenced dll

Re: My Revit app can't find SQLite. dll

JimJia — Fri, 20 Apr 2018 01:53:22 GMT

Hi usama, Please put SQLite.dll to the same folder with your external applicaiton "Licenses" dll. After that, your app will find the SQLite.dll when it runs.

Re: My Revit app can't find SQLite. dll

Anonymous — Fri, 20 Apr 2018 06:12:42 GMT

Thank you for the answer. Actually it is there. When I add a refrence to the sqlite.dll in the Revit.exe directory it works.

Re: My Revit app can't find SQLite. dll

jeremytammik — Sat, 21 Apr 2018 19:32:53 GMT

Revit.exe directory is the key. Alternatively, use a .NET assembly resolver:

http://thebuildingcoder.typepad.com/blog/2014/05/rvtva3c-assembly-resolver.html

Cheers,

Jeremy

Re: My Revit app can't find SQLite. dll

Tripler123 — Thu, 10 Dec 2020 17:44:33 GMT

Hi Jeremy,

i have the same problem. I try use Assembly.LoadFrom(Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "System.Data.SQLite.dll")); but don't working.

Re: My Revit app can't find SQLite. dll

Anonymous — Thu, 13 May 2021 11:15:07 GMT

I have the same problem. My plugin program run on Revit 2021. I make sure that Revit 2021 have not 'System.Data.SQLite.dll'. I don't know why tell me 'cannot load the dll'.

I haved try using 'Linq2Db' and 'EntityFramework' for sqlite to do, but I failed. If you have solution, please tell me.

Thinks!

Re: My Revit app can't find SQLite. dll

MarryTookMyCoffe — Mon, 17 May 2021 07:42:43 GMT

try read what path it give you back before calling dll.

Re: My Revit app can't find SQLite. dll

Anonymous — Mon, 17 May 2021 17:18:38 GMT

The dll path is valid. I guess that revit maybe not work well. My solution: Dapper+System.Data.SQLite.Core+DapperExtensions. You will can write lambda expression to do anything.

Demo: https://github.com/kelicto/HelloDapper. EntityFramework and Linq2Db cannot do that and throw exception.

Re: My Revit app can't find SQLite. dll

Sean_Page — Wed, 19 May 2021 10:07:35 GMT

I ran into issues recently in 2022 related to references that previously worked and turning on and using the Fusion Assembly Binding log viewer was a substantial help.

"Fuslogvw.exe (Assembly Binding Log Viewer) | Microsoft Docs" https://docs.microsoft.com/en-us/dotnet/framework/tools/fuslogvw-exe-assembly-binding-log-viewer

Re: My Revit app can't find SQLite. dll

joshua.lumley — Fri, 21 May 2021 05:31:21 GMT

SQlite is dependent on these two .net binaries that Revit does not load, therefore they also need to be loaded along with it:
Microsoft.WindowsAPICodePack.dll
Microsoft.WindowsAPICodePack.Shell.dll

Re: My Revit app can't find SQLite. dll

Anonymous — Fri, 21 May 2021 10:39:39 GMT

Maybe you are right. But why don't auto load them? 'Assembly.LoadFrom' method can auto load all required dlls. And the sqlite should give us all dlls.

Re: My Revit app can't find SQLite. dll

Anonymous — Fri, 21 May 2021 10:41:08 GMT

Please see my demo, it's very nice to assess sqlite db by lambda.

Re: My Revit app can't find SQLite. dll

joshua.lumley — Sat, 22 May 2021 00:21:47 GMT

What we're doing is API programming, unlike creating a standlone program there is no auto Loading and Revit is not going to load a single assembly unless explicitly told to do so. When loading assemblies I'm careful to examine what has already been loaded in order to avoid double loading and creating a memory leak.

See if you can make sense of the below code, to get my meaning..

And do you have a link to the demo.

if (AppDomain.CurrentDomain.GetAssemblies().Where(x => x.FullName == stringWindowsAPICodePack).Count() == 0) { Assembly.Load(File.ReadAllBytes(path + "\\Microsoft.WindowsAPICodePack.dll")); } if (AppDomain.CurrentDomain.GetAssemblies().Where(x => x.FullName == stringWindowsAPICodePackShell).Count() == 0) { Assembly.Load(File.ReadAllBytes(path + "\\Microsoft.WindowsAPICodePack.Shell.dll")); } //2 August 2019: End. Properties.Settings.Default.AssemblyNeedLoading = false; Properties.Settings.Default.Save();

Re: My Revit app can't find SQLite. dll

Anonymous — Tue, 25 May 2021 09:41:08 GMT

To access Sqlite db, I use System.Data.SQLite.dll.

I don't understand why should this.

Re: My Revit app can't find SQLite. dll

Anonymous — Tue, 25 May 2021 09:42:36 GMT

Sorry, it's invalid message. I don't know how to close it.

Re: My Revit app can't find SQLite. dll

joshua.lumley — Tue, 25 May 2021 19:38:53 GMT

Keep trying, your close to finding the solution.

Re: My Revit app can't find SQLite. dll

Anonymous — Wed, 26 May 2021 14:14:38 GMT

Hello @joshua.lumley ,

Thanks for your great answer it helped me a lot.
Could you tell me which using you need for the following snippet, and why it is needed? It seem to be working without.

Properties.Settings.Default.AssemblyNeedLoading = false; Properties.Settings.Default.Save();

Best regards,

François R

Re: My Revit app can't find SQLite. dll

joshua.lumley — Wed, 26 May 2021 19:37:42 GMT

This code is in the IExternalCommand interface (when the user clicks a button) and only needs to be run once per session. The AssemblyNeedLoading variable is set to true on launch.