public void TestRepository()
        {
            var target = new SwedbankRepository();
            var actual = target.RetrieveEntities().ToList();

            Assert.AreEqual(true, actual.Any());

            var first = actual.First();

            Assert.AreEqual(EntityType.Branch, first.EntityType);
        }
        public void Export_Test()
        {
            var target = new SwedbankRepository();
            var list = target.RetrieveEntities().ToList();

            foreach (var entity in list)
            {
                Console.WriteLine(
                    @"
            INSERT INTO [dbo].[Entity]
               ([Id]
               ,[Title]
               ,[Address]
               ,[City]
               ,[Country]
               ,[Latitude]
               ,[Longitude]
               ,[Description]
               ,[Branch]
               ,[CashOut]
               ,[CashIn]
               ,[Chain]
               ,[Icon]
               ,[IconSmall]
               ,[IconMap])
             VALUES
               ('" + entity.Id.ToString() + @"'
               ,N'" + entity.Title + @"'
               ,N'" + entity.Address + @"'
               ,N'" + entity.City + @"'
               ,N'" + entity.Country + @"'
               ," + entity.Latitude + @"
               ," + entity.Longitude + @"
               ,N'" + entity.Description + @"'
               ,'" + (entity.EntityType == EntityType.Branch ? "True" : "False") + @"'
               ,'" + ((entity.CashDirection & CashDirection.Out) == CashDirection.Out ? "True" : "False") + @"'
               ,'" + ((entity.CashDirection & CashDirection.In) == CashDirection.In ? "True" : "False") + @"'
               ,'" + entity.ChainCode + @"'" + @"
               ,'https://public.sn2.livefilestore.com/y1pKOlQfZIviShgTJZQ1WsivFhOqlRtgVgP1sMNRnzRKTYi6vV1bK17nubHaLCpv9QEJDTYhvnQxyr1aJyhS-EyUQ/swedbank-details.png'
               ,'https://public.sn2.livefilestore.com/y1pKOlQfZIviSiKIebSOvBNvwrHsTYGlpd7IPRKkiGkFxsVKgJZo96K-sjLFhlyh031vNYZpR5ZedUvgH5WM4yTbQ/swedbank-list.png'
               ,'https://public.sn2.livefilestore.com/y1pDfD1fyeUX4qqF2S1W3MQfST3Jnz-sHNCXrC08CE10RahJS1DzYQweIbokavH3CkPyBwsFo-hs2ZV8LZoqjp4bw/swedbank-map.png')");
            }
        }