Querying for Objects

Insight can automatically convert query results to objects. Just use the Query extension method to execute a query and return a list of objects.

class Beer
{
	public string Name { get; internal set; }
	public string Flavor { get; internal set; }
	public decimal? OriginalGravity { get; internal set; }
}

IList<Beer> beer = Database.Connection().Query<Beer>("FindBeer", new { Name = "IPA" });

Look, ma! No mapping files!

The generic type argument specifies the expected return type. Insight automatically creates a mapping between the schema of the result set and the object type and performs the mapping. For more details see Mapping Results to Objects.

This also works with SQL text:

IList<Beer> beer = Database.Connection().QuerySql<Beer>(
	"SELECT * FROM Beer WHERE Name = @Name",
	new { Name = "IPA" });

If you already have an IDataReader (from any source!), you can use the ToList extension to convert the reader to objects:

	using (SqlConnection connection = Database.Open())
	using (IDataReader reader = connection.GetReader("FindBeer", new { Name = "IPA" }))
	{
		IList<Beer> beer = reader.ToList<Beer>();
	}

Or AsEnumerable:

	using (SqlConnection connection = Database.Open())
	using (IDataReader reader = connection.GetReader("FindBeer", new { Name = "IPA" }))
	{
		foreach (Beer beer in reader.AsEnumerable<Beer>())
		{
			// drink?
		}
	}

Executing SQL Commands - BACK || NEXT- Identity Inserts