Database localization url routes with mvc 2?

Hi. I been looking for hours on the web to find a good tutorial where I can do a database localization with mvc 2, I can't find any its all resource files. So I'm trying to reach out to you guys and see if you got any links, books or suggestions on this topic? I would love for it to be url routes based localization but that I can figure out somehow i think. Thanks

Re: Database localization url routes with mvc 2?

See this:

http://forums.asp.net/t/1641542.aspx

Re: Database localization url routes with mvc 2?

Thanks Raduenuca, but this was not really what im looking for, for the moment i think i got the url routing problem done with /en-US/Site.. What seem impossible to find is the database tutorial. Why is there not a mvc/omr example of this out? its a pretty common task people would use and from what i seen a lot is wondering about it.

Re: Database localization url routes with mvc 2?

If you look for examples using databases and EF with mvc there are a lot, but this has nothing to do with the localization problem. Localization is done with the help of resource files. Please specify better the features of the example you need(just list all features).

Re: Database localization url routes with mvc 2?

Hi Franesco. Like i described in my first post I'm looking for a way to handle localization through a database and not resource files, i know it can be done i seen it but there are no good examples of it that i can find. So im looking for - Database localization for a asp.net mvc 2 project - entity framework 4 or nhibernate as OMR

Re: Database localization url routes with mvc 2?

If you want to use database for localization, just use anything (EF, plain old ADO.NET, nHibernate etc) that you would use to query database based on what incoming culture information you got from the client.

Am I missing something here?

Re: Database localization url routes with mvc 2?

Hi sachingusain I get that but how do you go about making it work so the localization gets the info from the database and use it, instead of the resource file? thats where the problem is.

I got no problems no problem with handling EF or Nhibernate but that has nothing to do with this matter except that is what I would like to use for it. It is how to kinda connect the resource database to the localization part that is the problem. There are a lot of tutorials on how to use resource files but no good one with database. so that is what Im looking for..

Re: Database localization url routes with mvc 2?

Refer to this post from Scott: http://weblogs.asp.net/scottgu/archive/2006/05/30/ASP.NET-2.0-Localization-_2800_Video_2C00_-Whitepaper_2C00_-and-Database-Provider-Support_2900_.aspx

Within that you can see: "Jeff Modzel recently published an article that shows how to build a custom Resource Provider that stores the resource strings in a database instead."

Refer that article and you can go from there. Note that even if the article would say ASP.NET, I am sure this can be done in MVC too without constraints (with some tweaking, ofcourse).

You can also refer to "Extending the ASP.NET 2.0 Resource-Provider Model" article here: http://msdn.microsoft.com/en-us/library/aa905797.aspx

Again, it might refer to ASP.NET but you can do it in MVC too.

Re: Database localization url routes with mvc 2?

I think @sachingusain gave you the solution. I add just that localization is not specific to either Asp.net, Mvc or windows form but is a general .Net concept, so any example dealing with localization with db is ok. The only peculiarity of MVC that, however is common also to Web Forms, is that you can set the currentUICulture simply by setting it in globalization section of the configuration file a fixed culture or "auto" in which case MVC or web froms will do culture autodetection based on information sent by the browser. Autodetection is a good starting point, then you can redirect the user to a culure specific url that set always the same culture. Obviously it is convenient to give also the opportunity to change culture manually.

Don't forget also of globalization of date and numbers....To handle them properly in client validation there is some job to be done...it is not automatic.

Re: Database localization url routes with mvc 2?

Thanks for the links. I found that the other day looking but I thought it was a bit complicated (or maybe I made it complicated?). Anyway I'll try this out today but if anybody got sample code they would love to share that would be awesome and welcome.

Thanks agin this place rocks

Re: Database localization url routes with mvc 2?

Wrong post, delete pls.