Can we map as this when we have sub query?
.HasComputedColumnSql("select top 1 address.[zipcode] + ', ' + address.[details] from address where [addressId]=address.id");
}
⚠Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.
@zxs731 The text passed to HasComputedColumnSql is opaque to EF, so if that works on SQL Server (or whatever database engine you are using) then it should work with EF.
Most helpful comment
@zxs731 The text passed to HasComputedColumnSql is opaque to EF, so if that works on SQL Server (or whatever database engine you are using) then it should work with EF.