using System;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using Microsoft.Extensions.Logging;

namespace EfInvalidSql;
public class Program
{
    public static async Task Main(params string[] args)
    {
        MyContext context = new();
        context.Database.EnsureDeleted();
        context.Database.EnsureCreated();

        var users = await context.Set<User>()
            .Where(x => EF.Functions.Like(x.Name, "Name%"))
            .ToListAsync();
    }
}

public class User
{
    public required int Id { get; set; }
    public required FullName Name { get; set; }
}

public readonly record struct FullName
{
    public FullName(string value)
    {
        Value = value;
    }

    public string Value { get; }

    public static implicit operator string(FullName fullName)
    {
        return fullName.Value;
    }
}

public class FullNameConverter : ValueConverter<FullName, string>
{
    public FullNameConverter() : base(
        v => v.Value,
        v => new FullName(v))
    {
    }
}

public class MyContext : DbContext
{
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder
            .UseSqlServer("Server=localhost,7438;Database=TestDb;User Id=sa;Password=RMfL3Tx%bZ5b;TrustServerCertificate=True;")
            .LogTo(Console.WriteLine, LogLevel.Information)
            .EnableSensitiveDataLogging();
    }

    protected override void ConfigureConventions(ModelConfigurationBuilder configurationBuilder)
    {
        configurationBuilder.Properties<FullName>()
            .HaveConversion<FullNameConverter>()
            .HaveColumnType("text");
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<User>(builder =>
        {
            builder.ToTable("Users");
        });

        modelBuilder.Entity<User>()
            .HasData(
                new User { Id = 1, Name = new FullName("Name1") },
                new User { Id = 2, Name = new FullName("Name2") }
                );
    }
}