<p>Consider this:</p>

<pre><code>var query = from r in this._db.Recipes
            where r.RecipesID == recipeID
            select new { r.RecipesID, r.RecipesName };
</code></pre>

<p>How would i get individual columns in my <code>query</code> object without using a for-loop?</p>

<p>Basicly: how do I translate <code>DataTable.Rows[0]["ColumnName"]</code> into Linq syntax?</p>

Sorry, misunderstood your question.  As others are saying, you can use ToList() to get a List back.  An alternative if all you need is the first one, just use:
```
```
query.First().ColumnName
```
```
or if you want to avoid an exception on empty list:
```
```
var obj = query.FirstOrDefault();
if (obj != null)
   obj.ColumnName;
```
```
Original Answer (so the comment makes sense):
Use
Linq to Datasets
.  Basically would be something like:
```
```
var query = from r in yourTable.AsEnumerable()
select r.Field<string>("ColumnName");
```
```