|
In a C# 2010 desktop application, I am trying to determine how to write the following sql statement via linq to sql:
select COUNT(Tran_ID) as good_count
from dbo.Trans t
inner join dbo.table1 iw on iw.pkg_id = t.pkg_id
inner join dbo.table2 ip on ip.pkg_id = iw.pkg_id
inner join dbo.table3 tt on tt.pkg_id = ip.cust_Number
where (t.cust_Date is not null) and
SUBSTRING(ip.item_Number,1,3) = 'UC3'
Thus can you tell me and/or point me to a reference I can use to determine how to write the above statement in linq to sql that connects to a sql server 2008 database?
|
|
|
|
|
I'm usually using the 101 LINQ samples[^], browsable online.
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
Nice! I don't have much experience with LINQ and that is something definitely worth bookmarking 
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
