public void BulkMerge(List <Stock> stockList)
{
var stockListModel = stockList.ConvertAll(a => new StockModel(a));
using (var connection = new System.Data.SqlClient.SqlConnection(connectionString))
{
connection.Open();
connection.BulkMerge(stockListModel);
connection.Close();
}
}