Skip to content

Instantly share code, notes, and snippets.

@Dillie-O
Created May 9, 2013 18:17
Show Gist options
  • Save Dillie-O/5549386 to your computer and use it in GitHub Desktop.
Save Dillie-O/5549386 to your computer and use it in GitHub Desktop.
Simple SearchParameter object for EF parameterized queries. Includes constructors to account for various scenarios
public class SearchParameter
{
public string Name { get; set; }
public string Criteria { get; set; }
public string VariableName { get; set; }
public string ParameterName { get; set; }
public string ParameterType { get; set; }
public string VariableNameSecondary { get; set; }
public string ParameterNameSecondary { get; set; }
public string ParameterTypeSecondary { get; set; }
public bool IsWildcard { get; set; }
public bool HasMultiple { get; set; }
// Full constructor
public SearchParameter(string name,
string criteria,
string variableName,
string parameterName,
string parameterType,
string variableNameSecondary,
string parameterNameSecondary,
string parameterTypeSecondary,
bool isWildcard,
bool hasMultiple)
{
Name = name;
Criteria = criteria;
VariableName = variableName;
ParameterName = parameterName;
ParameterType = parameterType;
VariableNameSecondary = variableNameSecondary;
ParameterNameSecondary = parameterNameSecondary;
ParameterTypeSecondary = parameterTypeSecondary;
IsWildcard = isWildcard;
HasMultiple = hasMultiple;
}
// Basic constructor
public SearchParameter(string name,
string criteria,
string variableName,
string parameterName,
string parameterType)
{
Name = name;
Criteria = criteria;
VariableName = variableName;
ParameterName = parameterName;
ParameterType = parameterType;
VariableNameSecondary = null;
ParameterNameSecondary = null;
ParameterTypeSecondary = null;
IsWildcard = false;
HasMultiple = false;
}
// Basic constructor with multiple/wildcard options
public SearchParameter(string name,
string criteria,
string variableName,
string parameterName,
string parameterType,
bool isWildcard,
bool hasMultiple)
{
Name = name;
Criteria = criteria;
VariableName = variableName;
ParameterName = parameterName;
ParameterType = parameterType;
VariableNameSecondary = null;
ParameterNameSecondary = null;
ParameterTypeSecondary = null;
IsWildcard = isWildcard;
HasMultiple = hasMultiple;
}
// Basic constructor with secondary values
public SearchParameter(string name,
string criteria,
string variableName,
string parameterName,
string parameterType,
string variableNameSecondary,
string parameterSecondaryName,
string parameterSecondaryType)
{
Name = name;
Criteria = criteria;
VariableName = variableName;
ParameterName = parameterName;
ParameterType = parameterType;
VariableNameSecondary = variableNameSecondary;
ParameterNameSecondary = parameterSecondaryName;
ParameterTypeSecondary = parameterSecondaryType;
IsWildcard = false;
HasMultiple = false;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment