title: Delete query not working
body: <p>I am using linq to delete data from database. I googled, and made query. I am using following query.</p>
  
  <p>When i put debugger over this, its not showing any error. Its going fine. But when I check my database , record does not gets delete.</p>
  
  <p>At the same time doing operation for insert:</p>
  
  <pre><code> splitTradeDataContext db = new splitTradeDataContext();
                      tradeFile tlbTradeFile = new tradeFile();
  
   tlbTradeFile.TradeNo = TradeNo + "_A";
                 tlbTradeFile.Status = Status;
                 tlbTradeFile.Scrip_Code = Scrip_Code;
                 tlbTradeFile.Inst_Type = Inst_Type;
                 tlbTradeFile.Expirydate = Expirydate;
                 tlbTradeFile.Strike_price = Strike_price;
                 tlbTradeFile.Option_type = Option_type;
                 tlbTradeFile.Sec_Name = Sec_Name;
                 tlbTradeFile.BookType = BookType;
                 tlbTradeFile.BookTypeName = BookTypeName;
                 tlbTradeFile.TerminalId = TerminalId;
                 tlbTradeFile.Branch_Id = Branch_Id;
                 tlbTradeFile.Buy_Sell = Buy_Sell;
                 tlbTradeFile.Trade_Qty = Trade_Qty;
                 tlbTradeFile.Market_Rate = Market_Rate;
                 tlbTradeFile.Pro_cli = Pro_cli;
                 tlbTradeFile.Party_Code = Party_Code + "_A";
                 tlbTradeFile.ParticipantCode = ParticipantCode;
                 tlbTradeFile.O_C_Flag = O_C_Flag;
                 tlbTradeFile.Sauda_Date = Sauda_Date;
                 tlbTradeFile.TradeModified = TradeModified;
                 tlbTradeFile.OrderNo = OrderNo;
                 tlbTradeFile.Opp_Broker_Id = Opp_Broker_Id;
                 tlbTradeFile.OrderTime = OrderTime;
                 tlbTradeFile.UnknowkNum = UnknowkNum;
  
   var remove = from aremove in db.tradeFiles
                where aremove.ID==int.Parse(gvTradeFile.SelectedRows[0].Cells[0].Value.ToString())
                select aremove;
   if(remove!=null)
      db.tradeFiles.DeleteAllOnSubmit(remove);
  </code></pre>
  
  <p>What can be problem? Am I using wrong query? Or any thing still remained from me?</p>