Now I experience a strange problem with very simple query:
Code: Select all
from eq in DB.ExamQuestions
join eqr in DB.ExamQuestionRanks on eq.Id equals eqr.Id_question
select eq;
Code: Select all
CREATE TABLE `exam_question` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Question` text,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `exam_question_rank` (
`Id_question` int(11) NOT NULL,
`Date_update` datetime NOT NULL,
PRIMARY KEY (`Id_question`),
CONSTRAINT `FK_Exam_question_rank_Exam_question` FOREIGN KEY (`Id_question`) REFERENCES `exam_question` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Code: Select all
[NotSupportedException: Specified method is not supported.]
Devart.Data.Linq.Provider.Query.a.a(an A_0) +219
Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0) +136
Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0) +36
Devart.Data.Linq.Provider.Query.SqlVisitor.a(a9 A_0) +177
Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0) +1797
Devart.Data.Linq.Provider.Query.SqlVisitor.e(SqlNode A_0) +36
Devart.Data.Linq.Provider.Query.SqlVisitor.e(bo A_0) +103
Devart.Data.Linq.Provider.Query.SqlVisitor.a(bo A_0) +39
Devart.Data.Linq.Provider.Query.SqlVisitor.a(ax A_0) +130
Devart.Data.Linq.Provider.Query.a.a(ax A_0) +89
Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0) +2574
Devart.Data.Linq.Provider.Query.bf.a(SqlNode A_0, SqlNode A_1, SqlFactory A_2, ao A_3) +83
Devart.Data.Linq.Provider.DataProvider.a(c A_0, Type A_1, SqlNode A_2, IList`1 A_3) +391
Devart.Data.Linq.Provider.DataProvider.a(Expression A_0) +236
Devart.Data.Linq.Provider.DataProvider.h(Expression A_0) +168
Devart.Data.Linq.DataQuery`1.i() +53
Aviationexam.BO.Reports.BOExamReports.ComputeProgressAreas(Int32 idExam, Int32 idLevel, String testMode)
...
The problem is really strange, because I have over 100 tables in my project and I'm using much more complicated queries without any problem. So I do not understand this error.
Thank you for your help in advance.