开发者

Join across databases using Subsonic 3.0

开发者 https://www.devze.com 2023-02-02 07:07 出处:网络
I\'m using .NET 4.0, SQL Server, looking to do an inner join across two databases on the same server. Subsoni开发者_运维问答c doesn\'t seem to like this. Any ideas?You can write a stored procedure and

I'm using .NET 4.0, SQL Server, looking to do an inner join across two databases on the same server. Subsoni开发者_运维问答c doesn't seem to like this. Any ideas?


You can write a stored procedure and join tables in it


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

eg.:

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

精彩评论

暂无评论...
验证码 换一张
取 消