public override string GetUserNameByEmail(string email)
{
if (email == null)
{
throw new ArgumentNullException("email");
}
string userName = null;
using (var conn = this.CreateConnection())
{
if (conn.HasConnection)
{
using (var cmd = conn.CreateTextCommand(string.Format("SELECT userName FROM {0}Users WHERE BlogID = {1}blogid AND emailAddress = {1}email", this.tablePrefix, this.parmPrefix)))
{
cmd.Parameters.Add(conn.CreateParameter(FormatParamName("blogid"), Blog.CurrentInstance.Id.ToString()));
cmd.Parameters.Add(conn.CreateParameter(FormatParamName("email"), email));
using (var rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
userName = rdr.GetString(0);
}
}
}
}
}
return userName;
}