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"); }