>public void UpdateTemplatesList(List<TemplatesList> listToChange) > { > DbContext db = (DbContext)_siriusContext; > db.Configuration.AutoDetectChangesEnabled = false; > > foreach (var row in listToChange) > { > EntityState entityState = _siriusContext.GetEntityState(row); > if (entityState != EntityState.Detached) > { > if (row.TemplateId == 0) > _siriusContext.SetAdd(row); > else > _siriusContext.SetModified(row); > } > else > { > if (row.TemplateId == 0) > _dbSetList.Add(row); // Todo - Add INSTEAD OF Insert trigger > else > _dbSetList.Attach(row); > _siriusContext.SetModified(row); > } > } > > db.Configuration.AutoDetectChangesEnabled = true; > > SaveChanges(); > } > }>
>CREATE view [dbo].[SiriusV_TemplatesList] WITH SCHEMABINDING >as >select t.TemplateID, > t.Descrip, > t.Hidden, > t.TmplType, > t.Prescedenc, > t.Dw > from dbo.template t >; > > >GO > >create trigger trChangeTemplatesList ON dbo.SiriusV_TemplatesList INSTEAD OF UPDATE >AS > BEGIN > SET NOCOUNT ON; > update dbo.template set prescedenc = I.prescedenc > from inserted I > END > > GO>