title: Can I use Linq to project a new typed datarow?
body: <p>I currently have a csv file that I'm parsing with an example from here:
  <a href="http://alexreg.wordpress.com/2009/05/03/strongly-typed-csv-reader-in-c/" rel="nofollow noreferrer">http://alexreg.wordpress.com/2009/05/03/strongly-typed-csv-reader-in-c/</a></p>
  
  <p>I then want to loop the records and insert them using a typed dataset xsd to an Oracle database.</p>
  
  <p>It's not that difficult, something like:</p>
  
  <pre><code>foreach (var csvItem in csvfile)
  {
     DataSet.MYTABLEDataTable DT = new DataSet.MYTABLEDataTable();
     DataSet.MYTABLERow row = DT.NewMYTABLERow();
     row.FIELD1 = csvItem.FIELD1;
     row.FIELD2 = csvItem.FIELD2;
  }
  </code></pre>
  
  <p>I was wondering how I would do something with LINQ projection:</p>
  
  <pre><code>var test = from csvItem in csvfile
    select new MYTABLERow {
      FIELD1 = csvItem.FIELD1,
      FIELD2 = csvItem.FIELD2
  }
  </code></pre>
  
  <p>But I don't think I can create datarows like this without the use of a rowbuilder, or maybe a better constructor for the datarow?</p>