I try to find a cost free configuration for an ASP.NET MVC application.
For this, Mono is the obvious part of the solution. PostgreSQL is a database solution that I follow since few years, and after trying MySql and SQLServer express, It’s sure that it’s my favorite one. Not only because it’s free, but specially for the clarity of the documentation and the high performance of this database.
The thing is thas I really hate working with SQL commands, and since few months, I ‘m really kind of Linq technology.
Indeed, I try to set up this configuration:
mono 2.4.2.3 – mod_mono 2.4.2 – apache 2.2.11 – PostgreSQL 8.3
mono – FastCGI – lighttpd – PostgreSQL 8.3
I tried both fascgi et mod_mono, and in both cases, the configuration is not so hard and works quite well. The issue is that I really need now to be able to use linq to SQL with the postgreSQL database.
I tried with the Devart dotConnect component which pretended to be compatible Mono, and Linq.
That’s right, it creates good DataContext models (compatible with SQLServer DataContext which allow to swith really easilly from one to other). The big issue, is that does not work under Mono, as they answer to my question in their forum.
I now wait the DBLinq integration in the Mono 2.6 which was annouced for September and supporting PostgreSQL/MysqlSQL/SQLite with linq support.
Just that my boss won’t be please, because I’m really late on this point…
Not an issue, right, I ‘ve quit last monday 
