Tham khảo tài liệu 'microsoft ado .net 4 step by step - p 16', công nghệ thông tin, kỹ thuật lập trình phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 126 Microsoft 4 Step by Step The .NET Framework also includes string builders for OLE DB ConnectionStringBuilder and ODBC connections. As with connection strings the builders include a large number of platform-specific properties used to set the supported keys and values. See the Visual Studio documentation of each string builder class for specific property lists. Storing Connection Strings Because they are standard text strings how or where you store the connection strings used in your applications is up to you. The Data Source Connection Wizard demonstrated in Chapter 1 offers to store its generated connection string in your application s settings file. As mentioned in that chapter storing the string in the user settings file makes it possible to modify this string within the application perhaps based on user-updated values. Storing the string in the application settings file provides consistent access to the connection string but it can t be modified by the application itself. Wherever you store the string be sure to weigh the risks of storing a plain-text key into the database system s locking mechanism. If your connection string includes the Password element you might want to encrypt the entire string before storing it in a disk file or registry entry. Understanding Data Providers provides a generic interface to many different types of data stores including SQL Server Microsoft Access file-based databases comma-delimited text files and Excel spreadsheets among others. To link these varied data sources with the common DataSet model includes providers class libraries that understand how to interact with a specific data platform such as SQL Server or a common data layer such as OLE DB. Other vendors offer additional providers beyond those included with Visual Studio that enable access to more third-party database systems and file formats. The Framework comes with
