EF 4.1 代码优先原始 SQL

发布于 2024-12-10 03:35:33 字数 568 浏览 1 评论 0原文

我想使用 RAW SQL 返回实体，因此我有以下代码返回一组实体：

var rawSql = "exec spFindStories @pattern, @page, @pageSize"; 

            // use raw SQL because SP is needed
            // results are not tracked.
            var stories = context.Database.SqlQuery<Story>(rawSql, 
                new SqlParameter("@pattern", pattern),
                new SqlParameter("@page", page),
                new SqlParameter("@pageSize", pageSize)                
               ).ToList();

现在，对于每个故事，我需要加载其相关标签。看来CF没有加载结果中返回的相关实体。我怎样才能做到这一点？

谢谢！！

原文

I would like to return entities using RAW SQL, so I have the following code which returns a set of Entities:

var rawSql = "exec spFindStories @pattern, @page, @pageSize"; 

            // use raw SQL because SP is needed
            // results are not tracked.
            var stories = context.Database.SqlQuery<Story>(rawSql, 
                new SqlParameter("@pattern", pattern),
                new SqlParameter("@page", page),
                new SqlParameter("@pageSize", pageSize)                
               ).ToList();

Now for each one of these stories, I need to load their related Tags. It seems that CF does not load related entities returned in the results. How can I achieve this ??

Thanks!!

分享到QQ

分享到微博