I am trying to get data for a specific county ID using LINQ statement,
the query in SQL looks like this :

```
Select  Ads_ComputersID, AdTitle, AdDesc, CityID, CategoryID, Price
From [dbo].[Ads_Computers] where CityID in ( Select CityID from [dbo].[Cities] where [StateID] in (select StateID from [dbo].[States] where CountryID=10))

```

since I am still new to LINQ can you please help me to achieve this , and what is better to use LINQ or stored procedure with datasets?

another SQL way:

```
SELECT  A.Ads_ComputersID, A.AdTitle, A.AdDesc, A.CityID, A.CategoryID, A.Price
FROM [dbo].[Ads_Computers] A
LEFT JOIN [dbo].[Cities] C ON A.CityID=C.CityID
LEFT JOIN [dbo].[States] S ON S.StateID = C.StateID
WHERE S.CountryID=10

```

thanks and best regards