Series: Analyzing SQL Server Dependencies

A step-by-step introduction to the system views containing dependency information in SQL Server:

Analyzing SQL Server Dependencies – sys.sql_dependencies

Analyzing SQL Server Dependencies – View Dependencies

Analyzing SQL Server Dependencies – sys.sql_expression_dependencies

Analyzing SQL Server Dependencies – Unresolved Dependencies in sys.sql_expression_dependencies

Analyzing SQL Server Dependencies – Client-side Dependencies

Analyzing SQL Server Dependencies – Read-only Stored Procedures

Series: Virtual Static Interface Methods in C#

A topic that was on my imaginary “C# Wishlist” until I found out

1) why it’s a bad idea and

2) how to implement it with techniques C# already provides.

So the series should really be called “Virtual Static Interface Methods in C# – and why you do not need them” 😉

Introduction

Virtual Static Interface Methods in C# – Introduction

First Implementation

Virtual Static Interface Methods in C# – Implementation

Updated Implementation

Even “More Static” Virtual Static Interface Methods in C#

Series: Batch Insert and Batch Update using Linq To SQL

Linq To SQL does not natively support bulk operations (batch operations).

A new batch operation should operate on the existing Linq To SQL infrastructure, namely

• the L2S DataContext
• the class declarations of the data model generated by the .dbml designer

This series sketches an implementation of batch operations using Linq To SQL:

Introduction

Bulk Operations using Linq To SQL

Batch Update

Batch Update using Linq To SQL

Generating T-SQL from Linq queries

Converting Linq Expressions to T-SQL

Batch Insert

Batch Insert using Linq To SQL

Batch Insert with Column Mapping

Batch Insert using Linq To SQL (2)

Series: ASP.Net User Control Libraries

How to create User Control Libraries in Visual Studio and why this is a bad idea.

Creating ASP.Net User Control Libraries in Visual Studio 2010

getting started

Migrating ASP.Net User Controls to a DLL in Visual Studio 2010

migrating existing code

Handling tilde (~) paths in ASCX correctly using ParseControl

an issue and a fix

Wiring Events of ASCX Controls after ParseControl

another issue fixed

ASP.Net UserControl Life Cycle in DesignMode

an insight

Updating a Single Column in Linq to SQL – Summary

The standard way to update a record using Linq to SQL is to load a record from the database, assign the new column values, and submit the changes.

This method is undesirable if your table contains long text or binary columns, since they are loaded into the Linq to SQL object without being used.

Starting with a table containing nvarchar(max) and varbinary(max) columns

CREATE TABLE [dbo].[FooMax](
  [OID] [int] IDENTITY(1,1) NOT NULL,
  [ID] [nvarchar](50) NOT NULL,
  [SomeText] [nvarchar](max) NULL,
  [SomeBinary] [varbinary](max) NULL,
  CONSTRAINT [PK_FooMax] PRIMARY KEY CLUSTERED ([OID] ASC)
)

I listed a couple of methods to reduce database access to the columns actually required in the UPDATE process:

• Initial post

• Updating a Single Column in Linq to SQL using a Stored Procedure

• Updating a Single Column in Linq to SQL using a View

• Updating a Single Column in Linq to SQL using ExecuteCommand

• Updating a Single Column in Linq to SQL using an Alias

• Updating a Single Column in Linq to SQL using Attach

The dbml mappings for these solutions