ArseniySavin

// Adding dll config for reference assembly into build folder. add this list into csproj file your library assembly.
<ItemGroup> 
    <Content Include="app.config"> 
      <Link>$(TargetName).dll.config</Link> 
      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> 
    </Content> 
  </ItemGroup> 

ArseniySavin

public static T Deserialize<T>(string xmlPath)
        {
            try
            {
                using (FileStream fileReader = new FileStream(xmlPath, FileMode.Open, FileAccess.Read))
                {

                    T result = (T)new XmlSerializer(typeof(T)).Deserialize(fileReader);

                    fileReader.Close();

ArseniySavin

class Program
    {
        static void Main(string[] args)
        {

            string val1 = "Savin Arseni".ToUpper();
            string val2 = "Arseniy Savin".ToUpper();

            int res = GetLevensteinDistance(val1, val2);

ArseniySavin

class Program
    {
        static void Main(string[] args)
        {
            List<string> dict = new List<string>
            {
                "Кодилак".ToUpper(),
                "Кодла".ToUpper(),
                "Колода".ToUpper(),
                "Изуируд".ToUpper(),

ArseniySavin

// Get SOAP current request
OperationContext.Curent.RequestContext.RequestMessage.ToString();

    public class WcfHelper : IDisposable
    {
        private static WcfHelper wcf = new WcfHelper();
        private static Dictionary<Type, ChannelFactory> factories = new Dictionary<Type, ChannelFactory>();
        private static readonly object syncObject = new object();

        public static WcfHelper Wcf

ArseniySavin

class Program
    {
        static void Main(string[] args)
        {

            RootMenu rootMenu = new RootMenu();

            CategoryMenu category1 = new CategoryMenu { CategoryId = 1, Name = "telecom", Alias = "telecom-internet" };

            category1.Add(new Service { ServiceId = 1, Alias = "mobile-altel", Name = "Altel", RegionName = "ALM" });

ArseniySavin

{
    "RouteInfo": {
        "InstanceId": "GUID",
        "ParentInstanceId": "GUID",
        "RouteType": "String",
        "RouteCode": "String"
    },
    "Correlation": [ // Какието ID запесей в очереди базы, которые нужно ожидать пока они исполнятся 
        {
            "Id": "1",

ArseniySavin

<!--
  Path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config
  Description: The setting calculate using this article https://docs.microsoft.com/en-us/previous-versions/msp-n-p/ff647813(v=pandp.10)
             The values set out of youre hardware.
             Example for hardware: CPU 4 Core, RAM 8 Gb
 -->
<system.web>
    <!--<processModel autoConfig="true" />-->
    <processModel autoConfig="False" maxWorkerThreads="1000" maxIoThreads="1000" minWorkerThreads="1000" minIoThreads="1000" />
    <httpRuntime appRequestQueueLimit="50000" minFreeThreads="999" minLocalRequestFreeThreads="999"/>

ArseniySavin

set nocount on
declare @name varchar(128), @substr nvarchar(4000), @column varchar(128)
set @substr = '%%' --фрагмент строки, который будем искать

create table #rslt 
(table_name varchar(128), field_name varchar(128), value ntext)

declare s cursor for select table_name as table_name from information_schema.tables where table_type = 'BASE TABLE' order by table_name
open s
fetch next from s into @name

ArseniySavin

SELECT TOP 10 substring(t.TEXT, qs.statement_start_offset / 2, CASE 
			WHEN qs.statement_end_offset = - 1
				THEN len(t.TEXT)
			ELSE (qs.statement_end_offset - qs.statement_start_offset) / 2
			END)
	,qs.execution_count
	,cast(qs.total_worker_time / 1000 AS DECIMAL(18, 2)) AS total_worker_time_ms
	,cast(qs.total_worker_time * 1. / qs.execution_count / 1000. AS DECIMAL(18, 2)) AS avg_worker_time_ms
	,cast(p.query_plan AS XML) AS query_plan
FROM sys.dm_exec_query_stats qs