.NET 32-bit dev vs. 64-bit prod

Question

This question is kind of related to another question but I have a specific scenario in mind.

We do our development on 32-bit machines and deploy to a 64-bit server. The application is an ASP.NET Web Application and we use SQLite for the backend of this application. When I try to build on the remote machine I get errors from MSBuild saying it cannot find the DLL.

The web application needs to be able to launch 64-bit processes (because these processes need lots and lots of memory!)

I have seen solutions where you simply put IIS into 32-bit mode and run everything in 32-bit mode to be able to use SQLite, but does this screw me out of being able to launch a 64-bit process??

Help!!

Answer 1

Have you tried the managed version of SQLite built in .NET? That may solve your problems.

http://code.google.com/p/csharp-sqlite/

Nick

Answer 2

Yes, if you put IIS in 32bit mode you won't get 64bit processes. If you want the database to run in-process with your app, you'll need to choose a database with a 64bit provider - perhaps sql server compact edition.

Alternatively, considering your purported RAM needs it sounds like maybe what you should really do is move to a full out-of-process server-class database engine like SQL Server Express or Standard.