ExecuteStoreQuery for custom columns
I am trying to run a custom query and I am using the Entity framework, I have 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();
But it didn't work out.
Is there a way to get results from ExecuteStoreQuery
in a struct that is not associated with any type of object?
+3
source to share