{"draftJsState":{"blocks":[{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":11,"offset":0,"style":"BOLD"}],"text":"1. Введение","type":"header-two","key":"1rpc7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":10,"offset":313,"style":"BOLD"}],"text":"При работе с Avalonia и Entity Framework Core (EF Core) часто требуется вручную редактировать сгенерированные модели, добавляя аннотации [JsonIgnore] к навигационным свойствам, чтобы избежать проблем с сериализацией в JSON. Однако, если моделей много, делать это вручную неудобно.\nРешением является использование T4-шаблона – мощного инструмента автоматической генерации кода.","type":"unstyled","key":"5hn40"},{"data":{"image":{"id":"67b3579eb3f1166ef52a26bd"}},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"atomic:image","key":"1ilmv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":36,"offset":4,"style":"BOLD"}],"text":"T4 (Text Template Transformation Toolkit) позволяет автоматически изменять код перед его компиляцией. В нашем случае он:","type":"unstyled","key":"88rm3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Находит файлы моделей.","type":"unordered-list-item","key":"fj3hm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Определяет навигационные свойства (public virtual).","type":"unordered-list-item","key":"eir84"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Добавляет к ним [JsonIgnore], если его еще нет.","type":"unordered-list-item","key":"b6d67"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вставляет using Newtonsoft.Json;, если он отсутствует.","type":"unordered-list-item","key":"b1jct"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Это особенно полезно, если вы обновляете модели через dotnet ef dbcontext scaffold, так как при каждом обновлении EF Core перезаписывает файлы.","type":"unstyled","key":"2q1jm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":32,"offset":0,"style":"BOLD"}],"text":"2. Установка необходимых пакетов","type":"header-two","key":"fdmhc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Перед началом работы установим нужные пакеты NuGet:","type":"unstyled","key":"e6iq0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dotnet add package Microsoft.EntityFrameworkCore.Design","type":"blockquote","key":"9gab5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL","type":"blockquote","key":"crgfv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Microsoft.EntityFrameworkCore.Design – для генерации моделей.","type":"unordered-list-item","key":"bcjq7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Npgsql.EntityFrameworkCore.PostgreSQL – для работы с PostgreSQL.","type":"unordered-list-item","key":"cv6rd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":20,"offset":0,"style":"BOLD"}],"text":"3. Генерация моделей","type":"header-two","key":"eku7p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Для работы с Entity Framework Core и генерации моделей из базы данных необходимо установить глобальный инструмент dotnet-ef. Выполните следующую команду:","type":"unstyled","key":"avel1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dotnet tool install --global dotnet-ef","type":"blockquote","key":"2vksj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Теперь создадим модели, используя dotnet ef dbcontext scaffold:","type":"unstyled","key":"cpvlv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dotnet ef dbcontext scaffold \"Host=0.0.0.0;Username=postgres;Password=password;Database=DataBaseName\" Npgsql.EntityFrameworkCore.PostgreSQL --output-dir --force","type":"blockquote","key":"b891l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":12,"offset":0,"style":"BOLD"}],"text":"--output-dir указывает, куда сохранять файлы моделей.","type":"unordered-list-item","key":"6v5s4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":7,"offset":0,"style":"BOLD"}],"text":"--force позволяет перезаписать существующие модели, если они уже есть.","type":"unordered-list-item","key":"dnlkc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":22,"offset":0,"style":"BOLD"}],"text":"4. Создание T4-шаблона","type":"header-two","key":"4341f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":9,"offset":57,"style":"BOLD"}],"text":"Чтобы автоматизировать добавление [JsonIgnore], создадим T4-шаблон.","type":"unstyled","key":"8lvjg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":26,"offset":0,"style":"BOLD"}],"text":"4.1. Добавляем T4 в проект","type":"header-three","key":"9rfa0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":13,"offset":2,"style":"BOLD"},{"length":13,"offset":35,"style":"BOLD"}],"text":"В Visual Studio создаем новый файл Text Template (.tt).","type":"ordered-list-item","key":"djhll"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вставляем в него следующий код:","type":"ordered-list-item","key":"d8drr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ template debug=\"false\" hostspecific=\"false\" language=\"C#\" #>","type":"blockquote","key":"ctscp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ assembly name=\"System.Core\" #>","type":"blockquote","key":"4aaes"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ import namespace=\"System.Linq\" #>","type":"blockquote","key":"eu3h8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ import namespace=\"System.Text\" #>","type":"blockquote","key":"eftf8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ import namespace=\"System.Collections.Generic\" #>","type":"blockquote","key":"apgkt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ output extension=\".txt\" #>","type":"blockquote","key":"8k4cb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"// Нужно к стандартным добавить следующее","type":"blockquote","key":"2dr6m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ output extension=\".cs\" #>","type":"blockquote","key":"afhf4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ assembly name=\"System.IO\" #>","type":"blockquote","key":"coeio"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ import namespace=\"System\" #>","type":"blockquote","key":"bhagn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ import namespace=\"System.IO\" #>","type":"blockquote","key":"9ndol"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ import namespace=\"System.Text.RegularExpressions\" #>","type":"blockquote","key":"bfsdr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#@ assembly name=\"System.Text.RegularExpressions\" #>","type":"blockquote","key":"fkt9p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"<#","type":"blockquote","key":"17mjk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"var directoryPath = @\"C:\\Users\\manakov\\source\\repos\\Test\\Test\\Models\";","type":"blockquote","key":"frqam"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"var files = Directory.GetFiles(directoryPath, \"*.cs\");","type":"blockquote","key":"9t3bc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"foreach (var file in files)","type":"blockquote","key":"dbgp7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"{","type":"blockquote","key":"4qnoo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"var fileContent = File.ReadAllText(file);","type":"blockquote","key":"1f985"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"// Добавление using и JsonIgnore для свойств","type":"blockquote","key":"8thkr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"if (!fileContent.StartsWith(\"using Newtonsoft.Json;\"))","type":"blockquote","key":"eau2g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"fileContent = \"using Newtonsoft.Json;\\n\" + fileContent;","type":"blockquote","key":"4h9nc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"fileContent = Regex.Replace(fileContent, @\"public\\s+virtual\\s+(\\w+\\??)\\s+(\\w+)\\s*\\{\",","type":"blockquote","key":"a6j2s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"match => fileContent.Contains($\"[JsonIgnore] {match.Value}\") ? match.Value : $\"[JsonIgnore] {match.Value}\");","type":"blockquote","key":"13sgb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"File.WriteAllText(file, fileContent);","type":"blockquote","key":"6v40r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"}","type":"blockquote","key":"5i6te"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"#>","type":"blockquote","key":"7e1n6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":27,"offset":0,"style":"BOLD"}],"text":"4.2. Как работает этот код?","type":"header-three","key":"ftcpt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":27,"offset":0,"style":"BOLD"}],"text":"Определяет папку с моделямиdirectoryPath содержит путь к папке с .cs-файлами моделей.","type":"ordered-list-item","key":"7ioj3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":18,"offset":0,"style":"BOLD"}],"text":"Читает каждый файлFile.ReadAllText(file) загружает содержимое модели.","type":"ordered-list-item","key":"8lnj2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":32,"offset":0,"style":"BOLD"}],"text":"Добавляет using Newtonsoft.Json;Проверяет, есть ли using Newtonsoft.Json;, и если нет — добавляет.","type":"ordered-list-item","key":"f72vm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":27,"offset":0,"style":"BOLD"}],"text":"Ищет навигационные свойстваpublic virtual означает, что свойство связано с другой моделью.\nЕсли [JsonIgnore] еще нет, он добавляется перед свойством.","type":"ordered-list-item","key":"4b64"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":33,"offset":0,"style":"BOLD"}],"text":"Перезаписывает файл с изменениями","type":"ordered-list-item","key":"297bp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":22,"offset":0,"style":"BOLD"}],"text":"4.3. Запуск T4-шаблона","type":"header-three","key":"eti2t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":13,"offset":2,"style":"BOLD"}],"text":"В Visual Studio нажмите Ctrl + S (или правой кнопкой по .tt → Run Custom Tool).","type":"unordered-list-item","key":"fq4e0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Файлы моделей автоматически обновятся.","type":"unordered-list-item","key":"d25sl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":37,"offset":0,"style":"BOLD"}],"text":"5. Использование контекста в Avalonia","type":"header-two","key":"65v06"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"В файле App.axaml.cs добавляем статический экземпляр контекста БД:","type":"unstyled","key":"7419j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"public static CrudContext DB = new CrudContext();","type":"blockquote","key":"4leto"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":7,"offset":0,"style":"BOLD"}],"text":"6. Итог","type":"header-two","key":"eco2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":17,"offset":66,"style":"BOLD"},{"length":38,"offset":121,"style":"BOLD"},{"length":34,"offset":187,"style":"BOLD"},{"length":35,"offset":224,"style":"BOLD"}],"text":"Теперь у вас есть автоматизированный процесс работы с моделями: ✅ Генерация моделей через dotnet ef dbcontext scaffold\n✅ Автоматическое добавление [JsonIgnore] в навигационные свойства\n✅ Обновление всех моделей за секунды\n✅ Готовый к использованию контекст БД","type":"unstyled","key":"cio9f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Этот подход значительно ускоряет разработку и избавляет от ручных правок при каждом обновлении моделей.","type":"unstyled","key":"bv1qi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Мои соцсети","type":"header-two","key":"104ja"},{"data":{},"depth":0,"entityRanges":[{"key":0,"length":23,"offset":8}],"inlineStyleRanges":[{"length":31,"offset":0,"style":"ITALIC"}],"text":"GitHub: https://github.com/c3n9","type":"unstyled","key":"9fdbe"},{"data":{},"depth":0,"entityRanges":[{"key":1,"length":31,"offset":6}],"inlineStyleRanges":[{"length":6,"offset":0,"style":"ITALIC"}],"text":"Habr: https://habr.com/ru/users/c3n9/","type":"unstyled","key":"4otel"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"marker","key":"pMhF6IlDAVKtJxnlQL5f"}],"entityMap":{"0":{"data":{"url":"https://dzen.ru/away?to=https%3A%2F%2Fgithub.com%2Fc3n9"},"mutability":"MUTABLE","type":"LINK"},"1":{"data":{"url":"https://dzen.ru/away?to=https%3A%2F%2Fhabr.com%2Fru%2Fusers%2Fc3n9%2F"},"mutability":"MUTABLE","type":"LINK"}}},"mentions":[]}