How to store constant strings in ASP MVC .Core ?

https://stackoverflow.com/a/21465221/991058

How to prevent exposed collection to be modified by client / consumer class ?

Use Immutables such as record, ImmutableList<> from .NET Core 5.0 > or look at below example

Custom immutable class MoneyAmmount using class Immutable

Warrning: If u want to publish in your class some collection property u should use Immutable.Clone() method to prevent from casting fg ReadOnlyCollection to List by client and change real published collection objects states

How to match not a word with regular expression ?

Not match a select word
^((?!select).)*$

Fg when u want to match title in html

How to get procedure name from sql script using regular expressions ?

Plain text:

public class ProcedureNameProvider : SqlObjectNameProvider { protected override string RegExPattern => @"((?!PROCEDURE).)*[\s]+PROCEDURE(\s*)(?[^\s]+)[\s]+"; public override string GetNameFromSqlScript(string sqlObjectDefinition) { Match match = new Regex(RegExPattern, RegexOptions.IgnoreCase).Match(sqlObjectDefinition); return match.Success ? NormalizeBrackets(match.Groups["proc_name"].Value) : String.Empty; } }

How to find sql procedure definition in script file using Regular expressions ?

How to show installed .NET version from cmd line in Windows ?

How to create xUnit test project in .NET Core ?

1/ Add new ClassLibrary project in .Net Core in your solution

2/ Add references to nuget libs
Fg this version

Microsoft.NET.Test.Sdk
xunit
xunit.runner.visualstudio

3/ Create simple test

4/ Run test

How to find all comments in sql script ?

C# RegExp: /[\*]*[^\*]*\*/|--[^\n]*

MoneyAmount value object defined in C#

How to run async from main method in C#

How to read file stream as a byte array from input type=file in javascript

How to clear Reasharper in VS 2019

Clear all subdirectories contents (try not to remove subdir itself) from directory C:\Users\{your_user_data}\AppData\Local\JetBrains\Transient

How to deal with instantly growing file C:\ProgramData\Synaptic\ValidityService.log ?

A wright solution is here: https://h30434.www3.hp.com/t5/Notebook-Software-and-How-To-Questions/Why-does-synaptics-validity-service-log-constantly-grow-in/td-p/6454758

TSQL regular expresion for search email in string

How to generate c# class from table using T-SQL?

Thanks to: https://stackoverflow.com/a/46244450

How to insert pdf from file to database table column in sql server ?

How to perfeorm deep copy in memory in C# ?

How to run async method from sync context / method ?

How to create and connect with mysql client to mysql server running on docker container ?

1/ Download Docker form WIndows
https://docs.docker.com/toolbox/toolbox_install_windows/

2/Download mysql image and run mysql container
docker container run -it --detach --name mysql-server -p 3306:3306 --env MYSQL_RANDOM_ROOT_PASSWORD=yes mysql:latest

3/Configure mysql
docker container logs mysql-server
find secret random password under"GENERATED ROOT PASSWORD"


Set up access users and passwords
Ensure that there is at least one user that has configured remote connection fg '%'

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MNBVCXZ987654321';
ALTER USER 'root'@'%' IDENTIFIED BY 'MNBVCXZ987654321';
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
UPDATE mysql.user SET Host='%' WHERE Host='127.0.0.1' AND User='root';

4/Connect to mysql using MySql client

host: 127.0.0.1
port: 3306
user: root
password: (known)

Do not forget to stop IIS or at least change ip for mysql service (docker bridge)