Documentation

YouGen Sharp generates C# and Javascript codebases for .Net 6 and 7. See the below links for more information about implemented features:

Software Development Kit components:

Primary

• • .NET 6/7 C#
  • Entity Framework Core
  • Integration Testing
  • MSTest Unit Testing

Servers and Clients

• • ASP.NET Core Web API (HTTP server and client)
  • CoreWCF (SOAP/WSDL server and client)
  • SignalR (Websocket realtime server and client)
  • Javascript (HTTP client)

User Interfaces

• • ASP.NET Core Blazor (Webassembly)
  • .NET MAUI (Multi-platform App UI for desktop and mobile)

Concepts:

• • Clean Architecture
  • Data and Reference Mocking
  • Data Encryption
  • Data Fuzzing
  • Data Transfer Object Hydration and Copy Constructor
  • Dependency Injection
  • Interfaces
  • Indirect References
  • Microservices
  • Model Validation
  • Repository Pattern
  • WebAssembly

Third Party Libraries:

• • Axios Http Client in Javascript
  • Blazored libraries
  • Coverlet Collector
  • Dapper
  • Entity Framework Plus
  • Fluent Validation
  • Json.NET
  • Moq
  • Mudblazor
  • Swagger Swashbuckle
  • Tynamix ObjectFiller.NET

Requirements:

General

• • Windows 10/11 x64 Service patch level 21H2 (10.0.19041) or greater
  • .NET 6 SDK x64
  • .NET 7 SDK x64
  • Visual Studio 2022 Patch level 17.5.0 or greater

For SQL Server Database Targets

• • SQL Server Management Studio 18 or greater

For Oracle Database Targets

• • Oracle Developer Tools for Visual Studio 2022
  • Oracle Instant Client for Windows x64

Limitations:

Database Schema Parsing Limitations

We advise you run the following scripts against your relational databases to determine their level of readiness for YouGen Sharp. Scripts can be found by clicking here.

SQL Server

• • • • Tables must have Primary Keys.
      • Tables must not have multiple indexes which each use the same list of columns.
      • Column datatypes of XML and JSON are treated as NVARCHAR types.
      • Nondeterministic column datatypes of HierarchyID, SqlSpatial (Geometry and Geography subtypes) are not supported and must be mapped manually.
      • User-Defined datatypes may not map correctly.
      • Stored Procedures which contain conditional statements, temporary tables, memory tables may not correctly map query outputs to CLR Entities and must be mapped manually
      • *(General Architectural Advice: if your stored procedures do not map correctly, you probably are putting too much complexity/business logic in them. Business logic should be contained in .NET classes.)
      • Stored Procedures map best when their names are defined with square bracket syntax, when each statement is terminated with a semicolon, and the are whole procedure is terminated with a GO statement.
      • Functions are not mapped.

Oracle

• • • • Procedures and Functions must be contained within Package definitions in order to be mapped.
      • Custom Types, Queues, Synonyms, Java, and XML Schemas are not supported.
      • Kerberos authentication to Database Server is not supported.

Generated Solution Limitations

• • • Object Hydrators for object graphs containing circular table self-references will not fill past the primary level of hierarchy.
    • Authentication/Authorization/Roles/Access for all servers and clients is NOT implemented by YouGen Sharp. Every organization has their own security choices and protocols and you will need to implement those manually to secure your application ecosystem.
    • Global Exception Handling has been implemented for all server workflows, but detailed, bespoke error handling will be up to you.
    • Javascript client testing and front end integration testing in general are areas where there are a lot of great options available. We highly suggest you employ one as you develop your front ends.

Quick Start Guide:

1. Ensure you have a computer that meets the above requirements.
2. Register for an account on this website. (see Video Tutorials for instructions and more info about multi-user accounts)
3. Add one of the YouGen Sharp products to your cart.
4. Complete the checkout process on your product(s).
5. Go to My account => Licenses.
6. Ensure you have your YouGen Sharp licenses assigned to you (or whomever will be following these steps) and save the settings.
7. Go to My account => Downloadable Products.
8. Click the link to download the YouGen Sharp zip file.
9. Unzip the zip file contents
10. Run the YouGenSharp.msix file to install
11. After installing, you should be able to find YouGenSharp in your start menu. Find it and run it.
12. On the YouGenSharp application's Profile page, enter your YouGenSoft.com username and password.
13. You will find the Company Identifier value on the My account => Customer info page.  Copy that value from the website and paste it into the YouGenSharp application.
14. Click "login and retrieve profile to download your active licensing information and to confirm your credentials are correct.
15.  Click the "settings" tab.
16. Choose your desired .NET version and database target.
17.  Click the "sql setup" tab.
18. You will see a sql script in the text area. We highly recommend using this script (feel free to change the user name) to create a sql user in your development database instance with the correct grants to be able to access only what YouGen Sharp needs.
19.  After creating the designated sqluser in your database instance, click back to the "settings" tab.
20.  Modify the database connection string that YouGenSharp will use to connect to your database and read the schema metadata using the user's credentials that you just created.
21.  Set a folder on your computer where you want the generated codebase to be saved.
22. Click the "solution" tab.
23. Click the "generate the solution" button.
24. Once the code has been fully generated, YouGen Sharp will automatically open the results folder for you to find your generated solution.