public static GetFlags ( string dtd ) : string | ||
dtd | string | |
return | string |
/// <summary> /// Retrieves parameter information from the stored procedure specified /// in the MySqlCommand and populates the Parameters collection of the /// specified MySqlCommand object. /// This method is not currently supported since stored procedures are /// not available in MySql. /// </summary> /// <param name="command">The MySqlCommand referencing the stored /// procedure from which the parameter information is to be derived. /// The derived parameters are added to the Parameters collection of the /// MySqlCommand.</param> /// <exception cref="InvalidOperationException">The command text is not /// a valid stored procedure name.</exception> public static void DeriveParameters(MySqlCommand command) { if (command.CommandType != CommandType.StoredProcedure) { throw new InvalidOperationException(Resources.CanNotDeriveParametersForTextCommands); } // retrieve the proc definition from the cache. string spName = command.CommandText; if (spName.IndexOf(".") == -1) { spName = command.Connection.Database + "." + spName; } try { DataSet ds = command.Connection.ProcedureCache.GetProcedure(command.Connection, spName, null); DataTable parameters = ds.Tables["Procedure Parameters"]; DataTable procTable = ds.Tables["Procedures"]; command.Parameters.Clear(); foreach (DataRow row in parameters.Rows) { MySqlParameter p = new MySqlParameter(); p.ParameterName = String.Format("@{0}", row["PARAMETER_NAME"]); if (row["ORDINAL_POSITION"].Equals(0) && p.ParameterName == "@") { p.ParameterName = "@RETURN_VALUE"; } p.Direction = GetDirection(row); bool unsigned = StoredProcedure.GetFlags(row["DTD_IDENTIFIER"].ToString()).IndexOf("UNSIGNED") != -1; bool real_as_float = procTable.Rows[0]["SQL_MODE"].ToString().IndexOf("REAL_AS_FLOAT") != -1; p.MySqlDbType = MetaData.NameToType(row["DATA_TYPE"].ToString(), unsigned, real_as_float, command.Connection); if (!row["CHARACTER_MAXIMUM_LENGTH"].Equals(DBNull.Value)) { p.Size = (int)row["CHARACTER_MAXIMUM_LENGTH"]; } if (!row["NUMERIC_PRECISION"].Equals(DBNull.Value)) { p.Precision = Convert.ToByte(row["NUMERIC_PRECISION"]); } if (!row["NUMERIC_SCALE"].Equals(DBNull.Value)) { p.Scale = Convert.ToByte(row["NUMERIC_SCALE"]); } if (p.MySqlDbType == MySqlDbType.Set || p.MySqlDbType == MySqlDbType.Enum) { p.PossibleValues = GetPossibleValues(row); } command.Parameters.Add(p); } } catch (InvalidOperationException ioe) { throw new MySqlException(Resources.UnableToDeriveParameters, ioe); } }
public static void DeriveParameters(MySqlCommand command) { if (command.CommandType != CommandType.StoredProcedure) { throw new InvalidOperationException(Resources.CanNotDeriveParametersForTextCommands); } string text = command.CommandText; if (text.IndexOf(".") == -1) { text = command.Connection.Database + "." + text; } try { ProcedureCacheEntry procedure = command.Connection.ProcedureCache.GetProcedure(command.Connection, text, null); command.Parameters.Clear(); foreach (MySqlSchemaRow current in procedure.parameters.Rows) { MySqlParameter mySqlParameter = new MySqlParameter(); mySqlParameter.ParameterName = string.Format("@{0}", current["PARAMETER_NAME"]); if (current["ORDINAL_POSITION"].Equals(0) && mySqlParameter.ParameterName == "@") { mySqlParameter.ParameterName = "@RETURN_VALUE"; } mySqlParameter.Direction = MySqlCommandBuilder.GetDirection(current); bool unsigned = StoredProcedure.GetFlags(current["DTD_IDENTIFIER"].ToString()).IndexOf("UNSIGNED") != -1; bool realAsFloat = procedure.procedure.Rows[0]["SQL_MODE"].ToString().IndexOf("REAL_AS_FLOAT") != -1; mySqlParameter.MySqlDbType = MetaData.NameToType(current["DATA_TYPE"].ToString(), unsigned, realAsFloat, command.Connection); if (current["CHARACTER_MAXIMUM_LENGTH"] != null) { mySqlParameter.Size = (int)current["CHARACTER_MAXIMUM_LENGTH"]; } if (current["NUMERIC_PRECISION"] != null) { mySqlParameter.Precision = Convert.ToByte(current["NUMERIC_PRECISION"]); } if (current["NUMERIC_SCALE"] != null) { mySqlParameter.Scale = Convert.ToByte(current["NUMERIC_SCALE"]); } if (mySqlParameter.MySqlDbType == MySqlDbType.Set || mySqlParameter.MySqlDbType == MySqlDbType.Enum) { mySqlParameter.PossibleValues = MySqlCommandBuilder.GetPossibleValues(current); } command.Parameters.Add(mySqlParameter); } } catch (InvalidOperationException ex) { throw new MySqlException(Resources.UnableToDeriveParameters, ex); } }
/// <summary> /// Retrieves parameter information from the stored procedure specified /// in the MySqlCommand and populates the Parameters collection of the /// specified MySqlCommand object. /// This method is not currently supported since stored procedures are /// not available in MySql. /// </summary> /// <param name="command">The MySqlCommand referencing the stored /// procedure from which the parameter information is to be derived. /// The derived parameters are added to the Parameters collection of the /// MySqlCommand.</param> /// <exception cref="InvalidOperationException">The command text is not /// a valid stored procedure name.</exception> public static void DeriveParameters(MySqlCommand command) { if (!command.Connection.driver.Version.isAtLeast(5, 0, 0)) { throw new MySqlException("DeriveParameters is not supported on MySQL versions " + "prior to 5.0"); } // retrieve the proc definitino from the cache. string spName = command.CommandText; if (spName.IndexOf(".") == -1) { spName = command.Connection.Database + "." + spName; } DataSet ds = command.Connection.ProcedureCache.GetProcedure(command.Connection, spName); DataTable parameters = ds.Tables["Procedure Parameters"]; DataTable procTable = ds.Tables["Procedures"]; command.Parameters.Clear(); foreach (DataRow row in parameters.Rows) { MySqlParameter p = new MySqlParameter(); p.ParameterName = String.Format("@{0}", row["PARAMETER_NAME"]); if (row["ORDINAL_POSITION"].Equals(0) && p.ParameterName == "@") { p.ParameterName = "@RETURN_VALUE"; } p.Direction = GetDirection(row); bool unsigned = StoredProcedure.GetFlags(row["DTD_IDENTIFIER"].ToString()).IndexOf("UNSIGNED") != -1; bool real_as_float = procTable.Rows[0]["SQL_MODE"].ToString().IndexOf("REAL_AS_FLOAT") != -1; p.MySqlDbType = MetaData.NameToType(row["DATA_TYPE"].ToString(), unsigned, real_as_float, command.Connection); if (!row["CHARACTER_MAXIMUM_LENGTH"].Equals(DBNull.Value)) { p.Size = (int)row["CHARACTER_MAXIMUM_LENGTH"]; } if (!row["NUMERIC_PRECISION"].Equals(DBNull.Value)) { p.Precision = Convert.ToByte(row["NUMERIC_PRECISION"]); } if (!row["NUMERIC_SCALE"].Equals(DBNull.Value)) { p.Scale = Convert.ToByte(row["NUMERIC_SCALE"]); } command.Parameters.Add(p); } }
private MySqlParameter GetAndFixParameter(string spName, MySqlSchemaRow param, bool realAsFloat, MySqlParameter returnParameter) { string arg_10_0 = (string)param["PARAMETER_MODE"]; string parameterName = (string)param["PARAMETER_NAME"]; if (param["ORDINAL_POSITION"].Equals(0)) { if (returnParameter == null) { throw new InvalidOperationException(string.Format(Resources.RoutineRequiresReturnParameter, spName)); } parameterName = returnParameter.ParameterName; } MySqlParameter parameterFlexible = this.command.Parameters.GetParameterFlexible(parameterName, true); if (!parameterFlexible.TypeHasBeenSet) { string typeName = (string)param["DATA_TYPE"]; bool unsigned = StoredProcedure.GetFlags(param["DTD_IDENTIFIER"].ToString()).IndexOf("UNSIGNED") != -1; parameterFlexible.MySqlDbType = MetaData.NameToType(typeName, unsigned, realAsFloat, base.Connection); } return(parameterFlexible); }