using System;

using System.Collections.Generic;

using System.Linq;

using Microsoft.EntityFrameworkCore;

using Microsoft.EntityFrameworkCore.Query.Internal;

​

public class BloggingContext : DbContext

{

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

​

    public DbSet<Post> Posts { get; set; }

​

    public string DbPath { get; }

​

    public BloggingContext()

    {

        var folder = Environment.SpecialFolder.LocalApplicationData;

        var path = Environment.GetFolderPath(folder);

        DbPath = System.IO.Path.Join(path, "blogging.db");

    }

​

    // The following configures EF to create a Sqlite database file as `C:\blogging.db`.

    // For Mac or Linux, change this to `/tmp/blogging.db` or any other absolute path.

    protected override void OnConfiguring(DbContextOptionsBuilder options) => options.UseSqlite($"Data Source={DbPath}");

    protected override void OnModelCreating(ModelBuilder modelBuilder)

    {

        base.OnModelCreating(modelBuilder);

    }

}

​

public class Blog

{

    public int BlogId { get; set; }

​

    public string Url { get; set; }

​

    public string Title { get; set; }

​

    public List<Post> Posts { get; set; } = new List<Post>();

}

​

public class Post

{

    public int PostId { get; set; }

​

    public string Title { get; set; }

​

    public string Content { get; set; }

​

    public int BlogId { get; set; }

​

    public Blog Blog { get; set; }

}

​

public class Program

{

    public static void Main()

    {

        using var context = new BloggingContext();

        int len = 3;

        //var query = context.Set<Blog>().Where(b => b.Posts.Any(p => p.Title.Contains("abc"))).Include(b => b.Posts.Where(p => p.Title.Contains("abc"))).Take(10).AsQueryable();

        var query1 = context.Set<Blog>().Where(b => b.Title.Length > len);

        var query2 = (EntityQueryable<Blog>)query1;

        Console.WriteLine(query2.DebugView.Query);

        Console.WriteLine("\n\n");

        len = 10;

        Console.WriteLine(query2.DebugView.Query);

        //query.Dump();

    }

}