Equivalent of SQL ISNULL in LINQ?

by

Since aa is the set/object that might be null, can you check aa == null ?

(aa / xx might be interchangeable (a typo in the question); the original question talks about xx but only defines aa)

i.e.

select new {
    AssetID = x.AssetID,
    Status = aa == null ? (bool?)null : aa.Online; // a Nullable<bool>
}

or if you want the default to be false (not null):

select new {
    AssetID = x.AssetID,
    Status = aa == null ? false : aa.Online;
}

Update; in response to the downvote, I’ve investigated more… the fact is, this is the right approach! Here’s an example on Northwind:

        using(var ctx = new DataClasses1DataContext())
        {
            ctx.Log = Console.Out;
            var qry = from boss in ctx.Employees
                      join grunt in ctx.Employees
                          on boss.EmployeeID equals grunt.ReportsTo into tree
                      from tmp in tree.DefaultIfEmpty()
                      select new
                             {
                                 ID = boss.EmployeeID,
                                 Name = tmp == null ? "" : tmp.FirstName
                        };
            foreach(var row in qry)
            {
                Console.WriteLine("{0}: {1}", row.ID, row.Name);
            }
        }

And here’s the TSQL – pretty much what we want (it isn’t ISNULL, but it is close enough):

SELECT [t0].[EmployeeID] AS [ID],
    (CASE
        WHEN [t2].[test] IS NULL THEN CONVERT(NVarChar(10),@p0)
        ELSE [t2].[FirstName]
     END) AS [Name]
FROM [dbo].[Employees] AS [t0]
LEFT OUTER JOIN (
    SELECT 1 AS [test], [t1].[FirstName], [t1].[ReportsTo]
    FROM [dbo].[Employees] AS [t1]
    ) AS [t2] ON ([t0].[EmployeeID]) = [t2].[ReportsTo]
-- @p0: Input NVarChar (Size = 0; Prec = 0; Scale = 0) []
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1

QED?

More Related Contents:

  1. convert sql query into lambda expression [closed]
  2. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  3. Is there a good LINQ way to do a cartesian product?
  4. LINQ to SQL – Left Outer Join with multiple join conditions
  5. linq case statement
  6. LINQ to SQL multiple tables left outer join
  7. Distinct in Linq based on only one field of the table
  8. Could not find an implementation of the query pattern
  9. Wildcard search for LINQ
  10. Get an IDataReader from a typed List
  11. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  12. Entity Framework. Delete all rows in table
  13. Use linq to generate direct update without select
  14. Join and Include in Entity Framework
  15. How to make LINQ execute a (SQL) LIKE range search
  16. Calling a SQL User-defined function in a LINQ query
  17. Issues Doing a String Comparison in LINQ
  18. Convert SQL to LINQ Query [closed]
  19. Linq To Sql compare Time only
  20. Linq union usage?
  21. LINQ’s Distinct() on a particular property
  22. LINQ Grouping dynamically
  23. Linq list of lists to single list
  24. linq where list contains any in list
  25. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  26. Entity Framework 6 Code First Custom Functions
  27. Merge multiple Lists into one List with LINQ
  28. Order by dynamic parameter
  29. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  30. LINQ: differences between single Where with multiple conditions and consecutive Wheres with single condition [duplicate]

Leave a Comment