is it possible to access multiple database? in other word can i produce equivelant of "select * from databse1.dbo.table1 where id not in select * from Databse2.dbo.table1"
using sql server databse
thanks
That's not possible unless you explicitly declare the table name in [Table] attribute as "Database2.dbo.table1". There has been a discussion about it in this topic: http://www.tmssoftware.com/site/forum/forum_posts.asp?TID=3875&title=mapping-classes