Rebus.SqlServer icon indicating copy to clipboard operation
Rebus.SqlServer copied to clipboard

Ability to customize column sizes for subscription storage

Open mookid8000 opened this issue 9 years ago • 0 comments

Because column sizes are tricky when they are NVARCHARs and they are used in an index, it should be possible to configure the sizes.

It could look like this:

Configure.With(...)
	.Transport(t => (...))
	.Subscriptions(s => {
		s.StoreInSqlServer(..., "Subscriptions")
			.SetColumnSizes(topicColumnSize: 350, addressColumnSize: 50);
	})
	.Start();

which would then create the schema accordingly.

Moreover, a warning could be logged or an error could be thrown if the schema reflection in Initialize detects that the schema does not match the sizes specified in the Customize... thing.

mookid8000 avatar Nov 14 '16 13:11 mookid8000