.Net Core 6.0 - Entity with mysql

Need sample project ASP.net CORE .net 6.0 connect and encrypt columns
Need to encrypt a couple of columns and be able to read and query as well. i.e Encrypt and Decrypt

public class User
{
public Guid ID { get; set; }
public string Firstname { get; set; }
public string Lastname { get; set; }
[EncryptColumn]
public string EmailAddress { get; set; }
[EncryptColumn]
public string IdentityNumber { get; set; }
}