using System;

using System.Linq;

​

using Microsoft.EntityFrameworkCore;

public class Program

{

    public class TestDbContext : DbContext

    {

​

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            base.OnConfiguring(optionsBuilder);

            optionsBuilder.UseSqlServer("data source=localhost;initial catalog=testdb;");

        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)

        {

            base.OnModelCreating(modelBuilder);

            modelBuilder.Entity<Blog>(b =>

            {

                b.HasKey(x => x.Id);

                b.Property(x => x.Name).IsRequired();

                b.Property(x => x.Title).IsRequired();

            });

        }

    }

    public class Blog

    {

        public int Id {get;set;}

        public string Name {get;set;}

        public string Title {get;set;}

    }

    public static void Main()

    {

        var dbContext = new TestDbContext();

        var query = dbContext.Set<Blog>()

            .Where(x => (x.Name + x.Title).Contains("Test"));

        Console.WriteLine("Query is: \"{0}\"", query.ToQueryString());

    }

}