gistfile1.txt

class Queries
{
	public static readonly string FindPrices = @"
SELECT *
FROM prices
";

	public static readonly string FindOneUserByUsername = @"
SELECT *
FROM users
WHERE username = @Username
LIMIT 1
";
}

class PriceEntity
{
	public int Id { get; set; }

	public double Price { get; set; }
}

class User
{
	public int Id { get; set; }

	public string Username { get; set; }
}

class Database
{
	public IEnumerable<PriceEntity> FindPrices()
	{
		using (var connection = CreateConnection())
		{
			var prices = command.Query<PriceEntity>(Queries.FindPrices);

			return prices;
		}
	}

	public User FindOneUserByUsername(string username)
	{
		using (var connection = CreateConnection())
		{
			var user = command.Query<User>(Queries.FindOneUserByUsername, new { Username = username }).FirstOrDefault();

			return user;
		}
	}
}