Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SqlServer schema name Cannot contains symbols #85

Closed
DillonHuang opened this issue Feb 8, 2018 · 1 comment

Comments

@DillonHuang
Copy link

commented Feb 8, 2018

schema设置了 my.cap

capOptions.UseEntityFramework<AppDbContext>(opts => opts.Schema = "my.cap");

会出如下错

System.Data.SqlClient.SqlException: 'Invalid object name 'my.cap.Published'.

应该是因为SqlServerStorage.CreateDbTablesScript方法中

BEGIN
	EXEC('CREATE SCHEMA {schema}')
END;

把上面 {schema} 改成 [{schema}],应该就可以了

DillonHuang pushed a commit to DillonHuang/CAP that referenced this issue Feb 8, 2018
yang-xiaodong added a commit that referenced this issue Feb 8, 2018
@yang-xiaodong

This comment has been minimized.

Copy link
Member

commented Feb 8, 2018

fixed in version 2.1.4-preview-34848409

@yang-xiaodong yang-xiaodong added the fixed label Feb 8, 2018

@DillonHuang DillonHuang closed this Feb 8, 2018

@yang-xiaodong yang-xiaodong changed the title 使用DotNetCore.CAP.SqlServer,Schema不能设置特殊符号的值 SqlServer schema name Cannot contains symbols Feb 8, 2018

yang-xiaodong added a commit that referenced this issue Mar 16, 2018
Release version 2.1.4 (#97)
* Fixed the connection bug of getting message from table. #83

* update version to 2.1.4

* remove `TableNamePrefix` option from `MySqlOptions` to `EFOptions`.  #84

* fixed entityframework rename table name prefix bug.  #84

* fixed sql server scripts bug of create table scheme. #85

* fixed entityframework rename table name prefix bug. #84

* modify error message of logger write

* Fixed bug of the FailedRetryCount does not increase when raised SubscriberNotFoundException. #90

* Fixed thread safety issue about KafkaOptions. #89

* upgrade nuget package
yang-xiaodong added a commit that referenced this issue Aug 21, 2018
Release version 2.1.4 (#97)
* Fixed the connection bug of getting message from table. #83

* update version to 2.1.4

* remove `TableNamePrefix` option from `MySqlOptions` to `EFOptions`.  #84

* fixed entityframework rename table name prefix bug.  #84

* fixed sql server scripts bug of create table scheme. #85

* fixed entityframework rename table name prefix bug. #84

* modify error message of logger write

* Fixed bug of the FailedRetryCount does not increase when raised SubscriberNotFoundException. #90

* Fixed thread safety issue about KafkaOptions. #89

* upgrade nuget package
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.