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.

How to return anonymous type from c# method that uses LINQ to SQL

Possible Duplicate: LINQ to SQL: Return anonymous type? I have a standard LINQ to SQL query, which returns the data …

c# linq linq-to-sql anonymous-types
Entity Framework/Linq to SQL: Skip & Take

Just curious as to how Skip & Take are supposed to work. I'm getting the results I want to see …

c# .net linq-to-sql sql-server-2008 entity-framework-4
How can you handle an IN sub-query with LINQ to SQL?

I'm a bit stuck on this. Basically I want to do something like the following SQL query in LINQ to …

sql linq linq-to-sql
Instantiate empty IQueryable for use with Linq to sql

I need to be able to either have an optional parameter in a Linq query, or be able to assign …

c# asp.net-mvc linq linq-to-sql iqueryable
Best way for retrieving single record results in LINQ to SQL

If I query a table with a condition on the key field as in: var user = from u in dc.…

linq linq-to-sql
Linq-to-SQL ToDictionary()

How do I properly convert two columns from SQL (2008) using Linq into a Dictionary (for caching)? I currently loop through …

c# linq linq-to-sql
How to create a LINQ to SQL Transaction?

I have a piece of code that involves multiple inserts but need to execute submitchanges method before I finish inserting …

.net linq-to-sql transactions
Get sum of two columns in one LINQ query

let's say that I have a table called Items (ID int, Done int, Total int) I can do it by …

c# .net linq linq-to-sql sum
Missing LINQ to SQL Classes (DBML designer) in Visual Studio 2017 RC

How can I add LINQ to SQL class (.dbml file) to Visual Studio 2017 RC. I can't find it. Please help, …

linq-to-sql visual-studio-2017
Random row from Linq to Sql

What is the best (and fastest) way to retrieve a random row using Linq to SQL when I have a …

c# .net linq-to-sql