Top "Linq-to-sql" questions

Return anonymous type results?

Using the simple example below, what is the best way to return results from multiple tables using Linq to SQL? …

c# linq linq-to-sql

Multiple WHERE clause in Linq

I'm new to LINQ and want to know how to execute multiple where clause. This is what I want to …

linq linq-to-sql

How do you perform a left outer join using linq extension methods

Assuming I have a left outer join as such: from f in Foo join b in Bar on f.Foo_…

c# linq-to-sql lambda

LINQ - Left Join, Group By, and Count

Let's say I have this SQL: SELECT p.ParentId, COUNT(c.ChildId) FROM ParentTable p LEFT OUTER JOIN ChildTable c …

c# .net linq linq-to-sql

How to select only the records with the highest date in LINQ

I have a table, 'lasttraces', with the following fields. Id, AccountId, Version, DownloadNo, Date The data looks like this: 28092|15240000|1.0.7.1782|2009040004731|2009-01…

c# .net linq linq-to-sql

How to do a subquery in LINQ?

Here's an example of the query I'm trying to convert to LINQ: SELECT * FROM Users WHERE Users.lastname LIKE '%…

c# linq linq-to-sql

How to store a list in a column of a database table

So, per Mehrdad's answer to a related question, I get it that a "proper" database table column doesn't store a …

sql linq linq-to-sql database-design linq-to-entities

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

How would you rate each of them in terms of: Performance Speed of development Neat, intuitive, maintainable code Flexibility Overall …

sql linq-to-sql entity-framework ado.net linq-to-entities

What's the Linq to SQL equivalent to TOP or LIMIT/OFFSET?

How do I do this Select top 10 Foo from MyTable in Linq to SQL?

linq-to-sql

Understanding SQL Server LOCKS on SELECT queries

I'm wondering what is the benefit to use SELECT WITH (NOLOCK) on a table if the only other queries affecting …

sql-server tsql linq-to-sql