Snipplr - rengber

(C#) Proxyless WCF Client Side

Thu, 02 Feb 2012 04:11:33 GMT

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

(C#) Minimalist WCF Client-side Config File

Wed, 01 Feb 2012 09:17:14 GMT

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

Wed, 01 Feb 2012 07:45:34 GMT

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

Wed, 30 Nov 2011 06:18:50 GMT

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)

Mon, 24 May 2010 16:44:20 GMT

Certmgr is in the Windows 7 SDK

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

Wed, 27 Jan 2010 12:21:41 GMT

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

Thu, 14 Jan 2010 15:09:24 GMT

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

Thu, 03 Sep 2009 21:48:26 GMT

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

Mon, 31 Aug 2009 22:48:15 GMT

Dead simple, but often forgotten.

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

Tue, 25 Aug 2009 17:52:51 GMT

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

Sun, 16 Aug 2009 18:45:04 GMT

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

(SQL) SQL Server String Split Function

Wed, 29 Jul 2009 23:37:26 GMT

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

Sun, 26 Jul 2009 23:57:39 GMT

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

(C#) Minimalist XSLT Transform Using Two Strings

Wed, 15 Jul 2009 21:24:03 GMT

(C#) DataGridView DataBind an Array of Arbitrary Objects

Tue, 09 Jun 2009 18:50:51 GMT

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

Wed, 03 Jun 2009 18:08:00 GMT

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

Thu, 30 Apr 2009 00:51:06 GMT

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

Mon, 20 Apr 2009 19:34:00 GMT

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

Tue, 14 Apr 2009 23:53:32 GMT

This is stupidly simple, but I always forget it.

(SQL) TSQL Try Catch Error Handling

Mon, 23 Feb 2009 21:05:08 GMT

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.