title: How to pass ADO.NET DataSet to a view
body: <p>I have a legacy project that we are slowly moving to MVC, but there are hundreds of ADO.NET SQL DataSet objects </p>
  
  <p>I would like to keep the data sets in the model and access it in the view. Is this possible, or is there a better way to do this? Creating lists is difficult because there is too much data. We will eventually convert the SQL to entity, but not now.</p>
  
  <p>Example:</p>
  
  <p>Model:</p>
  
  <pre><code> string query = "SELECT * FROM dbo.manf";
   SqlDataAdapter adapter = new SqlDataAdapter(query, conn);
   DataSet data = new DataSet();
   adapter.Fill(data, "manf");
  </code></pre>
  
  <p>View:</p>
  
  <pre><code>@foreach (DataRow data in manf.Tables["manf"].Rows)
  {
      @:manf["id"] + " " + manf["name"]);
  }  
  </code></pre>