This one has me completely confused. I am developing a search form for my application and I am dynamically creating queries based on the users input and then executing them via DataContext.ExecuteQuery but some weird things happen when I try and do INNER JOINs. Code Snippet string query = "SELECT * FROM Unit INNER JOIN UnitType ON UnitType.Id = Unit.UnitTypeId WHERE UnitType.Amenities LIKE '%Balcony%'"; IEnumerable units = PropertyDatabase.ExecuteQuery(query); If I run the above code I get a list
Read More...