RSCG example–Query Generator–part 21

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