Top "Linq-to-sql" questions

LINQ to SQL is a component of .NET Framework version 3.5 that provides a run-time infrastructure for managing relational data as objects stored in Microsoft SQL Server.

Last and LastOrDefault not supported

I am trying to get the first and last values in a list. The query operator First() is supported but …

c# .net linq linq-to-sql
How to use union all in LINQ?

How to use union all in LINQ TO SQL. I have use the following code for union, then how to …

linq linq-to-sql union
How to inner join tables from different Data Context?

I have two tables from two different Data Contexts. Although both tables are from the same database, two separate datacontexts …

c# .net linq linq-to-sql inner-join
NOLOCK with Linq to SQL

Is it possible to get Linq2Sql to emit a NOLOCK in its SQL? And if so, how?

linq-to-sql
Compare nullable types in Linq to Sql

I have a Category entity which has a Nullable ParentId field. When the method below is executing and the categoryId …

c# linq-to-sql nullable
What is the difference between Entity Framework and LINQ to SQL by .NET 4.0?

I was checking 2nd edition of Professional ASP.NET MVC and realized EF replaced LINQ to SQL. I am familiar …

.net linq-to-sql entity-framework .net-4.0
Linq-to-SQL Timeout

I've been receiving an error on one of my pages that the linq query has timed out as it is …

c# asp.net linq-to-sql timeout
LINQ to SQL query where a string StartsWith an element from a generic list

I'm looking to update one of my queries as the requirements for the search has changed. Originally, the user was …

c# linq-to-sql startswith
LINQ with SQLite (linqtosql)

I have a small project that require a storage (I choose SQLite) and I got good result with the ADO …

linq linq-to-sql sqlite