public void Test_CityCountryAndCompanyNameTranslation() { var translation = string.Empty; string dbConnectionString = @"Server=(localdb)\\mssqllocaldb;Database=Northwind;Trusted_Connection=True;MultipleActiveResultSets=true"; using (SqlConnection con = new SqlConnection(dbConnectionString)) { Northwind db = new Northwind(con); var query = db.Customers.Where(c => c.City == "London" && c.Country == "UK" && c.ContactName == "Thomas Hardy"); translation = new QueryTranslator().Translate(query.Expression); } translation.Should().Be("SELECT * FROM (SELECT * FROM Customers) AS T WHERE(((City = 'London') AND (Country = 'UK')) AND (ContactName = 'Thomas Hardy'))"); }
public void Test_CityTranslation() { var translation = string.Empty; string dbConnectionString = @"Server=(localdb)\\mssqllocaldb;Database=Northwind;Trusted_Connection=True;MultipleActiveResultSets=true"; using (SqlConnection con = new SqlConnection(dbConnectionString)) { Northwind db = new Northwind(con); var query = db.Customers.Where(c => c.City == "London"); translation = new QueryTranslator().Translate(query.Expression); } translation.Should().Be("SELECT * FROM (SELECT * FROM Customers) AS T WHERE(City = 'London')"); }