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); } }