C# NPoco 连接 Mysql 测试，包含随机生成姓名。

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.Common;
using System.Diagnostics;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql;
using MySql.Data.MySqlClient;
using NPoco;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string conn1 = ConfigurationManager.ConnectionStrings["default1"].ConnectionString;
        string conn2 = ConfigurationManager.ConnectionStrings["default2"].ConnectionString;
        Database data1 = new NPoco.Database(conn1,NPoco.DatabaseType.MySQL);
        data1.BeginTransaction();
        data1.Execute("delete from 股票表");

        var name_list = indexModel.GetManName();

        var count = 0;
        foreach(var k in name_list)
        {
            var obj = new 股票表();
            obj.代码 = Guid.NewGuid().ToString("N");
            obj.名称 = k;
            data1.Insert<股票表>(obj);
            count = count + 1;
            if (count > 2000)
            {
                break;
            }
        }
        data1.CompleteTransaction();
        var list = data1.Fetch<股票表>("select * from 股票表 order by rand() limit 0,1000");
        Response.Write("<h3>");
        foreach (var k in list)
        {
            Response.Write(k.名称+" ");
        }
        Response.Write("</h3>");
    }

    public class 股票表
    {
        public string 代码 { get; set; } = String.Empty;
        public string 名称 { get; set; } = String.Empty;
    }

    public class indexModel
    {
        public static List<string> Xing = new List<string>() {"赵", "钱", "孙", "李", "周", "吴", "郑", "王", "冯", "陈", "楮", "卫",