Help with LINQ

Question

Hello everyone!

I'm learning LINQ to SQL and I need help.

 

These are my tables into my DB 'Cars'.

Producer:

(IDVehicle,IDProducer,Producer,Summer,Winter)

Vehicle:

(IDVehicle,Vehicle)

Summer:

(IDProducer,Profile,Dimension,Tracing,Cost with PDV)

Winter:

(IDProducer,Profile,Dimension,Tracing,Cost with PDV)

I have simple web app,where User can choose Vehicle than Producer in comboBox,

also Summer or winter tires.I need when user clic on button to get view of data from database.

For example:

profile80

145/80 R13

ECO 3

89,66 $

I'm trying to do this with Linq to SQL.

I added 'LINQ to SQL Classes.