public void AppendComparison_creates_parameters_and_adds_AND_for_multiple_comparisons()
{
var parameters = new EntityCommand().Parameters;
var filterBuilder =
EntityStoreSchemaQueryGenerator.AppendComparison(
new StringBuilder(),
"alias1",
"propertyName1",
"Value1",
parameters);
EntityStoreSchemaQueryGenerator.AppendComparison(
filterBuilder,
"alias2",
"propertyName2",
"Value2",
parameters);
Assert.Equal(
"alias1.propertyName1 LIKE @p0 AND alias2.propertyName2 LIKE @p1",
filterBuilder.ToString());
Assert.Equal(2, parameters.Count);
Assert.Equal("p0,p1", string.Join(",", parameters.OfType <EntityParameter>().Select(p => p.ParameterName)));
Assert.Equal("Value1,Value2", string.Join(",", parameters.OfType <EntityParameter>().Select(p => p.Value)));
}
public void AppendComparison_creates_parameters_and_adds_AND_for_multiple_comparisons()
{
var parameters = CreateParameters();
var filterBuilder =
EntityStoreSchemaQueryGenerator.AppendComparison(
new StringBuilder(),
"alias1",
"propertyName1",
"Value1",
parameters);
EntityStoreSchemaQueryGenerator.AppendComparison(
filterBuilder,
"alias2",
"propertyName2",
"Value2",
parameters);
Assert.Equal(
"alias1.propertyName1 LIKE @p0 AND alias2.propertyName2 LIKE @p1",
filterBuilder.ToString());
Assert.Equal(2, parameters.Count);
Assert.Equal("p0", parameters[0].ParameterName);
Assert.Equal("Value1", parameters["p0"].Value);
Assert.Equal("Value2", parameters["p1"].Value);
}
public void AppendComparison_does_not_create_comparison_fragment_or_corresponding_parameter_for_non_value()
{
Assert.Empty(
EntityStoreSchemaQueryGenerator.AppendComparison(
new StringBuilder(),
string.Empty,
string.Empty,
/* value */ null,
new Dictionary <string, string>()).ToString());
}
public void AppendComparison_creates_comparison_fragment_and_corresponding_parameter_for_non_null_value()
{
var parameterMap = new Dictionary <string, string>();
Assert.Equal(
"alias.propertyName LIKE @p0",
EntityStoreSchemaQueryGenerator.AppendComparison(
new StringBuilder(),
"alias",
"propertyName",
"Value",
parameterMap).ToString());
Assert.Equal(1, parameterMap.Count);
Assert.Equal(parameterMap["Value"], "p0");
}
public void AppendComparison_creates_comparison_fragment_and_corresponding_parameter_for_non_null_value()
{
var parameters = new EntityCommand().Parameters;
Assert.Equal(
"alias.propertyName LIKE @p0",
EntityStoreSchemaQueryGenerator.AppendComparison(
new StringBuilder(),
"alias",
"propertyName",
"Value",
parameters).ToString());
Assert.Equal(1, parameters.Count);
Assert.Equal("p0", parameters[0].ParameterName);
Assert.Equal("Value", parameters[0].Value);
}
