Feature/pull request: Reseed Id's about respawn

[robertmantissa]

Got it, haven't bothered with temporal tables at all, so chances are that those won't work.
Anyway, check out my fork here:
https://github.com/robertmantissa/Respawn
(Simply did a:

  var checkpoint = new Checkpoint();
  checkpoint.WithReseed = true;

to keep the current api)

[jbogard]

Oh that's interesting. I don't know if other databases support this kind of thing, maybe it could be exposed through some kind of options object?

[robertmantissa]

After some quick googling it seems to be possible in both MySQL and Oracle.
I will create a fork and add the SQL Server functionality first, and we'll take it from there.

Regarding temporal tables, those were new to me. I guess there might be issues with reseeding those. I'll keep them in mind.

[jbogard]

Oh I dunno about reseeding those. I just meant that there are database that might want to do additional metadata queries and deletion steps

…

On Wed, Jan 31, 2018 at 8:28 AM, robertmantissa ***@***.***> wrote: After some quick googling it seems to be possible in both MySQL and Oracle. I will create a fork and add the SQL Server functionality first, and we'll take it from there. Regarding temporal tables, those were new to me. I guess there might be issues with reseeding those. I'll keep them in mind. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#38 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAGYMhWYYJ0ZPnLgqNdYZBqTKkNWDGMOks5tQHiRgaJpZM4R0ADt> .

[Lazys]

Hi,
I want to add few words:

We had problems with randomly failing tests.. I was struggling almost 2 days until I've found out that the problem is with Respawn and Identity value when tests are run in appropriate order. Then I've run into this pull request!

For my team changes that @robertmantissa proposed are crucial to be able to still use Respawn with ease. Please consider this @jbogard .

Important note: code prepared by @robertmantissa not covers scenario when table has custom IDENTITY SEED initial value. For example 1000 instead of 1. I had problems with it, so I've added fix to the @robertmantissa code and created pull request to his fork. Please check it out here: pull request

Right now I have to use locally compiled version of respawn which includes @robertmantissa and my changes, but I would like to go back to yours nugget package as soon as possible.

[robertmantissa]

Solved with pull request #40