ExecuteStoreQuery用于自定义列 [英] ExecuteStoreQuery for custom columns
本文介绍了ExecuteStoreQuery用于自定义列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试运行自定义查询,并且我正在使用Entity Framework,所以我尝试过
I am trying to run custom query and I am using Entity framework, I tried this
string query = @"SELECT dm.DistrictName,sm.SchoolName,u.UserId,u.FirstName,u.LastName, sa.StudentId, sa.ReadingLevel
FROM studentassessment sa
INNER JOIN assessmentmaster am ON sa.AssessmentId = am.AssessmentId
INNER JOIN studentclass sc ON sa.StudentId = sc.StudentId
INNER JOIN USER u ON sc.TeacherId = u.UserId
INNER JOIN schoolmaster sm ON u.SchoolCode = sm.SchoolCode
INNER JOIN districtmaster dm ON sm.DistrictId = dm.DistrictId
WHERE u.RoleId = 5 && sa.GradeId = " + objParam.Grade + " && sa.AssessmentPeriodId = " + x.AssessmentPeriodId + " && dm.DistrictId = " + districtCode + " && am.DRAType = '" + objParam.LanguageType + "' && am.AssessmentTypeId = 1";
var dt = db.ExecuteStoreQuery<List<object>>(query).FirstOrDefault();
但是没有成功.
在没有映射到任何对象类型的结构中,有什么方法可以从 ExecuteStoreQuery
获取结果吗?
Is there any way to get results from ExecuteStoreQuery
in the structure not mapped to any object type?
推荐答案
否.EF的 ExecuteStoreQuery
要求数据类型(类)的属性与您的查询结果集中的列具有相同的名称.如果要执行查询而不为其结果集创建特殊类型,则必须直接使用ADO.NET和 SqlDataReader
.
No. EF's ExecuteStoreQuery
requires data type (class) with properties with same names as columns in yours query result set. If you want to execute query without creating a special type for its result set you have to use ADO.NET and SqlDataReader
directly.
这篇关于ExecuteStoreQuery用于自定义列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文