Anonymous objects as key-value list

Anonymous object

Lately, I have been using anonymous object quite alot as a way to pass in a number of key-value pairs into methods. This (I believe) is a quite nice way to expose a way to send an unknown number of key-value pairs into a method.

I first encountered this in ASP.NET MVC where it can be used for passing in route data or html attributes to generate an ActionLink. I tend to use it mostly when I need to work with unknown key-value pairs, such as html attributes or sql parameters.

Here's an example of how to use an anonymous object as a way of passing parameters into a sql call (using SqlCe in this example). 

protected virtual IEnumerable<SqlCeParameter> BuildParameters(object parameters)
	foreach (PropertyDescriptor propertyDecriptor in TypeDescriptor.GetProperties(parameters))
		var name = propertyDecriptor.Name.StartsWith("@")
			? propertyDecriptor.Name
			: "@" + propertyDecriptor.Name;
		var value = propertyDecriptor.GetValue(parameters);
		yield return new SqlCeParameter(name, value ?? DBNull.Value);

And here is another example of a method call using an anonymous object.

public void Execute()
	Execute(@"INSERT INTO [User](FirstName, LastName, Email) 
		VALUES(@FirstName, @LastName, @Email)", 
		new { _user.FirstName, _user.LastName, _user.Email });

For complete code for this post, check out the github repository below.


[Demo Example]

May 22, 2012