Devart Forums

Code: Select all

from esv in DB.ExamSubjectVirtuals
join esvx in DB.ExamSubjectVirtualXes on esv.Id equals esvx.Id_subject_virtual
from eqc in DB.ExamQuestionCounts.Where(c => esvx.Id_subject == c.Id_area).DefaultIfEmpty()
where esv.Id_exam == idExam
orderby esv.Code
select new { esv.Id, eqc.Qs_count, esvx.Id_subject };

Code: Select all

SELECT t1.Id AS Id, t2.Id_subject AS Id_subject, t3.Qs_count AS Qs_count
FROM exam_subject_virtual t1
INNER JOIN exam_subject_virtual_x t2 ON t1.Id = t2.Id_subject_virtual
LEFT OUTER JOIN exam_question_count t3 ON (t2.Id_subject = t3.Id_area)
WHERE t1.Id_exam = :p1
ORDER BY t1.Code

Code: Select all

from esv in DB.ExamSubjectVirtuals
join esvx in DB.ExamSubjectVirtualXes on esv.Id equals esvx.Id_subject_virtual
from eqc in DB.ExamQuestionCounts.Where(c => esvx.Id_subject == c.Id_area).DefaultIfEmpty()
where esv.Id_exam == idExam
orderby esv.Code
select new { esv.Id, esvx.Id_subject, eqc.Qs_count};

Code: Select all

CREATE TABLE [order] (
  [id_order] INT NOT NULL, 
  CONSTRAINT [sqlite_autoindex_order_1] PRIMARY KEY ([id_order]));

CREATE TABLE [order_item] (
  [id_order] INT NOT NULL, 
  [amount] int NOT NULL, 
  CONSTRAINT [sqlite_autoindex_order_item_1] PRIMARY KEY ([id_order]));

INSERT INTO [order](id_order) VALUES(1);
INSERT INTO [order_item](id_order, amount) VALUES(1, 6);

Code: Select all

01 public void GetAmount(int idOrder, int? minAmount)
02 {
03   using (DBContext db = new DBContext())
04   {
05     var query = from o in db.Orders
06        from i in db.OrderItems.Where(i => i.IdOrder == i.IdOrder).DefaultIfEmpty()
07        where o.IdOrder == idOrder
08        select new { i.Amount, o.IdOrder };
09    
10     if (minAmount.HasValue)
11       query = query.Where(q => q.Amount > minAmount);
12    
13     foreach (var i in query)
14       Console.Write("Id order: " + i.IdOrder + "\t Amount: " + i.Amount);  
15 }
16  
17 GetAmount(1, 1);  
18 GetAmount(1, null);