Snipplr

(C#) Array ConvertAll with Lambda - rengber

Wed, 05 Sep 2012 06:40:26 UTC

Lambda expression to convert an array.

(C#) Proxyless WCF Client Side - rengber

Thu, 02 Feb 2012 04:11:33 UTC

From page 70 or so of Juval Lowry's Programming WCF

(C#) Minimalist WCF Client-side Config File - rengber

Wed, 01 Feb 2012 09:17:14 UTC

Again, A-B-C. All the Behaviour garbage that "Add Service Reference" inserts for the TCP binding is unnecessary, especially if the Operation Contract is only for simple value types.

(C#) Minimalist WCF Server-side Config File - rengber

Wed, 01 Feb 2012 07:45:34 UTC

ABC - Address Binding Contract Note that the Service Name and Contract must match a real live type (case Sensitive) Binding name is also case sensitive.

(C#) Simplest Possible Background Thread and Console App Lifetime Test - rengber

Wed, 30 Nov 2011 06:18:50 UTC

Saw some strange console app behavior while hosting quartz.net had to doublecheck that a console app will not exit while background threads are running. In the example below, once the main method ends, the app stays alive for 10 seconds while the background thread finishes.

(C#) Command Line to Add Certificates to Certificate Stores (Including the Intermediate CA Store) - rengber

Mon, 24 May 2010 16:44:20 UTC

Certmgr is in the Windows 7 SDK

(Other) Command to Extract the Contents of an MSI File to a Folder - rengber

Wed, 27 Jan 2010 12:21:41 UTC

note, MSIExec /? will launch a dialog box with switch documentation.

(C#) Get the Namespace, Class Name, and Method Name of the Currently Executing Method Via Reflection - rengber

Thu, 14 Jan 2010 15:09:24 UTC

GetFrame(1) to avoid the last method being this property accessor. Note that in a child class inherited member, the Class name will be the name of the type containing the implementation.

(SQL) TSQL Convert DateTime - rengber

Thu, 03 Sep 2009 21:48:26 UTC

I am forever forgetting this. Have to look up the 101 vs 103 in books online every time. Also forget which way around is US/NZ format. :-)

(SQL) TSQL to Get the SQL Autonumber ID of the Row Just Inserted - rengber

Mon, 31 Aug 2009 22:48:15 UTC

Dead simple, but often forgotten.

(C#) Dump an Arbitrary Object to XML (Bypassing Default Serialization) - rengber

Tue, 25 Aug 2009 17:52:51 UTC

Useful in cases where the object author has specified their own serialization that doesn't work for you.

(C#) DataBinding an Arbitrary XML String to an ASP.Net GridViev - rengber

Sun, 16 Aug 2009 18:45:04 UTC

Definitely falls into the category of "simple thing I shoulda memorized years ago", but whatever:

(SQL) SQL Server String Split Function - rengber

Wed, 29 Jul 2009 23:37:26 UTC

From StackOverflow. I'm still not quite happy with my understanding of it, but it looks an order of magnitude more elegant than most I've found.

(SQL) TSQL Function and Check Constraint to Ensure that a Parent Value is Present in the Table - rengber

Sun, 26 Jul 2009 23:57:39 UTC

If a "InReplyToID" is provided, it must be a valid MessageId

(C#) Minimalist XSLT Transform Using Two Strings - rengber

Wed, 15 Jul 2009 21:24:03 UTC

(C#) DataGridView DataBind an Array of Arbitrary Objects - rengber

Tue, 09 Jun 2009 18:50:51 UTC

Stupidly simple -- just one pitfall: class to be bound must have Get/Set methods for reflection to discover. Which is annoying when it comes to client side classes auto generated from WSDL.

(C#) Using Moq to Return a Mock Object from a Factory - rengber

Wed, 03 Jun 2009 18:08:00 UTC

Note that the interface member is mockVar.Object mockVar won't cast to your interface.

(C#) Copy All Object Values from Another Instance of the Same Type Using Reflection - rengber

Thu, 30 Apr 2009 00:51:06 UTC

Say that you have a collection of objects empty but for IDs. You want to do a foreach loop through those objects and lookup detail one at a time. Unfortunately, in the foreach, you can't replace the references, you can only copy the new detail into the object. This technique will populate your current reference from an object instance returned by a lookup.

(C#) LINQ Extension Methods - rengber

Mon, 20 Apr 2009 19:34:00 UTC

LINQ Extension method called with delegate, anonymous delegate, and lambda delegate. Note that this only returns a "default" in the sense that it does not throw an exception if no item in the source matches the selection criteria. .First() does throw an exception in this case.

(C#) C# Call a Constructor Overload from the Default Constructor - rengber

Tue, 14 Apr 2009 23:53:32 UTC

This is stupidly simple, but I always forget it.

(SQL) TSQL Try Catch Error Handling - rengber

Mon, 23 Feb 2009 21:05:08 UTC

This as it sits isn't an improvement on what happens by default. It's only useful combined with a compensating transaction or sad path in the catch block, or in allowing a loop to continue.

(SQL) TSQL to Start a Job Programatically - rengber

Sun, 22 Feb 2009 15:51:28 UTC

(SQL) Basic TSQL Cursor Syntax - rengber

Wed, 18 Feb 2009 22:21:44 UTC

Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.

(C#) Extracting an Int from a Little Endian or Big Endian Byte Array - rengber

Mon, 09 Feb 2009 22:21:05 UTC

Found this in some code I've been maintaining/expanding. Quite clever. Picture an array of bytes in binary 00000111 11100000 00000000 00000000 Now picture an Int32 in Binary 00000000000000000000000000000000 To grab a Little Endian Integer (16 bits) out of the array. Take the second array element 11100000 Assign it to the Int32 variable 00000000000000000000000011100000 Bit shift it up by 8 00000000000000001110000000000000 Now OR it with the first Array element - could also just add.


        00000000000000001110000000000000
or     00000000000000000000000000000111
=      00000000000000001110000000000111

(C#) C# Attribute to Mark a Method as "Deprecated" - rengber

Wed, 21 Jan 2009 16:27:42 UTC

(C#) Using NMock to Create an IDataReader for Testing Data Access Methods - rengber

Wed, 19 Nov 2008 21:32:37 UTC

Shows how to mock the Object["CollectionItemName"] syntax.

(C#) Using a Virtual Factory Method with NMock to help NUnit Testing - rengber

Thu, 13 Nov 2008 22:38:47 UTC

(C#) Generic Convert - rengber

Mon, 10 Nov 2008 19:42:38 UTC

This technique can convert a list of one type into a list of another in a single line given and instance to instance conversion method to be passed to the delegate constructor.

(C#) Manually Send an SMTP Message from a Telnet Session. - rengber

Thu, 21 Aug 2008 00:19:41 UTC

Mail might not send from user different from current domain or to user in ouside domain. Data section terminated by CRLF.CRLF

(C#) Using a BackgroundWorker Object from a Winform - rengber

Sun, 27 Jul 2008 23:18:51 UTC

I didn't like the way ReportProgress events backed up, so I ran a Timer object to update the progress meter instead.

(HTML) Using a Data URL to Embed an Image in an HTML Page - rengber

Tue, 01 Jul 2008 18:59:33 UTC

Should work for image/gif as well. Allegedly not supported by IE

(Perl) Markov Chain Generator - rengber

Mon, 30 Jun 2008 23:16:39 UTC

My PERL isn't strong enough to get this yet, but I plan on porting to C#. Read this: http://en.wikipedia.org/wiki/Markov_chain

(PHP) PHP to Delete a Cookie - rengber

Wed, 21 May 2008 16:28:14 UTC

(C#) Base64 Encode or Decode a File - rengber

Mon, 28 Apr 2008 19:45:24 UTC

Useful for sending files past filters via email.

(C#) ASP.Net Page to Return an Image from an SQL Blob Query - rengber

Mon, 24 Mar 2008 21:36:37 UTC

(SQL) TSQL for Recursive Select Using Common Table Expressions - rengber

Mon, 24 Mar 2008 18:00:18 UTC

(SQL) SQL To Show WaitTime and other Process Stats - rengber

Wed, 19 Mar 2008 22:55:37 UTC

(SQL) TSQL to Concatenate Subquery Row Values into a Column Value - rengber

Wed, 19 Mar 2008 22:54:33 UTC

(HTML) TiddlyWiki Macro to Create a New Tiddler from a Template Tiddler - rengber

Thu, 28 Feb 2008 21:34:51 UTC

Note that this is formatted for clarity, may need to be all one line for TiddlyWiki.

(XML) XSLT to Pull Data out of an Excel XML Spreadsheet - rengber

Tue, 19 Feb 2008 20:22:00 UTC

(SQL) TSQL to Reset a Tables Primary Key Autonumber - rengber

Sun, 17 Feb 2008 20:42:49 UTC

(HTML) Starting Point XHTML with DTD - rengber

Thu, 14 Feb 2008 19:39:32 UTC

(XML) Baseline RSS XML - rengber

Wed, 13 Feb 2008 22:11:19 UTC

From 4 Guys from Rolla

(HTML) RSS Pointer for IE7 and/or Firefox - rengber

Wed, 13 Feb 2008 21:53:33 UTC

Shows the browser that an RSS feed is available for a page.

(C#) Adding Eventhandlers to DataGrid Rows - rengber

Sun, 03 Feb 2008 19:17:48 UTC

(C#) Filter Expression for a DataTable - rengber

Thu, 31 Jan 2008 20:01:11 UTC

Pretty intuitive, might be an easier/simpler way.

(C#) Adding another item to a databound drop-down list. - rengber

Wed, 30 Jan 2008 22:13:55 UTC

Stupidly simple, but I keep forgetting it.

(C#) ASP.Net Code to Get an Active Directory User Name from the Integrated Authentication Principal Name - rengber

Mon, 28 Jan 2008 17:04:03 UTC

Typically won't work if the ASP.Net service identity (in the machine.config ProcessModel section) is a local account.

(C#) Declarative Code for ASP.Net Repeater to Access CodeBehind Method. - rengber

Tue, 22 Jan 2008 19:20:29 UTC

(SQL) Add a Constant Value to a RecordSet - rengber

Sun, 20 Jan 2008 19:46:57 UTC

Noob stuff, but I always end up looking this up.