22.04.2019 - 26.04.2019 arası işler

C# dünyasında Async kullanımı ile ilgili makaleler Link Link Link Örnek kod Link
Async return types Link
Daha sonra neden GO lang öğrenmeliyim diyebilirsiniz Link
Singleton Pattern kullanmak Link

  public sealed class SingletonNpgsqlConnection  
   {  
     /// <summary>  
     ///   
     /// </summary>  
     public static string _connection;   
     private static readonly Lazy<NpgsqlConnection> instance = new Lazy<NpgsqlConnection>(() => new NpgsqlConnection(_connection));  
     private SingletonNpgsqlConnection() { }  
     /// <summary>  
     /// Singleton nesnesi  
     /// </summary>  
     public static NpgsqlConnection Instance { get { return instance.Value; } }  
   }  
 Kullanımı  
 SingletonNpgsqlConnection._connection = _connectionStrings.TradeView;   
 var t = SingletonNpgsqlConnection.Instance;  
 // araya sorgunuz  
  using (var c = new NpgsqlCommand("SELECT * From function(@param1, @param2)"))  
         {  
  if (t.State == ConnectionState.Closed) t.Open();  
  c.Connection = t;  
           c.Parameters.AddWithValue("@param1", NpgsqlTypes.NpgsqlDbType.Integer, d1);  
           c.Parameters.AddWithValue("@param2", NpgsqlTypes.NpgsqlDbType.Bigint, d2);  
 using (var reader = c.ExecuteReader())  
           {  
             while (reader.Read())  
             {  
               var result = new  
               {  
                 dat1= reader.GetInt64(0),  
                 dat2 = reader.GetDecimal(1).ToString($"F{symbol.DenominatorPrecision}"),  
               };  
               model.c.Add(Convert.ToDecimal(result.dat1));  
               model.h.Add(Convert.ToDecimal(result.dat2));  
             }  
           }  
 }  
 t.Close();  
 return model;