SecretCollect.Localization.SqlLocalizer
1.4.0
See the version list below for details.
dotnet add package SecretCollect.Localization.SqlLocalizer --version 1.4.0
NuGet\Install-Package SecretCollect.Localization.SqlLocalizer -Version 1.4.0
<PackageReference Include="SecretCollect.Localization.SqlLocalizer" Version="1.4.0" />
paket add SecretCollect.Localization.SqlLocalizer --version 1.4.0
#r "nuget: SecretCollect.Localization.SqlLocalizer, 1.4.0"
// Install SecretCollect.Localization.SqlLocalizer as a Cake Addin
#addin nuget:?package=SecretCollect.Localization.SqlLocalizer&version=1.4.0
// Install SecretCollect.Localization.SqlLocalizer as a Cake Tool
#tool nuget:?package=SecretCollect.Localization.SqlLocalizer&version=1.4.0
Localization.SqlLocalizer
Repository to enable localizations using EF & SQL in an ASP.NET Core application
How to use
In your Startup.cs, add the services by calling:
services.AddGlobalization(...);
With the optionsBuilder delegate to setup the database server.
For example:
public void ConfigureServices(IServiceCollection services)
{
services.AddGlobalization(optionsBuilder => optionsBuilder.UseSqlServer(Configuration.GetConnectionString("LocalizationDb")));
services.AddMvc()
.AddViewLocalization(LanguageViewLocationExpanderFormat.Suffix)
.AddDataAnnotationsLocalization();
}
And you need to enable requestlocalization by calling:
app.UseRequestLocalization();
In the AppSettings.json you need to specify which (non-UI) culture you wish to support, the cookie name and the cookie domain.
{
"Globalization": {
"CookieName": "Language",
"CookieDomain": "localhost",
"SupportedCultures": [
"en-US"
],
"CacheTimeInMinutes": 15
}
}
Notes on database migrations
But of course the database needs to be initialized, you thus need to call context.Database.Migrate()
. As per https://github.com/aspnet/EntityFrameworkCore/issues/9033#issuecomment-317063370 it is bad form to do this in your request pipeline code. Therefore our sample application uses an extension method to migrate the database in the Program.cs:
public class Program
{
public static void Main(string[] args)
{
CreateWebHostBuilder(args)
.Build()
.MigrateDatabase<LocalizationContext>()
.Run();
}
public static IWebHostBuilder CreateWebHostBuilder(string[] args) =>
WebHost.CreateDefaultBuilder(args)
.UseApplicationInsights()
.UseStartup<Startup>();
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- Microsoft.AspNetCore.Http (>= 2.1.1)
- Microsoft.AspNetCore.Localization (>= 2.1.1)
- Microsoft.EntityFrameworkCore.SqlServer (>= 2.1.4)
- Microsoft.Extensions.Configuration.Binder (>= 2.1.1)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 2.1.1)
- Microsoft.Extensions.Localization.Abstractions (>= 2.1.1)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
- Updated to latest SDK version
- Added a preloader to enable pre loading of localizations into memcache