Posted on: 11/6/2014 11:37:09 AM | Views : 437

Hello,
        Var gethiddenext contains no. of extension that are to be hidden.         Var query  contains all the rows of table Messagetransaction         Both the table include ExtensionNo Field.         I want such a record from query variable that doesn't contains the record of the extensions that are under gethiddenext. var gethiddenext = dal.GetHiddenDtl(); var gethiddennumbers = from sa in gethiddenext select sa.CallerId; var query = from g in db.MessageTransactions where (Convert.ToDateTime(g.MessageDate) >= Convert.ToDateTime(strFromDate) && Convert.ToDateTime(g.MessageDate) <= Convert.ToDateTime(strTodate)) select new { g.MessageID, g.ChannelNo, g.ExtensionNo, g.MessageFileN ...

Go to the complete details ...