What does the Dispose method do with the connection object?

What does the Dispose method do with the connection object? 
by

1 Answer

Answer :

Deletes it from the memory.

To Do: answer better. The current answer is not entirely correct.
by

Related questions

What does the Dispose method do with the connection object?

Description : What does the Dispose method do with the connection object? 

Last Answer : Deletes it from the memory. To Do: answer better. The current answer is not entirely correct.

Define what is the difference between “dispose of” and “finalize” variables in C#?

Description : Define what is the difference between “dispose of” and “finalize” variables in C#?

Last Answer : Dispose of - This method uses interface - IDisposable interface and it will free up both managed and unmanaged codes like - database connection, files, etc. Finalize - This method is called internally ... called explicitly. It is called by the garbage collector and can't be called from the code.

What is a pre-requisite for connection pooling?

Description : What is a pre-requisite for connection pooling?

Last Answer : Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings. The connection string must be identical.

What does the Initial Catalog parameter define in the connection string?

Description : What does the Initial Catalog parameter define in the connection string?

Last Answer : The database name to connect to. 

What is a pre-requisite for connection pooling?

Description : What is a pre-requisite for connection pooling?

Last Answer : Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings. The connection string must be identical.

What does the Initial Catalog parameter define in the connection string?

Description : What does the Initial Catalog parameter define in the connection string?

Last Answer : The database name to connect to.

What are the three possible settings for the CommandType property of a SqlCommand object or an OleDbCommand object, and what does each mean?

Description : What are the three possible settings for the CommandType property of a SqlCommand object or an OleDbCommand object, and what does each mean?

Last Answer : A Command object can have a CommandType property setting of Text, StoredProcedure, or TableDirect. When set to Text, the command executes the SQL string that is stored in the Command object's ... that the command should return the entire contents of the table indicated by the CommandText property. 

Briefly explain encapsulation and why it is important in object-oriented - programming.

Description : Briefly explain encapsulation and why it is important in object-oriented - programming.

Last Answer : Encapsulation is the principle that all of the data and functionality required by an object be contained by that object. This allows objects to exist as independent, interchangeable units of functionality without maintaining dependencies on other units of code.

What size is a .NET object?

Description : What size is a .NET object?

Last Answer : Each instance of a reference type has two fields maintained by the runtime - a method table pointer and a sync block. These are 4 bytes each on a 32-bit system, making a total of 8 bytes ... bytes, even for classes with no data (e.g. System.Object). Values types have no equivalent overhead. 

Given part of a stack trace: aspnet.debugging.BadForm.Page_Load(Object sender, EventArgs e) +34. What does the +34 mean?

Description : Given part of a stack trace: aspnet.debugging.BadForm.Page_Load(Object sender, EventArgs e) +34. What does the +34 mean?

Last Answer : It is an actual offset (at the assembly language level) – not an offset into the IL instructions. 

Is object destruction deterministic?

Description : Is object destruction deterministic?

Last Answer : No

object is an alias for what?

Description : object is an alias for what? 

Last Answer : System.Object 

How do you dereference an object?

Description : How do you dereference an object? 

Last Answer : Set it equal to null. 

Does an object need to be made to run main?

Description : Does an object need to be made to run main?

Last Answer : No

Is C# object-oriented?

Description : Is C# object-oriented?

Last Answer : Yes, C# is an OO language in the tradition of Java and C++.

Is C# is object oriented?

Description : Is C# is object oriented?

Last Answer : Yes, C# is an OO language in the tradition of Java and C++.

Explain how to use the Begin and End methods on a Web Service to make an asynchronous method call.

Description : Explain how to use the Begin and End methods on a Web Service to make an asynchronous method call.

Last Answer : Every public Web method on a Web Service can be called either synchronously or asynchronously. To make an asynchronous call to a Web method, you call the method named Begin, where is the name of ... returned by Begin. This will allow you to retrieve the actual data returned by the Web method.

What is method overloading, and when is it useful?

Description : What is method overloading, and when is it useful?

Last Answer : Method overloading allows you to create several methods with the same name but different signatures. Overloading is useful when you want to provide the same or similar functionality to different sets of parameters.

What does assert() method do?

Description : What does assert() method do?

Last Answer : In debug compilation, assert takes in a Boolean condition as a parameter, and shows the error dialog if the condition is false. The program proceeds without any interruption if the condition is true. 

What are the different ways a method can be overloaded?

Description : What are the different ways a method can be overloaded?

Last Answer : Different parameter data types, different number of parameters, different order of parameters.

Can you declare an override method to be static if the original method is not static?

Description : Can you declare an override method to be static if the original method is not static? 

Last Answer : No. The signature of the virtual method must remain the same. (Note: Only the keyword virtual is changed to keyword override)

How is method overriding different from method overloading?

Description : How is method overriding different from method overloading? 

Last Answer : When overriding a method, you change the behavior of the method for the derived class. Overloading a method simply involves having another method with the same name within the class.

What does the keyword “virtual” declare for a method or property?

Description : What does the keyword “virtual” declare for a method or property? 

Last Answer : The method or property can be overridden. 

What’s the implicit name of the parameter that gets passed into the set method/property of a class?

Description : What’s the implicit name of the parameter that gets passed into the set method/property of a class?

Last Answer : Value. The data type of the value parameter is defined by whatever data type the property is declared as.

What happens if you inherit multiple interfaces and they have conflicting method names?

