mysql_with_nancy.cs

using Dapper;
using Nancy;
using Nancy.IO;
using Nancy.ModelBinding;
using Nancy.Json;
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.SqlClient;

namespace Sample
{
    public class User
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }
    public class Module : NancyModule
    {

        private string connString = "Server=192.168.99.100;Database=sample;Uid=root;Pwd=password;";

        public Module()
        {
            Get["/users"] = _ =>
            {
                using (var connection = new MySqlConnection(connString))
                {
                    var users = connection.Query<User>("select * from Users");
                    return Response.AsJson(users);
                }
            };
            Get["/users/{id}"] = parameters =>
            {
                using (var connection = new MySqlConnection(connString))
                {
                    var users = connection.Query<User>("select * from Users where Id = @Id", new { Id = (int)parameters.id });
                    return Response.AsJson(users.First());
                }
            };
            Post["/users"] = _ =>
            {
                var user = this.Bind<User>();
                using (var connection = new MySqlConnection(connString))
                {
                    connection.Execute(@"insert Users(Id, Name) values (@Id, @Name)", user);
                    return "true";
                }
            };
        }
    }
}

• "Dapper": "1.42.0",
• "MySql.Data": "6.9.8",
• "Nancy": "1.4.3",