Tag Archives: SQL

Using an EF Core database for the IdentityServer4 configuration data

December 30, 2017 · by · in .NET Core, MVC, OAuth2, Security, Web · 5 Comments

This article shows how to implement a database store for the IdentityServer4 configurations for the Client, ApiResource and IdentityResource settings using Entity Framework Core and SQLite. This could be used, if you need to create clients, or resources dynamically for the STS, or if you need to deploy the STS to multiple instances, for example […]

Import, Export ASP.NET Core localized data as CSV

July 15, 2016 · by · in .NET, ASP.NET Core, ASPNET5, dotnet · 4 Comments

This article shows how localized data can be imported and exported using Localization.SqlLocalizer. The data is exported as CSV using the Formatter defined in the WebApiContrib.Core.Formatter.Csv package. The data can be imported using a file upload. This makes it possible to export the applications localized data to a CSV format. A translation company can then […]

Creating and requesting SQL localized data in ASP.NET Core

May 26, 2016 · by · in angular, AngularJS, ASP.NET Core, ASPNET5, dotnet, MVC, SQL, SQLite, Web · 1 Comment

This article shows how localized data can be created and used in a running ASP.NET Core application without restarting. The Localization.SqlLocalizer package is used to to get and localize the data, and also to save the resources to a database. Any database which is supported by Entity Framework Core can be used. Code: https://github.com/damienbod/AngularLocalizationAspNetCore 2018-08-01: […]

SQL Localization NuGet package for ASP.NET Core

May 26, 2016 · by · in Uncategorized · 8 Comments

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. DOCUMENTATION NOW HERE: […]

ASP.NET Core using SQL Localization

January 29, 2016 · by · in .NET, ASP.NET Core, ASPNET5, dotnet, Entity Framework, MVC, SQL, SQLite, TopHeaderMenu, Web · 21 Comments

This article shows how to use SQL localization in ASP.NET Core using an SQL database. The SQL localization in the demo uses Entity Framework Core to access a SQLite database. This can be configured to use any EF core provider. Code: https://github.com/damienbod/AspNetCoreLocalization Library: https://github.com/damienbod/AspNetCoreLocalization/tree/master/src/Localization.SqlLocalizer NuGet package: https://www.nuget.org/packages/Localization.SqlLocalizer/ Documentation: http://localizationsqllocalizer.readthedocs.io/en/latest/ Posts in this series ASP.NET Core […]

Web API File Upload with MS SQL SERVER FileTable

April 8, 2014 · by · in .NET, Entity Framework, MVC, SQL, TopHeaderMenu, UI, Unity, Web · 11 Comments

This article demonstates how the setup a file upload using Web API and save it to a MS SQL Server database using a FileTable. Because a FileTable is used, the files can be saved directly to the database, without creating an extra stream. The files can be then accessed using the database or directly in […]

Getting started, using SQLite with .NET

November 14, 2013 · by · in .NET, Entity Framework, SQL, SQLite · 10 Comments

This post is a collection from docs, links, code examples which I found on various blogs, websites etc. I have included the references to all my sources. Thanks for all the cool blogs, websites and of course SQLite which made it so easy to get started with this database. UPDATE 02.03.2014: With the release of […]