ef core原始sql查询

ef core用原始sql查询，不能自动映射到类型中。
处理主要是将sql查询结果转换为json，然后再将json转换为类型对象

      public async Task<List<Warning_log>> GetStatData()
      {
   
          string sql = @"SELECT       
    CONVERT(date, [trigger_time]) as trigger_time
,count(distinct[warning_txt]) as P
,[warning_target]
          FROM  [warning_log] 
group by CONVERT(date, [trigger_time]) ,[warning_target] ";
          var db = GetNewDbContext();

          var jsonObj = await db.Database.SqlQueryRaw<string>($"{
     sql}   for json path ").ToListAsync();
          string json = jsonObj.First().ToString();         
          var list2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warning_log>>(json);

          return list2;
      }

参考资料
https://stackoverflow.com/questions/74876446/error-in-sqlquery-method-is-not-natively-supported-by-your-database-provider