Skip to content

Instantly share code, notes, and snippets.

@trainingLeader
Forked from pazteddy/AdvancedLINQ.cs
Created September 2, 2025 00:12
Show Gist options
  • Select an option

  • Save trainingLeader/07f5cb90b30ec899b9a24d228aad4c40 to your computer and use it in GitHub Desktop.

Select an option

Save trainingLeader/07f5cb90b30ec899b9a24d228aad4c40 to your computer and use it in GitHub Desktop.
Datos para consultas avanzadas con LINQ
namespace AdvancedLinq
{
class Character
{
public int Id { get; set; }
public string? Name { get; set; }
public string? Alias { get; set; }
public string? Team { get; set; }
}
class Ability
{
public int CharacterId { get; set; }
public string? Description { get; set; }
}
class Statistic
{
public int CharacterId { get; set; }
public int Power { get; set; }
}
class Program
{
public static void AdvancedLINQ()
{
List<Character> characters =
[
new Character { Id = 1, Name = "Peter Parker", Alias = "Spider-Man", Team = "Avengers" },
new Character { Id = 2, Name = "Tony Stark", Alias = "Iron Man", Team = "Avengers" },
new Character { Id = 3, Name = "Steve Rogers", Alias = "Capitán América", Team = "Avengers" },
new Character { Id = 4, Name = "T'Challa", Alias = "Black Panther", Team = "Wakanda" },
new Character { Id = 5, Name = "Stephen Strange", Alias = "Doctor Strange", Team = "Defenders" }
];
List<Ability> abilities =
[
new Ability { CharacterId = 1, Description = "Sentido arácnido" },
new Ability { CharacterId = 1, Description = "Trepar paredes" },
new Ability { CharacterId = 2, Description = "Inteligencia y armadura de alta tecnología" },
new Ability { CharacterId = 3, Description = "Super fuerza" },
new Ability { CharacterId = 4, Description = "Reflejos aumentados" },
new Ability { CharacterId = 5, Description = "Magia y hechicería" }
];
List<Statistic> statistics =
[
new Statistic { CharacterId = 1, Power = 85 },
new Statistic { CharacterId = 2, Power = 90 },
new Statistic { CharacterId = 3, Power = 88 },
new Statistic { CharacterId = 4, Power = 80 },
new Statistic { CharacterId = 5, Power = 95 }
];
// WriteLine($"👥 Equipo: {team}");
// WriteLine("🦸‍♂️ Personajes y sus habilidades:");
// WriteLine($"⚡ Poder total de todos los personajes: {totalPower}");
// WriteLine($"🛡️ Promedio de poder de los Avengers: {avengersPower:F2}");
// WriteLine("📝 Cantidad de habilidades por personaje:");
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment