Print Page | Close Window

Azure and business logic

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=3205
Printed Date: 29-Apr-2025 at 6:05pm


Topic: Azure and business logic
Posted By: smi-mark
Subject: Azure and business logic
Date Posted: 10-Jan-2012 at 5:36am
We would like to try one of our products on SQL Azure as a proof of concept, and I noticed that SQL Azure does not support managed CLR procedures.

We started writing our calculation logic in DevForce, but then our SSRS reports can't take advantage of it (Unless there is a solution for this?) So recently we have been writing some of our business logic in managed procedures so that it can be used by reports and apps.

Is the only real option to keep all the calculation logic in T-SQL procedures? What do some of your other customers do?


Replies:
Posted By: ting
Date Posted: 10-Jan-2012 at 4:00pm
Hi Mark,

If you're sticking with SQL Server Reporting Services, I'm not sure there are any great options. This forum thread had a link on how to get SSRS to report off of a .NET object model, but I don't know how feasible it is:
http://www.ideablade.com/forum/forum_posts.asp?TID=1677 - http://www.ideablade.com/forum/forum_posts.asp?TID=1677

The alternative is to use a reporting engine that can report off of a .NET object model, but then you may lose whatever feature in SSRS that was of interest.

Ting


Print Page | Close Window