linq-to-sql Archives - Page 2 of 2

What is the syntax for an inner join in LINQ to SQL?

I’m writing a LINQ to SQL statement, and I’m after the standard syntax for a normal inner join with an ON clause in ...

May 4, 2022
0 Comments

LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria

Consider the IEnumerable extension methods SingleOrDefault() and FirstOrDefault() MSDN documents that SingleOrDefault: Returns the only element of a sequence, or a default value ...

May 1, 2022
0 Comments

Entity Framework vs LINQ to SQL

Now that .NET v3.5 SP1 has been released (along with VS2008 SP1), we now have access to the .NET entity framework. My question ...

April 19, 2022
0 Comments

Returning IEnumerable vs. IQueryable

What is the difference between returning IQueryable<T> vs. IEnumerable<T>, when should one be preferred over the other? IQueryable<Customer> custs = from c in ...

April 14, 2022
0 Comments

Difference Between Select and SelectMany

I’ve been searching the difference between Select and SelectMany but I haven’t been able to find a suitable answer. I need to learn ...

April 13, 2022
0 Comments