Ok, that was a stupid title.  But hey, I’m not a comedian.

Just finished looking through the Stored Procedure Object Interface Layer (SPOIL) write up on MSDN’s Solution Architecture Center.  SPOIL allows you to declaratively link a method with the same signature as the stored procedure (except using BCL types) together.  For example,  take this stored procedure sample:

CREATE PROCEDURE [dbo].[SendLog_Update]
@BatchId uniqueidentifier,
@PartnerId nvarchar(50),
@Mailbox nvarchar(50),
@RootName nvarchar(100),
@Directory nvarchar(100),
@StartPackaging datetime,
@TotalBytes bigint,
@SendBytes bigint
) …

To something like this in code:

[SqlCommandMethod(CommandType.StoredProcedure, "SendLog_Update")]
public int SendLog_Update(
    Guid BatchId,
50)] string PartnerId,
50)] string Mailbox,
100)] string RootName,
100)] string Directory,
    DateTime StartPackaging,
long TotalBytes,
long SendBytes)
{ ... }

Kinda different, huh?  Check it out and let me know what you guys think!