开发者

LINQPAD trying to specify SQL Server Compact 4 databases

开发者 https://www.devze.com 2023-01-25 23:57 出处:网络
I have 2 SQL Server Compact 4 databases (sdf files) that I\'m trying to query using LINQPAD v4.28.2 (with autoco开发者_如何学Gompletion option). I opened the 2 sdf files in LINQPAD but when I try to s

I have 2 SQL Server Compact 4 databases (sdf files) that I'm trying to query using LINQPAD v4.28.2 (with autoco开发者_如何学Gompletion option). I opened the 2 sdf files in LINQPAD but when I try to specify the database to use (e.g. database1.table1.Take(50)) I get an error that says "The name 'database1' does not exist in the current context".


LINQPad 4.28 premium supports cross-database querying - but only for SQL Server, not SQL CE. I'm almost certain SQL CE itself forbids cross-database querying - have you tried it in SSMS or VS?

0

精彩评论

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