Today I spent couple of hours finding out why my ServiceStack + OrmLite was not working on Azure.
It seems that the current ServiceStack.OrmLite.SqlServer.Core package references an "old" System.Data.SqlClient (< 4.4).
There seems to be a problem on azure because they are using some old os for deploying the services.
So manually adding the System.Data.SqlClient 4.4 package resolved the issue.
For reference (and google's sake), check this when you are getting System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.TdsParser' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SNILoadHandle' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'sni.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
I've upgraded to use System.Data.SqlClient v4.4.0 in this commit that's available from v1.0.45 that's now available on MyGet.