static void Main(string[] args)
{
var context = new MuzicaContext();
var result = GetScensW(context);
foreach (var r in result)
{
Console.WriteLine(r);
}
Console.WriteLine();
var result2 = GetArtistsAbdAlbumes(context);
foreach (var r in result2)
{
Console.WriteLine(r.ToString());
}
Console.WriteLine();
var result3 = GetAlbumsPop(context);
foreach (var r in result3)
{
Console.WriteLine(r.ToString());
}
var result34 = GetGenuriMuzicalw(context);
Console.WriteLine(result34);
Console.ReadLine();
}
//public static IQueryable<object> GetAlbumsPop2(MuzicaContext muzicaContext)
//{
// var result = from c in muzicaContext.GenuriMuzicale.Include("Album")
// where c.Nume == "pop"
// select new { Album = c.Albume.Num , Pret = c.Pret, Gen = c.GenMuzical.Nume };
// return result;
//}
public static object GetGenuriMuzicalw(MuzicaContext muzicaContext)
{
var result = from c in muzicaContext.Albume.Include("GenMuzical")
group c by c.GenMuzical into g
select new { GenMuzical = g.Key, Numar = g.Sum(c => c.Numar) };
return(result.OrderByDescending(c => c.Numar).FirstOrDefault());
}
public static IQueryable <object> GetAlbumsPop(MuzicaContext muzicaContext)
{
var result = from c in muzicaContext.Albume.Include("GenMuzical")
where c.GenMuzical.Nume == "pop"
select new { Album = c.NumeAlbum, Pret = c.Pret, Gen = c.GenMuzical.Nume };
return(result);
}
public static IEnumerable <string> GetScensW(MuzicaContext muzicaContext)
{
var result = from c in muzicaContext.Artisti
where c.NumeScena.Length < 10
select c.NumeScena;
return(result);
}
public static IQueryable <object> GetArtistsAbdAlbumes(MuzicaContext muzicaContext)
{
var maxPrice = muzicaContext.Albume.Max(c => c.Pret);
var result = from c in muzicaContext.Albume.Include("Artisti")
where c.Pret == maxPrice
select new { Artist = c.Artist.Nume, NumeAlbum = c.NumeAlbum, Pret = c.Pret };
return(result);
}
