コード例 #1
0
        // Added saver of all the trades

        /// <summary>
        /// Saves to database.
        /// </summary>
        /// <param name="dbName">Name of the database.</param>
        protected override void SaveToDb(string dbName)
        {
            string connectionString = ConfigurationManager.ConnectionStrings[$"{dbName}"].ConnectionString;

            using (var connection = new SqlConnection(connectionString))
            {
                connection.Open();
                using (var transaction = connection.BeginTransaction())
                {
                    foreach (var trade in trades)
                    {
                        SaveTrade(trade, transaction, connection);
                    }

                    transaction.Commit();
                }
                connection.Close();
            }

            reporter.ShowMessage($"INFO: {trades.Count} trades processed");
        }