c# - Enterprise Library Database connection close -

c# - Enterprise Library Database connection close -

we using microsoft enterprise library access sql server database.we having doubts how close db connection.code given below.

databasefactory.setdatabaseproviderfactory(new databaseproviderfactory(), false); database db = new databaseproviderfactory().create("dataconnectionstring"); string sqlcommand = ""; dbcommand dbcommand = db.getstoredproccommand(sqlcommand); dbcommand.commandtimeout = 0; seek { success = convert.toint32(db.executescalar(dbcommand)); homecoming success; } how can close database connection.

one way utilize using statements. objects implementing idisposable can used in such way, when code reaches closing bracket calls dispose() supposed rid of object.

databasefactory.setdatabaseproviderfactory(new databaseproviderfactory(), false); int success = 0; using (var db = new databaseproviderfactory().create("dataconnectionstring")) { string sqlcommand = ""; using (var dbcommand = db.getstoredproccommand(sqlcommand)) { dbcommand.commandtimeout = 0; seek { success = convert.toint32(db.executescalar(dbcommand)); } } } homecoming success;

c# visual-studio-2012 enterprise-library