How to connect to a MySQL server with .net core

We already know that asp .net core works great with Microsoft technologies, but many times we need to work with other stuff.

Just think about the EF with SQL Server, the Identity or whatever things like these.
In my scenario,  I needed to interface the website with a MySQL database. In this case I’ve been lucky, because I’ve found the a first implementation of a connector for MySQL (info here).

However my needs, I’ve wrote a new .net standard library based on MySQLConnector that use also ORM features in a very clearly way.

You can find it here with all docs for how to use.

Pills of C#: strings

In many times people have asked me some question about strings in C#. The much quoted question is about: “What is the @ before the string?”

So, now I want try to give some pills about those strings in C#.

Just to be clear, I’m assuming that you already know a base of C# and strings operations (concats, escaping, etc.)

Continue reading “Pills of C#: strings”

Create a config file in asp .net core

With asp .net core we have another concept of website.

There is not a scripting language with an interpreter, but we have a software that is listening on a port.

This mean that, the code in Program.cs and Startup.cs files will be executed just the fist time, at program launch. In fact, the Startup.cs file contains the Startup class, that built the middleware pipeline and it will be executed at any request.

So, a big problem that we can have with a config file is this: to any request, we need to read it from the disk, and this can be very expansive with an huge number of users.

A first way to fix this is to use AddJsonFile in the Program class when you build the configuration, and to use like explained here.
However, I use another way to do this, because I prefer access data via dot notation.

Lets see the alternative way to use a config file.

Continue reading “Create a config file in asp .net core”

Change layout for authenticated users in asp net core

When we talk about MVC on asp net, we know that the views are (in default approach) parts of our web page, because we have defined a layout that contains them. But sometimes we need/want to use a different layout, one of these scenario is for example when we have a different layout for logged/not logged users.

Let’s see an example, which use the simple AuthenticationCookie from NuGet package Microsoft.AspNetCore.Authentication.Cookies.

Continue reading “Change layout for authenticated users in asp net core”