How to create left join query using Linq to sql

DataTable dt = new DataTable();

string sqlStatement1 = "select * from hsswith_view where cp_amount<='" + bug_amount + "' and no_of_days >='" + no_of_days + "'  or ep_amount<='" + bug_amount + "' and no_of_days >='" + no_of_days + "'";

SqlCommand sqlCmd1 = new SqlCommand(sqlStatement1,connection);
SqlDataAdapter sqlDa1 = new SqlDataAdapter(sqlCmd1);

          sqlDa1.Fill(dt1);
            var query = from r in dt1.AsEnumerable()
                        where r.Field<string>("pax") == no_person
                        select new
                        {
                            entry_id = r["entry_id"].ToString(),
                            pax = r["pax"].ToString(),
                            package = r["package"].ToString(),
                            no_of_days = r["no_of_days"].ToString(),
                            cp_amount = r["cp_amount"].ToString(),
                            ep_amount = r["ep_amount"].ToString()
                       };
            GridView1.DataSource = query;
            GridView1.DataBind();