SimpleData Raw Query Extension Method

DatabaseExtensions.cs

public static IEnumerable<dynamic> RawQuery(this Database database, string sql)
{
	using (var conn = ((Simple.Data.Ado.AdoAdapter)database.GetAdapter()).ConnectionProvider.CreateConnection())
	using (var cmd = new SqlCommand(sql, (SqlConnection)conn))
	{
		if (conn.State != System.Data.ConnectionState.Open)
			conn.Open();
		
		using (var reader = cmd.ExecuteReader())
		{
			while (reader.Read())
			{
				yield return reader.ToDynamicRecord();
			}
		}
	}
}

public void GetUsers()
{
    Database db = CreateDatabase();  // do not type this as 'var' or else the extension method will not be invoked
    var users = db.RawQuery("SELECT UserID, Name FROM Users");
}