问题描述
我正在学习实体SQL，我有一个关于代码的问题，当我使用时：
I'm learning about Entity SQL, I have a problem about code is, when I use :
EntitiesName context = new EntitiesName();
string sql = "SELECT VALUE tmp FROM EntitiesName.Tables AS tmp"
ObjectQuery<Tables> exam = ((IObjectAdapter)context).ObjectQuery.CreateQuery<Tables>(sql);
dataGridView.DataSource = exam.ToList();
数据显示在datagridview上。所以代码没问题，但当我将查询sql更改为：
The data displays on datagridview. So that code is OK, but when I change query sql to :
string sql = "SELECT tmp.STUDENT, tmp.CLASS FROM EntitiesName.Tables AS tmp"
代码不运行，datagridview为空，它们不显示任何内容。因此，当我使用SELECT VALUE时，每件事情都很好，但是当我将SELECT VALUE更改为SELECT tmp.column name时，代码不会运行。我已将'Tables'更改为'dbDataRecord'但它有同样的问题，所以任何人都可以帮我解决这个问题。首先感谢！
The code doesn't run, the datagridview is empty, they don't show anything. So when i use SELECT VALUE every thing is good, but when I change SELECT VALUE to SELECT tmp.column name the code doesn't run. I have change the 'Tables' into 'dbDataRecord' but it has same problem, so can anyone help me about this. Thank first !
推荐答案
var students = context.<entityname>.SqlQuery("Select tmp.STUDENT, tmp.CLASS EntitiesName.Tables AS tmp").FirstOrDefault<entityname>();
</entityname></entityname>
这里的EntityName是你的'表'
这篇关于实体SQL代码问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！