private static void CreateUserIfNotExist(DiabloContext context, IEnumerable<XElement> xUsers) { foreach (var xUser in xUsers) { var userName = xUser.Attribute("username").Value; Console.WriteLine(userName); } }
// nope static void Main() { var context = new DiabloContext(); var xmlDoc = XDocument.Load(@"..\..\users-and-games.xml"); var userNodes = xmlDoc.XPathSelectElements("/users/user"); foreach (var userNode in userNodes) { //CreateUserIfNotExist(context, userNode); } }
static void Main() { var context = new DiabloContext(); var characterNames = context.Characters .Select(c => c.Name) .ToList(); foreach (var charName in characterNames) { Console.WriteLine(charName); } }
static void Main() { var context = new DiabloContext(); var charsPlayers = context.Characters .OrderBy(c => c.Name) .Select(c => new { name = c.Name, playedBy = c.UsersGames .Select(u => u.User.Username) }) .ToList(); var jsSerializer = new JavaScriptSerializer(); var charsPlayersJson = jsSerializer.Serialize(charsPlayers); File.WriteAllText("characters.json", charsPlayersJson); Console.WriteLine("Characted and Players exported to characters.json"); }
static void Main() { var context = new DiabloContext(); var finishedGames = context.Games .Where(g => g.IsFinished == true) .OrderBy(g => g.Name) .ThenBy(g => g.Duration) .Select(g => new { Name = g.Name, Duration = g.Duration, Users = g.UsersGames .Select(u => new { UserName = u.User.Username, IPAddress = u.User.IpAddress }) .ToList() }) .ToList(); var gamesXml = new XElement("games"); foreach (var finishedGame in finishedGames) { var gameXml = new XElement("game"); gameXml.Add(new XAttribute("name", finishedGame.Name)); if (finishedGame.Duration.HasValue) { gameXml.Add(new XAttribute("duration", finishedGame.Duration)); } var usersXml = new XElement("users"); foreach (var user in finishedGame.Users) { var userXml = new XElement("user"); userXml.Add(new XAttribute("username", user.UserName)); userXml.Add(new XAttribute("ip-address", user.IPAddress)); usersXml.Add(userXml); } gameXml.Add(usersXml); gamesXml.Add(gameXml); } var xmlDocument = new XDocument(gamesXml); xmlDocument.Save("finished-games.xml"); Console.WriteLine("Finished Games exported to finished-games.xml."); }