public void FromWithExplicitPrefixShouldPrependPrefixBeforeTableName()
{
var from = new Select <DataSource>(c => c.Text).From(prefix: "prefix.");
Assert.Equal("SELECT Text FROM prefix.DataSourceTable", from.ToString());
}
public void FromWithPrefixedSourceShouldPrependPrefixBeforeTableName()
{
var from = new Select <PrefixedSource>(p => p.Text).From(typeof(PrefixedSource));
Assert.Equal("SELECT Text FROM dbo.Prefixed", from.ToString());
}
public void FromWithoutPrefixedSourceShouldNotPrependPrefixBeforeTableName()
{
var from = new Select <DataClass>(c => c.Text).From(typeof(DataClass));
Assert.Equal("SELECT Text FROM DataClass", from.ToString());
}
public void SimpleWhereClauseComparingStringShouldPutStringInQuotes()
{
var where = new Select <DataSource>(s => s.Text).Where(s => s.Text == "abc");
Assert.Equal("SELECT Text FROM DataSourceTable WHERE Text = 'abc'", where.ToString());
}
public void FromWithNormalTypeShouldUseNameOfType()
{
var from = new Select <DataClass>(s => s.Text).From(typeof(DataClass));
Assert.Equal("SELECT Text FROM DataClass", from.ToString());
}
public void FromWithIDataSourceShouldUseNameOfAttribute()
{
var from = new Select <DataSource>(s => s.Text).From(typeof(DataSource));
Assert.Equal("SELECT Text FROM DataSourceTable", from.ToString());
}
public void SelectWithPropertyShouldReturnCorrectSelectPart(string funcName, string expected)
{
var select = new Select <DataSource>(FuncProvider(funcName));
Assert.Equal(expected, select.ToString());
}
public void NewSelectShouldReturnSelect()
{
var select = new Select <DataClass>();
Assert.Equal("SELECT ", select.ToString());
}
