コード例 #1
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void DeleteCommentById()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            Comment commentInfo = blogDbContext.Comments.Single(comment => comment.Id == 1);
            blogDbContext.Comments.Remove(commentInfo);
            blogDbContext.SaveChanges();
            Console.WriteLine(@"Comment #{0} deleted", commentInfo.Id);
        }
コード例 #2
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void DeletePostById()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            Post postInfo = blogDbContext.Posts.Single(post => post.Id == 33);
            blogDbContext.Comments.RemoveRange(postInfo.Comments);
            postInfo.Tags.Clear();
            blogDbContext.Posts.Remove(postInfo);
            blogDbContext.SaveChanges();
            Console.WriteLine("Post #{0} deleted successfully", postInfo.Id);
        }
コード例 #3
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void JoinsAuthorsWithTitles()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            var users = blogDbContext.Users.SelectMany(user => user.Posts, (user, post) => new { user.UserName, post.Title });

            foreach (var user in users)
            {
                Console.WriteLine("Username: {0}", user.UserName);
                Console.WriteLine("Post Title: {0}", user.Title);
                Console.WriteLine();
            }
        }
コード例 #4
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void ListAllUsers()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            List<User> users = blogDbContext.Users.Select(user => user).ToList();

            foreach (User user in users)
            {
                Console.WriteLine("ID: {0}", user.Id);
                Console.WriteLine("Name: {0}", user.FullName);
                Console.WriteLine("Comments Count: {0}", user.Comments.Count);
                Console.WriteLine("Posts Count: {0}", user.Posts.Count);
                Console.WriteLine();
            }
        }
コード例 #5
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void ListAllPosts()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            List<Post> posts = blogDbContext.Posts.Select(post => post).ToList();

            foreach (Post post in posts)
            {
                Console.WriteLine("Title: {0}", post.Title);
                Console.WriteLine("AuthorID: {0}", post.AuthorId);
                Console.WriteLine("Comments Count: {0}", post.Comments.Count);
                Console.WriteLine("Tags Count: {0}", post.Tags.Count);
                Console.WriteLine();
            }
        }
コード例 #6
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void CreateData()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            Post post = new Post()
            {
                AuthorId = 2,
                Title = "Random title",
                Body = "Random content",
                Date = DateTime.Now
            };
            blogDbContext.Posts.Add(post);
            blogDbContext.SaveChanges();

            Console.WriteLine("Post #{0} Created!", post.Id);
        }
コード例 #7
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void ListTitleAndBodyFromPosts()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            var posts = blogDbContext.Posts.Select(post => new
            {
                post.Title,
                post.Body
            }).ToList();

            foreach (var post in posts)
            {
                Console.WriteLine("Title: {0}", post.Title);
                Console.WriteLine("Content: {0}", post.Body);
                Console.WriteLine();
            }
        }
コード例 #8
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void UpdateData()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            User userInfo = blogDbContext.Users.Single(user => user.UserName == "GBotev");
            string oldName = userInfo.FullName;
            userInfo.FullName = "Georgi Botev";
            blogDbContext.SaveChanges();
            Console.WriteLine(@"User '{0}' has been renamed to '{1}'", oldName, userInfo.FullName);
        }
コード例 #9
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void SelectAuthors()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            List<User> users = blogDbContext.Users.Select(user => user).Where(user => user.Posts.Count > 0).ToList();

            foreach (User user in users)
            {
                Console.WriteLine("Username: {0}", user.UserName);
                Console.WriteLine("Full Name: {0}", user.FullName);
                Console.WriteLine("Posts Count: {0}", user.Posts.Count);
                Console.WriteLine();
            }
        }
コード例 #10
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void SelectAuthorOfSpecificPost()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            var author = blogDbContext.Users.SelectMany(user => user.Posts, (user, post) => new { user.UserName, user.FullName, post.Id }).Single(post => post.Id == 4);

            Console.WriteLine("Username: {0}", author.UserName);
            Console.WriteLine("Full name: {0}", author.FullName);
            Console.WriteLine();
        }
コード例 #11
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void OrderPostsAuthors()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            var postAuthors = blogDbContext.Users.Where(user => user.Posts.Count > 0).OrderByDescending(user => user.Id).Select(user => new
            {
                user.UserName,
                user.FullName
            }).ToList();

            foreach (var user in postAuthors)
            {
                Console.WriteLine("Username: {0}", user.UserName);
                Console.WriteLine("Full Name: {0}", user.FullName);
            }
        }
コード例 #12
0
ファイル: Program.cs プロジェクト: hammer4/SoftUni
        private static void OrderData()
        {
            BlogDbContext blogDbContext = new BlogDbContext();

            var users = blogDbContext.Users.Select(user => new
            {
                user.UserName,
                user.FullName
            }).OrderBy(user => user.UserName).ToList();

            foreach (var user in users)
            {
                Console.WriteLine("Username: {0}", user.UserName);
                Console.WriteLine("Full Name: {0}", user.FullName);
                Console.WriteLine();
            }
        }