示例#1
0
        private void InsertPost()
        {
            var Post1 = new Post()
            {
                Title       = "C#",
                Body        = "Entity Framework",
                CreatedDate = new DateTime(2018, 09, 25)
            };
            var Post2 = new Post()
            {
                Title       = "Interface",
                Body        = "Working with repository pattern",
                CreatedDate = new DateTime(1990, 07, 28)
            };
            var Post3 = new Post()
            {
                Title       = "Gelegate",
                Body        = "Generic Delegate",
                CreatedDate = new DateTime(1989, 06, 26)
            };
            var Post4 = new Post()
            {
                Title       = "Extension",
                Body        = "Extension Method",
                CreatedDate = new DateTime(2001, 08, 27)
            };
            var Post5 = new Post()
            {
                Title       = "Entityframework",
                Body        = "Migration",
                CreatedDate = new DateTime(2002, 05, 30)
            };

            using (var context = new BlogAppDbContext())
            {
                context.Database.Log = Console.WriteLine;
                context.Set <Post>().AddRange(new List <Post> {
                    Post1, Post2, Post3, Post4, Post5
                });
                context.SaveChanges();
            }
        }
示例#2
0
        private void InsertBlog()
        {
            var blog1 = new Blog()
            {
                Name  = "TBF",
                Posts = new List <Post>
                {
                    new Post()
                    {
                        Title       = "Moment With Mo",
                        CreatedDate = new DateTime(2018, 01, 23),
                        Body        = "Every Second count"
                    }
                }
            };
            var blog2 = new Blog()
            {
                Name  = "Muna",
                Posts = new List <Post>
                {
                    new Post()
                    {
                        Title       = "SuperMan",
                        CreatedDate = new DateTime(2007, 06, 29),
                        Body        = "Review on batman superman"
                    }
                }
            };

            using (var context = new BlogAppDbContext())
            {
                context.Database.Log = Console.WriteLine;
                context.Set <Blog>().AddRange(new List <Blog> {
                    blog1, blog2
                });
                context.SaveChanges();
            }
        }
示例#3
0
        private void InsertAuthor()
        {
            var author1 = new Author()
            {
                FullName = "Muna Chimso",
                Posts    = new List <Post>
                {
                    new Post()
                    {
                        Title       = "African Beauty",
                        CreatedDate = new DateTime(2006, 05, 28),
                        Body        = "One Nigeria, One Africa"
                    }
                },
            };
            var author2 = new Author()
            {
                FullName = "Prolifik",
                Posts    = new List <Post>
                {
                    new Post()
                    {
                        Title       = "Seed To Fruition",
                        CreatedDate = new DateTime(2005, 08, 30),
                        Body        = "Having a seed is the start, growth is needed"
                    }
                }
            };

            using (var context = new BlogAppDbContext())
            {
                context.Database.Log = Console.WriteLine;
                context.Set <Author>().AddRange(new List <Author> {
                    author1, author2
                });
                context.SaveChanges();
            }
        }
示例#4
0
 public void Add(T entity)
 {
     context.Set <T>().Add(entity);
     Save();
 }
 public virtual async Task <Category> GetAsync(int id)
 {
     return(await _context.Set <Category>().EnabledCategories().FirstOrDefaultAsync(post => post.Id == id));
 }
示例#6
0
 public virtual async Task <Post> GetAsync(int id)
 {
     return(await _context.Set <Post>().Include(post => post.PostCategories).ThenInclude(postCategory => postCategory.Category).EnabledPosts().FirstOrDefaultAsync(post => post.Id == id));
 }