mssql-generate-poco

mvc and web api with angularjs to generate poco of table and sp

PrePare

• Visual Studio 2013 up
• .net framework 4.6.1

What is this project can help you?

If you have many dto for sp or table and this project is right for you.

This project can generate sp input and result params.

Of course focus on table of poco and auto generate stored procedure insert and update.

2017/07/10

Create new tool to export excel for db information

Here can generate every table and column name and foreign key information

Other solution

Default is direct column name.

But If you want to have camelcase params then you can new another class below

In the Controllers>TableController
```csharp private ITableService service; public TableController() { service = new TableService(); } ``` change to below

private ITableService service;
public TableController()
{
  service = new TableForCsharpNameService();
}

Publish notice

If you publish to iis. You might meet some error. That is you need to configure connection string. But file is not have permission. You need to allow permission from File>connection.txt.