Запрос Sql к выражению запроса EF linq [закрыто] ⇐ C#

[Anonymous]

INSERT INTO Report ( TestDetailID, ReceiptID, TestID, DrName, ReceiptDate, ReceiptTime, PatientName, Age, Sex, AgeDesc, Telephone, Address, DrID, ReportDate, ReportTime, CurrentUser, [Test Description], ReportType, TestPartID, PARTICULARS, [Part_Head], [Part_Head No], PartType, Results, UNITS, SUPERSCRIPT, MALE, FEMALE, [Rem-Com-Method], ReportHead, Specimen ) SELECT [TestDetails_2].TestDetailID, [TestDetails_2].ReceiptID, [TestDetails_2].TestID, Doctors.DrName, [SampleReceipts_2].ReceiptDate, [SampleReceipts_2].ReceiptTime, [SampleReceipts_2].PatientName, [SampleReceipts_2].Age, [SampleReceipts_2].Sex, [SampleReceipts_2].AgeDesc, [SampleReceipts_2].Telephone, [SampleReceipts_2].Address, [SampleReceipts_2].DrID, [SampleReceipts_2].ReportDate, [SampleReceipts_2].ReportTime, [SampleReceipts_2].CurrentUser, Tests.[Test Description], Tests.ReportType, TestParticulars.TestPartID, TestParticulars.PARTICULARS, TestParticulars.[Part_Head], TestParticulars.[Part_Head No], TestParticulars.PartType, TestParticulars.Results, TestParticulars.UNITS, TestParticulars.SUPERSCRIPT, TestParticulars.MALE, TestParticulars.FEMALE, [Rem-Comm-Method].[Rem-Com-Method], Tests.ReportHead, [SampleReceipts_2].Specimen FROM ( (Tests INNER JOIN TestParticulars ON Tests.TestNo = TestParticulars.TestNo) INNER JOIN [Rem-Comm-Method] ON Tests.TestNo = [Rem-Comm-Method].TestNo) INNER JOIN ( (Doctors INNER JOIN [SampleReceipts_2] ON Doctors.DrID = [SampleReceipts_2].DrID) INNER JOIN [TestDetails_2] ON [SampleReceipts_2].ReceiptID = [TestDetails_2].ReceiptID ) ON Tests.TestID = [TestDetails_2].TestID WHERE (( ([TestDetails_2].ReceiptID)=[Forms]![SampleReceipts]![ReceiptID] )) ORDER BY TestParticulars.TestPartID; How to convert this sql query into linq for C# entity framework? I tried it in Linqer but join sub query error raised. I try it to convert manually like below but faced errors in C#.
queryReports = from ((Tests INNER JOIN TestParticulars ON Tests.TestNo = TestParticulars.TestNo) INNER JOIN [Rem-Comm-Method] ON Tests.TestNo = [Rem-Comm-Method].TestNo) INNER JOIN ((Doctors INNER JOIN [SampleReceipts_2] ON Doctors.DrID = [SampleReceipts_2].DrID) INNER JOIN [TestDetails_2] ON [SampleReceipts_2].ReceiptID = [TestDetails_2].ReceiptID) ON Tests.TestID = [TestDetails_2].TestID where [TestDetails_2].ReceiptID=[SampleReceipts]![ReceiptID] orderby TestParticulars.TestPartID select new { [TestDetails_2].TestDetailID, [TestDetails_2].ReceiptID, [TestDetails_2].TestID, Doctors.DrName, [SampleReceipts_2].ReceiptDate, [SampleReceipts_2].ReceiptTime, [SampleReceipts_2].PatientName, [SampleReceipts_2].Age, [SampleReceipts_2].Sex, [SampleReceipts_2].AgeDesc, [SampleReceipts_2].Telephone, [SampleReceipts_2].Address, [SampleReceipts_2].DrID, [SampleReceipts_2].ReportDate, [SampleReceipts_2].ReportTime, [SampleReceipts_2].CurrentUser, Tests.[Test Description], Tests.ReportType, TestParticulars.TestPartID, TestParticulars.PARTICULARS, TestParticulars.[Part_Head], TestParticulars.[Part_Head No], TestParticulars.PartType, TestParticulars.Results, TestParticulars.UNITS, TestParticulars.SUPERSCRIPT, TestParticulars.MALE, TestParticulars.FEMALE, [Rem-Comm-Method].[Rem-Com-Method], Tests.ReportHead, [SampleReceipts_2].Specimen };

Источник: https://stackoverflow.com/questions/780 ... expression