EF Core Sidekick: Using this extension for auto code generationWhat's NewSee What's New about EF Core Sidekick at https://docs.devmagic.com/efsidekick/#whats-new. IntroductionEF Core Sidekick is a Visual Studio extension that enhances the power of auto code generation in Visual Studio. It provides a set of tools and templates for generating EF Core entities and derived DbContext from existing database, and then generating DTOs (data transfer objects), services and REST APIs from the entities. What can you do with EF Core SidekickGenerate entities from an existing databaseAutomatically generates entities based on the tables, views, functions, or (SQL Server only) stored procedures in the existing database. While selecting tables, it is possible to enable or disable selection of associated tables and references. When generating entities, table inheritance relationship mappings (such as TPT) are supported. The class names, property names and code generation paths are customizable. Generate DTOs from an existing entitiesAutomatically generates a DTO (data transfer object) based on one or multiple selected entities. You can select whether to create a built-in DTO mapper, or use an external mapper, for mapping entities to DTOs and vice-versa. The DataContract attribute can be automatically added in the generated DTO class. Scaffold services and APIs from an entityScaffolds basic CRUD services and APIs based on entities auto-generated using this extension (EF Core Sidekick), entities generated using a third-party extension, or entities manually created. The newly generated APIs can quickly apply the existing authentication and authorization system. And sensitive data (such as passwords) can be auto-processed (hidden) in the APIs to ensure the data transmission security. Scaffold APIsScaffolds APIs based on existing interfaces or services. The newly generated APIs can quickly apply the existing authentication and authorization system. And sensitive data (such as passwords) can be auto-processed (hidden) in the APIs to ensure the data transmission security. Add custom codeThe custom code functionality allows you to modify or add code to the generated code to meet specific needs. You can use it address the incompatibility where the generated code from this extension does not perfectly align with the existing project code. Full-featured DevMagic StudioThe full-featured DevMagic Studio is available as a FREE standalone tool, which generates C# projects that are fully compatible with Visual Studio. Install DevMagic Studio to experience its full productivity features: https://www.devmagic.com. DevMagic Studio is a comprehensive suite of visual designers that help you simplify the creation of the enums, entities, data filters, services & APIs. Instead of paying attention to the syntax details you can now just focus on the real business. Designers for entities - Support standard, owned entity & entity inherence; Support entities relationships design; Configure data validation without writing LINQs Designers for Filters - Configure the filters without writing the LINQs; Configure multiple filters for each entity; Configure simple or complex filters. Designer for Services & APIs - Configure the services and APIs for each entity; Configure the sorting rule for database and output data; Add services with customized Filters; Easy to create new or inherit from an existing service. Code Customization - Add customized code snippets and enable easy integration with existing authorization framework. DocumentationFor EF Core Sidekick, see: https://docs.devmagic.com/efsidekick For the full-featured DevMagic Studio, see: https://docs.devmagic.com |