title: Parsing a big CSV file C# .net 4
body: <p>I know this question has been asked before, but I can't seem to get it working with the answers I've read. I've got a CSV file ~ 1.2GB , If I'm running the process like a 32bit i get outOfMemoryException, it works if i run it as a 64bit process, but it still takes 3,4gb in memory, i do know that I'm storing a lot of data in my customData class, but still 3,4gb of ram?, Am I doing something wrong when reading the file?
  dict is a dictionary in which i just have a mapping to which property to save something in, depending on the column it's in. Am i doing the reading the right way?</p>
  
  <pre><code>StreamReader reader = new StreamReader(File.OpenRead(path));
  while(!reader.EndOfStream)  {
              String line = reader.ReadLine();
              String[] values = line.Split(';');
              CustomData data = new CustomData();
              string value;
              for (int i = 0; i &lt; values.Length; i++) {
                  dict.TryGetValue(i, out value);
                  Type targetType = data.GetType();
                  PropertyInfo prop = targetType.GetProperty(value);
                  if(values[i]==null)
                  {
                      prop.SetValue(data, "NULL",null);
                  }
                  else
                  {
                      prop.SetValue(data, values[i], null);
                  }
  
              }
              dataList.Add(data);
          }
  </code></pre>