ADO.Net 2.0 Notes(part two)

Connection of database

SqlConnection class

-> connection string -> ConnectionStringBuilder class

1. connection pool ( about connection close() issues)

2. SqlConnection class -> create SqlCommand instance ( class SqlCommand)

SqlConnection class -> SqlTransaction

SqlConnection class -> getSchema information ( about architecture of the database )

e.g. cn.GetSchema()

2. methods of Class SqlConnection

BeginTransaction() ;

ChangeDatabase() ; --> like " use databasename" in SSMS