It doesn't appear there is any direct support for 'exists' clauses. I realize that this can be handled with a stored procedure or the InlineQuery tool, but I am wondering why 'Exists' aren't directly supported as part of the where expression tree.
I'm going to venture a guess that since "Exists" is a database function, it's not implemented as there is no implemention of functions in SubSonic. This could simply be because some functions are database specific and SubSonic tries to abstract the underlaying database type.
------------------ Boyan Kostadinov Blog: http://blog.tech-cats.com Resume: http://boyan.tech-cats.com/resume Portfolio: http://boyan.tech-cats.com/portfolio
Correct me if I'm wrong but 'Exists' and 'IN' are very similar functional structures and SubSonic supports 'IN' queries. Additionally, I believe the 3 major DB's (SqlServer, Oracle, and MySql) all support 'EXISTS' so it .
yobi21: Correct me if I'm wrong but 'Exists' and 'IN' are very similar functional structures and SubSonic supports 'IN' queries. Additionally, I believe the 3 major DB's (SqlServer, Oracle, and MySql) all support 'EXISTS' so it .
Similar yes, performance is another matter. EXISTS will outperform IN in SQL Server 2k+ and Oracle, whereas in MySQL, it will not.