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?