troubleshooting Question

Architectural designs and technology

Avatar of razza_b
razza_b asked on
Microsoft Development.NET Programming
5 Comments4 Solutions138 ViewsLast Modified:

I'm looking to get some feedback on the best approach to designing a new system.

Basically our company like to keep all the business logic contained within the database(stored procedures), its always been like this and needs to stay the same. So we have been asked to come up with new layered applications using the latest .NET Core with VS2017 (MVC & WPF MVVM). The reason these 2 have been mentioned is that they are the best way forward in terms of web and windows based correct me if I'm wrong.

My question is...What would be the best way to design layers around keeping business logic in DB?

Having not used any of these technologies I'm looking to find good examples of how I can approach setting up layered architecture, based on our business needs.

Could we use EF7 using stored procedures or EF using LINQ? or just use plain old without EF?

Could we still use layers like so with or without EF (Presentation Layer, Service Layer(API), Business Layer, Data Layer)? Either way any examples would be great.

And could both technologies both benefit using these layers -> Service Layer(API), Business Layer, Data Layer for reusability?

Any feedback most welcome and appreciated.

Miguel Oz
Senior Software Engineer
Join our community to see this answer!
Unlock 4 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros