Helper method to cast SqlDataReader to generic list

SqlHelpers.cs

public static class SqlHelpers
{
	public static List<T> ToList<T>(this SqlDataReader reader)
	{
		var properties = typeof(T).GetProperties().Select(x => x.Name);
		List<T> result = new List<T>();
		while(reader.Read())
		{
			var instance = Activator.CreateInstance<T>();
			foreach(var p in properties)
			{
				var prop = instance.GetType().GetProperty(p);
				var value = (reader[p] == DBNull.Value) ? null : reader[p];
				prop.SetValue(instance, value, null);
			}
			result.Add(instance);
		}
		reader.Close();
		return result;
	}
}

SqlHelpersExample.cs

using(var connection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]))
{
	connection.Open();
	SqlCommand cmd = new SqlCommand("SELECT * FROM Posts", connection);
	List<Post> posts = cmd.ExecuteReader().ToList<Post>();
}