public cachivache AddCachivache(cachivache item) { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted, Timeout = new TimeSpan(1, 0, 0) })) { using (RinconDataContext db = new RinconDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString)) { var entity = Convert(item); db.Cachivaches.InsertOnSubmit(entity); try { db.SubmitChanges(ConflictMode.ContinueOnConflict); scope.Complete(); } catch (ChangeConflictException ex) { Trace.TraceError(ex.SerializeForLog(db)); // All database values overwrite current values. foreach (ObjectChangeConflict occ in db.ChangeConflicts) occ.Resolve(RefreshMode.OverwriteCurrentValues); throw ex; } catch (DbException ex) { Trace.TraceError(ex.Message); throw ex; } return Convert(entity); } } }
public cachivache[] GetAll() { using (RinconDataContext db = new RinconDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString)) { var all = from c in db.Cachivaches select Convert(c); return all.ToArray(); } }
public void DeleteCachivache(Guid id) { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted, Timeout = new TimeSpan(1, 0, 0) })) { using (RinconDataContext db = new RinconDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString)) { var entity = db.Cachivaches.First(delegate(Cachivache match) { return match.id == id; }); db.Cachivaches.DeleteOnSubmit(entity); } } }
public void UpdateCachivache(cachivache item) { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted, Timeout = new TimeSpan(1, 0, 0) })) { using (RinconDataContext db = new RinconDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString)) { var entity = db.Cachivaches.First(delegate(Cachivache match) { return match.id == item.id; }); entity.name = item.name; entity.description = item.description; entity.categoryId = item.category; entity.price = item.price; entity.createdBy = item.createdBy; entity.createdDate = item.createdDate; entity.lastUpdate = item.lastUpdate; entity.lastUpdatedBy = item.lastUpdatedBy; try { db.SubmitChanges(ConflictMode.ContinueOnConflict); scope.Complete(); } catch (ChangeConflictException ex) { Trace.TraceError(ex.SerializeForLog(db)); // All database values overwrite current values. foreach (ObjectChangeConflict occ in db.ChangeConflicts) occ.Resolve(RefreshMode.OverwriteCurrentValues); throw ex; } catch (DbException ex) { Trace.TraceError(ex.Message); throw ex; } } } }
public cachivache GetCachivache(Guid id) { using (RinconDataContext db = new RinconDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString)) { var query = from c in db.Cachivaches where c.id == id select Convert(c); return query.FirstOrDefault(); } }