Example #1
0
        static void Main()
        {
            var context = new DiabloContext();
            var charactersNames = context.Characters.Select(c => c.Name);

            foreach (var name in charactersNames)
            {
                Console.WriteLine(name);
            }
        }
Example #2
0
        static void Main()
        {
            var context         = new DiabloContext();
            var charactersNames = context.Characters.Select(c => c.Name);

            foreach (var name in charactersNames)
            {
                Console.WriteLine(name);
            }
        }
Example #3
0
        static void Main()
        {
            var context = new DiabloContext();

            var characters = context.Characters
                .OrderBy(c => c.Name)
                .Select(c => new
                {
                    name = c.Name,
                    playedBy = c.UsersGames.Select(ug => ug.User.Username)
                });

            string charactersJson = new JavaScriptSerializer().Serialize(characters);

            File.WriteAllText("../../../characters.json", charactersJson);
        }
Example #4
0
        static void Main()
        {
            var context = new DiabloContext();

            var finishedGames = context.Games
                .Where(g => g.IsFinished)
                .Select(g => new
                {
                    name = g.Name,
                    duration = g.Duration,
                    users = g.UsersGames.Select(ug => new
                    {
                        username = ug.User.Username,
                        ipAdress = ug.User.IpAddress
                    })
                });

            XElement gamesElement = new XElement("games");

            foreach (var game in finishedGames)
            {
                XElement gameElement = new XElement("game", new XAttribute("name", game.name));

                if (game.duration != null)
                {
                    gameElement.Add(new XAttribute("duration", game.duration));
                }

                XElement usersElement = new XElement("users");

                foreach (var user in game.users)
                {
                    XElement userElement = new XElement("user", new XAttribute("username", user.username),
                        new XAttribute("ip-address", user.ipAdress));

                    usersElement.Add(userElement);
                }

                gameElement.Add(usersElement);
                gamesElement.Add(gameElement);
            }

            gamesElement.Save("../../../finished-games.xml");
        }