Phpmyadmin – C# EF Core MySQL to LINQ return nothing
var IdSubProduct = new MySqlConnector.MySqlParameter("IdSubProduct", this.parameter.Id.ToString()); FormattableString cmd = $@"SELECT spr.*, c.Name CustomerName FROM ProductSubProductRate spr LEFT JOIN LibraryCustomer c ON (c.Id = spr.CustomerId) WHERE (spr.IdSubProduct = {IdSubProduct})"; this.contextSQL.ProductSubProductRate.FromSql(cmd).ToList(); this.contextSQL.ProductSubProductRate .Include("Customers") .Where(pr => pr.IdSubProduct == this.parameter.Id.ToString()) .Select(pr => new {…