Sql Server数据库名称存在小数点，执行SqlServerDbFirst报错

[LambertW]

可创建数据库 Test.DB,
_sqlserverFixture.SqlServer.DbFirst.GetTablesByDatabase("Test.DB");
就能重现此问题。

[LambertW]

use {db};
没有包裹[Test.DB]引起~

[2881099]

我是设计能支持多库，如果在内里[Test.DB]，就不能跨库或者跨Schema使用了。

[LambertW]

以GetTablesByDatabase为例，如何实现支持多库？不太理解。

use {db};
select 
 a.Object_id
,b.name 'Owner'
,a.name 'Name'
,'TABLE' type
from sys.tables a
inner join sys.schemas b on b.schema_id = a.schema_id
where not(b.name = 'dbo' and a.name = 'sysdiagrams')
union all
select
 a.Object_id
,b.name 'Owner'
,a.name 'Name'
,'VIEW' type
from sys.views a
inner join sys.schemas b on b.schema_id = a.schema_id
union all
select 
 a.Object_id
,b.name 'Owner'
,a.name 'Name'
,'StoreProcedure' type
from sys.procedures a
inner join sys.schemas b on b.schema_id = a.schema_id
where a.type = 'P' and charindex('$NPSP', a.name) = 0 and charindex('diagram', a.name) = 0
order by type desc, b.name, a.name
;
use {olddatabase};

[2881099]

看错了，确实有要加[]，我处理一下，谢谢

[2881099]

问题已修复，忘了回复。