public List <DBObjChanges> getUniqueGITCommittablesByFolder(LocalRepoFolder locfldr) { using (var db = new DBChangesAuditEntities()) { return(db.DBObjChanges.Where(q => q.BatchID == null).Where(q => q.BatchID == null && q.DBObjType == locfldr.DBObjType && q.DatabaseName == locfldr.DatabaseName && q.SchemaName == locfldr.SchemaName) .OrderBy(o => o.ObjectName).ThenBy(o => o.ID) .ToList()); } }
public List <LocalRepoFolder> getUniqueFolders() { using (var db = new DBChangesAuditEntities()) { return(db.DBObjChanges.Where(q => q.BatchID == null) .GroupBy(g => new { g.DBObjType, g.DatabaseName, g.SchemaName }) .Select(s => new LocalRepoFolder { DBObjType = s.Key.DBObjType, DatabaseName = s.Key.DatabaseName, SchemaName = s.Key.SchemaName }) .ToList()); } }
public void saveGITCommittable(DBObjChanges doc) { using (var db = new DBChangesAuditEntities()) { var result = db.DBObjChanges.SingleOrDefault(q => q.ID == doc.ID); if (result != null) { result.WritingToGIT = doc.WritingToGIT; result.BatchID = doc.BatchID; result.GitLink = doc.GitLink; db.SaveChanges(); } } }