protected DbOperationStatus UpdateEntity <TE>(TE entity) where TE : class { var opStatus = new DbOperationStatus { OperationSuccessStatus = false, AffectedIndices = null }; try { DataContext.Set <TE>().Attach(entity); DataContext.Entry(entity).State = EntityState.Modified; opStatus.OperationSuccessStatus = DataContext.SaveChanges() > 0; } catch (Exception ex) { opStatus = DbOperationStatus.CreateFromException("Error updating " + entity.GetType(), ex); } return(opStatus); }
public DbOperationStatus ExecuteStoredProcedure(string command) { if (command == null) { throw new ArgumentException("The stored procedure must be provided"); } var opStatus = new DbOperationStatus { OperationSuccessStatus = false }; try { opStatus.OperationSuccessStatus = DataContext.Database.ExecuteSqlCommand(command) > 0; } catch (Exception ex) { opStatus = DbOperationStatus.CreateFromException("Error executing Stored Procedure", ex); } return(opStatus); }