Transform text UPPERCASE or lowercase is a very common task for a developer. And when the text is not in the required case, you obviously don't want to type it one more time. Luckily, there are the developers of Visual Studio who already thought about it.
(read more...)
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.
(read more...)
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?
(read more...)
Class to determine if a user is in the SharePoint group or is in the AD Group, which is added to the SharePoint group. So, the admin access to a custom SharePoint module is that everybody, who exists in the admin group, has more data. The admin group is a SharePoint group, which contains SPUsers (from domain) and Domain groups, which contain AD Users. Actual for SharePoint 2016, 2019.
(read more...)When you make a SharePoint 2019 on-premises solution, you can make not only SPFX solutions, but also old-school WSP-solutions. It allows you not only to use SharePoint API, but also to use your own API services. With SharePoint 2019 you can use WCF service. For example, it’s a good way when you develop an application which uses the external database. This works also for SharePoint 2013 and SharePoint 2016.
(read more...)
You can add the service with PowerShell. New-Service and Get-service are available in PowerShell 5, for 'Remove-Service' PowerShell >= 6 required. Otherwise you can use 'sc.exe DELETE MyMegaServiceApplication'. You should execute it with as an administrator. Not any application you can start a service. As a .Net developer, I usually create .Net solutions, in this case you should create application based on 'worker service' template in VS 2022 or any other IDE.
(read more...)
If you want to write an application which uses RabbitMQ, I advise you to use docker image of Rabbit. It's lightweight and can be easily executed.
(read more...)C# snippet below helps to read SQL data to List<T> generic collection without any extensions or frameworks only with SQL and LINQ.
You can get list of available NuGet packages for Visual Studio using Package Manager Console (in VS – Tools / NuGet Package Manager / Package Manager Console).
CsvHelper is a very good library for reading and writing CSV files. It’s really easy for coding and fast for work. You can install it via Nuget in Visual studio or download from the project page in GitHub https://github.com/JoshClose/CsvHelper. (read more...)
