WebMatrix Database.Open… Close() and Dispose()

apple443322

于 2014-04-29 15:06:00 发布

阅读量95

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/happy-Chen/p/3699257.html

版权

ASP.NET Web Pages framework examples of the Database helper do not include calls to Close or Dispose because the framework itself is designed to call Dispose for you at the end of a request. If you use ADO.NET instead of the Database helper, you should employ using statements. Having said that, there is nothing to stop you from wrapping Database helper calls in using blocks:

IEnumerable<dynamic> floaters = null;
using(var db = Database.Open("MyDb")){
    var sql = "SELECT * From LifeRafts";
    floaters = db.Query(sql);
}

If you wanted to manage it all yourself, you can simply call Close or Dispose. They both result in the connection being returned to the ADO.NET connection pool anyway.

转载于:https://www.cnblogs.com/happy-Chen/p/3699257.html