public void ConstructType()
{
var statement = new DbStatement <SqlParameter>("exec proc", CommandType.StoredProcedure);
Assert.Equal("exec proc", statement.Text);
Assert.Empty(statement.Parameters);
Assert.Equal(CommandType.StoredProcedure, statement.Type);
}
public void ConstructBasic()
{
var statement = new DbStatement <SqlParameter>("select * from frog");
Assert.Equal("select * from frog", statement.Text);
Assert.Empty(statement.Parameters);
Assert.Equal(CommandType.Text, statement.Type);
}
public void ConstructTypeParameters()
{
var statement = new DbStatement <SqlParameter>(
"exec getfrogs @species, @colour", CommandType.StoredProcedure,
new SqlParameter("@species", "tree"), new SqlParameter("@colour", "green"));
Assert.Equal("exec getfrogs @species, @colour", statement.Text);
Assert.Equal(CommandType.StoredProcedure, statement.Type);
Assert.Equal(2, statement.Parameters.Length);
Assert.Contains(statement.Parameters, p => p.ParameterName == "@species" && (string)p.Value == "tree");
Assert.Contains(statement.Parameters, p => p.ParameterName == "@colour" && (string)p.Value == "green");
}
public void ConstructParameters()
{
var statement = new DbStatement <SqlParameter>(
"select * from frog where species like @species and colour like @colour",
new SqlParameter("@species", "tree"), new SqlParameter("@colour", "green"));
Assert.Equal("select * from frog where species like @species and colour like @colour", statement.Text);
Assert.Equal(CommandType.Text, statement.Type);
Assert.Equal(2, statement.Parameters.Length);
Assert.Contains(statement.Parameters, p => p.ParameterName == "@species" && (string)p.Value == "tree");
Assert.Contains(statement.Parameters, p => p.ParameterName == "@colour" && (string)p.Value == "green");
}
