How to use the Dapper (edit)
- Create new ASP.NET Web Application called WebApplication1 (MVC: Web Forms, MVC, Web API) based on .NET Framework 4.5.2
- Nuget packages:
+ Install-Package log4net
+ Install-Package Dapper
+ Install-Package MySql.Data
+ Install-Package AutoMapper
+ Install-Package Newtonsoft.Json
- Web.config/App.config
+ Define connection string in <connectionStrings> or <appSettings>
- Controllers/HomeController.cs
Dapper with MS SQL Server
- Dapper with raw SQL
- Dapper with Stored Procedure
Dapper with MySQL
Nuget notes
+ .NET Framework 4.5
+ ASP.NET MVC 5.2
+ ASP.NET Web API 2.2
+ Web Pages 3.2
Update-Package
Install-Package jQuery -Version 1.12.4
Install-Package Bootstrap -version 3.3.7
Install-Package modernizr
Install-Package Newtonsoft.json
Install-Package log4net
Install-Package Dapper -Version 1.50.2 (.NET Framework 4.5)
Install-Package Microsoft.AspNet.WebApi (-Version 5.2.4)
Install-Package Swashbuckle (-Version 5.6.0)
Web API & Swagger + OAuth2
http://wmpratt.com/swagger-and-asp-net-web-api-part-1/
http://wmpratt.com/part-ii-swagger-and-asp-net-web-api-enabling-oauth2/
https://www.codeproject.com/Articles/1187872/Token-Based-Authentication-for-Web-API-where-Legac
http://bitoftech.net/2014/06/01/token-based-authentication-asp-net-web-api-2-owin-asp-net-identity/
