how to write syntax(join tabl) using entity framework in mvc

Question

hello sir/mam,

 

 

 how to display the page where i selected the publish  only ..so how to write syntax 

 and  here is table below 

SELECT TOP 1000 [id]

,[Datetpublish]

,[statusid]

,[Title]

,[Author]

,[Content1]

FROM [blogstatus].[dbo].[Blogstatus]

 

 

SELECT TOP 1000 [statusid]

,[blogstatusname]

FROM [blogstatus].[dbo].[statusname]