SQL Localization NuGet package for ASP.NET Core

I have released a simple SQL Localization NuGet package which can be used with ASP.NET Core and any database supported by Entity Framework Core. The localization can be used like the default ASP.NET Core localization.

I would be grateful for feedback, new feature requests, pull requests, or ways of improving this package.




  • Supports any EFCore persistence
  • Import, export
  • Cache, reset cache
  • support for live update
  • Configurable keys for localization records
  • Default key display possible, if no localization available
  • KISS

NuGet | Issues | Code





Basic Usage ASP.NET Core

Add the NuGet package to the project.json file

"dependencies": {
        "Localization.SqlLocalizer": "1.0.10",

Add the DbContext and use the AddSqlLocalization extension method to add the SQL Localization package.

public void ConfigureServices(IServiceCollection services)
	// init database for localization
	var sqlConnectionString = Configuration["DbStringLocalizer:ConnectionString"];

	services.AddDbContext<LocalizationModelContext>(options =>
			b => b.MigrationsAssembly("Angular2LocalizationAspNetCore")

	// Requires that LocalizationModelContext is defined
	services.AddSqlLocalization(options => options.UseTypeFullNames = true);

Create your database

dotnet ef migrations add Localization --context LocalizationModelContext

dotnet ef database update Localization --context LocalizationModelContext

And now it can be used like the default localization.
See Microsoft ASP.NET Core Documentation for Globalization and localization

Add the standard localization configuration to your Startup ConfigureServices method:

	options =>
			var supportedCultures = new List<CultureInfo>
				new CultureInfo("en-US"),
				new CultureInfo("de-CH"),
				new CultureInfo("fr-CH"),
				new CultureInfo("it-CH")

			options.DefaultRequestCulture = new RequestCulture(culture: "en-US", uiCulture: "en-US");
			options.SupportedCultures = supportedCultures;
			options.SupportedUICultures = supportedCultures;

And also in the configure method:

var locOptions = app.ApplicationServices.GetService<IOptions<RequestLocalizationOptions>>();

Use like the standard localization.

using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Localization;

namespace AspNet5Localization.Controllers
    public class AboutController : Controller
        private readonly IStringLocalizer<SharedResource> _localizer;
        private readonly IStringLocalizer<AboutController> _aboutLocalizerizer;

        public AboutController(IStringLocalizer<SharedResource> localizer, IStringLocalizer<AboutController> aboutLocalizerizer)
            _localizer = localizer;
            _aboutLocalizerizer = aboutLocalizerizer;

        public string Get()
            // _localizer["Name"] 
            return _aboutLocalizerizer["AboutTitle"];

Release History

Version 1.0.10

  • Support for automaically added undefined resources as ong as the culture is supported
  • Support for net461

Version 1.0.6

  • return default key if localization cannot be found support


var useTypeFullNames = true;
var useOnlyPropertyNames = false;
var returnOnlyKeyIfNotFound = true;

services.AddSqlLocalization(options => options.UseSettings(

Version 1.0.5

  • bugfix context System.InvalidOperationException import, export

Version 1.0.4

  • Updated to .NET Core 1.1
  • changed the constraint to included the resourceKey for new records

Version 1.0.3

  • adding import, export interfaces

Version 1.0.2

  • Updated to dotnet RTM

Version 1.0.1

  • Added Unique constraint for key, culture
  • Fixed type full name cache bug

Version 1.0.0

  • Initial release
  • Runtime localization updates
  • Cache support, reset cache
  • ASP.NET DI support
  • Supports any Entity Framework Core database


Microsoft ASP.NET Core Documentation for Globalization and localization


  1. Shahzad Hassan · · Reply

    Thanks Damien for releasing that. Just wondering if DataAnnotationsLocalization will work using the SqlLocalization. Can you please share any examples of that. I couldn’t get it to work by following your earlier post before the RC2 was released.

    If I use the ErrorMessageResourseName and ErrorMessaResourseType properties of DataAnnotations it doesn’t look up for the resource in the database. Any ideas?

    1. Hi Shahzad, thanks

      I’ll create an example tomorrow.

      Greetings Damien

    2. Thanks for pointing this out, I fixed this bug. The Data Annotations on the Box class now work.


      1. Shahzad Hassan · ·

        Thanks Damien. I will give it a go and will let you know.

  2. Hi Damien, have been looking over your dotnet core repos with A2 and was going to jump to this one to use however I cannot get this running under vs2017 is there a vs2015 version per chance?

    1. Hi Peter

      Only VS2015 version at present. VS2017 tooling is not stable at present and the EF migrations don’t work yet, so I am waiting for a VS2017 update which fixes this and will migration the project then.


      Greetings Damien

  3. Hello –
    How shound be format for the ResourceKey field for use inside View (injecting IViewLocalizer) ? I try for example: Views.Home.Index .. not works


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: