private static void FillMongoDb()
{
DbLayerMongo dbLayerMongo = new DbLayerMongo();
DbLayerMongo.Connection.DropCollection("team");
DbLayerMongo.Connection.DropCollection("player");
var teams = new List <Team>
{
new Team("England"),
new Team("Arsenal"),
new Team("Chelsea"),
new Team("Manchester United"),
new Team("Scotland"),
new Team("Wales")
};
var players = new List <Player>
{
new Player("Neville Southall"),
new Player("James Chester"),
new Player("Gareth Southgate"),
new Player("Clarke Carlisle"),
new Player("Jermaine Darlington"),
new Player("Stuart Ripley"),
new Player("Steve Stone")
};
DbLayerMongo.TeamCollection.InsertMany(teams);
DbLayerMongo.PlayerCollection.InsertMany(players);
var manchesterUnitedId = DbLayerMongo.TeamCollection.Find(t => t.Name == "Manchester United").First().Id;
var playersManchester = new List <Player>
{
new Player("Bob Donaldson", manchesterUnitedId),
new Player("Fred Erentz", manchesterUnitedId),
new Player("Joe Cassidy", manchesterUnitedId),
new Player("James McNaught", manchesterUnitedId),
new Player("Dick Smith", manchesterUnitedId),
new Player("Walter Cartwright", manchesterUnitedId),
new Player("Harry Stafford", manchesterUnitedId)
};
DbLayerMongo.PlayerCollection.InsertMany(playersManchester);
}
private static void TestMongoDb()
{
Console.Clear();
Console.WriteLine("Connecting to MongoDB.");
DbLayerMongo mongo = new DbLayerMongo();
Console.WriteLine("DB connected.");
Console.WriteLine("Showing all Teams.");
//Console.WriteLine("Dropping old collections.");
//DBLayerMongo.Connection.DropCollection("team");
//DBLayerMongo.Connection.DropCollection("player");
//Console.WriteLine("Creating Team.");
//DBLayerMongo.Team.InsertOne(new Team()
//{
// Name = "Team One"
//});
//DBLayerMongo.Team.InsertOne(new Team()
//{
// Name = "Team Two"
//});
//DBLayerMongo.Team.InsertOne(new Team()
//{
// Name = "Team Three"
//});
//Console.WriteLine("Getting first Team Id.");
//string teamId = DBLayerMongo.Team.Find(t => t.Name == "Team One").First().Id;
//Console.WriteLine("Creating first Team Player.");
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player One",
// Team = teamId
//});
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player Two",
// Team = teamId
//});
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player Three",
// Team = teamId
//});
//Console.WriteLine("Getting second Team Id.");
//string secondTeamId = DBLayerMongo.Team.Find(t => t.Name == "Team Two").First().Id;
//Console.WriteLine("Creating second Team Player.");
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player Four",
// Team = secondTeamId
//});
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player Five",
// Team = secondTeamId
//});
//Console.WriteLine("Getting third Team Id.");
//string thirdTeamId = DBLayerMongo.Team.Find(t => t.Name == "Team Three").First().Id;
//Console.WriteLine("Creating third Team Player.");
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player Six",
// Team = thirdTeamId
//});
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player Seven",
// Team = thirdTeamId
//});
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player Eight",
// Team = thirdTeamId
//});
//DBLayerMongo.Player.InsertOne(new Player()
//{
// Name = "Player Nine",
// Team = thirdTeamId
//});
Console.WriteLine("Finished creating Team and Player.");
Console.WriteLine("\nPress any key to continue.");
Console.ReadKey();
Console.Clear();
Console.WriteLine("Querying for Team Name.");
List <Team> teams = DbLayerMongo.TeamCollection.Find(t => t.Name == "Arsenal").ToList();
Console.WriteLine("Team found: {0}", teams.Count);
foreach (Team team in teams)
{
string teamID;
Console.WriteLine("Name: {0}", team.Name);
teamID = team.Id;
Console.WriteLine("Querying for Players of {0}.", team.Name);
List <Player> players = DbLayerMongo.PlayerCollection.Find(p => p.TeamId == teamID).ToList();
foreach (Player player in players)
{
Console.WriteLine("Name: {0}", player.Name);
}
}
//string teamId = "";
//foreach (Team team in teams)
//{
// Console.WriteLine(team.Name);
// teamId = team.Id;
// Console.WriteLine("Querying for Player of {0}.", team.Name);
// List<Player> players = DBLayerMongo.PlayerCollection.Find(p => p.Team == teamId).ToList();
// Console.WriteLine("Player found: {0}", players.Count());
// foreach (Player player in players)
// {
// Console.WriteLine(player.Name);
// }
//}
Console.WriteLine("Query finished.");
Console.WriteLine("\nPress any key to quit.");
Console.ReadKey();
}
