System.Data.Sqlite for Linux / Ubuntu / Mono

System.Data.Sqlite default Nuget package will not work in Ubuntu / Mono.
This error will occur:

System.TypeInitializationException: The type initializer for 'System.Data.SQLite.SQLiteFactory' threw an exception. ---> System.DllNotFoundException: SQLite.Interop.dll  at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_config_none (System.Data.SQLite.SQLiteConfigOpsEnum)  at System.Data.SQLite.SQLite3.StaticIsInitialized () <0x4037a6f0 0x00087=""> in :0   at System.Data.SQLite.SQLiteLog.Initialize () <0x4037a370 0x00027=""> in :0   at System.Data.SQLite.SQLiteFactory..cctor () <0x403645f0 0x00057=""> in :0   --- End of inner exception stack trace ---

copying over SQLite.Interop.dll to the bin folder didn't fix the issue.
the solution is to download Sqlite source code and build it yourself using this command:

MSBuild System.Data.SQLite.2012.csproj /t:Rebuild /p:UseInteropDll=false /p:UseSqliteStandard=true

here is a download link to save you time:

System.Data.SQLite.dll

Access SharePoint 2013 from Linux/ Ubuntu

For a long time I couldn't access SharePoint 2013 from my Ubuntu machine.

when I try to access it, I get this error:

401 UNAUTHORIZED

Here is the solution for this problem:

1- Use any other machine to access SharePoint and for each site you want to access from Ubuntu disable (  Minimal Download Strategy ) feature.

Site settings -> Manage site features -> Disable Download Strategy

2- Make sure you use the fully qualified name for your SharePoint server in the URL
so instead of http://sharepointserver, use http://sharepointserver.compnaydomain.com

not using the fully qualified name will cause SharePoint to keep prompting you for user name and password.