Dinamically grouping in T-SQL

Extracting, manipulating and presenting data from a SQL database could be a complicated operation, expecially if we talk about business intelligence, reports and graphics for the final users. If we couldn't use a BI tool and we need to write extraction queries manually, we could have some problem to write complex queries. Writing a query … Continue reading Dinamically grouping in T-SQL →

Local functions in C# 7

The release of C# 7 brought a lot of useful features and constructors and one of that are the local functions. Before of these, when we had to provide a functionality to a class method we had to use a private class method and than call it. This is a common approach but in some … Continue reading Local functions in C# 7 →

Javascript code refactoring with Visual Studio 17

As we have seen in the previous post, Visual Studio 2017 have introduced a lot of code refactoring tools for C# and other languages like javascript. We can customize these options as we prefer and, for some aspects, define the rules for Javascript formatting is most important than with C# because with the first one … Continue reading Javascript code refactoring with Visual Studio 17 →

C# code refactoring with Visual Studio 2017

With the release of Visual Studio 2017 and updates, code refactoring helpers of C# projects are strongly improved and the refactoring activities has become easier. The intellisense has default rules that, normally, are the most used and recommended for the developers, but fortunately we have the ability to change these settings as we prefer. We … Continue reading C# code refactoring with Visual Studio 2017 →

Logging Entity Framework SQL queries

Often, when we write complex entity framework queries we would want to check how the translated query looks like or simply we would want to monitor the efficiency of it. If we have SQL Server Management Studio, we can leverage SQL Profiler to track all the queries on a specific database: This is not very … Continue reading Logging Entity Framework SQL queries →

Configure and analyze Application Insight logs of an ASP.NET Core application

Application insight is an Azure monitoring tool that we can use to inspect the behaviours of .NET application. Based on the logs and the exceptions, it's collect and categorize the datas, that are available for analysis by the developers who want to understand what is the cause of an anomaly or simply know the healty … Continue reading Configure and analyze Application Insight logs of an ASP.NET Core application →

Exposing ML.NET features with a typed C# service

As we have seen in the previous post, in order to use ML.NET we have to configure the pipeline with all the operations that we need to do to transform our dataset and the algorithm that we want to use. In my opinion this syntax is rather verbose and of course has to be repeated … Continue reading Exposing ML.NET features with a typed C# service →

Training, prediction and evaluation with ML.NET

Train a ML.NET algorithm is the activity that we need to do when we want to prepare and algorithm to predict some values. As we'll see we have to prepare the pipeline with some operations that will be propedeutic to the training, like load the dataset, convert alphanumeric colums and so on. Now that we … Continue reading Training, prediction and evaluation with ML.NET →

Choosing an ML.NET algorithm

A tipical question when we approach a machine learning problem is: what is the algorithm that fits better in my dataset? In the previous post we have seen the possible classifications for the ML.NET algorithms and this is the first step to restrict the possible choices. Now we can make considerations about what are our … Continue reading Choosing an ML.NET algorithm →

Machine Learning algorithms tipologies in ML.NET

ML.NET is a new open source project released by Microsoft few months ago implemented for .NET applications and available as a NuGet package. Now in version 0.4 is growing rapidly but it already has a significative number of algorithms that show the power of the framework. It's a group of libraries used internally by microsoft … Continue reading Machine Learning algorithms tipologies in ML.NET →