using Microsoft.EntityFrameworkCore;

using System.Collections.Generic;

using System.Linq;

using System;

​

namespace EFTest

{

    public class Blog

    {

        public int BlogId { get; set; }

        public string Url { get; set; }

    }

​

    public class BloggingContext : DbContext

    {

        public BloggingContext(){ }

​

        public BloggingContext(DbContextOptions<BloggingContext> options)

            : base(options){ }

​

        public DbSet<Blog> Blogs { get; set; }

    }

​

    public class BlogService

    {

        private BloggingContext _context;

​

        public BlogService(BloggingContext context)

        {

            _context = context;

        }

​

        public void Add(string url)

        {

            var blog = new Blog { Url = url };

            _context.Blogs.Add(blog);

            _context.SaveChanges();

        }

​

        public IEnumerable<Blog> Find(string term)

        {

            return _context.Blogs

                .Where(b => b.Url.Contains(term))

                .OrderBy(b => b.Url)

                .ToList();

        }

    }

​

    class Program

    {

        static void Main(string[] args)

        {

            Console.WriteLine("This is an example of using EF Core InMemory Database");

            Console.WriteLine("======================================================");

            Console.WriteLine("");

            var options = new DbContextOptionsBuilder<BloggingContext>()

                .UseInMemoryDatabase(databaseName: "Add_writes_to_database")

                .Options;

​

            // Run the test against one instance of the context

            using (var context = new BloggingContext(options))

            {

            }

        }

    }

​

}