Xamarin: "Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"

I am aware this questioned has been asked on here multiple times, but no answer seems to get me anywhere. The thing is that I have a Xamarin.Android app, and following this tutorial (https://blog.xamarin.com/building-android-apps-with-entity-framework/) I am trying to set up a local SQLite database.

However, when I get to the step about creating a console app and making migrations, it doesn't seem to work as the tutorial shows. For one thing, I can't get the example migration code running in the console app window, but running the same code from my class library works fine, and adds a folder which contains migrations. But starting the emulator with the migration folder there won't work, as the application never starts, it stops at the emulator home screen.

Trying to do "dotnet ef database update" in this folder gives me "Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)", and I can't figure out how to solve this. Any help would be appreciated.