What's the point of the garbage collector

Question

SqlConnection connection = new SqlConnection(FROM_CONFIGURATION) 
SqlCommand command = new SqlCommand("SomeSQL", connection); 
connection.Open(); 
command.ExecuteNonQuery(); 
command.Dispose(); 
connection.Dispose();

It is recommended that the above code include try / catch (or use), so that when an exception occurs, all resources are located correctly.

But if you need to worry about recycling manually, then what a GC point! Isn't GC there taking care of this for the encoder?

Answer 1

, GC , , . , , ( , ), . Dispose , , . , , GC . .

, 'using' .

Answer 2

, .

, GC . , (, ) , , .

, - , , .

, GC . , , , , , .

, GC , , . .

.

Answer 3

, GC?! GC ?

, , GC. , .

Answer 4

, :

class MonkeyGrabber : IDisposable {
   public MonkeyGrabber() { /* construction grabs a real, live monkey from the cage */
   public void Dispose() { Dispose(true); /* releases the monkey back into the cage */ }
   // the rest of the monkey grabbing is left as an exercise to grad student drones
}

class MonkeyMonitor {
    public void CheckMonkeys() {
        if (_monkeyPool.GettingTooRowdy()) {
            MonkeyGrabber grabber = new MonkeyGrabber();
            grabber.Spank();
        }
    }
}

MonkeyMonitor , , - , , , . , , . , MonkeyGrabber, . . , : , IDisposable, , . GC .

, . , , , GC , , , , , GC .

IDisposable.

- RAII.

Answer 5

, IDisposable, , , . , . , , , , , , //.

Answer 6

GC , . , , , , , ( C/++), , , , . , , , . , , using db :

using (SqlConnection connection = new SqlConnection(...))
using (SqlCommand command = connection.CreateCommand())
{
   ...
}

dispose , , .

Answer 7

GC - , . , , -, .., / , GC, .

using:

using (SqlConnection connection = new SqlConnection(FROM_CONFIGURATION))
using (SqlCommand command = new SqlCommand("SomeSQL", connection))
{
  connection.Open(); 
  command.ExecuteNonQuery(); 
  command.Dispose(); 
  connection.Dispose();
}

, , , , using.

Answer 8

... GC ; ... , ... ( )

OP , .net-specific, , GC , , using IDisposable, .

. , ++ () , , RAII .

cPython . , . "" , , , ++ RAII. , , . , Java .NET. .NET , cPython .

, OP , , , (, , GC, using RAII) , .

Answer 9

(, , Dispose(), , ). GC ( , ), .

Answer 10

#, , , , . , , . , , . .

Answer 11

(GC) .NET .NET Common Language Runtime (CLR) .NET. GC ; , , .NET-. , .

, - , .. Close() / Dispose(), , GC.

Answer 12

. . !

Answer 13

GC , . .

Answer 14

GC , , . .NET .

Answer 15

, . , , " " . / , , .

, , , ( -), , .