| An Evaluation of Stored Procedures for the .NET Developer |
| MSDN |
| In this introduction to SQL Server stored procedures for .NET developers you’ll discover the pros and cons of using stored procedures, take a look at related Visual Studio .NET 2003 tools, and more. |
|
| 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 Access and Transaction Handling Framework |
| The Code Project |
| Generic data access component for different datasources, sprocs/sql, implicitly propagated transactions, explicitly managed transaction contexts etc. |
|
| Hardcore Visual Studio .NET: Code Generation with Codesmith |
| MSDN |
| Bryan Boyce of Hardcore Visual Studio .NET shows off Codesmith, a freeware code generator that can automate code generation of some of your most common procedures. |
|
| HOW TO: Connect to a Database and Run a Command by Using ADO.NET and Visual J# .NET |
| http://www.kbalertz.com/ |
| (322045) - This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT or the DELETE command) by using a Visual J# .NET console application. Requirements The following list outlines the recommended... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual C++ .NET |
| http://www.kbalertz.com/ |
| (317017) - Use this step-by-step guide to read and write data to and from BLOB (LongVarBinary) columns in a database table. NOTES This article contains examples for both the SqlClient and the OleDb DataAdapter classes. The only differences, apart from the class... |
|
| 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... |
|
| TripleASP.Net Table Editor |
| http://tripleasp.net/ |
| I recently started building some data administration pages for TripleASP.Net. Functions like adding resources, editing and moving content, will need to have specific pages/controls and methods to efficiently handle their administration. However, I quickly noticed that building a custom page/control to edit each table would be a very tedious process. In addition, some of the tables only require one or two values to be updated or tweaked every once in a while. So I decided to start exploring some of SQL Server’s system tables in an attempt to build a user control that would be capable of administering all of them, with little or no customization needed to edit each table. And the TripleASP.Net Table Editor was born. |
|