
The picture given shows where you should place the CS in your application. Where does CS fit in a tier based application. Which simply means partitoning your application into components. Net application or C# application to an Sql Server database.Ĭonnection string in a n-tier application All commercial applications are designed based on the N-Tier concept. You will see this, when we write the CS for connecting a VB. Note that when we need to connect to sql server we need not mention the provider in the CS. We specify the appropriate provider depending on the datasource we wish to access. With the provider, we can setup a connection from an application and gain access to the datasource. A provider allows us to specify the driver which can access the datasource in binary form. It is made of many parts and one of them is the Provider. The data sources can be MS SQL Server, MS Access or SQL Server on remote server. A connection string (hereafter CS) is a string which is used to gain access to different data sources from a VB.
