For example Table B (MessageParticipant) is having a foreign key relation ship with Table A (MessageInfo) then how to remove a record from Table B (MessageParticipant).
protected override SAF.Core.FrameworkResponse Delete()
{
SAF.Core.FrameworkResponse response = new SAF.Core.FrameworkResponse();
int result = 0;
string userid = ApplicationContext.UserContext.UserID;
using (FrameworkEntities entity = new FrameworkEntities(SAF.Core.Entity.ConnectionManager.GetEntityConnection(Constants.ModuleName)))
{
base.Entity.MessageParticipant.Where(u => u.ParticipantId == userid).Where(s => s.FolderId == entity.MessageFolder.Where(m => m.Name == "Trash").FirstOrDefault().Id).FirstOrDefault().IsDeleted = true;
entity.MessageInfo.Attach(base.Entity);
entity.Entry(base.Entity).State = System.Data.Entity.EntityState.Modified;
result = entity.SaveChanges();
}
if (result > 0)
{
response.Status = SAF.Common.Status.Success;
}
return response;
}