For a process I had to update the Author field in SharePoint online list item. This time I decided to use PnP.Core instead of PnP.Framework. Was it worth it? I don't really know, but the method is not the most difficult part of the task.

The Azurite open-source emulator provides a free local environment for testing your Azure Blob, Queue Storage, and Table Storage applications. When you're satisfied with how your application is working locally, switch to using an Azure Storage account in the cloud. The emulator provides cross-platform support on Windows, Linux, and macOS.

Error with 'pragma_table_list' is actual not only for DBeaver, but also for any driver for SQLite. This post is about DBeaver just because I was working with it, when I met the error. The case is like this: I created an SQLIte database with Microsoft.EntityFrameworkCore and then I wanted to open it in DBeaver. But I got the error that "no such table: pragma_table_list". Started to research.

SmartFormat is a is a lightweight text templating library to replace string.Format. Unlike common String.Format, with SmartFormat you can read templates from text files or another source. Here I will share the way, how I tried to write the DateTime in the format 'dd/MM/yyyy HH:mm:ss'. It was not so obvious.

For a prototype I loaded a pfx certificate from file system of Azure App. It can be done only while test!!And I got the error "Exception Info: System.Security.Cryptography.CryptographicException: The system cannot find the file specified."

AutoMapper is a simple little library which allows you to make less code for transforming objects of one class to another. It's a must-have library for any complex project. There is a short scenario in 5 steps how to add and use AutoMapper in a new Net Core project with REST API.

There are a lot of cases when you need to get the items by the author. For me the only correct way to get the SharePoint list items by user with CAML is like this:

<Where><Eq><FieldRef Name='Author' LookupId='TRUE' /><Value Type='Integer'>123</Value></Eq></Where>

When you want to download a publish profile for the service in Azure, there can be an error, that basic authentication is disabled.

Once again I have to make Export of to Excel. And this time there are requirements to the template – colors, formatting and others. Not so long ago I implemented the export to Excel with XLSX package for React, and it was rendered at client. This solution is good but has many constraints. So, I started to look for another solution.

When you execute your Web Api and at Swagger Page you can see Swagger error ‘Failed to load API definition’, you can’t really determine, where the error is. It is in one of the controllers. But do you want to check all of them?