Options for in-process databases under medium trust

Question

I have seen a few different in-process SQL databases for .NET (including one from Microsoft), but either they do not work under medium trust (ASP.NET) or the documentation/websites don't even talk about.

What experiences have you had with in-process databases in general, and do you know of any that work under medium trust for ASP.NET?

Update: I know that a lot of things work in Medium trust when placed in the GAC, it acts as kind of a trust authority. However, I would prefer solutions that are bin deployable.

Answer 1

Lots of them will work (I know SQLite does) when the assemblies are stored in the GAC.

I assume you're on some form of shared hosting to experience the woes of Medium Trust. Most providers are understanding enough to add binaries to the global cache on the basis that they're third party and look fairly reputable. SQLite is well established so it shouldn't look like you're asking them to install a trojan.

Answer 2

Try VistaDB, it works in medium trust configuration, and can be deployed in the application's bin file.

It also supports ASP.Net Membership API, 100% .Net, encryption, uses SQL Server syntax, etc.