protected virtual SqlStatement CreateSqlStatement(MembershipProviderSqlStatement command)
{
SqlText sql = new SqlText(Statements[command], ConnectionStringSettings.Name);
sql.Command.CommandText = sql.Command.CommandText.Replace("@", sql.ParameterMarker);
if (sql.Command.CommandText.Contains((sql.ParameterMarker + "ApplicationName")))
{
sql.AssignParameter("ApplicationName", ApplicationName);
}
sql.Name = ("VSM Application Membership Provider - " + command.ToString());
sql.WriteExceptionsToEventLog = WriteExceptionsToEventLog;
return(sql);
}
public override Image UserPictureImage(MembershipUser user)
{
using (SqlText sql = new SqlText("SELECT gpu.Picture FROM Grid_Persona_Usuario_V gpu WHERE gpu.UserName = @UserName"))
{
sql.AssignParameter("@UserName", user.UserName);
if (sql.Read())
{
byte[] value = (byte[])sql["Picture"];
if (value != null)
{
return(Image.FromStream(new MemoryStream(value)));
}
}
}
return(base.UserPictureImage(user));
}