EF 使用SQL查询

SQL 查询 - EF Core | Microsoft Learn

 

        /// <summary>
        /// 测试：使用EF执行sql
        /// </summary>
        /// <returns></returns>
        public List<T_SRM_Suppliers> GetDemoList()
        {
            //https://learn.microsoft.com/zh-cn/ef/core/querying/sql-queries?tabs=sqlserver#querying-scalar-non-entity-types
            var ids1 = _repository.DbContext.Set<T_SRM_Suppliers>().FromSql($"select * from T_SRM_Suppliers").ToList();
            var ids2 = _repository.DbContext.Database.SqlQuery<int>($"select count(1) from T_SRM_Suppliers").ToList(); ;
            var ids3 = _repository.DbContext.Database.SqlQuery<T_SRM_Suppliers>($"select * from T_SRM_Suppliers").ToList();

            return ids3;
        }