Selecting primitive types

[dplaskon]

Perhaps I'm missing something obvious - but is there no way to get a result set of primitive types back without resorting to using a data reader.

For example, how do I do something along the lines of:

var query = SQL
   .SELECT("p.ProductName")
   .FROM("Products p");

IEnumerable<string> names = conn.Map<string>(query);

[maxtoroq]

Currently, you have to explicitly provide a mapping delegate, otherwise it asumes you want to map columns to properties of the type parameter (String on this case):

IEnumerable<string> names = conn.Map<string>(query, r => r.GetString(0));

[maxtoroq]

With type inference you can ommit the type parameter:

IEnumerable<string> names = conn.Map(query, r => r.GetString(0));

[dplaskon]

Works perfectly, thanks again!