Support cache when creating a sequence

[bruceliu2008]

Hi,
May I know are there any plan for ef core to support cache size for sequence, something like this:
modelBuilder.HasSequence("OrderNumbers", schema: "shared")
.StartsAt(1000)
.IncrementsBy(5)
.CacheSize(10);

Thanks,
Bruce'

[ilmax]

If nobody is working on this, I would like to give it a try

[divega]

Sounds good @ilmax. Just keep in mind that at this stage we may choose not to take the PR in 2.1.

[ilmax]

Ok, no problem! I'm working on it now

[ilmax]

I made some progress on this, some unit tests are still missing but the implementation should mostly be done. I have a some questions though and would like to get some feedback because adding cache size support ended up in a breaking change, I've also left a couple of TODOs around.
What's the best way to proceed with this? Should I open a WIP PR or wait till 2.1 is out of the door?

[smitpatel]

@ilmax - Feel free to open PR. We can always merge it after 2.1 or merge into feature branch if 2.1 is not fully done.

[koenmetsu]

@ilmax if things are working out, could you try fitting in "NO CACHE" as well?