public List <SP_GetAddressListToBindGrid_Result> GetAddressByObjectNameReferenceID(string SourceObjectName, long ReferenceID, string TargetObjectName, string SessionID, string UserID, string[] conn) { List <SP_GetAddressListToBindGrid_Result> AddressList = new List <SP_GetAddressListToBindGrid_Result>(); BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); AddressList = (from sp in db.SP_GetAddressListToBindGrid(SourceObjectName, ReferenceID) orderby sp.Sequence where sp.Active != "Y" // active=isArchive select sp).ToList(); SaveTempDataToDB(AddressList, SessionID, UserID, TargetObjectName, conn); return(AddressList); }