ASP.NET MVC Crud Operation(delete)

G Y

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;

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar Singh9y ago

hey

public class FoodJournalEntities : DbContext {

public DbSet<Journal> Journals { get; set; }

public DbSet<JournalEntry> JournalEntries { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder) {

      modelBuilder.Entity<Journal>()

.HasOptional(j => j.JournalEntries)

.WithMany() .WillCascadeOnDelete(true);

base.OnModelCreating(modelBuilder); }