dotnet-codegencs 1.0.2

CodegenCS

DbSchema Extractor

This is a dotnet tool (command-line tool) that extracts the schema of a MSSQL or PostgreSQL database and saves it in a JSON file. It also contains a simple template to generate POCOs based on the JSON schema.

Sample usage:

codegencs dbschema-extractor /postgresql /cn="Host=localhost; Database=Adventureworks; Username=postgres; Password=MyPassword" /output=AdventureWorks.json

codegencs dbschema-extractor /mssql /cn="Server=MYSERVER; Database=AdventureWorks; User Id=myUsername;Password=MyPassword" /output=AdventureWorks.json

codegencs dbschema-extractor /mssql /cn="Server=(local)\SQLEXPRESS; Database=AdventureWorks; Integrated Security=True" /output=AdventureWorks.json

Simple POCO Generator

This is a template that generates POCO classes from a JSON schema extracted with dbschema-extractor.

Sample usage:

codegencs poco /input=AdventureWorks.json /targetFolder=OutputFolder /namespace=MyProject.POCOs

codegencs poco /input=AdventureWorks.json /targetFolder=. /namespace=MyProject.POCOs /SingleFile=POCOs.generated.cs /CrudExtensions

codegencs poco /input=AdventureWorks.json /targetFolder=. /namespace=MyProject.POCOs /CrudClassMethods

For more templates or for more information check out the main project documentation.

License

MIT License