Advertisement

03.04.2008 at 02:20PM PST, ID: 23214268
[x]
Attachment Details

Linq Many to many group and sum

Asked by Mgreenway in Language Integrated Query - LINQ

Tags: Linq, C#, Firefox (doesnt really effect it)

I have 3 tables (that matter in my DB)

FantasyTeams
-FantasyTeamId PK
-TeamName

PitcherTeamMatrix
-MatrixId  PK
-FantasyTeamId
-PitcherId


Pitchers
-PitcherId
-PitcherName
-Wins


I am trying to get the sum of all wins for a specific FantasyTeam (i have the Id)
I just cant figure out how to go about it.

101 Linq samples just didnt clarify it for me...

Start Free Trial
 
Keywords: Linq Many to many group and sum
Title
1 Sum Query
2 Criteria in the Sum Field of a query
3 Sum in a query
4 SQL Coldfusion join and sum with wro…
5 Conditional sum in Crystal
6 SUM of Fields
 
Loading Advertisement...
 
[+][-]03.06.2008 at 09:09PM PST, ID: 21067509

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Language Integrated Query - LINQ
Tags: Linq, C#, Firefox (doesnt really effect it)
Sign Up Now!
Solution Provided By: Ceiled
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628