static void Main(string[] args)
{
GameObjects _gobjs = new GameObjects();
var _playerXPDetails = _gobjs.players
.Select(p => new {
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerXP = p.XP });
foreach (var pxp in _playerXPDetails)
Console.WriteLine("Player XP is {0}",
String.Concat(pxp.Name, " ", pxp.PlayerXP.ToString()));
var playerScores = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
join g in _gobjs.games
on s.GameID equals g.GameID
select new { Game = g.GameName,
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerScore = s.score});
foreach (var item in playerScores)
Console.WriteLine("Player Score for {0}", String.Concat("Game name ", item.Game,item.Name," score ", item.PlayerScore.ToString()) );
//foreach (var game in _gobjs.games)
// Console.WriteLine("Game is {0} ", game.ToString());
//foreach (var player in _gobjs.players)
// Console.WriteLine("Player is {0}", player.ToString());
//foreach (var score in _gobjs.scores)
// Console.WriteLine("Score is {0}", score.ToString());
Console.ReadKey();
}
static void Main(string[] args)
{
GameObjects _gobjs = new GameObjects();
var _playerXPDetails = _gobjs.players
.Select(p => new {
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerXP = p.XP
});
foreach (var pxp in _playerXPDetails)
{
Console.WriteLine("Player XP is {0}",
String.Concat(pxp.Name, " ", pxp.PlayerXP.ToString()));
}
var playerScores = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
join g in _gobjs.games
on s.GameID equals g.GameID
select new { Game = g.GameName,
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerScore = s.score });
foreach (var item in playerScores)
{
Console.WriteLine("Player Score for {0}", String.Concat("Game name ", item.Game, item.Name, " score ", item.PlayerScore.ToString()));
}
//foreach (var game in _gobjs.games)
// Console.WriteLine("Game is {0} ", game.ToString());
//foreach (var player in _gobjs.players)
// Console.WriteLine("Player is {0}", player.ToString());
//foreach (var score in _gobjs.scores)
// Console.WriteLine("Score is {0}", score.ToString());
Console.ReadKey();
}
static void Main(string[] args)
{
GameObjects _gobjs = new GameObjects();
// Lab Instruction
foreach (var item in _gobjs.Collectables)
{
if (item.selected)
{
Console.WriteLine(" Selected {0} with value {1}", item.id, item.val);
}
else
{
Console.WriteLine(" Not Selected {0} with value {1}", item.id, item.val);
}
}
var selected = _gobjs.Collectables
.Where(s => s.selected == true);
foreach (var item in selected)
{
Console.WriteLine("Collected {0}", item.ToString());
}
var orderedSelected = _gobjs.Collectables
.Where(s => s.selected == false)
.OrderByDescending(s => s.val);
foreach (var item in orderedSelected)
{
Console.WriteLine("Ordered descending Collected {0}", item.ToString());
}
var _playerXPDetails = _gobjs.players
.Select(p => new {
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerXP = p.XP
});
foreach (var pxp in _playerXPDetails)
{
Console.WriteLine("Player XP is {0}",
String.Concat(pxp.Name, " ", pxp.PlayerXP.ToString()));
}
var playerScores = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
join g in _gobjs.games
on s.GameID equals g.GameID
select new { Game = g.GameName,
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerScore = s.score }).
OrderByDescending(o => o.PlayerScore);
foreach (var item in playerScores)
{
Console.WriteLine("Player Score for {0} ", String.Concat("Game name ", item.Game, " ", item.Name, " score ", item.PlayerScore.ToString()));
}
// Exercises
#region EX 1
// Select all scores greater than 500.
var greaterThan500 = playerScores.Where(f => f.PlayerScore > 500);
// Display
foreach (var player in greaterThan500)
{
Console.WriteLine("\nABOVE 500: {0} with a score of {1}", player.Name, player.PlayerScore);
}
#endregion
#region EX 2
// Select all XP values greater than 250.
var XPgreaterThan200 = _playerXPDetails.Where(f => f.PlayerXP > 250);
// Display
foreach (var XPplayer in XPgreaterThan200)
{
Console.WriteLine("\nABOVE 250 XP: {0} with an XP value of {1}", XPplayer.Name, XPplayer.PlayerXP);
}
#endregion
#region EX 3 Attempt.
//var selectedPlayer = _gobjs.players.Where(
// p => p.GamerTag == "Twinny"
// );
//foreach (var sp in selectedPlayer)
//{
// Console.WriteLine("{0} Found", sp.GamerTag);
//}
#endregion
#region EX 3 Corrected. (& EX 4).
// Find Twinny. FirstOrDefault is used instead of Where when you know what you are looking for is unique.
Player twinny = _gobjs.players.FirstOrDefault(p => p.GamerTag == "Twinny");
// Display
if (twinny != null)
{
Console.WriteLine("\n{0} found", twinny.ToString());
}
// Exercise 4: Get Twinny's scores.
var twinnyScores = _gobjs.scores.Where(s => s.PlayerID == twinny.playerId);
foreach (var item in twinnyScores)
{
Console.WriteLine("\n{0}'s score is {1}", twinny.GamerTag, item.ToString());
}
#endregion
#region EX 5
// Select all players that have a score greater than 300.
var scoresForPlayersOver300 = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
where s.score > 300
select new { player = p.GamerTag,
playerScore = s.score });
// Display
foreach (var item in scoresForPlayersOver300)
{
Console.WriteLine("\n {0} {1}", item.player, item.playerScore);
}
#endregion
//foreach (var game in _gobjs.games)
// Console.WriteLine("Game is {0} ", game.ToString());
//foreach (var player in _gobjs.players)
// Console.WriteLine("Player is {0}", player.ToString());
//foreach (var score in _gobjs.scores)
// Console.WriteLine("Score is {0}", score.ToString());
Console.ReadKey();
}
static void Main(string[] args)
{
Activity.Track("LINQ example First Run");
GameObjects _gobjs = new GameObjects();
foreach (var item in _gobjs.Collectables)
{
if (item.selected)
{
Console.WriteLine(" Selected {0} with value {1}", item.id, item.val);
}
else
{
Console.WriteLine(" Not Selected {0} with value {1}", item.id, item.val);
}
}
//IEnumerable is an interface defining a single method GetEnumerator() that returns an IEnumerator interface.
//It is the base interface for all non-generic collections that can be enumerated.
//This works for read-only access to a collection that implements that IEnumerable can be used with a foreach statement
var selected = _gobjs.Collectables
.Where(s => s.selected == true);
foreach (var item in selected)
{
Console.WriteLine("Collected {0}", item.ToString());
}
var orderedSelected = _gobjs.Collectables
.Where(s => s.selected == false)
.OrderByDescending(s => s.val);
foreach (var item in orderedSelected)
{
Console.WriteLine("Ordered descending Not Collected {0}", item.ToString());
}
//.Concat joins items into one string
var _playerXPDetails = _gobjs.players
.Select(p => new {
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerXP = p.XP
});
foreach (var pxp in _playerXPDetails)
{
Console.WriteLine("Player XP is {0}",
String.Concat(pxp.Name, " ", pxp.PlayerXP.ToString()));
}
var playerScores = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
join g in _gobjs.games
on s.GameID equals g.GameID
select new { Game = g.GameName,
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerScore = s.score })
.OrderByDescending(order => order.PlayerScore);
foreach (var item in playerScores)
{
Console.WriteLine("Player Score for {0} ", String.Concat("Game name ", item.Game, " ", item.Name, " score ", item.PlayerScore.ToString()));
}
//foreach (var game in _gobjs.games)
// Console.WriteLine("Game is {0} ", game.ToString());
//foreach (var player in _gobjs.players)
// Console.WriteLine("Player is {0}", player.ToString());
//foreach (var score in _gobjs.scores)
// Console.WriteLine("Score is {0}", score.ToString());
//Select all scores greater than 500
var g500 = _gobjs.scores.Where(s => s.score > 500);
foreach (GameScore item in g500)
{
Console.WriteLine("{0}", item.ToString());
}
//Select all players with XP > 250.
var xp250 = _gobjs.players.Where(p => p.XP > 250);
foreach (Player item in xp250)
{
Console.WriteLine("{0}", item.ToString());
}
// Select the player with the gamer tag Twinny
Player twinny = _gobjs.players.FirstOrDefault(p => p.GamerTag == "Twinny");
if (twinny != null)
{
Console.WriteLine("{0}", twinny.ToString());
}
var twinnyScores = _gobjs.scores.Where(s => s.PlayerID == twinny.playerId);
foreach (var item in twinnyScores)
{
Console.WriteLine("Score for {0} is {1}",
twinny.playerId, item.ToString());
}
// Select all players that have a score greater than 300
var scoresForPlayersOver300 = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
where s.score > 300
select new { player = p.GamerTag,
playerScore = s.score });
foreach (var item in scoresForPlayersOver300)
{
Console.WriteLine("{0} {1}", item.player, item.playerScore);
}
Console.ReadKey();
}
static void Main(string[] args)
{
GameObjects _gobjs = new GameObjects();
foreach (var item in _gobjs.Collectables)
{
if (item.selected)
{
Console.WriteLine("Selected {0} with value {1}", item.id, item.val);
}
else
{
Console.WriteLine("Non-Selected {0} with value {1}", item.id, item.val);
}
}
var selected = _gobjs.Collectables
.Where(s => s.selected == true);
foreach (var item in selected)
{
Console.WriteLine("Collected {0}", item.ToString());
}
var orderedSelected = _gobjs.Collectables
.Where(s => s.selected == false)
.OrderByDescending(s => s.val);
foreach (var item in orderedSelected)
{
Console.WriteLine("Ordered descending Not Collected {0}", item.ToString());
}
var _playerXPDetails = _gobjs.players
.Select(p => new {
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerXP = p.XP
});
foreach (var pxp in _playerXPDetails)
{
Console.WriteLine("Player XP is {0}",
String.Concat(pxp.Name, " ", pxp.PlayerXP.ToString()));
}
var playerScores = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
join g in _gobjs.games
on s.GameID equals g.GameID
select new { Game = g.GameName,
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerScore = s.score });
foreach (var item in playerScores)
{
Console.WriteLine("Player Score for {0} ", String.Concat("Game name ", item.Game, " ", item.Name, " score ", item.PlayerScore.ToString()));
}
//foreach (var game in _gobjs.games)
// Console.WriteLine("Game is {0} ", game.ToString());
//foreach (var player in _gobjs.players)
// Console.WriteLine("Player is {0}", player.ToString());
//foreach (var score in _gobjs.scores)
// Console.WriteLine("Score is {0}", score.ToString());
Console.WriteLine();
var scoresGreaterThan500 = (from s in _gobjs.scores.Where(s => s.score > 500)
select new { ID = s.ScoreID, Scores = s.score });
foreach (var item in scoresGreaterThan500)
{
Console.WriteLine("Score ID {0} : {1}", item.ID, item.Scores);
}
var allPlayersWithMoreThan250XP = (from p in _gobjs.players.Where(x => x.XP > 250)
select new { PlayerId = p.playerId, XP = p.XP });
foreach (var item in allPlayersWithMoreThan250XP)
{
Console.WriteLine("Player ID {0} : {1}", item.PlayerId, item.XP);
}
var playersWithGamerTagTwinny = _gobjs.players.Where(o => o.GamerTag == "Twinny");
foreach (var item in playersWithGamerTagTwinny)
{
Console.WriteLine("Player ID {0}", item.playerId);
}
var scoreForTwinny = (from p in _gobjs.players.Where(o => o.GamerTag == "Twinny")
join s in _gobjs.scores
on p.playerId equals s.PlayerID
select new { PlayerId = p.playerId, GamerTag = p.GamerTag, Score = s.score }
);
foreach (var item in scoreForTwinny)
{
Console.WriteLine("Player ID {0} {1} : {2}", item.PlayerId, item.GamerTag, item.Score);
}
Console.WriteLine();
Console.ReadKey();
}
static void Main(string[] args)
{
Activity.Track("Linq Example First Run");
GameObjects _gobjs = new GameObjects();
foreach (var item in _gobjs.Collectables)
{
if (item.selected)
{
Console.WriteLine(" Selected {0} with value", item.id, item.val);
}
else
{
Console.WriteLine(" Not Selected {0} with value", item.id, item.val);
}
}
var selected = _gobjs.Collectables
.Where(s => s.selected == true);
foreach (var item in selected)
{
Console.WriteLine("Collected {0}", item.ToString());
}
var orderedSelected = _gobjs.Collectables
.Where(s => s.selected == false)
.OrderByDescending(s => s.val);
foreach (var item in orderedSelected)
{
Console.WriteLine("Ordered descending Not Collected {0}", item.ToString());
}
var _playerXPDetails = _gobjs.players
.Select(p => new {
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerXP = p.XP
});
foreach (var pxp in _playerXPDetails)
{
Console.WriteLine("Player XP is {0}",
String.Concat(pxp.Name, " ", pxp.PlayerXP.ToString()));
}
var playerScores = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
join g in _gobjs.games
on s.GameID equals g.GameID
select new { Game = g.GameName,
Name = String.Concat(p.firstName, " ", p.sceondName),
PlayerScore = s.score })
.OrderByDescending(order => order.PlayerScore);
foreach (var item in playerScores)
{
Console.WriteLine("Player Score for {0} ", String.Concat("Game name ", item.Game, " ", item.Name, " score ", item.PlayerScore.ToString()));
}
//foreach (var game in _gobjs.games)
// Console.WriteLine("Game is {0} ", game.ToString());
//foreach (var player in _gobjs.players)
// Console.WriteLine("Player is {0}", player.ToString());
//foreach (var score in _gobjs.scores)
// Console.WriteLine("Score is {0}", score.ToString());
//Select all scores greater than 500
var g500 = _gobjs.scores.Where(s => s.score > 500);
foreach (GameScore item in g500)
{
Console.WriteLine("{0}", item.ToString());
}
//Select all players with XP > 250.
var xp250 = _gobjs.players.Where(p => p.XP > 250);
foreach (Player item in xp250)
{
Console.WriteLine("{0}", item.ToString());
}
// Select the player with the gamer tag Twinny
Player twinny = _gobjs.players.FirstOrDefault(p => p.GamerTag == "Twinny");
if (twinny != null)
{
Console.WriteLine("{0}", twinny.ToString());
}
var twinnyScores = _gobjs.scores.Where(s => s.PlayerID == twinny.playerId);
foreach (var item in twinnyScores)
{
Console.WriteLine("Score for {0} is {1}",
twinny.playerId, item.ToString());
}
// Select all players that have a score greater than 300
var scoresForPlayersOver300 = (from p in _gobjs.players
join s in _gobjs.scores
on p.playerId equals s.PlayerID
where s.score > 300
select new { player = p.GamerTag,
playerScore = s.score });
foreach (var item in scoresForPlayersOver300)
{
Console.WriteLine("{0} {1}", item.player, item.playerScore);
}
Console.ReadKey();
}