Dapper基本增刪改查

標籤：

說明：

　　1、在using語句塊中不用dbConnection.Open()，因為Execute方法中會Open，並且在執行完成會Close。

　　2、在Ado.Net中要手動Open，在Using語句塊中使用時，可以不用手動Close。

 public ActionResult Select()        {            string sql = @"select * from Info";            List<Info> list = null;            using (IDbConnection dbConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))            {                list = dbConnection.Query<Info>(sql, CommandType.StoredProcedure).ToList();                SqlMapper.GridReader gridReader = dbConnection.QueryMultiple(sql);                gridReader.Read();            }            return Content("");        }        public ActionResult Update()        {            string sql = @"update info set [email protected] where [email protected]";            using (IDbConnection dbConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))            {                dbConnection.Execute(sql, new Info() { Name = "s張", Age = 10 });            }            return Content("");        }        public ActionResult Delete()        {            string sql = @"delete from info where [email protected]";            using (IDbConnection dbConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))            {                dbConnection.Execute(sql, new Info() { Age = 10 });            }            return Content("OK");        }        public ActionResult Insert()        {            string sql = "insert Userinfo values(‘zhao2323‘,23,‘上海‘)";            string str = "";            IDbConnection dbConnection = null;            using (dbConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))            {                str += "<br />Execute之前" + dbConnection.State;                dbConnection.Execute(sql);                str += "<br />Execute之後" + dbConnection.State;            }            str += "<br />using之後" + dbConnection.State;            return Content("OK" + str);            //執行結果：            //            Execute之前Closed            //Execute之後Closed            //using之後Closed        }        public ActionResult AdoNet()        {            string sql = "insert into UserInfo values(‘zhao‘,23,‘上海‘)";            string str = "";            SqlConnection connection = null;            using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))            {                using (SqlCommand command = new SqlCommand(sql, connection))                {                    connection.Open();                    command.ExecuteNonQuery();                    str += "<br />ExecuteNonQuery之後：" + connection.State;                }                str += "<br />using Command之後：" + connection.State;            }            str += "<br />using Connection之後：" + connection.State;            return Content("Ok" + str);            //執行結果            //            ExecuteNonQuery之後：Open            //using Command之後：Open            //using Connection之後：Closed        }

 

Dapper基本增刪改查