public void GetsAndSetsCommandText()
{
// Arrange
var command = new SqlCommand();
var adapter = new SqlCommandAdapter(command);
// Act -> Assert
adapter.CommandText = "myCommandText";
Assert.Equal("myCommandText", adapter.CommandText);
}
public void UnquoteIdentifier()
{
var adapter = new CommandAdapter();
Assert.AreEqual("[test]", adapter.UnquoteIdentifier("[test]"));
Assert.AreEqual("[tes''t]", adapter.UnquoteIdentifier("[tes''t]"));
adapter = new SqlCommandAdapter();
Assert.AreEqual("test", adapter.UnquoteIdentifier("[test]"));
Assert.ThrowsException <InvalidOperationException>(() => adapter.UnquoteIdentifier("[tes't]"));
}
public void QuoteIdentifier()
{
var adapter = new CommandAdapter();
Assert.AreEqual("test", adapter.QuoteIdentifier("test"));
Assert.ThrowsException <ArgumentException>(() => adapter.QuoteIdentifier("tes't"));
adapter = new SqlCommandAdapter();
Assert.AreEqual("[test]", adapter.QuoteIdentifier("test"));
Assert.ThrowsException <ArgumentException>(() => adapter.QuoteIdentifier("tes't"));
}
public void ReturnsSqlParameterCollection()
{
// Arrange
var command = new SqlCommand();
var adapter = new SqlCommandAdapter(command);
// Act
var parameters = adapter.Parameters;
// Assert
Assert.IsAssignableFrom <SqlParameterCollection>(parameters);
}
