How To separate database access in .Net Core

Question

In Webforms you could use an ObjectDataSource, use methods defined in your Business Logic Layer that would get data from your Data Layer, usually a data set or EF. Then all the code accessing database would be all in one place and retrieved logically based on methods.

In .Net Core Razor, how do you organize this?

Generally speaking, you just throw it all in a class library. Much more than that I can't say as you haven't provided much information about what you're trying to do. — Chris Pratt
– Chris Pratt, Commented Mar 21, 2019 at 18:22

Richard Garside · Accepted Answer · 2019-03-21 18:34:26Z

1

.NET Core web apps generally follows the Model View Controller (MVC) pattern, but you can use 'Razor Pages' for simpler apps.

If you're using MVC then in your razor views you should just be displaying data in the model for the view. A model is typically a simple Plain Old C# Object (POCO).

The model is created and populated in the controller from any data source or service.

If you're new to MVC from web forms then this guide on .NET Core MVC should be helpful.

If your app is pretty simple then this guide on Razor Pages might be helpful.

edited Mar 21, 2019 at 18:34

answered Mar 21, 2019 at 18:14

Richard Garside

89.5k12 gold badges88 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jackal Over a year ago

I see, i don't know much about MVC yet but i have started using controllers on a razor pages template, basically just mixing stuff around when it's suitable. So I have a controller for my Car model, GetCars Action will just do the db call and populate it. Looks clean and simple

Collectives™ on Stack Overflow

How To separate database access in .Net Core

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related