Menu
Whilst investigating a very dull and exponetially security flawful 2005 project, I debugged into a connection hang.
Inspecting the object, to find the server name, I've encountered this three little properties:
IsShiloh IsKatmaiOrNewerIsYukonOrNewerWhat are those members and why are they so awesomely named?
562
SqlConnection Class Here, we will use two important methods of SqlConnection. Open() : The open() method is used to open the Database connection. Close() : The close() method is used to close the Database connection. In the preceding code, I have added the namespace "System.
A SqlConnection object represents a unique session to a SQL Server data source. With a client/server database system, it is equivalent to a network connection to the server. SqlConnection is used together with SqlDataAdapter and SqlCommand to increase performance when connecting to a Microsoft SQL Server database.
If you want to access a database multiple times, you should establish a connection using the Connection object. You can also make a connection to a database by passing a connection string via a Command or Recordset object. However, this type of connection is only good for one specific, single query.
It is used to establish an open connection to the SQL Server database. It is a sealed class so that cannot be inherited. SqlConnection class uses SqlDataAdapter and SqlCommand classes together to increase performance when connecting to a Microsoft SQL Server database.
I believe these are all different codenames for different versions of SQL Server. The Wikipedia article for SQL Server lists the different codenames:
8.0 2000 SQL Server 2000 Shiloh
9.0 2005 SQL Server 2005 Yukon
10.0 2008 SQL Server 2008 Katmai
Also, just for funsies, the codenames follow a National Park naming pattern.
122
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
