dapper .IDbConnection.Query<T>(selectSQL);

static void DapperDemo()
        {
            string connString = ConfigurationManager.AppSettings.Get("SqlConnString");
            using(IDbConnection conn=new SqlConnection(connString))
            {
                conn.ConnectionString = connString;
                conn.Open();
                string select = "use AdventureWorks2019;select* from INFORMATION_SCHEMA.TABLES";
                var obj = conn.Query<dynamic>(select);
                var jsonValue = JsonConvert.SerializeObject(obj, Formatting.Indented);
                Console.WriteLine(jsonValue);
            }
        }
原文地址:https://www.cnblogs.com/Fred1987/p/13740158.html