Just wondering about something

[NewsBot]

I'm just wondering about something and so I figured the best place to ask was channel9. (yeah i know ambitious of me).

 

Can anyone give me a solid well thought out reason for keeping 90% or more (or even any) of your business logic in SQL sprocs? I've moved into a new position at a new company and the application I am working on uses sprocs to handle most of its logic. I'm trying to find a reason as to why this might be beneficial vs some other more OO technique.

 

Please keep in mind that:

****** this is SQL 2000

****** this is an ASP.Net 2.0 app

****** this is IIS 6.0

 

Upgrading is not an option at this point, but I am trying to make an argument for MVC and Linq2SQL with a better Data Model.

 

Thanks in advance

 

More...

 

View All Our Microsoft Related Feeds