title: ASP.NET MVC Database access
body: <p>I've been trying to use a preexisting database in my ASP.NET MVC project. I create a "Data Connection" to my (Microsoft SQL)Database (".\SQLEXPRESS.Databases"), which has the table "Test". This table has two columns, "ID (int)" and "name (nvarchar(MAX))".</p>
  
  <p>In the "Models" folder I put this new class:</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Web;
  
  using System.Data.Entity;
  
  namespace MvcMovie.Models
  {
      public class Test
      {
          public int ID { get; set; }
          public string name { get; set; }
      }
  }
  </code></pre>
  
  <p>Then (in "Controllers") I have a new Controller, "HelloWorldController". In this I have this function:</p>
  
  <pre><code>    public ActionResult Index()
      {
          DataSet data;
          DataTable table;
  
          using (SqlConnection connection = new SqlConnection(connectionString))
          {
              connection.Open();
  
              SqlCommand select = new SqlCommand("SELECT * FROM Test", connection);
  
              SqlDataAdapter adapter = new SqlDataAdapter();
              adapter.SelectCommand = select;
  
              data = new DataSet();
              adapter.Fill(data, "Test");
  
              table = data.Tables[0]; //is the [0] really correct?
          }
  
          return View(/* HOW DO I GET THE TABLE TO THE VIEW? */);
      }
  </code></pre>
  
  <p>Now I would like to display the rows of the table in my "Index.cshtml" file (in "Views"). How do I get the table from the Controller to the view? What I found was with "@model" and "IEnumerable", but that does not work, since I cannot convert my table.</p>
  
  <pre><code>@model IEnumerable&lt;MyProject.Models.Test&gt;
  
  @{
      ViewBag.Title = "Index";
  }
  
  &lt;h2&gt;Index&lt;/h2&gt;
  
  @foreach (var item in Model) {
      &lt;p&gt;blaaaah&lt;/p&gt;
  }
  </code></pre>
  
  <p>Now there are three questions: <br>
  1. Am I doing something completely wrong? (Method of DB-Access,..) <br>
  2. Is there an easier way to do this? (Without all adapter,.. stuff) <br>
  3. If !1&amp;&amp;!2, How do I get it to work? (Get the view file to "know" my table)</p>
  
  <p>Thanks for help, <br>
  Regards, <br>
  Caba</p>