keeper013 / oasis.efmapper Goto Github PK

CreateInitialFolderAndFileStructure();

var root = _mapper.GetFolders().FirstOrDefault();

root.Files.RemoveAt(1);

_mapper.AddOrUpdateFolder(root);

        public void AddOrUpdateFolder(FolderDTO folderDTO)
        {
            using (var context = new FileSystemEntities())
            {
                _dbMapper.DatabaseContext = context;
                _dbMapper.StartSession();
                var mapperTask = _dbMapper.MapAsync<FolderDTO, Folder>(folderDTO, p => p.Include(f => f.Files));
                mapperTask.Wait();
                _dbMapper.StopSession();

                context.SaveChanges();
            }
        }

        public MyEFMapper()
        {
            _dbMapper = new MapperBuilderFactory()
            .MakeMapperBuilder()
                .Configure<FolderDTO>()
                    .SetIdentityPropertyName(nameof(FolderDTO.Id))
                    .Finish()
                .Configure<Folder>()
                    .SetIdentityPropertyName (nameof(Folder.Id))
                    .Finish()
                .Configure<FileDTO>()
                    .SetIdentityPropertyName(nameof(FileDTO.Id))
                    .Finish()
                .Configure<File>()
                    .SetIdentityPropertyName(nameof(File.Id))
                    .ExcludePropertiesByName(nameof(File.Folder), nameof(File.FolderId))
                    .Finish()
            .Register<FolderDTO, Folder>(MapType.Upsert)
            .Register<FileDTO, File>(MapType.Upsert)
            .Build()
            .MakeToDatabaseMapper();

            _memoryMapper = new MapperBuilderFactory()
            .MakeMapperBuilder()
            .Register<Folder, FolderDTO>()
            .Register<Label, LabelDTO>()
            .Build()
            .MakeToMemoryMapper();
        }

USE [FileSystem]
GO

-- Create a table for FileSystemBase
CREATE TABLE FileSystemBase (
    Id INT IDENTITY(1,1) PRIMARY KEY,
    ObjectId uniqueidentifier NOT NULL, 
    Name VARCHAR(255)
);

-- Create a table for Folders
CREATE TABLE Folder (
    Id INT PRIMARY KEY REFERENCES FileSystemBase(Id),
    ParentFolderId INT NULL FOREIGN KEY REFERENCES Folder(Id),
);

-- Create a table for Files
CREATE TABLE [File] (
    Id INT PRIMARY KEY REFERENCES FileSystemBase(Id),
    Size INT,
    FolderId INT NOT NULL FOREIGN KEY REFERENCES Folder(Id) ON DELETE CASCADE,
  
);

-- Create a table for FileDetails
CREATE TABLE [FileDetail] (
    Id INT IDENTITY(1,1) PRIMARY KEY,
    ObjectId uniqueidentifier NOT NULL,
    [Key] VARCHAR(255),
    [Value] VARCHAR(255),
    FileId INT FOREIGN KEY REFERENCES [File](Id) ON DELETE CASCADE,
);

-- Create a table for Labels
CREATE TABLE Label (
    Id INT IDENTITY(1,1) PRIMARY KEY,
    ObjectId uniqueidentifier NOT NULL,
    Name VARCHAR(255)
);

-- Create a junction table for Folder-Label relationship
CREATE TABLE FolderLabel (
    FolderId INT NOT NULL,
    LabelId INT NOT NULL,
    PRIMARY KEY (FolderId, LabelId),
    FOREIGN KEY (FolderId) REFERENCES Folder(Id) ON DELETE CASCADE,
    FOREIGN KEY (LabelId) REFERENCES Label(Id) ON DELETE CASCADE
);

-- Create a junction table for File-Label relationship
CREATE TABLE FileLabel (
    FileId INT NOT NULL,
    LabelId INT NOT NULL,
    PRIMARY KEY (FileId, LabelId),
    FOREIGN KEY (FileId) REFERENCES [File](Id) ON DELETE CASCADE,
    FOREIGN KEY (LabelId) REFERENCES Label(Id) ON DELETE CASCADE
);