title: Stored Procedure for Deleting a Record from three tables
body: <p>I am new to stored procedure so i need very much help from you folks,I have three tables Event_Session,Event_Speaker,Session_Speaker. I want to delete Event_Session Record by passing Event_session_id it should also  delete Session_Speaker and Event_Speaker Record simultaneously, Pls help me in this ! Here are the tables</p>
  <p><strong>Event_Session</strong>(Table With fields)</p>
  <blockquote>
  <p>Event_Session_Id,    Session_name,     Session_Description,    Tags</p>
  <p>Navigation Properties: <strong>Session_Speaker</strong></p>
  </blockquote>
  <p><strong>Session_Speaker</strong>(Table With fields)</p>
  <blockquote>
  <p>Event_Session_Id,    Event_Speaker_Id,  created_date</p>
  <p>Navigation properties: <strong>Event_Session , Event_Speaker</strong></p>
  </blockquote>
  <p><strong>Event_Speaker</strong>(Table With fields)</p>
  <blockquote>
  <p>Event_Speaker_Id,    Speaker_name,    Created_date</p>
  <p>Navigation Properties : <strong>Session_Speaker</strong></p>
  </blockquote>