Join across databases using Subsonic 3.0

Question

I'm using .NET 4.0, SQL Server, looking to do an inner join across two databases on the same server. Subsonic doesn't seem to like this. Any ideas?

Answer 1

if you have your sql-statement execute it via the CodingHorror-Class

eg.:

            CodingHorror cr = new CodingHorror(sqlIDetails);
            result = cr.ExecuteTypedList<QueueLog>();

Answer 2

You can write a stored procedure and join tables in it