Click here to Skip to main content
12,944,121 members (51,206 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
select cl.clientid,clad.address1,clad.address2 from Client cl 
join ClientAddress clad on cl.id=clad.clientguid
where clad.Address2 like '150%' and cl.clientid='650450'
Posted 6-Feb-13 3:59am
Updated 6-Feb-13 4:12am
digimanus59.8K
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Ugly one:

Even in LINQ you still can run sql queries. Example

IEnumerable<Customer> results = db.ExecuteQuery<Customer>
(@"SELECT c1.custid as CustomerID, c2.custName as ContactName
    FROM customer1 as c1, customer2 as c2
    WHERE c1.custid = c2.custid"
);



Good one:
Model your schema in designer, and you should not experience problems with righting.


Code will be smth like

var query = from cl in Client 
            join clad in ClientAddress on cl.id equals clad.clientguid
            where  cl.clientid='650450' && clad.Address2.StartsWith('150') 
            select new { l.clientid,clad.address1,clad.address2 }
;
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 4,653
CHill60 2,970
Maciej Los 2,388
Jochen Arndt 1,900
ppolymorphe 1,765


Advertise | Privacy | Mobile
Web01 | 2.8.170518.1 | Last Updated 6 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100