Devart Forums

Code: Select all

            var sdt = new CrmDemoContextSQLite.CrmDemoDataContextSQLite();
            sdt.Connection.Open();

            // In my project, then calculated value. For simplicity, wrote this in an example.
            bool bIsGeneralUser = true;

            var query = from o in sdt.Orders
                        from c in o.Customers.Where(c => bIsGeneralUser || (c.Name == "test"))
                        select new
                            {
                                o.OrderID,
                                c.Name
                            };

            dataGridView1.DataSource = query;

Code: Select all

var col1 = sdt.Orders;
var col2 = from c in col1
           join o in sdt.CustomersOrders on c.OrderID equals o.OrdersOrderID
           select o;

var col3 = from c in col2
           join o in sdt.Customers on c.CustomersCustomerId equals o.CustomerId
           select new {
                       c.Order.OrderID,
                       o.Name
                       };

Code: Select all

SELECT t1.OrderID AS OrderID, J1.Name AS Name
FROM "main".Orders t1
CROSS JOIN ("main".Customers t2
    INNER JOIN "main".Customers_Orders t3 ON t3.Customers_CustomerId = t2.CustomerId) J1
WHERE (t1.OrderID = J1.Orders_OrderID) AND (:p0 OR (J1.Name = :p1))