RSCG example–Query Generator–part 21

   

name	DatabaseToWebAPI
nuget	https://www.nuget.org/packages/QueryGenerator/
link	http://msprogrammer.serviciipeweb.ro/category/roslyn/
author	Andrei Ignat

This will generate code (WebAPI/Swagger) for any table/view from SqlServer. You can see the table via Angular   The code that you start with is

    //add queries.json with all the connection string and tables necessary

    //add in templates folder the files to generate controllers

    using RoslynQueryGenerator;

    using System.Collections.Generic;

    //TODO : modify namespace

    namespace WebFromQuery.Classes

    {

        public class FieldDescription

        {

            public string ItemName { get; set; }

            public string QueryName { get; set; }

    

            public string FieldName { get; set; }

            public string FieldType { get; set; }

    

            public SearchField DefaultValue { get; set; }

        }

        public class DisplayData

        {

            public string QueryName { get; set; }

            public string ItemName { get; set; }

            public FieldDescription[] FieldNames { get; set; }

            public Dictionary<string  , object="">[] Values { get; set; }

        }

      

    }

    

The code that you will use is

    //In Startup

    services.AddFactoryGenerated();

    app.UseDefaultFiles();

    app.UseStaticFiles();

   The code that is generated is

    //ApplicationDbContext : too much lines - see project

    //Controllers : too much lines - see project

Example Code: https://github.com/ignatandrei/RSCG_Examples/tree/main/QueryGenerator

All RSCG

Nr	Blog Post
1	RSCG–part 1
2	RSCG- AppVersion–part 2
3	http://msprogrammer.serviciipeweb.ro/2021/02/17/rsgc-enum-part-3/
4	RSGC-JSON to Class- part 4
5	RSGC-Constructor – Deconstructor – part 5
6	RSGC – DTO Mapper – part 6
7	RSGC – Skinny Controllers- part 7
8	RSGC-Builder Design Pattern – part 8
9	RSGC- MetadataFromObject – part 9
10	RSGC- Dynamic Mock – part 10
11	RSCG- Method Decorator – part 11
12	RSCG – Curry – Partial function – part 12
13	RSCG- part 13 – IFormattable
14	RSCG- part 14 – DP_Decorator
15	RSCG- part 15 – Expression Generator
16	RSCG- part 16 – Many Others
17	RSCG- the book
18	RSCG–Template Rendering- part 17
19	CI Version
20	HttpClientGenerator
21	Query from database
22	AutoRegister
23	TinyTypes
24	Static2Interface
25	AppSettings
26	Properties
27

Roslyn Source Code Generators