private List<UserIdPair> GetUserIdPairs(IDbConnection connection, IDbTransaction transaction)
{
var userIdPairs = new List<UserIdPair>();
using (var command = connection.CreateCommand())
{
command.Transaction = transaction;
command.CommandText = "SELECT [UserID], [UserName] FROM [Membership].[User] WHERE [UserName] IN ('bradpitt', 'meganfox', 'terminator')";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var pair = new UserIdPair((string)reader["UserName"], (Guid)reader["UserID"]);
userIdPairs.Add(pair);
}
}
}
return userIdPairs;
}
private List <UserIdPair> GetUserIdPairs(IDbConnection connection, IDbTransaction transaction)
{
var userIdPairs = new List <UserIdPair>();
using (var command = connection.CreateCommand())
{
command.Transaction = transaction;
command.CommandText = "SELECT [UserID], [UserName] FROM [Membership].[User] WHERE [UserName] IN ('bradpitt', 'meganfox', 'terminator')";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var pair = new UserIdPair((string)reader["UserName"], (Guid)reader["UserID"]);
userIdPairs.Add(pair);
}
}
}
return(userIdPairs);
}
