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