请问using(SqlConnection conn= new SqlConnection(strConn)){try{...}...}的using是什么？

2006-04-23 01:14:24 627 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

MFC仓库管理系统实战：数据库事务与界面优化全解析 MFC作为Windows桌面应用开发的经典框架，其核心价值在于紧贴Win32 API、调试直观、教学适配度高，特别适合课程设计与轻量级本地业务系统开发。理解CRecordset数据封装、CDatabase事务控制（BeginTrans/CommitTrans）、虚拟列表（LVS_OWNERDATA）性能优化等关键技术，是保障超市仓库类系统数据强一致性与交互流畅性的基础。结合ODBC数据库连接、DDX/DDV数据绑定、GDI打印等原生能力，MFC能以极低依赖实现入库单生成、库存联动更新、滞销预警等闭环业务逻辑阅读详情

请问using(SqlConnection conn= new SqlConnection(strConn)){try{...}...}的using是什么？

实在搞不明白怎么在这地方写using

using不是一般在源文件开头用于类似
using System.Data的吗？

...全文

C#常用代码 C#基础代码,为初学者更好认识,编程的魅力立即下载

moksha

C# 111,129 成员 642,538 内容

+ 关注 + 加入社区

切换为时间正序

bill024 2006-11-21

打赏
举报

mark!

-渔民- 2006-04-25

打赏
举报

mark

yurow 2006-04-25

打赏
举报

定义SqlConnection conn= new SqlConnection(strConn)后，这只是赋值,实例化了类
conn.Open()//打开数据库
conn.Close()//关闭数据库
conn.Dispose()/释放conn,和conn=null是一个道理，不过这个时候是conn本身的地址也没了

namhyuk 2006-04-25

打赏
举报

If you are making use of the using block, you don't need to explicitly call Close, because that will be called as a part of Dispose for you at the end of the using block.

* Calling Close on a connection object enables the underlying connection to be pooled.

* Calling Dispose on a connection alleviates the need for you to call Close on it explicitly. It not only ensures that the underlying connection can be pooled, but it also makes sure that allocated resources can now be garbage collected.

* Not calling either Close or Dispose will effectively kill your application performance by increasing the connection pool to a maximum limit, and then everyone will have to wait for the next available connection object. Not only that, but even when the open connection fall out of scope, they won't be garbage collected for a relatively long time because the connection object itself doesn't occupy much memory-and the lack of memory is the sole criterion for the garbage collector to kick in and do its work.

In short, Dispose is the best option as it helps garbage collection and connection pooling, Close is second best option as it helps only connection pooling, and not calling either Close or Dispose is so bad that you shouldn't even go there.

marvelstack 2006-04-23

打赏
举报

using语法相当于
try{}finally{}

copico 2006-04-23

打赏
举报

如果你的conn没有及时的关闭,会帮你关闭
如果你的conn是在外面创建的资源,它不会帮你释放资源
用using在你的代码里主要是释放链节

wumingxiaodi 2006-04-23

打赏
举报

Dispose conn，只是释放conn占用的资源，不会关闭数据库

moksha 2006-04-23

打赏
举报

释放conn是什么？
是Dispose conn对象还是关闭数据库？

copico 2006-04-23

打赏
举报

就像析构函数

copico 2006-04-23

打赏
举报

using(SqlConnection conn= new SqlConnection(strConn)){try{...}...}
这里写using是更好的控制代码
如果你没有释放conn
using自动帮你释放

请问using(SqlConnection conn= new SqlConnection(strConn)){try{...}...}的using是什么？

相关推荐