Routes with multiple arguments in ASP.NET MVC 3

Question

I am trying to set up dynamic routes in an MVC app, and I have this so far...

string conString = "YATAYATAYATA";

        SqlConnection con = new SqlConnection(conString);
        SqlCommand cmd = new SqlCommand();

        // Retrieve routes from database
        cmd.CommandText = "SELECT R.*,S.* FROM Routes R INNER JOIN Sites S ON S.ID = R.SiteID WHERE S.ID = 1";
        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;

        con.Open();

        SqlDataReader rdr = cmd.ExecuteReader();

        while (rdr.Read())
        {
            routes.MapRoute(
            rdr["name"].ToString(),             // Route name
            rdr["url"].ToString(),   // URL with parameters
                new
                {
                    controller = rdr["controller"].ToString(),  // Controller name
                    action = rdr["action"].ToString(),          // Action name
                    id = UrlParameter.Optional                 // Parameter defaults
                } 
            );
        }

And that is working great for now, the only issue I am having is that I would like to have the ability to specify a comma delimited list of optional arguments in the database that I could pull out like...

Array optParams = rdr["parametersOpt"].ToString().Split(',');

But I was not sure how to stick those params into the route object properly. Could just be a minor C# syntax I am not familiar with.

Oops...I guess I forgot to do that...Thanks! I am clearly a noob... — jcreamer898
– jcreamer898, Commented Jan 19, 2011 at 16:30

quentin-starin · Accepted Answer · 2011-01-19 21:32:01Z

1

I very well may be wrong, but I believe you can use IDictionary<string, object> for the 3rd parameter to MapRoute instead of an anonymous object (MSDN documentation is unusually sparse for MVC).

I tried to whip up a test proj quick and it seems to work.

Here's what your code would look like if you tried to use a dictionary (again, I'm not certain this will work):

        while (rdr.Read()) {
            var defaults = new Dictionary<string, object>() {
                                                                {"controller", rdr["controller"].ToString()},
                                                                {"action", rdr["action"].ToString()},
                                                                {"id", UrlParameter.Optional}
                                                            };
            foreach (var param in rdr["parametersOpt"].ToString().Split(',')) {
                defaults.Add(param, UrlParameter.Optional);
            }

            routes.MapRoute(
                rdr["name"].ToString(),             // Route name
                rdr["url"].ToString(),   // URL with parameters
                defaults
            );
        }

edited Jan 19, 2011 at 21:32

answered Jan 19, 2011 at 18:58

quentin-starin

26.9k7 gold badges70 silver badges87 bronze badges

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

3 Comments

jcreamer898 Over a year ago

Would you mind a quick sample of what you used? That would be great!

quentin-starin Over a year ago

edited my answer. I'm still not totally certain a dictionary can be used in place of the anonymous object. If it can, this should work .. if I understand what you're doing with the parameters correctly.

quentin-starin Over a year ago

I had one typo - mistakenly quoted the param variable. I've fixed it in my answer.

jcreamer898 · Accepted Answer · 2011-01-19 21:40:06Z

Thanks to @qstarin I was pointed in the right thought process...

After much trouble and hardship...

while (rdr.Read())
        {
            Route invRoute = new Route(rdr["url"].ToString(), new MvcRouteHandler());

            RouteValueDictionary defaults = new RouteValueDictionary();
            defaults.Add("controller", rdr["controller"].ToString());
            defaults.Add("action", rdr["action"].ToString());

            Array arrParams = rdr["parametersOpt"].ToString().Split(',');

            foreach (string i in arrParams)
            {
                defaults.Add(i, UrlParameter.Optional);
            }

            invRoute.Defaults = defaults;

            routes.Add(rdr["name"].ToString(), invRoute);
        }

This was my solution...

Collectives™ on Stack Overflow

Routes with multiple arguments in ASP.NET MVC 3

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related