C# LINQ Left Join

 
C# LINQ Left Join
 
from transaction in entity.Stock_Transaction
join stock in entity.Stock_Info on transaction.Stock_ID equals stock.Stock_ID into result
from result_stock in result.DefaultIfEmpty()
select new { transaction.Transaction_ID, transaction.User_ID, transaction.Stock_ID, result_stock.Stock_Name, result_stock.Stock_Category }