Mention the usage of Connection Object in ADO.NET
Connection object is used to establish a connection between your .NET application and the database used by your application.
You have to ensure that you close the connection as soon as you finish your tasks related to the database. This makes your application run faster and allows the database to be used by multiple resources of your application.
Two different types of connection object exist in ADO.NET. They are mentioned below:
Available in the namespace System.Data.SqlClient. It is used to connect
to SQL Server database with version 7.0 or higher.
creating and opening a connection, several other methods exist in a connection
object. Methods associated with Connection Object are: BeginTrans, Cancel,
Close, CommitTrans, Execute, Open, OpenSchema and RollbackTrans. With
these methods, you can manage your transaction and you can even rollback
from your current transaction. Connection object also includes several
properties, events and collections.
to our mailing list and receive new articles Note
: We never rent, trade, or sell my email lists to Visit
.NET Programming Tutorial Homepage ______________________________________________________
Visit .NET Programming Tutorial Homepage
| How do you implement Observer Design Pattern in .NET? | How do you pass data between different Tiers in .NET Architecture? | How is Classic ADO different from ADO.NET? | How is Dataadapter useful in ADO.NET? | How is Datareader different from Dataset in ADO.NET? | How is .NET Application Development different from Traditional Development? | How is HashTable different from ArrayList in .NET? | How is Inheritance achieved in C#? | How is new keyword different from override keyword during inheritance in .NET? | How is String class different from StringBuilder class in .NET? | Illustrate ADO.NET Architecture | Illustrate the importance of Server.Transfer and Response.Redirect in .NET? | Mention the different objects available in Dataset of ADO.NET | Mention the usage of Connection Object in ADO.NET | What are the commonly used methods of Dataadapter in ADO.NET? | What are the different Behavioral Design Patterns that can be used in .NET Architecture? | What are the different Creational Design Patterns that can be used in .NET Architecture? | What are the different Structural Design Patterns that can be used in .NET Architecture? | What are the methods provided by Command Objects in ADO.NET? | What is Internal Access Modifier in C#? |