public static MySqlCommand LogError(
Guid id,
string appName,
string hostName,
string typeName,
string source,
string message,
string user,
int statusCode,
DateTime time,
string xml)
{
var command = new MySqlCommand("elmah_LogError");
command.CommandType = CommandType.StoredProcedure;
var parameters = command.Parameters;
parameters.Add("ErrorId", MySqlDbType.String, 36).Value = id.ToString();
parameters.Add("Application", MySqlDbType.VarChar, _maxAppNameLength).Value = appName.Substring(0, Math.Min(_maxAppNameLength, appName.Length));
parameters.Add("Host", MySqlDbType.VarChar, 30).Value = hostName.Substring(0, Math.Min(30, hostName.Length));
parameters.Add("Type", MySqlDbType.VarChar, 100).Value = typeName.Substring(0, Math.Min(100, typeName.Length));
parameters.Add("Source", MySqlDbType.VarChar, 60).Value = source.Substring(0, Math.Min(60, source.Length));
parameters.Add("Message", MySqlDbType.VarChar, 500).Value = message.Substring(0, Math.Min(500, message.Length));
parameters.Add("User", MySqlDbType.VarChar, 50).Value = user.Substring(0, Math.Min(50, user.Length));
parameters.Add("AllXml", MySqlDbType.Text).Value = xml;
parameters.Add("StatusCode", MySqlDbType.Int32).Value = statusCode;
parameters.Add("TimeUtc", MySqlDbType.Datetime).Value = time;
return command;
}