DataBase.cs 1009 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
using System.Collections.Generic;
using System.Globalization;
using System.IO;

namespace Winforms.Cartesian.Linq
{
    public static class DataBase
    {
        static DataBase()
        {
            var reader = new StreamReader(File.OpenRead(@"cities.csv"));

            var read = new List<City>();

            while (!reader.EndOfStream)
            {
                var line = reader.ReadLine();
                if (line != null)
                {
                    var values = line.Split(',');

                    read.Add(new City
                    {
                        Name = values[0],
                        Population = double.Parse(values[1], CultureInfo.InvariantCulture),
                        Area = double.Parse(values[2], CultureInfo.InvariantCulture),
                        Country = values[3]
                    });
                }
            }

            Cities = read.ToArray();
        }

        public static City[] Cities { get; private set; }

    }
}