using System.Diagnostics;

using System.Linq;

using AutoMapper;

using AutoMapper.QueryableExtensions;

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.Logging;

​

namespace IssueConsoleTemplate

{

    public class Foo

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public BarVW Bar { get; set; }

    }

​

    public class BarVW

    {

        public int FooId { get; set; }

        public string FooName { get; set; }

        public Foo Foo { get; set; }

    }

    public class Context : DbContext

    {

        public virtual DbSet<Foo> Foo { get; set; }

        public virtual DbSet<BarVW> BarVW { get; set; }

​

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            optionsBuilder

                .UseSqlServer(

                    FiddleHelper.GetConnectionStringSqlServer())

                .UseLoggerFactory(LoggerFactory.Create(b => b

                    .AddConsole()

                    .AddFilter(level => level >= LogLevel.Information)))

                .EnableSensitiveDataLogging()

                .EnableDetailedErrors();

        }

​

        protected override void OnModelCreating(ModelBuilder modelBuilder)

        {

            modelBuilder.Entity<Foo>()

                .HasData(

                    new Foo {Id = 1, Name = "Fo"},

                    new Foo {Id = 2, Name = "Foo"},

                    new Foo {Id = 3, Name = "Fooo"});

​

            modelBuilder.Entity<BarVW>(

                eb =>

                {

                    eb.HasKey(e => e.FooId);

                    eb.ToView("v_Bar");

                    eb.HasOne(e => e.Foo)

                        .WithOne(e => e.Bar)

                        .HasForeignKey<BarVW>(e => e.FooId);

                });

        }

    }

    public class FooDto

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public bool IsBar { get; set; }

    }

​

    internal static class Program

    {

        private static void Main()

        {

            using var context = new Context();

​

            // context.Database.EnsureDeleted();

            context.Database.EnsureCreated();

            context.Database.ExecuteSqlRaw(

                @"CREATE VIEW [v_Bar] AS 

    select

        f.[Id] as [FooId],

        f.[Name] as [FooName]

    from

        [Foo] f

    where

        f.[Id] >= 1 and f.[Id] <= 2"

            );

            var config = new MapperConfiguration(

                cfg => cfg

                    .CreateMap<Foo, FooDto>()

                        .ForMember(dto => dto.IsBar, opt => opt.MapFrom(src => src.Bar != null)));

            var result = context.Foo

                .ProjectTo<FooDto>(config)

                .ToList();

            Debug.Assert(result.Count == 3);

            Debug.Assert(result.Count(dto => dto.IsBar) == 2);

        }

    }

}