ASP.NET MVC Database localization

Question

I'm developing an multilingual enterprise web site and I would like to store the localization in database.

I have read the following article which is very good but I personally think that is a an overhead and I can achieve the same much easy:

Extending the ASP.NET 2.0 Resource-Provider Model

I have already setup some ground but I'm not sure if my approach is fine. Basically I have created a service that is registers with DI.

public interface ILocalizedStringProvider
{
    string GetLocalizedString(string key);

    string GetLocalizedString(string key, string deafultValue);
}

Also i have created a Html helper like this

public static MvcHtmlString LocalizedString(this HtmlHelper helper, string key, string defaultValue)
    {            
        if (string.IsNullOrEmpty(defaultValue)) return new MvcHtmlString("");
        if (string.IsNullOrEmpty(key)) return new MvcHtmlString(defaultValue);

        ILocalizedStringProvider localizedStringProvider = DependencyResolver.Current.GetService<ILocalizedStringProvider>();

        if (localizedStringProvider == null)
        {
            return MvcHtmlString.Create(defaultValue);
        }

        string val = localizedStringProvider.GetLocalizedString(key, defaultValue);

        if (string.IsNullOrEmpty(val))
        {
            return MvcHtmlString.Create(defaultValue);
        }

        return MvcHtmlString.Create(val);
    }

Then the helper is simply invoked from the view.

First I want to know if this approach is good and if is not an anti-pattern.

Second my concern is this line:

ILocalizedStringProvider localizedStringProvider = DependencyResolver.Current.GetService<ILocalizedStringProvider>();

Is it maybe better to resolve the service ILocalizedStringProvider in the controller with constructor injection and let the controller populate the ViewBag with the localization's?

Thanks!

Answer 1

You can use my Griffin.MvcContrib project. It contains a ready to use MS SqlServer implementation for storing localization in the database.

Introduction: http://www.codeproject.com/Articles/352583/Localization-in-ASP-NET-MVC-with-Griffin-MvcContri

Administration

There is also an adminstration area which you can use to manage the localizations:

SQL Server setup

https://github.com/jgauffin/griffin.mvccontrib/wiki/SqlServer

Source code

The project is available at github: https://github.com/jgauffin/griffin.mvccontrib