LINQ/Lambda's
var quantity = ...
var query = db.Model.Select( m => new
{
Name = m.Name,
Price = m.Price,
Cost = M.Price * quantity
} );
foreach (var q in query)
{
Console.WriteLine( q.Name );
Console.WriteLine( q.Price );
Console.WriteLine( q.Cost );
}
ASP.NET MVC -HtmlHelpers or when returning JSON
<%= Html.TextBox( "Name", Model.Name, new { @class = "required" } ) %>
public ActionResult SearchModels( var q, int limit )
{
var query = db.Models.Where( m => m.Name.StartsWith( q ) )
.Take( limit )
.Select( m => new { m.DisplayName, m.Name, m.ID } );
return Json( query.ToList() );
}
Actually, pretty much anywhere you just need a temporary container type for a short-lived action.