How to make a join in C #

I have a question, can I make a SQL statement (for example select * from T_TABELA) in my C # repository as in the database, but I would like to know if to make an order rejoin in C # how do I do at the bank?

I was trying this command, but still the error, what am I doing wrong?

select * from tblModelo join tblMarca mark template on marca.IdMarca = modelo.IdModelo;

In my SQL SERVER database, this command works!