Dapper.Net glimpse

HomeController.cs

 DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
            
            using (DbConnection conn = factory.CreateConnection()) {
                conn.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();

                conn.Open();

                var list = conn.Query<Category>("select * from categories").ToList();
            }