OrmLite with in-memory Sqlite on AWS Linux machine

[gerdaditeriha]

Hi. I am using OrmLite to run some tests using Sqlite in-memory option. All is good, when running locally on my windows machine. But the tests fail on AWS Linux machine(using amazonlinux2-aarch64-standard:2.0 image)

This is how I create connection

dbFactory = new OrmLiteConnectionFactory(":memory:", new SqliteOrmLiteDialectProvider());
...
dbFactory .OpenDbConnection()

On my AWS Linux machine I get this error:
System.DllNotFoundException : Unable to load shared library 'SQLite.Interop.dll' or one of its dependencies.

I have tried it also on Ubunut VM, there is works, just like on my local windows machine. Anyone has issues running on this particular AWS image?

These are the OrmLite libraries I have

Following other suggestion I have installed bunch of sqlite libraries

None of those helped

[mythz]

You have 2 OrmLite Sqlite packages referenced, you should only be referencing the one implementation you're using.

If this is for ARM server you'll have the best chance with Microsoft.Data.Sqlite provider, i.e:

<PackageReference Include="ServiceStack.OrmLite.Sqlite.Data" Version="6.*" />

[gerdaditeriha]

Thank you for the suggestion. Setting version to 6.* and deleting other OrmLite.Sqlite library did not help though :(

[mythz]

It should definitely help with this error since you should no longer be using or referencing the package that produces this StackTrace. Whether or not the Microsoft.Data.Sqlite provider supports this platform would be a different issue.