#linq-to-sql

How to: LINQ – Left Join, Group By, and Count #dev #development #answer

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 ON p.ParentId = c.ChildParentId GROUP BY p.ParentId

How can I translate this into LINQ to SQL? I got stuck at the COUNT(c.ChildId), the generated SQL always seems to output COUNT(*). Here’s what I got so far:

from p in context.ParentTable join c in…

How to: Learning about LINQ #computers #solution #dev

Learning about LINQ Overview

One of the things I’ve asked a lot about on this site is LINQ. The questions I’ve asked have been wide and varied and often don’t have much context behind them. So in an attempt to consolidate the knowledge I’ve acquired on Linq I’m posting this question with a view to maintaining and updating it with additional information as I continue to learn about LINQ.

I also…

Solution: LINQ-to-SQL vs stored procedures? #answer #fix #development

LINQ-to-SQL vs stored procedures?

I took a look at the “Beginner’s Guide to LINQ” post here on StackOverflow (http://stackoverflow.com/questions/8050/beginners-guide-to-linq), but had a follow-up question:

We’re about to ramp up a new project where nearly all of our database op’s will be fairly simple data retrievals (there’s another segment of the project which already writes the data). Most of…

Resolved: What's the Linq to SQL equivalent to TOP or LIMIT/OFFSET? #it #computers #answer

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?

Answer [by David Alpert]: What’s the Linq to SQL equivalent to TOP or LIMIT/OFFSET?

In VB:

from m in MyTable take 10 select m.Foo

This assumes that MyTable implements IQueryable. You may have to access that through a DataContext or some other provider.

It also assumes that…

How to: Is LINQ to SQL Dead or Alive?

Is LINQ to SQL Dead or Alive?

Just when I make friends with LINQ to SQL, it appears as though MS is pulling the rug out from under it.

http://blogs.msdn.com/adonet/archive/2008/10/29/update-on-linq-to-sql-and-linq-to-entities-roadmap.aspx

From my little bit of research, EF is way overkill for simple work. But after this announcement is there a point in continuing to use LINQ to SQL?

Beyond the…

How to: Random row from Linq to Sql

Random row from Linq to Sql

What is the best (and fastest) way to retreive a random row using Linq to SQL when I have a condition, e.g. some field must be true ?

Answer: Random row from Linq to Sql

EDIT: I’ve only just noticed this is LINQ to SQL, not LINQ to Objects. Use Marc’s code to get the database to do this for you. I’ve left this answer here as a potential point of interest for LINQ to…

How to: Case insensitive string compare in LINQ-to-SQL

Case insensitive string compare in LINQ-to-SQL

I’ve read that it’s unwise to use ToUpper and ToLower to perform case-insensitive string comparisons, but I see no alternative when it comes to LINQ-to-SQL. The ignoreCase and CompareOptions arguments of String.Compare are ignored by LINQ-to-SQL (if you’re using a case-sensitive database, you get a case-sensitive comparison even if you ask for a…

How to: How to compare only Date without Time in DateTime types in C#?

How to compare only Date without Time in DateTime types in C#?

Is there a way to compare 2 DateTime variables in Linq2Sql but to disregard the Time part.

The app stores items in the DB and adds a published date. I want to keep the exact time but still be able to pull by the date itself.

I want to compare 12/3/89 12:43:34 and 12/3/89 11:22:12 and have it disregard the actual time of day so both…