New Posts New Posts RSS Feed: Azure and business logic
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Azure and business logic

 Post Reply Post Reply
Author
smi-mark View Drop Down
DevForce MVP
DevForce MVP
Avatar

Joined: 24-Feb-2009
Location: Dallas, Texas
Posts: 343
Post Options Post Options   Quote smi-mark Quote  Post ReplyReply Direct Link To This Post Topic: Azure and business logic
    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?
Back to Top
ting View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 27-Mar-2009
Location: San Francisco
Posts: 427
Post Options Post Options   Quote ting Quote  Post ReplyReply Direct Link To This Post 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:

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

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down