public class Account
{
    public string Email { get; set; }
    public bool Active { get; set; }
    public DateTime CreatedDate { get; set; }
    public IList<string> Roles { get; set; }
}

Account account = new Account
{
     Email = "[email protected]",
     Active = true,
     CreatedDate = new DateTime(2013, 1, 20, 0, 0, 0, ateTimeKind.Utc),
     Roles = new List<string>
     {
         "User",
         "Admin"
    }
};

string json = JsonConvert.SerializeObject(account, Formatting.Indented);
// {
//   "Email": "[email protected]",
//   "Active": true,
//   "CreatedDate": "2013-01-20T00:00:00Z",
//   "Roles": [
//     "User",
//     "Admin"
//   ]
// }

Console.WriteLine(json);

# 下面为例子需要的数据库的建表语句
CREATE TABLE `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `email` varchar(255) COLLATE utf8_bin NOT NULL,
    `password` varchar(255) COLLATE utf8_bin NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
AUTO_INCREMENT=1 ;

# -*- coding: utf-8 -*-
import pymysql.cursors

# 连接数据库
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='passwd',
                             db='db',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        # 创建一个新的纪录（record）
        sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
        cursor.execute(sql, ('[email protected]', 'very-secret'))

    # 连接不会自动提交，所以你想下面要调用 commit 方法，存储对数据库的改动
    connection.commit()

    with connection.cursor() as cursor:
        sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
        cursor.execute(sql, ('[email protected]',))

        # 获取一条的纪录（record）
        result = cursor.fetchone()
        print(result)  # 结果输出：{'password': 'very-secret', 'id': 1}
finally:
    connection.close()  # 操作完数据库一要记得调用 close 方法，关闭连接

微信中搜：<strong>HelloGitHub</strong> 关注公众号

不仅能第一时间收到推送，还有回馈粉丝的活动

如果文中的图刷不出来，可以点击 <a href='https://hellogithub.com/periodical/volume/08'>这里</a>。

      <sub>UCloud</sub>

      <sub>超值的GPU云服务</sub>
    </a>
  </th>
  <th align="center" style="width: 80px;">
    <a href="https://www.upyun.com/?from=hellogithub">
      

      <sub>CDN</sub>

      <sub>开启全网加速</sub>
    </a>
  </th>
  <th align="center" style="width: 80px;">
    <a href="https://github.com/OpenIMSDK/Open-IM-Server">
      

      <sub>OpenIM</sub>

      <sub>开源IM力争No.1</sub>
    </a>
  </th>
  <th align="center" style="width: 80px;">
    <a href="https://www.qiniu.com/products/ai-token-api?utm_source=hello">
      

      <sub>七牛云</sub>

      <sub>百万 Token 免费体验</sub>
    </a>
  </th>
</tr>