| An introduction to Web Service Security using WSE - Part I |
| The Code Project |
| This article explains the first steps to build secure Web Services. It introduces the WSE specification and a first authenication mechnism based on username identifiction and password validation. |
|
| An introduction to Web Service Security using WSE - Part I |
| The Code Project |
| This article explains the first steps to build secure Web Services. It introduces the WSE specification and the easiest authentication mechanism based on username identification and password validation. |
|
| BETA-PRB: No Method in DataReader Closes Its Underlying Connection (Q310369) |
| Microsoft Support |
| The DataReader object does not include a property to retrieve its underlying connection. Although you can close DataReader and then close the OleDbConnection or SqlConnection object on which DataReader was opened, DataReader does not have a built-in connection. Thus, if you retrieve a DataReader from a component method, you cannot close the underlying connection. That is, if you retrieve a DataReader object from a component, the DataReader stays connected, and there is no way to disconnect it.
|
|
| Building a Custom Data Provider for Use with the .NET Data Access Framework |
| MSDN |
| The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers. |
|
| Commands in ADO .NET |
| MSDN |
| In ADO there are three possible ways to update a data source. One is through direct SQL commands, like INSERT, DELETE and UPDATE, or more complex and sophisticated stored procedures. Another is through batch update, where you submit a new image of a certain table to the server all at once. The third way is through direct fields update using server cursors. |
|
| Data Points |
| MSDN |
| Contrasting the ADO.NET DataReader and DataSet |
|
| Generic Data Provider |
| The Code Project |
| Generic Data Provider. An approach to make applications database independent. |
|
| Hardcore Visual Studio .NET: Using DataReaders to Increase Speed and Reduce Memory |
| MSDN |
| Rick Dobson shows you how to take advantage of the DataReader's high performance and low memory requirements in database connections. |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual C++ .NET |
| http://www.kbalertz.com/ |
| (317044) - This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, sometimes you may need to retrieve... |
|
| HOW TO: Retrieve Column Schema Using the DataReader GetSchemaTable Method and Visual Basic .NET |
| http://www.kbalertz.com/ |
| (310108) - This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties. Column schema information includes the following... |
|
| PRB: Error "Invalid Attempt to Read from Column Ordinal" When You Use DataReader in Visual Basic .NET (Q308069) |
| Microsoft Support |
| When you use DataReader to read a row, if you try to access columns in that row, you receive an error message similar to the following: "System.InvalidOperationException: Invalid attempt to read from column ordinal '0'. With CommandBehavior.SequentialAccess, you may only read from column ordinal '2' or greater."
|
|
| Using an ADO.NET DataSet as a Reporting Services Data Source |
| MSDN |
| Learn how to build a data processing extension for Reporting Services that enables you to use an ADO.NET DataSet as a data source. |
|
| Why Create a DataSet, use a DataTable |
| DotNetJunkies |
| This article asks the question, "Why do you create a whole DataSet when all you are using is a single DataTable?". |
|