Asp.net MVC set route from database table C#

Question

0.00/5 (No votes)

See more:

Currently I'm working on an asp.net mvc project. I have done an attribute routing and it's working well. The code is given below.
Now I'm thinking of keeping the Route values on a table and set it to relevant actions.

For example currently for the action TestOne I've set "Test_Test_One" as a route.
What I want to do is taking that route value from a database table and set it to the TestOne action.

Is it possible to do? Can someone help me on this? Thanks in advance.

What I have tried:

[RoutePrefix("")]
public class TestController : Controller
{

	public ActionResult Index(int page)
        {
            switch(page)
            {
                case 1: return RedirectToAction("TestOne", "Test");               
                default: return View();
            }
            
        }

	[Route("Test_Test_One")]
        public ActionResult TestOne()
        {
            return View();
        }
}

Posted 26-Nov-19 20:03pm

Krishnananthan Vijayaretnam

Updated 26-Nov-19 20:14pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2019-11-26T20:14:00

What you are looking for is to be done on the runtime, and these attributed at mapped at compile-time. You will not be able to modify them after your app has been built.

One way to solve this would be to use a dynamic route and then process the actual URI on runtime and execute the controller/action based on that.

Dynamic controller routing in ASP.NET Core 3.0 | StrathWeb. A free flowing web tech monologue.[^]

Most of the dynamic path mapping techniques would also fail since your data comes from a database. So unless your database is used to generate the code and routes in the application, these techniques would fail. You would need to use a wildcard to catch all the requests and then pass the request to the appropriate controller and action. Yep, things like RedirectToAction() would come in use here. This thread on SO talks about this approach, c# - Dynamic Routes from database for ASP.NET MVC CMS - Stack Overflow[^]

Handle requests with controllers in ASP.NET Core MVC | Microsoft Docs[^]