Description : What happens if you inherit multiple interfaces and they have conflicting method names?

Last Answer : It’s up to you to implement the method inside your own class, so implementation is left entirely up to you. This might cause a problem on a higher-level scale if similarly named methods from different interfaces expect different data, but as far as compiler cares you’re okay. To Do: Investigate 

Can you allow a class to be inherited, but prevent the method from being over-ridden?

Description : Can you allow a class to be inherited, but prevent the method from being over-ridden?

Last Answer : Yes. Just leave the class public and make the method sealed. 

Are value types are slower to pass as method parameters?

Description : Are value types are slower to pass as method parameters? 

Last Answer : Yes

What is an overloaded method?

Description : What is an overloaded method?

Last Answer : An overloaded method has multiple signatures that are different. 

Write code to show how a method can accept a varying number of parameters.

Description : Write code to show how a method can accept a varying number of parameters.

Last Answer : using System; namespace Console1 { class Class1 { static void Main(string[] args) { ParamsMethod(1,"example"); ParamsMethod(1,2,3,4); Console.ReadLine(); } static void ... o in list) { Console.WriteLine(o.ToString()); } } } }

Methods must declare a return type, what is the keyword used when nothing is returned from the method?

Description : Methods must declare a return type, what is the keyword used when nothing is returned from the method?

Last Answer : void 

What does assert() method do?

Description : What does assert() method do? 

Last Answer : In debug compilation, assert takes in a Boolean condition as a parameter, and shows the error dialog if the condition is false. The program proceeds without any interruption if the condition is true. 

What are the different ways a method can be overloaded?

Description : What are the different ways a method can be overloaded?

Last Answer : Different parameter data types, different number of parameters, different order of parameters.

Can you declare an override method to be static if the original method is not static?

Description : Can you declare an override method to be static if the original method is not static? 

Last Answer : No. The signature of the virtual method must remain the same. (Note: Only the keyword virtual is changed to keyword override)

How is method overriding different from method overloading?

Description : How is method overriding different from method overloading? 

Last Answer : When overriding a method, you change the behavior of the method for the derived class. Overloading a method simply involves having another method with the same name within the class.

What does the keyword “virtual” declare for a method or property?

Description : What does the keyword “virtual” declare for a method or property? 

Last Answer : The method or property can be overridden.

What’s the implicit name of the parameter that gets passed into the set method/property of a class?

Description : What’s the implicit name of the parameter that gets passed into the set method/property of a class?

Last Answer : Value. The data type of the value parameter is defined by whatever data type the property is declared as.

What happens if you inherit multiple interfaces and they have conflicting method names?

Description : What happens if you inherit multiple interfaces and they have conflicting method names?

Last Answer : It’s up to you to implement the method inside your own class, so implementation is left entirely up to you. This might cause a problem on a higher-level scale if similarly named methods from different interfaces expect different data, but as far as compiler cares you’re okay.  To Do: Investigate 

Can you allow a class to be inherited, but prevent the method from being over-ridden?

Description : Can you allow a class to be inherited, but prevent the method from being over-ridden?

Last Answer : Yes. Just leave the class public and make the method sealed. 

How can you overload a method?

Description : How can you overload a method?

Last Answer : Different parameter data types, different number of parameters, different order of parameters.

Can you allow class to be inherited, but prevent the method from being overridden?

Description : Can you allow class to be inherited, but prevent the method from being overridden? 

Last Answer : Yes, just leave the class public and make the method sealed. 

Can you declare the override method static while the original method is nonstatic?

Description : Can you declare the override method static while the original method is nonstatic?

Last Answer : No, you can’t, the signature of the virtual method must remain the same, only the keyword virtual is changed to keyword override. 

What does the keyword virtual mean in the method definition?

Description : What does the keyword virtual mean in the method definition? 

Last Answer : The method can be over-ridden. 

How’s method overriding different from overloading?

Description : How’s method overriding different from overloading?

Last Answer : When overriding, you change the method behavior for a derived class. Overloading simply involves having a method with the same name within the class.

What’s the implicit name of the parameter that gets passed into the class’ set method?

Description : What’s the implicit name of the parameter that gets passed into the class’ set method?

Last Answer : Value, and it’s datatype depends on whatever variable we’re changing. 

Define what is the Static Method?

Description : Define what is the Static Method?

Last Answer : It is possible to declare a method as Static provided that they don’t attempt to access any instance data or other instance methods.

Define what is the difference between an abstract method & virtual method?

Description : Define what is the difference between an abstract method & virtual method?

Last Answer : An Abstract method does not provide an implementation and forces overriding to the deriving class (unless the deriving class also an abstract class), whereas the virtual method has an ... abstract method does not provide implementation & forces the derived class to override the method.

Can we declare a method as sealed?

Description : Can we declare a method as sealed?

Last Answer : In C# a method can’t be declared as sealed. However, when we override a method in a derived class, we can declare the overridden method as sealed. By declaring it as sealed, we can avoid further overriding of this method.

Which method will you call to start a thread?

Description : Which method will you call to start a thread?

Last Answer : Start

How can we suppress a finalize method?

Description : How can we suppress a finalize method?

Last Answer : GC.SuppressFinalize()

Define what are the different ways a method can be overloaded?

Description : Define what are the different ways a method can be overloaded?

Last Answer : Different parameter data types, different number of parameters, different order of parameters.