Given the following limitations:
- I will develop the BRAND NEW website.
- I will use C # and ASP.NET MVC
- Linux with mono will be fine, but windows are an acceptable limitation (please indicate if this is the case).
Now an interesting bit:
I want to get as close as possible to the 'click of a switch to change RDBMS between SQL Server / SQL Azure and PostgreSQL / Cloud based on PostgreSQL.
I want to use ORM as much as possible (ORM MUST PERFECT requires a little more than changing a parameter to switch to one of these alternative database databases).
This should include calling stored procedures in the same way with everyone.
In the interest of many, I am looking for OPTIONS with detailed limitations from experience.
- Please DO NOT give answers like "impossible" or "do not disturb".
- Please DO NOT compare ORMs in any other way than their ability to perform the above, and how much their functionality is preserved. This should NOT turn into x ORM better than ORM.
- Please DO NOT discuss the limitations of SQL Azure and dedicated hosting.
- Please do NOT discuss differences, strengths / weaknesses of SQL Server or PostgreSQL, conversion of stored procedures, etc.
- , , .