CODEWITHSUNDEEP
subsonicdata-access-layerazure-sql-databasetelerik-open-access
aron
aron

Reputation: 2886

SubSonic and SQL Azure

I wrote an e-commerce app and used SubSonic 2.2 to generate the Data-Access-Layer. It works perfectly with Sql Server 2005 and 2008. However I would like to add support for SQL Azure.

Does anyone know if the code generated by SubSonic 2.2 with work with SQL Azure?

Side note: If there are big issues I may scrap the 2 yrs old Data-Access-Layer and use Telerik ORM.

thanks

Upvotes: 0

Views: 198

Answers (2)

ryancrawcour
ryancrawcour

Reputation: 676

I would consider / strongly advise using something like EntityFramework which is fully supported. Other fully support ORMs include Lightspeed, nHibernate etc.

Upvotes: 0

quentin-starin
quentin-starin

Reputation: 26628

I'm not that familiar with SQL Azure, but I understand it supports T-SQL. In that case, it shouldn't be too difficult to adapt SubSonic to it.

However, changing the template files will not be enough, you will need to modify the source project and rebuild it. I say this because the SubSonic dll contains references to the various ADO.Net providers it supports (Microsoft.Practices.EnterpriseLibrary.Data, MySql.Data, System.Data.SQLite, System.Data.SqlServerCe).

Upvotes: 1

Related Questions