tailieunhanh - Professional Visual Basic 2010 and .neT 4 phần 5

Một ứng dụng có thể dễ dàng sử dụng XmlReader để đi qua một tài liệu nhận được trong một định dạng được biết đến. Tài liệu này do đó có thể được đi qua một cách cố ý. Bạn chỉ cần thực hiện một lớp học mà tuần tự các mảng của các đơn đặt hàng bộ phim. | CLR Integration in SQL Server I 489 When the minimum distance has been determined the Send SqlDataRecord method of the SqlPipe class is used to write the data to the output stream returning it to the calling function. The CopyRow function is used to create the SqlDataRecord to return. The first step in creating a SqlDataRecord is to define the columns of data. The constructor for the SqlDataRecord requires an array of SqlMetaData objects that define each column. The preceding code uses the List generic collection to make defining this array easier. Once the columns are defined the data returned from the GetValues method is used to populate the columns of the new SqlDataRecord. Exposing Web Services from SQL Server Another feature of SQL Server is the capability to expose Web services directly from the server. This means there is no requirement for IIS on the server as the requests are received and processed by SQL Server. You define what ports will be used to host the Web service. The structure of the Web service is defined based on the parameters and return data of the function or stored procedure you use as the source of the Web service. i Exposing Web services directly from SQL Server is supported only on the Standard kJ and higher editions. The Express and Compact editions do not support creating Web services in this manner. When you are architecting a scenario and plan to expose Web services from SQL Server keep in mind at least one important question Why do you think you need to expose this database functionality outside of the SQL Server It s not a trivial question. It means that you plan on hanging data off of the server possibly for public access. That s a potentially dangerous scenario not to be taken lightly. Most of the scenarios for which it makes sense to provide Web services directly from a SQL Server involve systems entirely behind a firewall where Web services are used as the conduit between departments typical A2A integration . This would be .