public void StringQueryTest(IQueryable <TestQuery> query, string expectedResult)
{
MySQLTranslator translator = new MySQLTranslator();
SQLPredicate Sql = translator.Translate(query.Expression);
Assert.Equal(expectedResult, Sql.Sql);
}
public void QueryTests(IQueryable <TestModel> query, string expectedResult)
{
SQLServerTranslator translator = new SQLServerTranslator();
SQLPredicate Sql = translator.Translate(query.Expression);
Assert.Equal(expectedResult, Sql.Sql);
}
public void QueryTests(IQueryable <TestModel> query, string expectedResult)
{
MySQLTranslator translator = new MySQLTranslator();
SQLPredicate Sql = translator.Translate(query.Expression);
Console.WriteLine(Sql.Sql);
Assert.Equal(expectedResult, Sql.Sql);
}
public void SelectReturningStringTest()
{
Query <TestModel> queryObject = new Query <TestModel>(new QueryProvider(new DbProvider(DbType.Sql, "Server=127.0.0.1;Database=fakedb;User Id=FakeUser;Password=fake.password;")));
IQueryable <string> query = queryObject.Where(t => t.BoolProperty == true && t.EnumProperty == TestEnum.Three).Select(t => t.StringProperty);
string expectedResult = "SELECT t.[StringProperty] FROM (SELECT * FROM (SELECT t.[Id], t.[BoolProperty], t.[CreatedOn], t.[DateTimeProperty], t.[EnumProperty], t.[StringProperty], t.[UpdatedOn] FROM TestModels AS t) AS t WHERE ((t.[BoolProperty] = @P0) AND (t.[EnumProperty] = @P1))) AS t";
SQLServerTranslator translator = new SQLServerTranslator();
SQLPredicate Sql = translator.Translate(query.Expression);
Assert.Equal(expectedResult, Sql.Sql);
}
