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

 

posted @ 2020-09-27 16:13  FredGrit  阅读(440)  评论(0编辑  收藏  举报