ASP.NET C# Razor: dynamically list SQL Server table data

@{Layout = "Layout.cshtml";

var db = Database.Open("MYTESTDB"); // defined in Web.config
var query = db.Query("SELECT * FROM tStopReports");    // returns enumerator: System.Collections.Generic.IEnumerable<WebMatrix.Data.DynamicRecord>
var columnCount = @query.ElementAt(0).Columns.Count;
}
<h1>MY TEST DB: dynamic (headers + content) listing of "stop reports" table data</h1>
<table border="1">
<tr>
@for(var i = 0; i < @columnCount; i++) {
    <th>@query.ElementAt(0).Columns[@i]</th>
}
</tr>

@foreach(var row in query)
{
<tr>
@for(var i = 0; i < @columnCount; i++) {
    <td>@row[@i]</td>
}
</tr>
}
</table>