Top "Linq-to-sql" questions

LINQ: combining join and group by

I have a query that combines a join and a group, but I have a problem. The query is like: …

c# linq linq-to-sql join group-by

LINQ-to-SQL vs stored procedures?

I took a look at the "Beginner's Guide to LINQ" post here on StackOverflow (Beginners Guide to LINQ), but had …

linq linq-to-sql stored-procedures

Update using LINQ to SQL

How can I update a record against specific id in LINQ to SQL?

linq linq-to-sql

Max or Default?

What is the best way to get the Max value from a LINQ query that may return no rows? If …

c# .net linq linq-to-sql

Can I return the 'id' field after a LINQ insert?

When I enter an object into the DB with Linq-to-SQL can I get the id that I just inserted without …

c# .net linq linq-to-sql

efficient way to implement paging

Should I use LINQ's Skip() and Take() method for paging, or implement my own paging with a SQL query? Which …

sql sql-server asp.net-mvc linq-to-sql pagination

Linq to Sql: Multiple left outer joins

I'm having some trouble figuring out how to use more than one left outer join using LINQ to SQL. I …

vb.net linq linq-to-sql tsql left-join

How do I get the MAX row with a GROUP BY in LINQ query?

I am looking for a way in LINQ to match the follow SQL Query. Select max(uid) as uid, Serial_…

.net linq linq-to-sql

Apply properties values from one object to another of the same type automatically?

Given 2 objects A and B of type T, I want to assign the properties' values in A to the same …

c# linq-to-sql

LINQ to SQL Where Clause Optional Criteria

I am working with a LINQ to SQL query and have run into an issue where I have 4 optional fields …

c# asp.net linq linq-to-sql