ArseniySavin

using Dapper;
using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;

public class OracleDynamicParameters : Dapper.SqlMapper.IDynamicParameters {
	private static Dictionary<SqlMapper.Identity, Action<IDbCommand, object>> paramReaderCache = new Dictionary<SqlMapper.Identity, Action<IDbCommand, object>>( );

ArseniySavin

  public static string TruncateString(this string value, int maxLength)
  {
      int valueLength = value.Length;
      const string CHARACTER_REPLACE = "...";
      int startPosition              = (maxLength / 3);

      if(valueLength > maxLength)
      {
          try
          {

ArseniySavin

public static class ConditionalExtensions
    {
        /// <summary>
        /// Unification ternary operation
        /// </summary>
        /// <typeparam name="T">in type</typeparam>
        /// <typeparam name="V">out type</typeparam>
        /// <param name="baseObject">this object</param>
        /// <param name="exp">boolean expression</param>
        /// <param name="firstValue">true value</param>

ArseniySavin

var phone = "+77771112233"
var record = GetRecordById(Id);

new RulePrototypeConcrete()
                        .With(new ChangePhoneRule(phone))
                        .With(new DeletePhoneRule(phone))
                        .With(new ExistsPhoneRule(phone))
                        .Execute(record);

public abstract class RulePrototype : IDisposable

ArseniySavin

/* Config setting
<configuration>
  <system.diagnostics>
    <sources>
      <source name="System.ServiceModel.MessageLogging">
        <listeners>
          <add name="xml" />
        </listeners>
      </source>
    </sources>

ArseniySavin

SELECT 
	j.name AS job_name
	,ja.start_execution_date
	,ISNULL(last_executed_step_id, 0) + 1 AS current_executed_step_id
	,js.step_name
	,ja.session_id
	,js.command
	,js.last_run_duration
	,ja.job_id
FROM msdb.dbo.sysjobactivity ja

ArseniySavin

SELECT cast(TextData AS XML)
	,DatabaseName
	,TransactionID
	,HostName
	,ApplicationName
	,LoginName
	,SPID
	,Duration
	,StartTime
	,EndTime

ArseniySavin

#region MEF dll example 
namespace MEF
{
    public interface ICore
    {
        String PerformOperations(string data, string command);

        string Operation(string data, IOperation oper);
    }

ArseniySavin

/// <summary>
    /// Format placeholder in string
    /// </summary>
    public static class StringExtension
    {
        public static string FormatPlaceholder(this string inString, params string[] param)
        {
            int placeholderCounter = 0;
            string[] placeholder = new string[param.Length];

ArseniySavin

class Program
    {
        static void Main(string[] args)
        {
            using (var log = new LogScope())
            {
              try
              {
                var tM = new TestModel
                {