I’m using EFCore 7.0 and Pomelo 7.0 with MySQL 8.0. When I execute raw SQL in NetCore project, it has error. This is a working way in previous version.

The code is:

var cnt = context.Database.SqlQuery<int>($"SELECT COUNT(*) AS CNT FROM TABLE").FirstOrDefault();

It keeps getting error

MySqlConnector.MySqlException: ‘Unknown column ‘t.Value’ in ‘field
list” ef core raw sql

Any help will be appreciated.