internal void DeleteFileFromSync(String guid) { using (MobeelizerDatabaseContext transaction = new MobeelizerDatabaseContext(this.ConnectionString)) { var query = from f in transaction.Files where f.Guid == guid select f; transaction.Files.DeleteAllOnSubmit(query); transaction.SubmitChanges(); } }
private void AddFile(String guid, String path, int modificationFlag) { using (MobeelizerDatabaseContext transaction = new MobeelizerDatabaseContext(this.ConnectionString)) { MobeelizerFilesTableEntity entity = new MobeelizerFilesTableEntity(); entity.Guid = guid; entity.Path = path; entity.Modyfied = modificationFlag; transaction.Files.InsertOnSubmit(entity); transaction.SubmitChanges(ConflictMode.FailOnFirstConflict); } }
internal MobeelizerOperationError UpdateEntitiesFromSync(IEnumerable <MobeelizerJsonEntity> entities, bool isAllSynchronization) { MobeelizerOperationError transactionErrors = null; using (MobeelizerDatabaseContext dataContext = new MobeelizerDatabaseContext(this.ConnectionString)) { if (isAllSynchronization) { foreach (var model in models.Values) { var table = dataContext.GetTable(model.Type); table.DeleteAllOnSubmit(from MobeelizerWp7Model record in table select record); } dataContext.ModelMetadata.DeleteAllOnSubmit(from m in dataContext.ModelMetadata select m); // TODO: check it //dataContext.Files.DeleteAllOnSubmit(from f in dataContext.Files select f); dataContext.SubmitChanges(); } foreach (MobeelizerJsonEntity entity in entities) { transactionErrors = models[entity.Model].UpdateFromSync(entity, dataContext); if (transactionErrors != null) { break; } } if (transactionErrors == null) { dataContext.SubmitChanges(); } } return(transactionErrors); }