Top "Linq-to-sql" questions

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 …

c# .net sql linq-to-sql join

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 …

c# linq-to-sql linq

Convert Linq Query Result to Dictionary

I want to add some rows to a database using Linq to SQL, but I want to make a "custom …

c# linq linq-to-sql todictionary

How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?

Is there a way to compare two DateTime variables in Linq2Sql but to disregard the Time part. The app …

c# .net database entity-framework linq-to-sql

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 …

.net linq linq-to-sql

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 …

.net entity-framework linq-to-sql

How to do Select All(*) in linq to sql

How do you select all rows when doing linq to sql? Select * From TableA In both query syntax and method …

linq-to-sql

Returning IEnumerable<T> vs. IQueryable<T>

What is the difference between returning IQueryable<T> vs. IEnumerable<T>, when should one be preferred …

c# linq linq-to-sql ienumerable iqueryable

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

I've been using this piece of code I've written and it's working in this most unclear manner. I wish to …

asp.net linq-to-sql sql-server-2008

LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?

Given: A table named TABLE_1 with the following columns: ID ColumnA ColumnB ColumnC I have SQL query where TABLE_1 joins …

c# linq-to-sql left-join multiple-columns