LINQ-直接查询执行 [英] LINQ - Direct Query Execution

问题描述

大家好，

通常，我们会将TResult类型赋予ExecuteQuery命令以进行查询.但是在这种情况下，我希望执行查询，但我不知道查询返回的列.因此，我不想提供TResult类型.这样...

Hi All,

In general we will give TResult type to ExecuteQuery command for our query. But in this scene, I want a query to be executed and I don''t know what columns it returns. So, I don''t want to give TResult type. Like this...

<pre lang="xml">var varRes = db.ExecuteQuery<SampleMaster>(@TxtQry.Text, objects).ToList();<br />
                if (varRes == null)<br />
                    lblErr.Text = "Information : No Records Found with given search criteria..!";<br />
<br />
                gv_Account.DataSource = varRes;<br />
                gv_Account.DataBind();</pre><br />

在这里，我不想给SampleMaster.我不知道TxtQry文本框中存在什么选择查询.
我的问题是动态的，它应该在数据表中返回查询结果/toList()可以将数据源分配给gridview.

在此先感谢....

Here I don''t want to give SampleMaster. I don''t know what select query is present in TxtQry textbox.
My problem is dynamically, it should return query result in a datatable / toList() is okay with me to assign datasource to gridview.

Thanks in advance....

推荐答案

您可以使用类类型对象代替SampleMaster(如果samplemastr是表)返回选择查询. >

You can use a class type object to return select query in place of SampleMaster(if samplemastr is a table).

var varRes = db.ExecuteQuery<classname>(@TxtQry.Text, objects).ToList();               
 if (varRes == null)                  
  lblErr.Text = "Information : No Records Found with given search criteria..!";               
  gv_Account.DataSource = varRes;    
  gv_Account.DataBind();</classname>

类声明

class declaration

public class className
{
//define here variables as re requirements;
}

这篇关于LINQ-直接查询执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！