15110088 / dappercodegenerator

Simple C# Code Generator to create Database Models and Dapper CRUD

Dapper Code Generator

Simple C# Code Generator to create Database Models and Dapper CRUD to reduce manual code entry and repetitive work.

Instructions

1. Clone or download the repository
2. Open the solution file (DapperCodeGenerator.sln) in Visual Studio 2017
3. Make sure the Web project is set as the startup project
4. Start/run with IIS
   • I run it with IIS Express from Visual Studio 2017, you can run it however you want
5. Navigate to the site
6. Select the Connection Type
   • If you want further support for an existing or any other DB types feel free to make a PR and/or submit a ticket, just know I won't prioritize it
7. Enter a valid Connection String for the selected Connection Type
8. Press the "Connect" button
   • If you get messages about there not being any databases, confirm your Connection Type and Connection String
9. Select any database you wish to generate code for
10. A table should be populated with a list of tables for the database you selected, click the "Data Model" or "Dapper" buttons to the right to generate code
    • If there are tables and it says there aren't try refreshing (state is preserved, but the tables should then populate)

Data Models

This is to generate C# objects that directly reflect the database tables for use with Dapper (or anything really).

Dapper

This is to generate the Dapper CRUD (Create, Retrieve/Get, Update, and Delete) methods for interacting with the Database using the data models generated in this tool and Dapper - a simple, lightweight and powerfull ORM (Object Relational Mapper). See more at https://github.com/StackExchange/Dapper.

You can also try the below alternatives...

• https://github.com/MoonStorm/Dapper.FastCRUD
• https://github.com/ericdc1/Dapper.SimpleCRUD

Other Projects:

• Code Snippets (gists) - https://gist.github.com/kcrossman