如何从编译的 Linq 查询中提取 Sql 命令

发布于 2024-08-11 16:35:58 字数 1111 浏览 12 评论 0原文

在正常（未编译）的 Linq to Sql 查询中，您可以通过以下代码从 IQueryable 中提取 SQLCommand：

SqlCommand cmd = (SqlCommand)table.Context.GetCommand(query);

是否可以对编译的查询执行相同的操作？

以下代码为我提供了编译查询的委托：

        private static readonly Func<Data.DAL.Context, string, IQueryable<Word>> Query_Get =
        CompiledQuery.Compile<Data.DAL.Context, string, IQueryable<Word>>(
            (context, name) =>
                from r in context.GetTable<Word>()
                where r.Name == name
                select r);

当我使用它生成 IQueryable 并尝试提取 SqlCommand 时，它似乎不起作用。调试代码时，我可以看到返回的 SqlCommand 有“非常”有用的 CommandText“SELECT NULL AS [EMPTY]”，

        using (var db = new Data.DAL.Context())
        {
            IQueryable<Word> query = Query_Get(db, "word");
            SqlCommand cmd = (SqlCommand)db.GetCommand(query);
            Console.WriteLine(cmd != null ? cmd.CommandText : "Command Not Found");
        }

毫无疑问，我在 google 中找不到有关此特定场景的任何内容尝试这不是一件常见的事情...

所以...有什么想法吗？

原文

In normal (not compiled) Linq to Sql queries you can extract the SQLCommand from the IQueryable via the following code:

SqlCommand cmd = (SqlCommand)table.Context.GetCommand(query);

Is it possible to do the same for a compiled query?

The following code provides me with a delegate to a compiled query:

        private static readonly Func<Data.DAL.Context, string, IQueryable<Word>> Query_Get =
        CompiledQuery.Compile<Data.DAL.Context, string, IQueryable<Word>>(
            (context, name) =>
                from r in context.GetTable<Word>()
                where r.Name == name
                select r);

When i use this to generate the IQueryable and attempt to extract the SqlCommand it doesn't seem to work. When debugging the code I can see that the SqlCommand returned has the 'very' useful CommandText of 'SELECT NULL AS [EMPTY]'

        using (var db = new Data.DAL.Context())
        {
            IQueryable<Word> query = Query_Get(db, "word");
            SqlCommand cmd = (SqlCommand)db.GetCommand(query);
            Console.WriteLine(cmd != null ? cmd.CommandText : "Command Not Found");
        }

I can't find anything in google about this particular scenario, as no doubt it is not a common thing to attempt...

So.... Any thoughts?

分享到QQ

分享到微博