Nice way to store Connection strings for external databases in Secure Store SharePoint 2019

How to store credentials? It’s always a question because nobody wants to demonstrate the passwords, neither for the databases, nor for web services or anything else. SharePoint has a built-in tool to store a sensitive data – technical user accounts, databases or any data like this.  Here is how to create variables in the secure […] Read more»

February 6, 2024. Aleksei

SharePoint

Determine with C# if a user exists in the SharePoint group or in the included AD Group

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 […] Read more»

January 26, 2024. Aleksei

SharePoint

Get Groups for AD User with PowerShell or C#

In apps with different Roles and permissions you may need to get information about AD Groups. Here are some snippets which can help you with this part of the task. Read more»

January 23, 2024. Aleksei

.Net & C#

8 steps to add SVC service to SharePoint on-premises solution programmatically

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 […] Read more»

January 2, 2024. Aleksei

SharePoint

Add the application as a service at Windows Server

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 […] Read more»

September 13, 2023. Aleksei

Windows

C# method to create a UNC directory recursively and return the path

I will write down the useful method. I used it several times and it works good. It’s C# method to create a UNC directory recursively and return the path. Read more»

August 21, 2023. Aleksei

.Net & C#

Create .Net application with RabbitMQ on your local machine

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»

August 18, 2023. Aleksei

.Net & C#

Dapper with PostgreSQL and MSSQL Server

Create a console app with .Net Framework 4.7.2 with Dapper and datasource in MSSQL Server or PostgreSQL. If you create this ancient app, you should only add Dapper and NPGSQL packages from Nuget. The support of MS SQL Server is already built in. The scenario for .Net Framework is from real life, several applications still […] Read more»

May 29, 2023. Aleksei

.Net & C#

Create list item and add data to SharePoint 2019 lists via REST C#

Once I tried to make the application to migrate a custom data source from SharePoint 2010 to SharePoint 2019 on-premise. To make it easier, I decided to make to separate solutions – the first one to export the data from SharePoint 2010 from the list to JSON and attachments to local folder(CSOM for SharePoint 2010 […] Read more»

November 18, 2022. Aleksei

SharePoint

C# Convert Char to Int

Once again I decided to make a new task from LeetCode and finally my process had been stopped. I could not convert Char to Int. I even spent some time for research, but I could not find any solution. Then I open the documentation and started to read. Read more»

September 29, 2022. Aleksei

.Net & C#