public static void Main()
{
dynamic result = null;
/* comment using-statement while scaffolding */
using (var db = new chinookContext())
{
var query =
from a in db.Album
join ar in db.Artist on a.ArtistId equals ar.ArtistId
where ar.Name.StartsWith("A")
select new
{
album = a.Title,
artist = ar.Name,
tracks = string.Join(", ", a.Track.Select(t => t.Name).Take(3))
};
result = JsonConvert.SerializeObject(query.Take(5).ToList(), Formatting.Indented);
}
/* comment-end */
Console.WriteLine(result);
}
public PlaylistTracksController(chinookContext context)
{
_context = context;
}
public IQueryable <Customers> GetCustomers([Service] chinookContext context)
{
return(context.Customers);
}
public UnitofWork(chinookContext dbContext)
{
Genres = new GenreRepository(dbContext);
}
public AlbumsController(chinookContext context)
{
_context = context;
}
public MediaTypesController(chinookContext context)
{
_context = context;
}
public InvoiceItemsController(chinookContext context)
{
_context = context;
}
public CustomersController(chinookContext context)
{
_context = context;
}
public EmployeesController(chinookContext context)
{
_context = context;
}
public TracksController(chinookContext context)
{
_context = context;
}
public ArtistsController(chinookContext context)
{
_context = context;
}
public GenresController(chinookContext context)
{
_context = context;
}
