I'm trying to see which route is best. Having a Business Logic Layer or have all the logic as stored procedures in the database.
The application architecture looks like this: Data Access Layer (LINQ to SQL) -> Business Logic Layer (Needed?) -> UI Layer (Web).
Does it make sense to have the middle layer if everything is done via stored procedures? If not, what do you recommend for the BLL? Could you advice on both routes? Advantages and disadvantages? Kindly note that the application is married to the database (Sql Server 2005) so there is no need to take into concideration that the dbms will change in the future.
LeafView 3.6.5 by Razvan Serea
LeafView is a fast, open-source image viewer built with Electron. It offers a sleek, minimal UI for fast and efficient image browsing. Supporting various formats, LeafView ensures a smooth viewing experience with essential features like zoom, rotation, and slideshow mode. Designed for simplicity and performance, it utilizes hardware acceleration for smooth rendering and supports touch gestures for seamless navigation. LeafView key features: Lightweight & Open-Source – Minimal resource usage with a clean, efficient design
Electron-Based – Cross-platform compatibility with modern UI
Multiple Image Format Support – Opens JPG, PNG, GIF, BMP, and more
Smooth Rendering – Hardware acceleration for fast performance
Essential Image Controls – Zoom, rotate, and slideshow mode
Touch Gesture Support – Seamless navigation on compatible devices
Minimal UI – Focused on simplicity and ease of use
LeafView 3.6.5 changelog: Update electron to v36.5.0
Download: LeafView 3.6.5 | Portable | ~100.0 MB (Open Source)
View: LeafView Website | Other operating systems | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
Question
Bazenga
Hello,
I'm trying to see which route is best. Having a Business Logic Layer or have all the logic as stored procedures in the database.
The application architecture looks like this: Data Access Layer (LINQ to SQL) -> Business Logic Layer (Needed?) -> UI Layer (Web).
Does it make sense to have the middle layer if everything is done via stored procedures? If not, what do you recommend for the BLL? Could you advice on both routes? Advantages and disadvantages? Kindly note that the application is married to the database (Sql Server 2005) so there is no need to take into concideration that the dbms will change in the future.
Thanks.
Link to comment
https://www.neowin.net/forum/topic/868664-aspnet-design-business-logic-layer-or-stored-procedures/Share on other sites
14 answers to this question
Recommended Posts