public static void ParameterBuilderShouldReturnParameterCountMatchingComparisonCount()
{
TableColumns test = new TableColumns();
QueryFilter <TableColumns> q = test.TestOne == "gorilla" && test.TestOne != "gobots";
SqlClientParameterBuilder paramBuilder = new SqlClientParameterBuilder();
Out(q.Parse(), ConsoleColor.Cyan);
foreach (DbParameter parameter in paramBuilder.GetParameters(q))
{
OutFormat("Name: {0}, Value: {1}", parameter.ParameterName, parameter.Value, ConsoleColor.Yellow);
}
}
public static void ParameterBuilderShouldBuildParametersFromSqlString()
{
SqlStringBuilder sql = new SqlStringBuilder();
TableColumns columns = new TableColumns();
sql.Select("Monkey").Where(columns.TestOne != "monkey");
Expect.AreEqual(1, sql.Parameters.Length);
SqlClientParameterBuilder builder = new SqlClientParameterBuilder();
DbParameter[] parameters = builder.GetParameters(sql);
Expect.AreEqual(1, parameters.Length);
Out(sql.ToString());
foreach (DbParameter param in parameters)
{
OutFormat("{0}={1}\r\n", param.ParameterName, param.Value.ToString());
}
}
