Programming PERL in the .NET Environment

ADO.NET Connection

In order to obtain access to information stored in a database, we have to connect to our data source. ADO.NET provides special Connection classes for different data providers. These classes encapsulate all the required functionality to establish connection to databases. You just have to make sure you choose the relevant class and supply it with correct connection parameters.

Whenever we need to connect to our database, the SqlConnection class will serve this purpose. We instantiate this class in our PerlNET programs as we do every other .NET class. We pass to its constructor the connection string. This string contains all the required information for connecting to a database server and/or authentication. The connection string ...